TAXBLE_ENTITY |
Default Table Name | TAXBLE_ENTITY |
Definition |
TAXBLE_ENTITY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | NO | ||
TAXBLE_ENTITY_NAME | VARCHAR2(40) | NO | ||
TAX_ID | VARCHAR2(20) | NO | ||
CITY_NAME | VARCHAR2(25) | NO | ||
LN_1_ADR | VARCHAR2(40) | NO | ||
LN_2_ADR | VARCHAR2(40) | NO | ||
LN_3_ADR | VARCHAR2(40) | NO | ||
MAIL_STATE_DC![]() |
VARCHAR2(15) | YES | ||
POSTAL_CD | VARCHAR2(10) | NO | ||
COUNTRY_CD![]() |
VARCHAR2(8) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
PHONE_ID | VARCHAR2(25) | NO | ||
STS_CLIENT_ID | VARCHAR2(6) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
TAXBLE_ENTITY Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0034 | PrimaryKey | TAXBLE_ENTITY_ID |
TAXBLE_ENTITY Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
MAIL_STATE | Non-Identifying | Zero or One to Zero or More | F04720 | MAIL_STATE_DC, COUNTRY_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EMPL | Non-Identifying | One To Zero or More | F00590 | NO | NO | NO | |||
ORG | Non-Identifying | One To Zero or More | F02380 | NO | NO | NO | |||
EMPL_PAYROLL | Non-Identifying | One To Zero or More | F09972 | NO | NO | NO | |||
EMPL_EARNINGS | Non-Identifying | One To Zero or More | F09973 | NO | NO | NO | |||
FED_W2_FILE | Identifying | One To Zero or More | F09975 | NO | NO | NO | |||
STATE_W2_FILE | Identifying | One To Zero or More | F09979 | NO | NO | NO | |||
LOCAL_W2_FILE | Identifying | One To Zero or More | F09982 | NO | NO | NO | |||
H_NOTIF_LET_SETUP | Non-Identifying | One To Zero or More | F20405 | NO | NO | NO | |||
MULTI_CO_ST_OVRD | Identifying | One To Zero or More | F21000 | NO | NO | NO | |||
MULTI_CO_LOC_OVRD | Identifying | One To Zero or More | F21011 | NO | NO | NO | |||
CO_SAV_BOND_INFO | Identifying | One To Zero or More | F21514 | NO | NO | NO | |||
MAG_MEDIA_RPT | Identifying | One To Zero or More | F21577 | NO | NO | NO | |||
H_AFF_PL_LOC_CMP | Identifying | One To Zero or More | F21580 | NO | NO | NO | |||
FED_ACCT_OVRD | Identifying | One To Zero or More | F21596 | NO | NO | NO | |||
DIR_DEP_SETTINGS | Non-Identifying | One To Zero or More | F21614 | NO | NO | NO | |||
STATE_SUTA_RPTING | Identifying | One To Zero or More | F21615 | NO | NO | NO | |||
PAY_CHK_SETUP | Non-Identifying | One To Zero or More | F21616 | NO | NO | NO | |||
HB_1094C_TAXBLE_ENTITY | Identifying | One To Zero or More | FK_H1TE_TA_IDX | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | FK_H_POS_RQ_RQST_TA_IDX | NO | NO | NO | |||
HB_1095C_COVERED | Identifying | One To Zero or More | FK_HB_1095C_COVERED_TA_IDX | NO | NO | NO | |||
HB_1095C_DATA | Identifying | One To Zero or More | FK_HB_1095C_DATA_TA_IDX | NO | NO | NO | |||
HB_BENEFIT_YR_TE_FTE | Identifying | One To Zero or More | FK_HB_BENEFIT_YR_TE_FTE_TA_IDX | NO | NO | NO | |||
HB_BENEFIT_YR_TE | Identifying | One To Zero or More | FK_HB_BENEFIT_YR_TE_TA_IDX | NO | NO | NO | |||
HB_DEP_BEN_OFFER_LN | Identifying | One To Zero or More | FK_HB_DEP_BEN_OFFER_LN_TA_IDX | NO | NO | NO | |||
HB_EMPL_BEN_OFFER_HDR | Identifying | One To Zero or More | FK_HB_EMPL_BEN_OFFER_HDR_T_IDX | NO | NO | NO | |||
HB_EMPL_BEN_OFFER_LN | Identifying | One To Zero or More | FK_HB_EMPL_BEN_OFFER_LN_TA_IDX | NO | NO | NO | |||
HB_EMPL_EOI | Non-Identifying | One To Zero or More | FK_HB_EMPL_EOI_TA_IDX | NO | NO | NO | |||
HB_EMPL_FULLTIME_EQUIV | Identifying | One To Zero or More | FK_HB_EMPL_FT_EQUIV_TA_IDX | NO | NO | NO | |||
SUTA_EXCLUDE_PAY_TYPE | Identifying | One To Zero or More | FK_SUTAEXCLUDEPAYTYPE_TA_IDX | NO | NO | NO |