EMPL_EARNINGS |
Default Table Name | EMPL_EARNINGS |
Definition |
EMPL_EARNINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR2(12) | NO | ||
CHK_DT | DATE | NO | ||
S_PAYCHK_TYPE![]() |
VARCHAR2(1) | NO | ||
PAY_PD_CD | VARCHAR2(4) | NO | ||
PAY_PD_END_DT | DATE | NO | ||
CHK_NO | NUMBER(10, 0) | NO | ||
GROSS_AMT | NUMBER(10, 2) | NO | ||
NET_AMT | NUMBER(10, 2) | NO | ||
TOT_HRS | NUMBER(14, 2) | NO | ||
FED_EXMPT_PT_AMT | NUMBER(10, 2) | NO | ||
FED_EXMPT_DED_AMT | NUMBER(10, 2) | NO | ||
FED_TXBL_AMT | NUMBER(10, 2) | NO | ||
SS_EXMPT_PT_AMT | NUMBER(10, 2) | NO | ||
SS_EXMPT_DED_AMT | NUMBER(10, 2) | NO | ||
SS_TXBL_AMT | NUMBER(10, 2) | NO | ||
MDCR_EXMPT_PT_AMT | NUMBER(10, 2) | NO | ||
MDCR_EXMPT_DED_AMT | NUMBER(10, 2) | NO | ||
MDCR_TXBL_AMT | NUMBER(10, 2) | NO | ||
FED_WH_AMT | NUMBER(10, 2) | NO | ||
SS_WH_AMT | NUMBER(10, 2) | NO | ||
SS_ACCR_AMT | NUMBER(10, 2) | NO | ||
MEDICR_WH_AMT | NUMBER(10, 2) | NO | ||
MEDICR_ACCR_AMT | NUMBER(10, 2) | NO | ||
AEIC_AMT | NUMBER(10, 2) | NO | ||
SUTA_STATE_CD | VARCHAR2(2) | YES | ||
SUTA_TXBL_AMT | NUMBER(10, 2) | NO | ||
SUTA_ACCR_AMT | NUMBER(10, 2) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
FUTA_TXBL_AMT | NUMBER(10, 2) | NO | ||
FUTA_ACCR_AMT | NUMBER(10, 2) | NO | ||
FY_CD![]() |
VARCHAR2(6) | NO | ||
PD_NO![]() |
NUMBER(5, 0) | NO | ||
POST_SEQ_NO![]() |
NUMBER(10, 0) | NO | ||
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | YES | ||
S_DISB_CD | VARCHAR2(2) | NO | ||
DD_AMT | NUMBER(8, 2) | NO | ||
DD_DT | DATE | YES | ||
DD_NO | NUMBER(10, 0) | NO | ||
DD_EFFECT_DT | DATE | YES | ||
DD_CREATE_TIME | VARCHAR2(4) | NO | ||
DD_CASH_ACCT_ID | VARCHAR2(15) | YES | ||
DD_CASH_ORG_ID | VARCHAR2(20) | YES | ||
DD_CASH_REF1_ID | VARCHAR2(20) | YES | ||
DD_CASH_REF2_ID | VARCHAR2(20) | YES | ||
DD_BANK_ACCT_ABBRV | VARCHAR2(6) | YES | ||
DD_BANK_REC_ST_FL | VARCHAR2(1) | NO | ||
CK_CASH_ACCT_ID | VARCHAR2(15) | YES | ||
CK_CASH_ORG_ID | VARCHAR2(20) | YES | ||
CK_CASH_REF1_ID | VARCHAR2(20) | YES | ||
CK_CASH_REF2_ID | VARCHAR2(20) | YES | ||
CK_BANK_ACCT_ABBRV | VARCHAR2(6) | YES | ||
CK_BANK_REC_ST_FL | VARCHAR2(1) | NO | ||
DD_CREATE_DT | DATE | YES | ||
VOID_CHK_FL | VARCHAR2(1) | NO | ||
CTS_TRANS_FL | VARCHAR2(1) | YES | ||
WEEK_NO | NUMBER(5, 0) | YES | ||
PAYROLL_RUN_NO | NUMBER(5, 0) | YES | ||
REF_CHK_NO | NUMBER(10, 0) | YES | ||
REF_CHK_DT | DATE | YES | ||
AP_940_FL | VARCHAR2(1) | NO | ||
AP_941_FL | VARCHAR2(1) | NO | ||
AP_STATE_WH_FL | VARCHAR2(1) | NO | ||
AP_STATE_SUTA_FL | VARCHAR2(1) | NO | ||
REIMB_AMT | NUMBER(10, 2) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
REF_CHK_TYPE | VARCHAR2(1) | YES | ||
SEVERANCE_FL | VARCHAR2(1) | YES | ||
FUTA_EXMPT_PT_AMT | NUMBER(10, 2) | NO | ||
FUTA_EXMPT_DED_AMT | NUMBER(10, 2) | NO | ||
FUTA_EXCESS_AMT | NUMBER(10, 2) | YES | ||
SUTA_EXMPT_PT_AMT | NUMBER(10, 2) | NO | ||
SUTA_EXMPT_DED_AMT | NUMBER(10, 2) | NO | ||
SUTA_EXCESS_AMT | NUMBER(10, 2) | YES | ||
FED_ADDTL_AMT | NUMBER(10, 2) | YES | ||
FED_EXMPT_NO | NUMBER(5, 0) | YES | ||
FED_OVRIDE_AMT | NUMBER(10, 2) | YES | ||
FED_OVRIDE_PCT | NUMBER(5, 4) | YES | ||
FUTA_RT | NUMBER(9, 8) | NO | ||
FUTA_TXBL_FL | VARCHAR2(1) | YES | ||
MDCR_ADD_TXBL_AMT | NUMBER(10, 2) | NO | ||
MEDICR_ADD_WH_AMT | NUMBER(10, 2) | NO | ||
MEDICR_TXBL_FL | VARCHAR2(1) | YES | ||
S_FED_FIL_STAT_CD | VARCHAR2(1) | YES | ||
SS_TXBL_FL | VARCHAR2(1) | YES | ||
SSN_ID | VARCHAR2(11) | YES | ||
SUTA_RT | NUMBER(9, 8) | NO | ||
SUTA_TXBL_FL | VARCHAR2(1) | YES | ||
TAX_SVC_GRP_ID | VARCHAR2(25) | YES | ||
TAX_EXPORT_FL | VARCHAR2(1) | YES | ||
REF_TAX_EXPORT_FL | VARCHAR2(1) | YES | ||
REF_PR_YR_NO | NUMBER(4, 0) | YES | ||
REF_QTR_NO | NUMBER(2, 0) | YES |
EMPL_EARNINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0591 | PrimaryKey | EMPL_ID, S_PAYCHK_TYPE, FY_CD, PD_NO, POST_SEQ_NO |
EMPL_EARNINGS 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 | F09125 | EMPL_ID | NO | NO | NO | ||
TAXBLE_ENTITY | Non-Identifying | Zero or One to Zero or More | F09973 | TAXBLE_ENTITY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EMPL_EARN_PAY_TYPE | Identifying | One To Zero or More | F09126 | NO | NO | NO | |||
EMPL_EARN_WC | Identifying | One To Zero or More | F09127 | NO | NO | NO | |||
EMPL_EARN_DED | Identifying | One To Zero or More | F09128 | NO | NO | NO | |||
EMPL_EARN_CNTRB | Identifying | One To Zero or More | F09129 | NO | NO | NO | |||
EMPL_EARN_LOCAL | Identifying | One To Zero or More | F09159 | NO | NO | NO | |||
EMPL_E_PROJ | Identifying | One To Zero or More | F21369 | NO | NO | NO | |||
EMPL_E_FRNG_DETL | Identifying | One To Zero or More | F21371 | NO | NO | NO | |||
EMPL_EARN_TS_INFO | Identifying | One To Zero or More | F21435 | NO | NO | NO | |||
EMPL_EARN_DD | Identifying | One To Zero or More | F21794 | NO | NO | NO | |||
EMPL_EARN_STATE | Identifying | One To Zero or More | F21795 | NO | NO | NO |