Alias: PRN#

(P2K_PR_PAY_RUNS)

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

Pay Runs

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DEN_ID	Number(10)	ID	Y	link to P2K_CM_ENTITIES
PAY_RUN_NUMBER	Number(10)	NUMBER10	Y
MUS_ID	Number(10)	ID	Y	link to P2K_AM_USERS
PPA_ID	Number(10)	ID	Y	link to P2K_PR_PAYROLLS
PPTS_ID	Number(10)	ID	Y	link to P2K_PR_PAY_POINT_SETS
PPP_ID	Number(10)	ID	Y	link to P2K_PR_PAY_PERIODS
PPP_ID_FUTURE	Number(10)	ID		link to P2K_PR_PAY_PERIODS
MEX_ID	Number(10)	ID		link to P2K_AM_EXECUTIONS
PAY_RUN_STAGE	Varchar2(2)	X_PAY_RUN_STAGE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PAY_RUN_START_TIMESTAMP	Date()	TIMESTAMP
PAY_RUN_END_TIMESTAMP	Date()	TIMESTAMP
EMPLOYEE_COUNT	Number(5)	NUMBER5
REVERSAL_PAY_COUNT	Number(5)	NUMBER5
ADJUSTMENT_PAY_COUNT	Number(5)	NUMBER5
CURRENT_PAY_COUNT	Number(5)	NUMBER5
FUTURE_PAY_COUNT	Number(5)	NUMBER5
ADVANCE_PAY_COUNT	Number(5)	NUMBER5
BONUS_PAY_COUNT	Number(5)	NUMBER5
RETROACTIVE_PAY_COUNT	Number(5)	NUMBER5
DISBURSED	Varchar2(1)	TOGGLE
TRIAL_RUN	Varchar2(1)	TOGGLE
JOURNALIZED	Varchar2(1)	TOGGLE
JOURNALIZED_FUND	Varchar2(1)	TOGGLE
ADP_SUBMITTED	Varchar2(1)	TOGGLE
MEX_ID_GARNISHMENT	Number(10)	ID		link to P2K_AM_EXECUTIONS

Derived Fields#

Column Name
DRV_UPVENDED_PAY_RUN

User Fields: Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page