Wiki: P 2 K_PR_PAY

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

User Fields: Not Allowed
Audit Logging: Not Allowed

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