AMENDMENT_DATE | TIMESTAMP | , |
AMENDMENT_DATE_CD | CHAR (1) | , |
AMENDMENT_DATE_DY | INTEGER | , |
AMENDMENT_DATE_HR | INTEGER | , |
AMENDMENT_DATE_MT | INTEGER | , |
AMENDMENT_DATE_OF | FLOAT | , |
AMENDMENT_DATE_ST | FLOAT | , |
AMENDMENT_DATE_YP | INTEGER | , |
AMENDMENT_DATE_YR | FLOAT | , |
AMEND_REGULATION_CLAUSE_S | CHAR VARYING (19) | REFERENCES REGULATION_CLAUSE (INSTANCE_S), |
DESCRIPTION | CHAR VARYING (2000) | , |
ENTITY_TYPE_NM | CHAR VARYING (30) | NOT NULL CHECK (ENTITY_TYPE_NM IN ('REGULATION_CLAUSE', 'REGULATION_CLAUSE_AMENDMENT')), |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
OCCURRENCE_ORDER | INTEGER | , |
REGULATION_S | CHAR VARYING (19) | NOT NULL REFERENCES GUIDELINE_OR_PRIVILEGE (INSTANCE_S), |
R_CLAUSE_AMENDMENT_REASON | CHAR VARYING (80) | REFERENCES R_CLAUSE_AMENDMENT_REASON (IDENTIFIER), |
R_REGULATION_CLAUSE | CHAR VARYING (80) | REFERENCES R_REGULATION_CLAUSE (IDENTIFIER), |
SOURCE | CHAR VARYING (80) | , |
TEXT | CHAR VARYING | |
)