!!!Alias: PLPL Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ 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|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]| | |[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]| | |[SOURCE_REFERENCE]|Varchar2(50)|[VARCHAR50|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]| | |[UPTL_STATUS]|Varchar2(2)|[X_UPTL_STATUS]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[WORK_ORDER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[TRANSACTION_POINTER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]| | |[UNIT_CODE]|Varchar2(16)|[CODE]| | |[WORK_RULE_CODE]|Varchar2(16)|[CODE]| | User Fields: Allowed\\ Audit Logging: Not Allowed\\