Alias: PPH#

(P2K_PR_PAY_HEADERS)

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

Pay Headers

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
EEM_ID	Number(10)	ID	Y	link to P2K_HR_EMPLOYMENTS
PAY_NUMBER	Number(5)	NUMBER5	Y
PPH_ID	Number(10)	ID		link to P2K_PR_PAY_HEADERS
DGR_ID	Number(10)	ID	Y	link to P2K_CM_GROUPS
DSP_ID_HOME	Number(10)	ID	Y	link to P2K_CM_STATE_PROVINCES
DSP_ID_WORK	Number(10)	ID	Y	link to P2K_CM_STATE_PROVINCES
PCT_ID	Number(10)	ID	Y	link to P2K_PR_PAY_CATEGORIES
PPP_ID	Number(10)	ID	Y	link to P2K_PR_PAY_PERIODS
MUS_ID	Number(10)	ID	Y	link to P2K_AM_USERS
PBT_ID	Number(10)	ID	Y	link to P2K_PR_BATCHES
PRN_ID	Number(10)	ID		link to P2K_PR_PAY_RUNS
PPTS_ID	Number(10)	ID		link to P2K_PR_PAY_POINT_SETS
PPA_ID	Number(10)	ID	Y	link to P2K_PR_PAYROLLS
PDS_ID	Number(10)	ID		link to P2K_PR_DISBURSEMENTS
DSD_ID	Number(10)	ID		link to P2K_CM_SCHOOL_DISTRICTS
DTX_ID_HOME	Number(10)	ID		link to P2K_CM_TAX_JURISDICTIONS
DTX_ID_WORK	Number(10)	ID		link to P2K_CM_TAX_JURISDICTIONS
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
AUDITED	Varchar2(1)	TOGGLE
CHECK_NUMBER	Number(10)	NUMBER10
FINAL_PAY_METHOD	Varchar2(2)	X_FINAL_PAY_METHOD
FIRST_PAY_IN_MONTH	Varchar2(1)	TOGGLE
FIRST_PAY_IN_PERIOD	Varchar2(1)	TOGGLE
HAND_CHECK	Varchar2(1)	TOGGLE
PAY_BY_CHECK	Varchar2(2)	X_PAY_BY_METHOD
PAY_HEADER_SOURCE	Varchar2(2)	X_PAY_HEADER_SOURCE
PAY_HEADER_STAGE	Varchar2(2)	X_PAY_HEADER_STAGE
PAY_RUN_SEQUENCE	Number(5)	NUMBER5
POSTED_BENEFITS	Varchar2(1)	TOGGLE
POSTED_ATTENDANCE	Varchar2(1)	TOGGLE
QUICK_PAY	Varchar2(1)	TOGGLE
TAX_WEEKS	Number(18)	AMT12V6
TIMESHEET_RETURNED	Varchar2(1)	TOGGLE
CHECK_AMOUNT	Number(18)	AMT12V2
PAY_ISSUE_DATE	Date()	DATE
SUNDRY_ATTACHED	Varchar2(1)	TOGGLE
JOURNALIZED	Varchar2(1)	TOGGLE
TRACE_LEVEL	Varchar2(1)	X_TRACE_LEVEL
PROCESS_NUMBER	Number(5)	NUMBER5
EAS_ID	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS
JOURNALIZED_FUND	Varchar2(1)	TOGGLE
POSTED_RETIREMENT	Varchar2(1)	TOGGLE
FLSA_AUDIT_TEXT	VARCHAR2(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