Z_HBR1095C_COV |
Default Table Name | Z_HBR1095C_COV |
Definition |
Z_HBR1095C_COV Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DEP_ID | VARCHAR2(12) | YES | ||
EMPL_ID | VARCHAR2(12) | YES | ||
TAXBLE_ENTITY_ID | VARCHAR2(10) | YES | ||
CAL_YR_NO | NUMBER(4, 0) | YES | ||
SEQ_NO | NUMBER(4, 0) | YES | ||
EMPL_OR_DEP_ID | VARCHAR2(12) | YES | ||
IND_TYPE_CD | VARCHAR2(1) | YES | ||
ORDER_NUM | NUMBER(4, 0) | YES | ||
DEP_LAST_FIRST_NAME | VARCHAR2(60) | YES | ||
DEP_SSN_ID | VARCHAR2(11) | YES | ||
DEP_BIRTH_DT | DATE | YES | ||
HC_IND_TYPE_CD | VARCHAR2(1) | YES | ||
HC_COVERED_ALL_FL | VARCHAR2(1) | YES | ||
HC_COVERED_JAN_FL | VARCHAR2(1) | YES | ||
HC_COVERED_FEB_FL | VARCHAR2(1) | YES | ||
HC_COVERED_MAR_FL | VARCHAR2(1) | YES | ||
HC_COVERED_APR_FL | VARCHAR2(1) | YES | ||
HC_COVERED_MAY_FL | VARCHAR2(1) | YES | ||
HC_COVERED_JUN_FL | VARCHAR2(1) | YES | ||
HC_COVERED_JUL_FL | VARCHAR2(1) | YES | ||
HC_COVERED_AUG_FL | VARCHAR2(1) | YES | ||
HC_COVERED_SEP_FL | VARCHAR2(1) | YES | ||
HC_COVERED_OCT_FL | VARCHAR2(1) | YES | ||
HC_COVERED_NOV_FL | VARCHAR2(1) | YES | ||
HC_COVERED_DEC_FL | VARCHAR2(1) | YES |
Z_HBR1095C_COV Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_HBR1095C_COV Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |