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
THIRD_PARTY_TO_DISBURSEVarchar2(2)TOGGLE
PAID_TO_ORDER_OFVarchar2(30)VARCHAR30
PAYMENT_SCHEDULE_TYPEVarchar2(2)X_PAYMENT_SCHEDULE_TYPE
PAYMENT_SCHEDULE_ACCRUINGVarchar2(16)VARCHAR16
MEMORANDUM_1Varchar2(50)VARCHAR50
MEMORANDUM_2Varchar2(50)VARCHAR50
AGENCY_CASE_IDENTIFICATIONVarchar2(30)VARCHAR30
DSP_IDNumber(10)IDYlink to P2K_PR_PAY_COMPONENTS
DEPENDANT_MEDICAL_COVERAGEVarchar2(2)TOGGLE

SUNDRY_STATUSVarchar2(2)X_SUNDRY_STATUS

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page
This particular version was published on 26-Nov-2021 10:22 by jmyers.Top