POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE CONTRACT_DESIGNATION
(
ACCOUNT_NUMBERCHAR VARYING (2000),
ADDRESS_SCHAR VARYING (19) REFERENCES ADDRESS (INSTANCE_S),
AMOUNTFLOAT,
AMOUNT_UCHAR VARYING (15) REFERENCES R_CURRENCY_UNIT (ACRONYM),
BUSINESS_ASSOCIATE_ROLECHAR VARYING (80) NOT NULL REFERENCES R_CONTRACT_DESIGNATION (IDENTIFIER),
BUSINESS_ASSOCIATE_SCHAR VARYING (19) NOT NULL REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S),
CONTRACTUAL_OBLIGATION_SCHAR VARYING (19) REFERENCES CONTRACTUAL_OBLIGATION (INSTANCE_S),
CONTRACT_SCHAR VARYING (19) REFERENCES CONTRACT (INSTANCE_S),
DEPOSITORY_DESIGNATION_SCHAR VARYING (19) REFERENCES CONTRACT_DESIGNATION (INSTANCE_S),
DESCRIPTIONCHAR VARYING (2000),
EFFECTIVE_DATETIMESTAMP,
EFFECTIVE_DATE_CDCHAR (1),
EFFECTIVE_DATE_DYINTEGER,
EFFECTIVE_DATE_HRINTEGER,
EFFECTIVE_DATE_MTINTEGER,
EFFECTIVE_DATE_OFFLOAT,
EFFECTIVE_DATE_STFLOAT,
EFFECTIVE_DATE_YPINTEGER,
EFFECTIVE_DATE_YRFLOAT,
ENTITY_TYPE_NMCHAR VARYING (30) NOT NULL CHECK (ENTITY_TYPE_NM IN ('CONTRACT_DESIGNATION', 'DEPOSITORY_DESIGNATION', 'INTEREST_DESIGNATION', 'OWNERSHIP_DESIGNATION')),
EXPIRY_DATETIMESTAMP,
EXPIRY_DATE_CDCHAR (1),
EXPIRY_DATE_DYINTEGER,
EXPIRY_DATE_HRINTEGER,
EXPIRY_DATE_MTINTEGER,
EXPIRY_DATE_OFFLOAT,
EXPIRY_DATE_STFLOAT,
EXPIRY_DATE_YPINTEGER,
EXPIRY_DATE_YRFLOAT,
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
INTEREST_KINDCHAR VARYING (80) REFERENCES R_INTEREST_DESIGNATION (IDENTIFIER),
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
OWNERSHIP_KINDCHAR VARYING (80) REFERENCES R_OWNERSHIP (IDENTIFIER),
PERCENTFLOAT (6),
R_HOLD_OR_PAYCHAR VARYING (80) REFERENCES R_HOLD_OR_PAY (IDENTIFIER),
SOURCECHAR VARYING (80)
)


Generated on Tue Jul 10 19:39:56 2001
© Copyright 2001 POSC. All rights reserved.