P 2 K_PR_PAY_LINES
Back to current versionRestore this version

Alias: PPL#

(P2K_PR_PAY_LINES)

Unique Keys:
Child Table: P2K_PR_PAY_LINE_DETAILS
Parent Table:
ERD: ERD-PR55


Pay Lines

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPH_IDNumber(10)IDYlink to P2K_PR_PAY_HEADERS
AAL_IDNumber(10)ID link to P2K_AT_LEAVE_LINES
BBL_IDNumber(10)ID link to P2K_BE_BENEFIT_LINES
PPCR_IDNumber(10)ID link to P2K_PR_PC_RULES
PSL_IDNumber(10)ID link to P2K_PR_SUNDRY_LINES
ALPT_IDNumber(10)ID link to P2K_AT_LEAVE_POLICY_TYPES
BPN_IDNumber(10)ID link to P2K_BE_PLAN_DEFINITIONS
MUC_IDNumber(10)ID link to P2K_AM_USER_CALCS
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
PPC_IDNumber(10)ID link to P2K_PR_PAY_COMPONENTS
DJB_IDNumber(10)ID link to P2K_CM_JOBS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PAY_LINE_STATUSVarchar2(2)X_PAY_LINE_STATUSY
PAY_POINT_TYPEVarchar2(2)X_PAY_POINT_TYPE
PAY_POINT_TASKVarchar2(2)X_PAY_POINT_TASK
PAY_POINT_SEQUENCENumber(5)NUMBER5
START_DATEDate()DATE
END_DATEDate()DATE
JOURNALIZEDVarchar2(1)TOGGLE
POSTED_EXPERIENCEVarchar2(1)TOGGLE
POSTED_CAREER_PLANNINGVarchar2(1)TOGGLE
POSTED_SAFETYVarchar2(1)TOGGLE
POSTED_BENEFITSVarchar2(1)TOGGLE
POSTED_ATTENDANCEVarchar2(1)TOGGLE
WORK_IN_PROCESSVarchar2(1)TOGGLE
AUDITEDVarchar2(1)TOGGLE
TIME_ENTEREDNumber(18)AMT12V6
TIME_BASISVarchar2(2)X_TIME_BASIS
STD_WAGE_RATENumber(18)AMT12V6
STD_WAGE_RATE_BASISVarchar2(2)X_RATE_BASIS
PAY_LINE_SOURCEVarchar2(2)X_PAY_LINE_SOURCE
WCB_CLASSVarchar2(2)X_WCB_CLASS
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
REFERENCE_INFOVarchar2(2000)VARCHAR2000
AUDIT_TEXTVarchar2(4000)VARCHAR4000
DETAIL_GENERATEDVarchar2(1)TOGGLE
RATE_OVERRIDDENVarchar2(1)TOGGLE
ARREARS_COLLECTEDVarchar2(1)TOGGLE
RETRO_PAYVarchar2(1)TOGGLE
WORK_ORDERVarchar2(50)VARCHAR50
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
TRANSACTION_POINTERVarchar2(30)VARCHAR30
REFERENCE_ID_REVERSALNumber(10)NUMBER10
REASON_FOR_TIMEVarchar2(2)X_REASON_FOR_TIME
THIRD_PARTY_TO_DISBURSEVarchar2(1)TOGGLE
AGENCY_CASE_IDENTIFICATIONVarchar2(30)VARCHAR30
DSP_IDNumber(10)ID link to P2K_CM_STATE_PROVINCES
MEX_IDNumber(10)ID link to P2K_CM_STATE_PROVINCES

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page