P 2 K_PR_PAY_RUNS
Back to current versionRestore this version

Alias: PRN#

(P2K_PR_PAY_RUNS)

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


Pay Runs

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
PAY_RUN_NUMBERNumber(10)NUMBER10Y
MUS_IDNumber(10)IDYlink to P2K_AM_USERS
PPA_IDNumber(10)IDYlink to P2K_PR_PAYROLLS
PPTS_IDNumber(10)IDYlink to P2K_PR_PAY_POINT_SETS
PPP_IDNumber(10)IDYlink to P2K_PR_PAY_PERIODS
PPP_ID_FUTURENumber(10)ID link to P2K_PR_PAY_PERIODS
MEX_IDNumber(10)ID link to P2K_AM_EXECUTIONS
PAY_RUN_STAGEVarchar2(2)X_PAY_RUN_STAGEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PAY_RUN_START_TIMESTAMPDate()TIMESTAMP
PAY_RUN_END_TIMESTAMPDate()TIMESTAMP
EMPLOYEE_COUNTNumber(5)NUMBER5
REVERSAL_PAY_COUNTNumber(5)NUMBER5
ADJUSTMENT_PAY_COUNTNumber(5)NUMBER5
CURRENT_PAY_COUNTNumber(5)NUMBER5
FUTURE_PAY_COUNTNumber(5)NUMBER5
ADVANCE_PAY_COUNTNumber(5)NUMBER5
BONUS_PAY_COUNTNumber(5)NUMBER5
RETROACTIVE_PAY_COUNTNumber(5)NUMBER5
DISBURSEDVarchar2(1)TOGGLE
TRIAL_RUNVarchar2(1)TOGGLE
JOURNALIZEDVarchar2(1)TOGGLE
JOURNALIZED_FUNDVarchar2(1)TOGGLE

Derived Fields#

Column Name
DRV_UPVENDED_PAY_RUN

User Fields: Allowed
Audit Logging: Not Allowed

Notes #

Click to create a new notes page

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

All content © High Line Corporation