DED_CD_CORP |
Default Table Name | DED_CD_CORP |
Definition |
DED_CD_CORP Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DED_CD![]() |
VARCHAR2(6) | NO | ||
DED_SDESC | VARCHAR2(8) | NO | ||
DED_DESC | VARCHAR2(30) | NO | ||
S_DED_TYPE![]() |
VARCHAR2(6) | NO | ||
DED_FL | VARCHAR2(1) | NO | ||
CNTRB_FL | VARCHAR2(1) | NO | ||
S_DED_MTHD_CD | VARCHAR2(6) | NO | ||
PAY_TYPE![]() |
VARCHAR2(3) | YES | ||
DED_MOD_CD![]() |
VARCHAR2(6) | YES | ||
CNTRB_RT | NUMBER(7, 6) | NO | ||
DED_AMT | NUMBER(10, 2) | NO | ||
DED_ANN_CEIL_AMT | NUMBER(10, 2) | NO | ||
DED_START_DT | DATE | YES | ||
DED_END_DT | DATE | YES | ||
DED_PRIORITY_NO | NUMBER(5, 0) | NO | ||
S_CNTRB_MTHD_CD | VARCHAR2(6) | NO | ||
CNTRB_DED_MOD_CD![]() |
VARCHAR2(6) | YES | ||
DED_RT | NUMBER(7, 6) | NO | ||
CNTRB_AMT | NUMBER(10, 2) | NO | ||
CNTRB_START_DT | DATE | YES | ||
CNTRB_END_DT | DATE | YES | ||
CNTRB_ANN_CEIL_AMT | NUMBER(10, 2) | NO | ||
S_FED_INCM_TXBL_CD | VARCHAR2(1) | NO | ||
SS_TX_EXMPT_FL | VARCHAR2(1) | NO | ||
MEDICR_TX_EXMPT_FL | VARCHAR2(1) | NO | ||
FUTA_TX_EXMPT_FL | VARCHAR2(1) | NO | ||
S_W2_CLASS_CD | VARCHAR2(6) | NO | ||
WORK_COMP_CD![]() |
VARCHAR2(6) | YES | ||
ELIG_AREARS_FL | VARCHAR2(1) | NO | ||
S_DED_CEIL_MTHD_CD | VARCHAR2(1) | YES | ||
DED_ARREARS_CD | VARCHAR2(6) | YES | ||
UNION_DED_AMT | NUMBER(12, 6) | NO | ||
CTS_SUP_CD | VARCHAR2(6) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
CTS_LOCAL_CD | VARCHAR2(4) | YES | ||
COUNTY_CD | VARCHAR2(1) | YES | ||
HLTH_COV_FL | VARCHAR2(1) | NO | ||
CNTRB_BASED_ON_MULTI_DED | VARCHAR2(1) | YES | ||
TAX_SVC_CD | VARCHAR2(25) | YES | ||
STATE_CD | VARCHAR2(2) | YES |
DED_CD_CORP Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6930 | PrimaryKey | DED_CD |
DED_CD_CORP Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
S_DED_TYPE | Non-Identifying | One To Zero or More | F08340 | S_DED_TYPE | NO | NO | NO | ||
PAY_TYPE | Non-Identifying | Zero or One to Zero or More | F08344 | PAY_TYPE | NO | NO | NO | ||
DED_MOD | Non-Identifying | Zero or One to Zero or More | F08345 | DED_MOD_CD | NO | NO | NO | ||
DED_MOD | Non-Identifying | Zero or One to Zero or More | F08352 | CNTRB_DED_MOD_CD | NO | NO | NO | ||
WORK_COMP | Non-Identifying | Zero or One to Zero or More | F09589 | WORK_COMP_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
DED_STATE_TXBL | Identifying | One To Zero or More | F08370 | NO | NO | NO | |||
DED_LOC_TXBL | Identifying | One To Zero or More | F08380 | NO | NO | NO | |||
DED_SCH_LN | Identifying | One To Zero or More | F08390 | NO | NO | NO | |||
CNTRB_MATCH_RT | Identifying | One To Zero or More | F08400 | NO | NO | NO | |||
EMPL_DED | Identifying | One To Zero or More | F09071 | NO | NO | NO | |||
EMPL_CNTRB | Identifying | One To Zero or More | F09081 | NO | NO | NO | |||
H_HEALTH_BEN | Identifying | One To Zero or More | F20399 | NO | NO | NO | |||
H_CODA_DED_CD | Identifying | One To Zero or More | F20406 | NO | NO | NO | |||
HB_BEN_PLAN_LN | Non-Identifying | One To Zero or More | F20911 | NO | NO | NO | |||
HB_BEN_PKG_HDR | Non-Identifying | One To Zero or More | F20912 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F20953 | NO | NO | NO | |||
HB_SETTINGS | Non-Identifying | One To Zero or More | F20984 | NO | NO | NO | |||
HB_SETTINGS | Non-Identifying | One To Zero or More | F20986 | NO | NO | NO | |||
EMPL_GARN | Identifying | One To Zero or More | F21283 | NO | NO | NO | |||
EMPL_GARN | Non-Identifying | One To Zero or More | F21284 | NO | NO | NO | |||
EMPL_BOND_HDR2 | Identifying | One To Zero or More | F21588 | NO | NO | NO | |||
DISP_INC_DED | Identifying | One To Zero or More | F21719 | NO | NO | NO | |||
EMPL_GARN_WAGE | Identifying | One To Zero or More | F21723 | NO | NO | NO | |||
EMPL_GARN_ADM_FEE | Non-Identifying | One To Zero or More | F21727 | NO | NO | NO | |||
EMPL_GRN | Non-Identifying | One To Zero or More | F21773 | NO | NO | NO | |||
EMPL_GRN_DI_DED | Identifying | One To Zero or More | F21782 | NO | NO | NO | |||
DED_CD | Identifying | One To Zero or More | FK_DED_CD_DED_CD_CORP | NO | NO | NO |