Alias: PEP#

(P2K_PR_EXT_PAY_LINES)

Unique Keys:
Child Table:
Parent Table:

P2K_PR_EXT_PAY_LINES table has been created for third party systems like Cayenta to insert information into as they do not have all of the information required to insert directly into the P2K_PR_LOADED_PAY_LINES.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
COLLECTION_CODE	Varchar2(16)	CODE	Y
LINE_NUMBER	Number(5)	NUMBER5	Y
USER_NAME	Varchar2(30)	VARCHAR30	Y
LINE_STATUS	Varchar2(2)	X_UPTL_STATUS
SOURCE_REFERENCE	Varchar2(50)	VARCHAR50
ENTITY_CODE	Varchar2(16)	CODE
EMPLOYMENT_TYPE	Varchar2(2)	X_EMPLOYMENT_TYPE
CATEGORY_CODE	Varchar2(16)	CODE
PERSON_CODE	Varchar2(16)	CODE
GOVERNMENT_CODE	Varchar2(16)	GOVERNMENT CODE
START_DATE	Date()	DATE
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
ASSIGNMENT_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
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
TRANSACTION_POINTER	Varchar2(30)	VARCHAR30
WORK_ORDER	Varchar2(50)	VARCHAR50
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y

User Fields: Not Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page