Alias: PLPL#

(P2K_PR_LOADED_PAY_LINES)

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

Loaded Pay Lines

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
ENTITY_CODE	Varchar2(16)	CODE	Y
EMPLOYMENT_TYPE	Varchar2(2)	X_EMPLOYMENT_TYPE	Y
CATEGORY_CODE	Varchar2(16)	CODE	Y
PERSON_CODE	Varchar2(16)	CODE
GOVERNMENT_CODE	Varchar2(16)	GOVERNMENT CODE
START_DATE	Date()	DATE	Y
END_DATE	Date()	DATE
PAY_PERIOD	Number(10)	NUMBER10
TIME_CODE	Varchar2(16)	CODE
PC_CODE	Number(4)	CODE NUMERIC
TIME_OR_AMOUNT	Number(18)	AMT12V6
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
POSITION_CODE	Varchar2(16)	CODE
JOB_CODE	Varchar2(16)	CODE
DEPARTMENT_CODE	Varchar2(16)	CODE
BATCH_CODE	Varchar2(16)	CODE
PREMIUM_CODE1	Varchar2(16)	CODE
PREMIUM_CODE2	Varchar2(16)	CODE
PREMIUM_CODE3	Varchar2(16)	CODE
DISTRIBUTION_MASK	Varchar2(50)	DISTRIBUTION
COST_CENTER_CODE	Varchar2(16)	CODE
WORK_IN_PROCESS	Varchar2(1)	TOGGLE
REFERENCE_INFO	Varchar2(2000)	VARCHAR2000
SOURCE_REFERENCE	Varchar2(50)	VARCHAR50
REASON_FOR_TIME	Varchar2(2)	X_REASON_FOR_TIME
LEAVE_REASON	Varchar2(2)	X_LEAVE_REASON
DESTINATION_TYPE	Varchar2(2)	X_DESTINATION_TYPE
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
BATCH_NUMBER	Number(10)	NUMBER10
UPTL_STATUS	Varchar2(2)	X_UPTL_STATUS
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
WORK_ORDER	Varchar2(50)	VARCHAR50
TRANSACTION_POINTER	Varchar2(30)	VARCHAR30
ASSIGNMENT_CODE	Varchar2(16)	CODE
UNIT_CODE	Varchar2(16)	CODE
WORK_RULE (Field)	Varchar2(16)	CODE
GROUP_CODE	VARCHAR2(16)	CODE

Derived Fields#

Column Name
DRV_ID

User Fields: Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page