!!!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|NUMBERn]|Y| 
|[USER_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[LINE_STATUS]|Varchar2(2)|[X_UPTL_STATUS]| | 
|[SOURCE_REFERENCE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | 
|[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|NUMBERn]| | 
|[TIME_CODE]|Varchar2(16)|[CODE]| | 
|[PC_CODE]|Number(4)|[CODE NUMERIC]| | 
|[TIME_OR_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | 
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | 
|[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|VARCHARnn]| | 
|[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|VARCHARnn]| | 
|[BATCH_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | 
|[TRANSACTION_POINTER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | 
|[WORK_ORDER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | 
|[CREATE_DATE]|Date()|[DATE]|Y| 
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[CHANGE_DATE]|Date()|[DATE]|Y| 
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 

User Fields: Not Allowed\\
Audit Logging: Not Allowed\\


----
![Notes|Edit:Internal.P2K_PR_EXT_PAY_LINES] 	
[{InsertPage page='Internal.P2K_PR_EXT_PAY_LINES' default='Click to create a new notes page'}]