Wiki: P 2 K_PR_SUNDRY

Alias: PSL#

(P2K_PR_SUNDRY_LINES)

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

Sundry Lines

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

User Fields: Allowed
Audit Logging: Allowed