Z_HBR1094C |
Default Table Name | Z_HBR1094C |
Definition |
Z_HBR1094C Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MEM_COUNT | NUMBER(2, 0) | YES | ||
CAL_YR_NO | NUMBER(4, 0) | YES | ||
SEQ_NO | NUMBER(4, 0) | YES | ||
CORRECTED_FL | VARCHAR2(1) | YES | ||
E_EMPL_ID | VARCHAR2(12) | YES | ||
E_LAST_FIRST_NAME | VARCHAR2(25) | YES | ||
E_EMPL_ID_DGE | VARCHAR2(12) | YES | ||
E_LAST_FIRST_NAME_DGE | VARCHAR2(25) | YES | ||
T_TAXBLE_ENTITY_ID | VARCHAR2(10) | YES | ||
T_TAXBLE_ENTITY_NAME | VARCHAR2(40) | YES | ||
T_TAX_ID | VARCHAR2(20) | YES | ||
T_LN_1_ADR | VARCHAR2(40) | YES | ||
T_LN_2_ADR | VARCHAR2(40) | YES | ||
T_LN_3_ADR | VARCHAR2(40) | YES | ||
T_PHONE_ID | VARCHAR2(25) | YES | ||
T_CITY_NAME | VARCHAR2(25) | YES | ||
T_MAIL_STATE_DC | VARCHAR2(15) | YES | ||
T_COUNTRY_CD | VARCHAR2(8) | YES | ||
T_POSTAL_CD | VARCHAR2(10) | YES | ||
T_TAXBLE_ENTITY_ID_DGE | VARCHAR2(10) | YES | ||
T_TAXBLE_ENTITY_NAME_DGE | VARCHAR2(40) | YES | ||
T_TAX_ID_DGE | VARCHAR2(20) | YES | ||
T_LN_1_ADR_DGE | VARCHAR2(40) | YES | ||
T_LN_2_ADR_DGE | VARCHAR2(40) | YES | ||
T_LN_3_ADR_DGE | VARCHAR2(40) | YES | ||
T_PHONE_ID_DGE | VARCHAR2(25) | YES | ||
T_CITY_NAME_DGE | VARCHAR2(25) | YES | ||
T_MAIL_STATE_DC_DGE | VARCHAR2(15) | YES | ||
T_COUNTRY_CD_DGE | VARCHAR2(8) | YES | ||
T_POSTAL_CD_DGE | VARCHAR2(10) | YES | ||
HD_TOTAL_1095C_COUNT | NUMBER(10, 0) | YES | ||
HD_AUTH_TRANS_FL | VARCHAR2(1) | YES | ||
HD_AUTH_TRANS_1095_COUNT | NUMBER(10, 0) | YES | ||
HD_AGGREGATED_GRP_FL | VARCHAR2(1) | YES | ||
HD_QUAL_OFFER_MTHD_FL | VARCHAR2(1) | YES | ||
HD_QUAL_OFFER_MTHD_TRN_RLF_FL | VARCHAR2(1) | YES | ||
HD_ACA_4980H_TRANS_RELIEF_FL | VARCHAR2(1) | YES | ||
HD_ACA_98_PCT_OFFER_MTHD_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_ALL_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_JAN_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_FEB_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_MAR_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_APR_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_MAY_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_JUN_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_JUL_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_AUG_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_SEP_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_OCT_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_NOV_FL | VARCHAR2(1) | YES | ||
HD_MEC_FT_DEC_FL | VARCHAR2(1) | YES | ||
HD_FT_EE_JAN_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_FEB_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_MAR_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_APR_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_MAY_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_JUN_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_JUL_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_AUG_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_SEP_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_OCT_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_NOV_COUNT | NUMBER(10, 0) | YES | ||
HD_FT_EE_DEC_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_ALL_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_JAN_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_FEB_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_MAR_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_APR_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_MAY_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_JUN_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_JUL_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_AUG_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_SEP_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_OCT_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_NOV_COUNT | NUMBER(10, 0) | YES | ||
HD_TOT_DEC_COUNT | NUMBER(10, 0) | YES | ||
HD_AGGREGATED_GRP_ALL_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_JAN_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_FEB_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_MAR_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_APR_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_MAY_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_JUN_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_JUL_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_AUG_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_SEP_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_OCT_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_NOV_FL | VARCHAR2(1) | YES | ||
HD_AGGREGATED_GRP_DEC_FL | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_ALL_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_JAN_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_FEB_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_MAR_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_APR_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_MAY_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_JUN_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_JUL_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_AUG_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_SEP_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_OCT_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_NOV_CD | VARCHAR2(1) | YES | ||
HD_SAFEHRBR_4980H_DEC_CD | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
Z_HBR1094C Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_HBR1094C 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 |