Wiki: P 2 K_PR_PAY

Alias: PRN#

Unique Keys: _
Child Table: _
Parent Table: _

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

User Fields: 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