P 2 K_PR_PAY_HEADERS

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
POSTED_RETIREMENTVarchar2(1)TOGGLE
FLSA_AUDIT_TEXTVARCHAR2(4000) VARCHAR4000

Derived Fields#

Column Name
DRV_PAY_RUN_SEQUENCE_NUMBER

User Fields: Not Allowed
Audit Logging: Not Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation