Alias: IVPPL#
The INF_CV_PAYLINES table is used to import pay lines into the software data structures.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. |