ACCOUNT_NUMBER | CHAR VARYING (2000) | , |
ADDRESS_S | CHAR VARYING (19) | REFERENCES ADDRESS (INSTANCE_S), |
AMOUNT | FLOAT | , |
AMOUNT_U | CHAR VARYING (15) | REFERENCES R_CURRENCY_UNIT (ACRONYM), |
BUSINESS_ASSOCIATE_ROLE | CHAR VARYING (80) | NOT NULL REFERENCES R_CONTRACT_DESIGNATION (IDENTIFIER), |
BUSINESS_ASSOCIATE_S | CHAR VARYING (19) | NOT NULL REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S), |
CONTRACTUAL_OBLIGATION_S | CHAR VARYING (19) | REFERENCES CONTRACTUAL_OBLIGATION (INSTANCE_S), |
CONTRACT_S | CHAR VARYING (19) | REFERENCES CONTRACT (INSTANCE_S), |
DEPOSITORY_DESIGNATION_S | CHAR VARYING (19) | REFERENCES CONTRACT_DESIGNATION (INSTANCE_S), |
DESCRIPTION | CHAR VARYING (2000) | , |
EFFECTIVE_DATE | TIMESTAMP | , |
EFFECTIVE_DATE_CD | CHAR (1) | , |
EFFECTIVE_DATE_DY | INTEGER | , |
EFFECTIVE_DATE_HR | INTEGER | , |
EFFECTIVE_DATE_MT | INTEGER | , |
EFFECTIVE_DATE_OF | FLOAT | , |
EFFECTIVE_DATE_ST | FLOAT | , |
EFFECTIVE_DATE_YP | INTEGER | , |
EFFECTIVE_DATE_YR | FLOAT | , |
ENTITY_TYPE_NM | CHAR VARYING (30) | NOT NULL CHECK (ENTITY_TYPE_NM IN ('CONTRACT_DESIGNATION', 'DEPOSITORY_DESIGNATION', 'INTEREST_DESIGNATION', 'OWNERSHIP_DESIGNATION')), |
EXPIRY_DATE | TIMESTAMP | , |
EXPIRY_DATE_CD | CHAR (1) | , |
EXPIRY_DATE_DY | INTEGER | , |
EXPIRY_DATE_HR | INTEGER | , |
EXPIRY_DATE_MT | INTEGER | , |
EXPIRY_DATE_OF | FLOAT | , |
EXPIRY_DATE_ST | FLOAT | , |
EXPIRY_DATE_YP | INTEGER | , |
EXPIRY_DATE_YR | FLOAT | , |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
INTEREST_KIND | CHAR VARYING (80) | REFERENCES R_INTEREST_DESIGNATION (IDENTIFIER), |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
OWNERSHIP_KIND | CHAR VARYING (80) | REFERENCES R_OWNERSHIP (IDENTIFIER), |
PERCENT | FLOAT (6) | , |
R_HOLD_OR_PAY | CHAR VARYING (80) | REFERENCES R_HOLD_OR_PAY (IDENTIFIER), |
SOURCE | CHAR VARYING (80) | |
)