!!!Alias: [IVPPL] (INF_CV_PAYLINES) The INF_CV_PAYLINES table is used to import pay lines into the software data structures. Tables loaded: [P2K_PR_PAY_LINES] !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[ENTITY_CODE]|Varchar2(16)|Y| |[PERSON_CODE]|Varchar2(16)|Y| |[EMPLOYMENT_TYPE]|Varchar2(30)| | |[HIRE_DATE]|Date()| | |[PAY_NUMBER]|Number(5)|Y| |[PAY_LINE_STATUS]|Varchar2(30)|Y| |[UNIT_CODE]|Varchar2(16)| | |[GROUP_CODE]|Varchar2(16)| | |[LEAVE_TYPE_CODE]|Varchar2(16)| | |[PLAN_CODE]|Varchar2(16)| | |[USER_CALC_CODE]|Varchar2(16)| | |[JOB_CODE]|Varchar2(16)| | |[DEPARTMENT_CODE]|Varchar2(16)| | |[POSITION_CODE]|Varchar2(16)| | |[ASSIGNMENT_START_DATE]|Date()| | |[ASSIGNMENT_CODE]|Varchar2(16)|Y| |[PC_CODE_HEADER]|Number(4)| | |[COUNTRY_CODE]|Varchar2(16)| | |[STATE_PROVINCE_CODE]|Varchar2(16)| | |[GEO_CODE]|Varchar2(16)| | |[PAY_POINT_TYPE]|Varchar2(30)| | |[PAY_POINT_TASK]|Varchar2(30)| | |[PAY_POINT_SEQUENCE]|Number(5)| | |[START_DATE]|Date()| | |[END_DATE]|Date()| | |[JOURNALIZED]|Varchar2(4)| | |[POSTED_EXPERIENCE]|Varchar2(4)| | |[POSTED_CAREER_PLANNING]|Varchar2(4)| | |[POSTED_SAFETY]|Varchar2(4)| | |[POSTED_BENEFITS]|Varchar2(4)| | |[POSTED_ATTENDANCE]|Varchar2(4)| | |[WORK_IN_PROCESS]|Varchar2(4)| | |[AUDITED]|Varchar2(4)| | |[TIME_ENTERED]|Number(18)| | |[TIME_BASIS]|Varchar2(30)| | |[STD_WAGE_RATE]|Number(18)| | |[STD_WAGE_RATE_BASIS]|Varchar2(30)| | |[PAY_LINE_SOURCE]|Varchar2(30)| | |[WCB_CLASS]|Varchar2(30)| | |[DISTRIBUTION_MASK]|Varchar2(50)| | |[REFERENCE_INFO]|Varchar2(50)| | |[DETAIL_GENERATED]|Varchar2(4)| | |[RATE_OVERRIDDEN]|Varchar2(4)| | |[AUDIT_TEXT_HEADER]|Varchar2(4000)| | |[ARREARS_COLLECTED]|Varchar2(4)| | |[RETRO_PAY]|Varchar2(4)| | |[WORK_ORDER]|Varchar2(50)| | |[CONTRACT_CALENDAR_CODE]|Varchar2(16)| | |[TRANSACTION_POINTER_HEADER]|Varchar2(30)| | |[REASON_FOR_TIME]|Varchar2(30)| | |[PC_CODE_DETAIL]|Number(4)| | |[ELEMENT_CODE]|Varchar2(16)| | |[USER_VARIABLE_CODE]|Varchar2(16)| | |[PREMIUM_CODE]|Varchar2(16)| | |[PAY_LINE_DETAIL_STATUS]|Varchar2(30)| | |[PC_ACTION]|Varchar2(30)| | |[PC_DETAIL_TYPE]|Varchar2(30)| | |[PC_CALC_METHOD]|Varchar2(30)| | |[DESCRIPTION]|Varchar2(50)| | |[WAGE_RATE]|Number(18)| | |[WAGE_RATE_OVERRIDE]|Number(18)| | |[RATE_BASIS]|Varchar2(30)| | |[RATE_BASIS_OVERRIDE]|Varchar2(30)| | |[AMOUNT]|Number(18)| | |[AMOUNT_OVERRIDE]|Number(18)| | |[AMOUNT_PROCESSED]|Number(18)| | |[USER_VARIABLE_OVERRIDE]|Number(18)| | |[DISTRIBUTION_DR_MASK]|Varchar2(50)| | |[DISTRIBUTION_CR_MASK]|Varchar2(50)| | |[PC_RATE_SOURCE]|Varchar2(30)| | |[HIGHER_OF_RATE]|Varchar2(4)| | |[RETRO_AMOUNT]|Number(18)| | |[AUDIT_TEXT_DETAILS]|Varchar2(4000)| | |[STAT_CODE]|Varchar2(16)| | |[REFERENCE_ID]|Number(10)| | |[JOURNALIZED_BY]|Varchar2(30)| | |[WC_REGIST_TYPE]|Varchar2(30)| | |[WCB_CLASS_DETAILS]|Varchar2(30)| | |[ENTERED_VALUE]|Number(18)| | |[ENTERED_VALUE_SOURCE]|Varchar2(50)| | |[TRANSACTION_POINTER_DETAILS]|Varchar2(30)| | |[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. ---- ![Notes|Edit:Internal.INF_CV_PAYLINES] [{InsertPage page='Internal.INF_CV_PAYLINES' default='Click to create a new notes page'}]