BUSINESS_ASSOCIATE_S | CHAR VARYING (19) | REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S), |
DATA_VALUE | FLOAT | , |
DATA_VALUE_Q | CHAR VARYING (80) | REFERENCES R_QUANTITY_TYPE (IDENTIFIER), |
DATA_VALUE_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
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 ('BUSINESS_ASSOCIATE_PRIVILEGE', 'GUIDELINE', 'LIMITATION', 'OBJECTIVE', 'REGULATION')), |
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 | , |
GUIDELINE_SET_S | CHAR VARYING (19) | REFERENCES GUIDELINE_SET (INSTANCE_S), |
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) | , |
LIMITATION_SET_S | CHAR VARYING (19) | REFERENCES LIMITATION_SET (INSTANCE_S), |
OBJECTIVE_SET_S | CHAR VARYING (19) | REFERENCES OBJECTIVE_SET (INSTANCE_S), |
R_BUSINESS_ASSOC_PRIVILEGE | CHAR VARYING (80) | REFERENCES R_BUSINESS_ASSOC_PRIVILEGE (IDENTIFIER), |
R_GUIDELINE | CHAR VARYING (80) | REFERENCES R_GUIDELINE (IDENTIFIER), |
R_LIMITATION | CHAR VARYING (80) | REFERENCES R_LIMITATION (IDENTIFIER), |
R_OBJECTIVE | CHAR VARYING (80) | REFERENCES R_OBJECTIVE (IDENTIFIER), |
R_REGULATION | CHAR VARYING (80) | REFERENCES R_REGULATION (IDENTIFIER), |
R_REGULATION_PURPOSE | CHAR VARYING (80) | REFERENCES R_REGULATION_PURPOSE (IDENTIFIER), |
SOURCE | CHAR VARYING (80) | , |
TEXT | CHAR VARYING | |
)