P 2 K_PR_PAY_LINES

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_AM_EXECUTIONS
DEPENDANT_MEDICAL_COVERAGEVarchar2(1)TOGGLE
LIEN_DEDUCTIONVarchar2(2)X_LIEN_DEDUCTION
EXTERNAL_DOCUMENT_IDVarchar2(16)VARCHAR16

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