Alias: IVPPL#
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. |
