P 2 K_PR_SUNDRY_LINES
Back to current versionRestore this version

Alias: PSL#

(P2K_PR_SUNDRY_LINES)

Unique Keys:
Child Table: P2K_PR_SUNDRY_LINE_DETAILS
Parent Table:
ERD: ERD-PR40


Sundry Lines

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPC_IDNumber(10)IDYlink to P2K_PR_PAY_COMPONENTS
PFQ_IDNumber(10)IDYlink to P2K_PR_FREQUENCIES
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
PPCR_IDNumber(10)ID link to P2K_PR_PC_RULES
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DJB_IDNumber(10)ID link to P2K_CM_JOBS
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
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
SUNDRY_LINE_TYPEVarchar2(2)X_SUNDRY_LINE_TYPEY
START_DATEDate()DATEY
END_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
TIMES_REMAININGNumber(5)NUMBER5
PAY_POINT_TYPEVarchar2(2)X_PAY_POINT_TYPE
PAY_POINT_TASKVarchar2(2)X_PAY_POINT_TASK
PAY_POINT_SEQUENCENumber(5)NUMBER5
TIME_ENTEREDNumber(18)AMT12V6
TIME_BASISVarchar2(2)X_TIME_BASIS
WCB_CLASSVarchar2(2)X_WCB_CLASS
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
REFERENCE_INFOVarchar2(2000)VARCHAR2000
AUDIT_TEXTVarchar2(4000)VARCHAR4000
WORK_ORDERVarchar2(50)VARCHAR50
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
INCOME_PRORATIONVarchar2(1)TOGGLE
DCL_IDNumber(10)ID link to P2K_CM_CALENDARS
SUNDRY_STATUSVarchar2(2)X_SUNDRY_STATUS
SUNDRY_STATUSVarchar2(2)X_SUNDRY_STATUS

User Fields: Allowed
Audit Logging: 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