HB_1094C_DATA |
Default Table Name | HB_1094C_DATA |
Definition |
HB_1094C_DATA Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | NO | ||
CAL_YR_NO![]() |
NUMBER(4, 0) | NO | ||
SEQ_NO![]() |
NUMBER(4, 0) | NO | ||
CORRECTED_FL | VARCHAR2(1) | NO | ||
ALE_CONTACT_EMPL_ID | VARCHAR2(12) | NO | ||
ALE_CONTACT_PHONE_ID | VARCHAR2(25) | NO | ||
DGE_TAXBLE_ENTITY_ID | VARCHAR2(10) | YES | ||
DGE_CONTACT_EMPL_ID | VARCHAR2(12) | YES | ||
DGE_CONTACT_PHONE_ID | VARCHAR2(25) | YES | ||
TOTAL_1095C_COUNT | NUMBER(10, 0) | NO | ||
AUTH_TRANS_FL | VARCHAR2(1) | NO | ||
AUTH_TRANS_1095_COUNT | NUMBER(10, 0) | YES | ||
AGGREGATED_GRP_FL | VARCHAR2(1) | NO | ||
QUAL_OFFER_MTHD_FL | VARCHAR2(1) | NO | ||
QUAL_OFFER_MTHD_TRN_RLF_FL | VARCHAR2(1) | NO | ||
ACA_4980H_TRANS_RELIEF_FL | VARCHAR2(1) | NO | ||
ACA_98_PCT_OFFER_MTHD_FL | VARCHAR2(1) | NO | ||
MEC_FT_ALL_CD | VARCHAR2(1) | YES | ||
MEC_FT_JAN_CD | VARCHAR2(1) | YES | ||
MEC_FT_FEB_CD | VARCHAR2(1) | YES | ||
MEC_FT_MAR_CD | VARCHAR2(1) | YES | ||
MEC_FT_APR_CD | VARCHAR2(1) | YES | ||
MEC_FT_MAY_CD | VARCHAR2(1) | YES | ||
MEC_FT_JUN_CD | VARCHAR2(1) | YES | ||
MEC_FT_JUL_CD | VARCHAR2(1) | YES | ||
MEC_FT_AUG_CD | VARCHAR2(1) | YES | ||
MEC_FT_SEP_CD | VARCHAR2(1) | YES | ||
MEC_FT_OCT_CD | VARCHAR2(1) | YES | ||
MEC_FT_NOV_CD | VARCHAR2(1) | YES | ||
MEC_FT_DEC_CD | VARCHAR2(1) | YES | ||
FT_EE_ALL_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_JAN_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_FEB_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_MAR_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_APR_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_MAY_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_JUN_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_JUL_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_AUG_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_SEP_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_OCT_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_NOV_COUNT | NUMBER(10, 0) | YES | ||
FT_EE_DEC_COUNT | NUMBER(10, 0) | YES | ||
TOT_ALL_COUNT | NUMBER(10, 0) | YES | ||
TOT_JAN_COUNT | NUMBER(10, 0) | YES | ||
TOT_FEB_COUNT | NUMBER(10, 0) | YES | ||
TOT_MAR_COUNT | NUMBER(10, 0) | YES | ||
TOT_APR_COUNT | NUMBER(10, 0) | YES | ||
TOT_MAY_COUNT | NUMBER(10, 0) | YES | ||
TOT_JUN_COUNT | NUMBER(10, 0) | YES | ||
TOT_JUL_COUNT | NUMBER(10, 0) | YES | ||
TOT_AUG_COUNT | NUMBER(10, 0) | YES | ||
TOT_SEP_COUNT | NUMBER(10, 0) | YES | ||
TOT_OCT_COUNT | NUMBER(10, 0) | YES | ||
TOT_NOV_COUNT | NUMBER(10, 0) | YES | ||
TOT_DEC_COUNT | NUMBER(10, 0) | YES | ||
AGGREGATED_GRP_ALL_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_JAN_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_FEB_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_MAR_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_APR_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_MAY_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_JUN_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_JUL_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_AUG_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_SEP_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_OCT_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_NOV_CD | VARCHAR2(1) | YES | ||
AGGREGATED_GRP_DEC_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_ALL_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_JAN_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_FEB_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_MAR_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_APR_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_MAY_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_JUN_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_JUL_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_AUG_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_SEP_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_OCT_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_NOV_CD | VARCHAR2(1) | YES | ||
SAFEHRBR_4980H_DEC_CD | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
TIME_STAMP | DATE | NO | ||
XML_GENERATION_NO | NUMBER(10, 0) | YES | ||
XML_ACCEPTED_FL | VARCHAR2(1) | NO |
HB_1094C_DATA Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_HB_1094C_DATA_IDX | PrimaryKey | TAXBLE_ENTITY_ID, CAL_YR_NO, SEQ_NO |
HB_1094C_DATA 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 |
HB_1094C_TAXBLE_ENTITY | Identifying | One To Zero or More | FK_H1TE_TACASE_IDX | NO | NO | NO |