Wiki: P 2 K_PR_SUNDRY

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 name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
PPC_ID	Number(10)	ID	Y	link to P2K_PR_PAY_COMPONENTS
PFQ_ID	Number(10)	ID	Y	link to P2K_PR_FREQUENCIES
EEM_ID	Number(10)	ID	Y	link to P2K_HR_EMPLOYMENTS
PPCR_ID	Number(10)	ID		link to P2K_PR_PC_RULES
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
DJB_ID	Number(10)	ID		link to P2K_CM_JOBS
ALPT_ID	Number(10)	ID		link to P2K_AT_LEAVE_POLICY_TYPES
BPN_ID	Number(10)	ID		link to P2K_BE_PLAN_DEFINITIONS
MUC_ID	Number(10)	ID		link to P2K_AM_USER_CALCS
DTX_ID	Number(10)	ID		link to P2K_CM_TAX_JURISDICTIONS
EAS_ID	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS
SUNDRY_LINE_TYPE	Varchar2(2)	X_SUNDRY_LINE_TYPE	Y
START_DATE	Date()	DATE	Y
END_DATE	Date()	DATE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
TIMES_REMAINING	Number(5)	NUMBER5
PAY_POINT_TYPE	Varchar2(2)	X_PAY_POINT_TYPE
PAY_POINT_TASK	Varchar2(2)	X_PAY_POINT_TASK
PAY_POINT_SEQUENCE	Number(5)	NUMBER5
TIME_ENTERED	Number(18)	AMT12V6
TIME_BASIS	Varchar2(2)	X_TIME_BASIS
WCB_CLASS	Varchar2(2)	X_WCB_CLASS
DISTRIBUTION_MASK	Varchar2(50)	DISTRIBUTION
REFERENCE_INFO	Varchar2(2000)	VARCHAR2000
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
WORK_ORDER	Varchar2(50)	VARCHAR50
DCC_ID	Number(10)	ID		link to P2K_CM_COST_CENTERS
INCOME_PRORATION	Varchar2(1)	TOGGLE
DCL_ID	Number(10)	ID		link to P2K_CM_CALENDARS
THIRD_PARTY_TO_DISBURSE	Varchar2(2)	TOGGLE
PAID_TO_ORDER_OF	Varchar2(30)	VARCHAR30
PAYMENT_SCHEDULE_TYPE	Varchar2(2)	X_PAYMENT_SCHEDULE_TYPE
PAYMENT_SCHEDULE_ACCRUING	Varchar2(16)	VARCHAR16
MEMORANDUM_1	Varchar2(50)	VARCHAR50
MEMORANDUM_2	Varchar2(50)	VARCHAR50
AGENCY_CASE_IDENTIFICATION	Varchar2(30)	VARCHAR30
DSP_ID	Number(10)	ID	Y	link to P2K_CM_STATE_PROVINCES
DEPENDANT_MEDICAL_COVERAGE	Varchar2(2)	TOGGLE
LIEN_DEDUCTION	Varchar2(2)	X_LIEN_DEDUCTION
EXTERNAL_DOCUMENT_ID	Varchar2(16)	VARCHAR16
LIEN_NUMBER	Number(5)	NUMBER5
EID_ID_PAYEE	Number(10)	NUMBER5
SUNDRY_STATUS	Varchar2(2)	X_SUNDRY_STATUS
Pph_ID	Number(10)	ID	Y	link to P2K_PR_PAY_HEADERS for Arrears

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page