Alias: PPH#

(P2K_PR_PAY_HEADERS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR55


Pay Headers

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
PAY_NUMBERNumber(5)NUMBER5Y
PPH_IDNumber(10)ID link to P2K_PR_PAY_HEADERS
DGR_IDNumber(10)IDYlink to P2K_CM_GROUPS
DSP_ID_HOMENumber(10)IDYlink to P2K_CM_STATE_PROVINCES
DSP_ID_WORKNumber(10)IDYlink to P2K_CM_STATE_PROVINCES
PCT_IDNumber(10)IDYlink to P2K_PR_PAY_CATEGORIES
PPP_IDNumber(10)IDYlink to P2K_PR_PAY_PERIODS
MUS_IDNumber(10)IDYlink to P2K_AM_USERS
PBT_IDNumber(10)IDYlink to P2K_PR_BATCHES
PRN_IDNumber(10)ID link to P2K_PR_PAY_RUNS
PPTS_IDNumber(10)ID link to P2K_PR_PAY_POINT_SETS
PPA_IDNumber(10)IDYlink to P2K_PR_PAYROLLS
PDS_IDNumber(10)ID link to P2K_PR_DISBURSEMENTS
DSD_IDNumber(10)ID link to P2K_CM_SCHOOL_DISTRICTS
DTX_ID_HOMENumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
DTX_ID_WORKNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
AUDITEDVarchar2(1)TOGGLE
CHECK_NUMBERNumber(10)NUMBER10
FINAL_PAY_METHODVarchar2(2)X_FINAL_PAY_METHOD
FIRST_PAY_IN_MONTHVarchar2(1)TOGGLE
FIRST_PAY_IN_PERIODVarchar2(1)TOGGLE
HAND_CHECKVarchar2(1)TOGGLE
PAY_BY_CHECKVarchar2(2)X_PAY_BY_METHOD
PAY_HEADER_SOURCEVarchar2(2)X_PAY_HEADER_SOURCE
PAY_HEADER_STAGEVarchar2(2)X_PAY_HEADER_STAGE
PAY_RUN_SEQUENCENumber(5)NUMBER5
POSTED_BENEFITSVarchar2(1)TOGGLE
POSTED_ATTENDANCEVarchar2(1)TOGGLE
QUICK_PAYVarchar2(1)TOGGLE
TAX_WEEKSNumber(18)AMT12V6
TIMESHEET_RETURNEDVarchar2(1)TOGGLE
CHECK_AMOUNTNumber(18)AMT12V2
PAY_ISSUE_DATEDate()DATE
SUNDRY_ATTACHEDVarchar2(1)TOGGLE
JOURNALIZEDVarchar2(1)TOGGLE
TRACE_LEVELVarchar2(1)X_TRACE_LEVEL
PROCESS_NUMBERNumber(5)NUMBER5
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
JOURNALIZED_FUNDVarchar2(1)TOGGLE

User Fields: Not Allowed
Audit Logging: Not Allowed

This particular version was published on 26-Nov-2021 10:22 by JEscott.Top