EMPL_PAYROLL |
Default Table Name | EMPL_PAYROLL |
Definition |
EMPL_PAYROLL Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR2(12) | 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 | ||
CHK_DT | DATE | YES | ||
GROSS_AMT | NUMBER(17, 2) | NO | ||
NET_AMT | NUMBER(17, 2) | NO | ||
TOT_HRS | NUMBER(14, 2) | NO | ||
FED_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
FED_EXMPT_DED_AMT | NUMBER(17, 2) | NO | ||
FED_TXBL_AMT | NUMBER(17, 2) | NO | ||
SS_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
SS_EXMPT_DED_AMT | NUMBER(17, 2) | NO | ||
SS_TXBL_AMT | NUMBER(17, 2) | NO | ||
MDCR_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
MDCR_EXMPT_DED_AMT | NUMBER(17, 2) | NO | ||
MDCR_TXBL_AMT | NUMBER(17, 2) | NO | ||
FED_WH_AMT | NUMBER(17, 2) | NO | ||
SS_WH_AMT | NUMBER(17, 2) | NO | ||
SS_ACCR_AMT | NUMBER(17, 2) | NO | ||
MEDICR_WH_AMT | NUMBER(17, 2) | NO | ||
MEDICR_ACCR_AMT | NUMBER(17, 2) | NO | ||
AEIC_AMT | NUMBER(17, 2) | NO | ||
SUTA_STATE_CD | VARCHAR2(2) | YES | ||
SUTA_TXBL_AMT | NUMBER(17, 2) | NO | ||
SUTA_ACCR_AMT | NUMBER(17, 2) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
FY_CD | VARCHAR2(6) | YES | ||
PD_NO | NUMBER(5, 0) | YES | ||
SUB_PD_NO | NUMBER(5, 0) | YES | ||
POST_SEQ_NO | NUMBER(10, 0) | YES | ||
FUTA_TXBL_AMT | NUMBER(17, 2) | NO | ||
FUTA_ACCR_AMT | NUMBER(17, 2) | NO | ||
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | YES | ||
S_DISB_CD | VARCHAR2(2) | NO | ||
DD_AMT | NUMBER(17, 2) | NO | ||
DD_DT | DATE | YES | ||
DD_NO | NUMBER(10, 0) | NO | ||
DD_EFFECT_DT | DATE | YES | ||
DD_CREATE_TIME | VARCHAR2(4) | NO | ||
DD_CREATE_DT | DATE | YES | ||
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(17, 2) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
REF_CHK_TYPE | VARCHAR2(1) | YES | ||
SEVERANCE_FL | VARCHAR2(1) | YES | ||
PP_CHK_DT | DATE | YES | ||
FUTA_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
FUTA_EXMPT_DED_AMT | NUMBER(17, 2) | NO | ||
FUTA_EXCESS_AMT | NUMBER(17, 2) | YES | ||
SUTA_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
SUTA_EXMPT_DED_AMT | NUMBER(17, 2) | NO | ||
SUTA_EXCESS_AMT | NUMBER(17, 2) | YES | ||
FED_ADDTL_AMT | NUMBER(17, 2) | YES | ||
FED_EXMPT_NO | NUMBER(5, 0) | YES | ||
FED_OVRIDE_AMT | NUMBER(17, 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(17, 2) | NO | ||
MEDICR_ADD_WH_AMT | NUMBER(17, 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 | ||
FED_DEP_NO | NUMBER(5, 0) | YES | ||
FED_OTHER_DEP_NO | NUMBER(5, 0) | YES | ||
FED_OTHER_CREDITS_AMT | NUMBER(17, 2) | YES | ||
FED_OTHER_INC_AMT | NUMBER(17, 2) | YES | ||
FED_DED_AMT | NUMBER(17, 2) | YES | ||
FED_STEP2_W4_FL | VARCHAR2(1) | YES | ||
FED_W4_NO | NUMBER(4, 0) | YES | ||
CONSOLIDATED_FL | VARCHAR2(1) | YES | ||
S_EMPL_TYPE_CD | VARCHAR2(1) | YES | ||
S_HRLY_SAL_CD | VARCHAR2(1) | YES | ||
EXMPT_FL | VARCHAR2(1) | YES | ||
S_PR_FREQ_CD | VARCHAR2(1) | YES | ||
SAL_AMT | NUMBER(17, 2) | YES | ||
PAYSTUB_NAME | VARCHAR2(70) | YES | ||
LN_1_ADR | VARCHAR2(30) | YES | ||
LN_2_ADR | VARCHAR2(30) | YES | ||
LN_3_ADR | VARCHAR2(30) | YES | ||
CITY_NAME | VARCHAR2(30) | YES | ||
MAIL_STATE_DC | VARCHAR2(30) | YES | ||
POSTAL_CD | VARCHAR2(30) | YES | ||
SS_ER_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
SS_ER_TXBL_AMT | NUMBER(17, 2) | NO | ||
MDCR_ER_EXMPT_PT_AMT | NUMBER(17, 2) | NO | ||
MDCR_ER_TXBL_AMT | NUMBER(17, 2) | NO | ||
SS_DFRD_REPAY_FL | VARCHAR2(1) | YES |
EMPL_PAYROLL Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0586 | PrimaryKey | EMPL_ID, S_PAYCHK_TYPE |
EMPL_PAYROLL 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 | F09120 | EMPL_ID | NO | NO | NO | ||
TAXBLE_ENTITY | Non-Identifying | Zero or One to Zero or More | F09972 | TAXBLE_ENTITY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EMPL_PR_PAY_TYPE | Identifying | One To Zero or More | F09121 | NO | NO | NO | |||
EMPL_PR_WC | Identifying | One To Zero or More | F09122 | NO | NO | NO | |||
EMPL_PR_DED | Identifying | One To Zero or More | F09123 | NO | NO | NO | |||
EMPL_PR_CNTRB | Identifying | One To Zero or More | F09124 | NO | NO | NO | |||
EMPL_PR_LOCAL | Identifying | One To Zero or More | F09158 | NO | NO | NO | |||
EMPL_PR_PROJ | Identifying | One To Zero or More | F21368 | NO | NO | NO | |||
EMPL_PR_FRNG_DETL | Identifying | One To Zero or More | F21370 | NO | NO | NO | |||
EMPL_PR_TS_INFO | Identifying | One To Zero or More | F21434 | NO | NO | NO | |||
EMPL_PR_STATE | Identifying | One To Zero or More | F21770 | NO | NO | NO | |||
EMPL_PR_PAYSTUB_HRLY_RATES | Identifying | One To Zero or More | FK_EMPL_PR_PYST_HRLY_RT_ES_IDX | NO | NO | NO |