HB_1095C_DATA |
Default Table Name | HB_1095C_DATA |
Definition |
HB_1095C_DATA Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR2(12) | NO | ||
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | NO | ||
CAL_YR_NO![]() |
NUMBER(4, 0) | NO | ||
SEQ_NO![]() |
NUMBER(4, 0) | NO | ||
VOID_FL | VARCHAR2(1) | YES | ||
CORRECTED_FL | VARCHAR2(1) | YES | ||
OFFEROFCVG_CD_ALL | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_JAN | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_FEB | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_MAR | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_APR | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_MAY | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_JUN | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_JUL | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_AUG | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_SEP | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_OCT | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_NOV | VARCHAR2(5) | YES | ||
OFFEROFCVG_CD_DEC | VARCHAR2(5) | YES | ||
LOW_PREM_ALL | NUMBER(19, 4) | YES | ||
LOW_PREM_JAN | NUMBER(19, 4) | YES | ||
LOW_PREM_FEB | NUMBER(19, 4) | YES | ||
LOW_PREM_MAR | NUMBER(19, 4) | YES | ||
LOW_PREM_APR | NUMBER(19, 4) | YES | ||
LOW_PREM_MAY | NUMBER(19, 4) | YES | ||
LOW_PREM_JUN | NUMBER(19, 4) | YES | ||
LOW_PREM_JUL | NUMBER(19, 4) | YES | ||
LOW_PREM_AUG | NUMBER(19, 4) | YES | ||
LOW_PREM_SEP | NUMBER(19, 4) | YES | ||
LOW_PREM_OCT | NUMBER(19, 4) | YES | ||
LOW_PREM_NOV | NUMBER(19, 4) | YES | ||
LOW_PREM_DEC | NUMBER(19, 4) | YES | ||
SAFEHRBR_4980CD_ALL | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_JAN | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_FEB | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_MAR | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_APR | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_MAY | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_JUN | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_JUL | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_AUG | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_SEP | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_OCT | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_NOV | VARCHAR2(5) | YES | ||
SAFEHRBR_4980CD_DEC | VARCHAR2(5) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
TIME_STAMP | DATE | NO | ||
PHONE_ID | VARCHAR2(25) | YES | ||
PLAN_CVG_START_MONTH | VARCHAR2(2) | YES | ||
XML_GENERATION_NO | NUMBER(10, 0) | YES | ||
XML_ACCEPTED_FL | VARCHAR2(1) | NO | ||
XML_RECORD_NO | NUMBER(10, 0) | YES | ||
EMPL_AGE | NUMBER(5, 0) | YES | ||
POSTAL_CD_ALL | VARCHAR2(10) | YES | ||
POSTAL_CD_JAN | VARCHAR2(10) | YES | ||
POSTAL_CD_FEB | VARCHAR2(10) | YES | ||
POSTAL_CD_MAR | VARCHAR2(10) | YES | ||
POSTAL_CD_APR | VARCHAR2(10) | YES | ||
POSTAL_CD_MAY | VARCHAR2(10) | YES | ||
POSTAL_CD_JUN | VARCHAR2(10) | YES | ||
POSTAL_CD_JUL | VARCHAR2(10) | YES | ||
POSTAL_CD_AUG | VARCHAR2(10) | YES | ||
POSTAL_CD_SEP | VARCHAR2(10) | YES | ||
POSTAL_CD_OCT | VARCHAR2(10) | YES | ||
POSTAL_CD_NOV | VARCHAR2(10) | YES | ||
POSTAL_CD_DEC | VARCHAR2(10) | YES |
HB_1095C_DATA Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_HB_1095C_DATA_IDX | PrimaryKey | EMPL_ID, TAXBLE_ENTITY_ID, CAL_YR_NO, SEQ_NO |
HB_1095C_DATA Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
EMPL | Identifying | One To Zero or More | FK_HB_1095C_DATA_EM_IDX | EMPL_ID | NO | NO | NO | ||
TAXBLE_ENTITY | Identifying | One To Zero or More | FK_HB_1095C_DATA_TA_IDX | TAXBLE_ENTITY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
HB_1095C_COVERED | Identifying | One To Zero or More | FK_HB_1095C_COVERED_ETCS_IDX | NO | NO | NO |