!!!Alias: IVPPL The INF_CV_SUNDRYLINES table is used to import pay transactions into the software data structures. !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[PERSON_CODE]|Varchar2(16)|[CODE]|Y| |[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[HIRE_DATE]|Date()|[DATE]| | |[PAY_NUMBER]|Number(5)|[NUMBER5|NUMBERn]|Y| |[PAY_LINE_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[UNIT_CODE]|Varchar2(16)|[CODE]| | |[GROUP_CODE]|Varchar2(16)|[CODE]| | |[LEAVE_TYPE_CODE]|Varchar2(16)|[CODE]| | |[PLAN_CODE]|Varchar2(16)|[CODE]| | |[USER_CALC_CODE]|Varchar2(16)|[CODE]| | |[JOB_CODE]|Varchar2(16)|[CODE]| | |[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| | |[POSITION_CODE]|Varchar2(16)|[CODE]| | |[ASSIGNMENT_START_DATE]|Date()|[DATE]| | |[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y| |[PC_CODE_HEADER]|Number(4)|[CODE NUMERIC]| | |[COUNTRY_CODE]|Varchar2(16)|[CODE]| | |[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| | |[GEO_CODE]|Varchar2(16)|[CODE]| | |[PAY_POINT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PAY_POINT_TASK]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PAY_POINT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[START_DATE]|Date()|[DATE]| | |[END_DATE]|Date()|[DATE]| | |[JOURNALIZED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSTED_EXPERIENCE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSTED_CAREER_PLANNING]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSTED_SAFETY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSTED_BENEFITS]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[POSTED_ATTENDANCE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[WORK_IN_PROCESS]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[AUDITED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[TIME_ENTERED]|Number(18)|[AMT12V6|AMTnn]| | |[TIME_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[STD_WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[STD_WAGE_RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PAY_LINE_SOURCE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[WCB_CLASS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[REFERENCE_INFO]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[DETAIL_GENERATED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[RATE_OVERRIDDEN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[AUDIT_TEXT_HEADER]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[ARREARS_COLLECTED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[RETRO_PAY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[WORK_ORDER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[CONTRACT_CALENDAR_CODE]|Varchar2(16)|[CODE]| | |[TRANSACTION_POINTER_HEADER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[REASON_FOR_TIME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PC_CODE_DETAIL]|Number(4)|[CODE NUMERIC]| | |[ELEMENT_CODE]|Varchar2(16)|[CODE]| | |[USER_VARIABLE_CODE]|Varchar2(16)|[CODE]| | |[PREMIUM_CODE]|Varchar2(16)|[CODE]| | |[PAY_LINE_DETAIL_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PC_ACTION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PC_DETAIL_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PC_CALC_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[WAGE_RATE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[RATE_BASIS_OVERRIDE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[AMOUNT_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[AMOUNT_PROCESSED]|Number(18)|[AMT12V6|AMTnn]| | |[USER_VARIABLE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[DISTRIBUTION_DR_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[DISTRIBUTION_CR_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[PC_RATE_SOURCE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[HIGHER_OF_RATE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[RETRO_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[AUDIT_TEXT_DETAILS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[STAT_CODE]|Varchar2(16)|[CODE]| | |[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]| | |[JOURNALIZED_BY]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[WC_REGIST_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[WCB_CLASS_DETAILS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ENTERED_VALUE]|Number(18)|[AMT12V6|AMTnn]| | |[ENTERED_VALUE_SOURCE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[TRANSACTION_POINTER_DETAILS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |