!!!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|NUMBERn]|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|VARCHARnn]|Y| 
|[CHANGE_DATE]|Date()|[DATE]|Y| 
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[PAY_RUN_START_TIMESTAMP]|Date()|[TIMESTAMP]| | 
|[PAY_RUN_END_TIMESTAMP]|Date()|[TIMESTAMP]| | 
|[EMPLOYEE_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[REVERSAL_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[ADJUSTMENT_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[CURRENT_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[FUTURE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[ADVANCE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[BONUS_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[RETROACTIVE_PAY_COUNT]|Number(5)|[NUMBER5|NUMBERn]| | 
|[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|DERIVED FIELDS]
||Column Name
|[DRV_UPVENDED_PAY_RUN]

User Fields: Allowed\\
Audit Logging: Not Allowed\\


----
![Notes|Edit:Internal.P2K_PR_PAY_RUNS] 	
[{InsertPage page='Internal.P2K_PR_PAY_RUNS' default='Click to create a new notes page'}]