Alias: PPLD#

(P2K_PR_PAY_LINE_DETAILS)

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

Pay Line Details

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
PPL_ID	Number(10)	ID	Y	link to P2K_PR_PAY_LINES
PEL_ID	Number(10)	ID		link to P2K_PR_ELEMENTS
MVR_ID	Number(10)	ID		link to P2K_AM_USER_VARIABLES
SPM_ID	Number(10)	ID		link to P2K_SA_PREMIUMS
DSC_ID	Number(10)	ID		link to P2K_CM_STATISTIC_COMPONENTS
PAY_LINE_DETAIL_STATUS	Varchar2(2)	X_PAY_LINE_DETAIL_STATUS	Y
PC_ACTION	Varchar2(1)	X_PC_ACTION	Y
PC_DETAIL_TYPE	Varchar2(2)	X_PC_DETAIL_TYPE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PC_CALC_METHOD	Varchar2(2)	X_PC_CALC_METHOD
DESCRIPTION	Varchar2(50)	DESCRIPTION
WAGE_RATE	Number(18)	AMT12V6
WAGE_RATE_OVERRIDE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
RATE_BASIS_OVERRIDE	Varchar2(2)	X_RATE_BASIS
AMOUNT	Number(18)	AMT12V6
AMOUNT_OVERRIDE	Number(18)	AMT12V6
AMOUNT_PROCESSED	Number(18)	AMT12V6
RETRO_AMOUNT	Number(18)	AMT12V6
USER_VARIABLE_OVERRIDE	Number(18)	AMT12V6
DISTRIBUTION_CR_MASK	Varchar2(50)	DISTRIBUTION
PC_RATE_SOURCE	Varchar2(2)	X_PC_RATE_SOURCE
HIGHER_OF_RATE	Varchar2(1)	X_HIGHER_OF_RATE
DISTRIBUTION_DR_MASK	Varchar2(50)	DISTRIBUTION
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
REFERENCE_ID	Number(10)	NUMBER10
JOURNALIZED_BY	Varchar2(2)	X_JOURNALIZED_BY
PWCC_ID	Number(10)	ID		link to P2K_PR_WC_CLASSES
ENTERED_VALUE	Number(18)	AMT12V6
ENTERED_VALUE_SOURCE	Varchar2(50)	VARCHAR50
TRANSACTION_POINTER	Varchar2(30)	VARCHAR30
REFERENCE_ID_HOD	Number(10)	NUMBER10
REFERENCE_ID_REVERSAL	Number(10)	NUMBER10
VARIABLE_RATE	NUMBER(18,6)	AMT12V6
PREMIUM_AUDIT_TEXT	VARCHAR2(4000)	VARCHAR4000
VARIABLE_RATE_AUDIT_TEXT	VARCHAR2(4000)	VARCHAR4000
SALARY_RATE_METHOD	VARCHAR2(2)	X_SALARY_RATE_METHOD

Derived Fields#

Column Name
DRV_PAY_AUDIT_AMOUNT
DRV_PAY_AUDIT_DESCRIPTION
DRV_PAY_AUDIT_DESCRIPTION

User Fields: Not Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page