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 name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
PPH_ID	Number(10)	ID	Y	link to P2K_PR_PAY_HEADERS
AAL_ID	Number(10)	ID		link to P2K_AT_LEAVE_LINES
BBL_ID	Number(10)	ID		link to P2K_BE_BENEFIT_LINES
PPCR_ID	Number(10)	ID		link to P2K_PR_PC_RULES
PSL_ID	Number(10)	ID		link to P2K_PR_SUNDRY_LINES
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
PPC_ID	Number(10)	ID		link to P2K_PR_PAY_COMPONENTS
DJB_ID	Number(10)	ID		link to P2K_CM_JOBS
DDP_ID	Number(10)	ID		link to P2K_CM_DEPARTMENTS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
EAS_ID	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PAY_LINE_STATUS	Varchar2(2)	X_PAY_LINE_STATUS	Y
PAY_POINT_TYPE	Varchar2(2)	X_PAY_POINT_TYPE
PAY_POINT_TASK	Varchar2(2)	X_PAY_POINT_TASK
PAY_POINT_SEQUENCE	Number(5)	NUMBER5
START_DATE	Date()	DATE
END_DATE	Date()	DATE
JOURNALIZED	Varchar2(1)	TOGGLE
POSTED_EXPERIENCE	Varchar2(1)	TOGGLE
POSTED_CAREER_PLANNING	Varchar2(1)	TOGGLE
POSTED_SAFETY	Varchar2(1)	TOGGLE
POSTED_BENEFITS	Varchar2(1)	TOGGLE
POSTED_ATTENDANCE	Varchar2(1)	TOGGLE
WORK_IN_PROCESS	Varchar2(1)	TOGGLE
AUDITED	Varchar2(1)	TOGGLE
TIME_ENTERED	Number(18)	AMT12V6
TIME_BASIS	Varchar2(2)	X_TIME_BASIS
STD_WAGE_RATE	Number(18)	AMT12V6
STD_WAGE_RATE_BASIS	Varchar2(2)	X_RATE_BASIS
PAY_LINE_SOURCE	Varchar2(2)	X_PAY_LINE_SOURCE
WCB_CLASS	Varchar2(2)	X_WCB_CLASS
DISTRIBUTION_MASK	Varchar2(50)	DISTRIBUTION
REFERENCE_INFO	Varchar2(2000)	VARCHAR2000
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
DETAIL_GENERATED	Varchar2(1)	TOGGLE
RATE_OVERRIDDEN	Varchar2(1)	TOGGLE
ARREARS_COLLECTED	Varchar2(1)	TOGGLE
RETRO_PAY	Varchar2(1)	TOGGLE
WORK_ORDER	Varchar2(50)	VARCHAR50
DCC_ID	Number(10)	ID		link to P2K_CM_COST_CENTERS
TRANSACTION_POINTER	Varchar2(30)	VARCHAR30
REFERENCE_ID_REVERSAL	Number(10)	NUMBER10
REASON_FOR_TIME	Varchar2(2)	X_REASON_FOR_TIME
THIRD_PARTY_TO_DISBURSE	Varchar2(1)	TOGGLE
AGENCY_CASE_IDENTIFICATION	Varchar2(30)	VARCHAR30
DSP_ID	Number(10)	ID		link to P2K_CM_STATE_PROVINCES
MEX_ID	Number(10)	ID		link to P2K_AM_EXECUTIONS
DEPENDANT_MEDICAL_COVERAGE	Varchar2(1)	TOGGLE
LIEN_DEDUCTION	Varchar2(2)	X_LIEN_DEDUCTION
EXTERNAL_DOCUMENT_ID	Varchar2(16)	VARCHAR16

User Fields: Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page