Alias: IVPSL#
(INF_CV_SUNDRYLINES)The INF_CV_SUNDRYLINES table is used to import miscellaneous and sundry transactions into the software data structures. Sundry transaction lines are transactions, usually of recurring nature, that are not attached to a specific pay period and that have a processing frequency associated with them.
Tables loaded:
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 | Used for validation of the employment record. Validation: The Entity Code provided must be defined on P2K_CM_ENTITIES |
| PERSON_CODE | Varchar2(16) | Y | Used for validation of the employment record. Validation: Must be a valid PERSON_CODE already defined on the P2K_HR_IDENTITIES table. |
| HIRE_DATE | Date() | Used for validation of the employment record. Derivation: If you do not provide a hire date, the conversion application will look for any P2K_HR_EMPLOYMENTS record that matches the other criteria. Validation: Must be a valid date. | |
| FREQUENCY_CODE | Varchar2(16) | Y | Validation: Must be a valid frequency code defined on P2K_PR_FREQUENCIES. |
| SUNDRY_LINE_TYPE | Varchar2(30) | Y | Validation: Must be one of the fixed lexicon values from X_SUNDRY_LINE_TYPE |
| START_DATE | Date() | Y | Validation: Must be a valid date. |
| END_DATE | Date() | Y | Validation: Must be a valid date. |
| PC_CODE_HEADER | Number(4) | Y | Validation: Must be a valid pay component already defined on P2K_PR_PAY_COMPONENTS for which transactions may be entered |
| UNIT_CODE | Varchar2(16) | Used to validate the GROUP_CODE, JOB_CODE, PREMIUM_CODE and PC_CODE provided. Validation: Must be a valid unit already existing in the P2K_CM_UNITS table. | |
| GROUP_CODE | Varchar2(16) | Used to validate the PC_CODE provided. Validation: Must be a valid group for the indicated unit already defined on P2K_CM_GROUPS. | |
| POSITION_CODE | Varchar2(16) | Validation: Must be a valid position already defined on P2K_CM_POSITIONS | |
| JOB_CODE | Varchar2(16) | Validation: Must be a valid job already defined on P2K_CM_JOBS | |
| LEAVE_TYPE_CODE | Varchar2(16) | Validation: Must be a valid leave type already defined on P2K_AT_LEAVE_POLICY_TYPES | |
| PLAN_CODE | Varchar2(16) | Validation: Must be a valid plan code already defined on P2K_BE_PLAN_DEFINITIONS | |
| USER_CALC_CODE | Varchar2(16) | Validation: Must be a valid User Calc Code already defined on P2K_AM_USER_CALCS | |
| COUNTRY_CODE | Varchar2(16) | Used to validate the STATE_PROVINCE_CODE provided. | |
| STATE_PROVINCE_CODE | Varchar2(16) | Used to validate the GEO_CODE provided. | |
| GEO_CODE | Varchar2(16) | Validation: Must be a valid GEO_CODE already defined on P2K_CM_TAX_JURISDICTIONS in the state indicated | |
| ASSIGNMENT_START_DATE | Date() | Used to validate the ASSIGNMENT record. The employee must have an assignment record that corresponds to the Assignment Type / Assignment Start Date for this employee. Validation: Must be a valid date. | |
| ASSIGNMENT_CODE | Varchar2(16) | Y | Used to validate the ASSIGNMENT record. The employee must have an assignment record that corresponds to the Assignment Type / Assignment Start Date for this employee |
| TIMES_REMAINING | Number(5) | ||
| PAY_POINT_TYPE | Varchar2(30) | Y | Validation: Must be one of the fixed lexicon values fromX_PAY_POINT_TYPE |
| PAY_POINT_TASK | Varchar2(30) | Y | Validation: Must be one of the fixed lexicon values fromX_PAY_POINT_TASK |
| PAY_POINT_SEQUENCE | Number(5) | ||
| TIME_ENTERED | Number(18) | ||
| TIME_BASIS | Varchar2(30) | Validation: Must be one of the fixed lexicon values fromX_TIME_BASIS | |
| WCB_CLASS | Varchar2(30) | Validation: Must be one of the fixed lexicon values fromX_WCB_CLASS | |
| DISTRIBUTION_MASK | Varchar2(50) | Validation: Must be a valid distribution mask for the GL_COMPANY_CODE of the ENTITY_CODE specified. | |
| REFERENCE_INFO | Varchar2(50) | ||
| AUDIT_TEXT | Varchar2(4000) | ||
| WORK_ORDER | Varchar2(50) | ||
| COST_CENTER_CODE | Varchar2(16) | ||
| INCOME_PRORATION | Varchar2(4) | ||
| CALENDAR_CODE | Varchar2(16) | ||
| PC_CODE_DETAILS | Number(4) | Validation: Must be a valid Pay Component code already defined on P2K_PR_PAY_COMPONENTS. | |
| PC_ACTION | Varchar2(30) | Y | Validation: Must be one of the fixed lexicon values from X_PC_ACTION. |
| PC_DETAIL_TYPE | Varchar2(30) | Y | Validation: Must be one of the fixed lexicon values from X_PC_DETAIL_TYPE. |
| ELEMENT_CODE | Varchar2(16) | Validation: Must be a valid element code already defined on P2K_PR_ELEMENTS. | |
| USER_VARIABLE_CODE | Varchar2(16) | Validation: Must be a valid user variable already defined on P2K_AM_USER_VARIABLES | |
| PC_CALC_METHOD | Varchar2(30) | Validation: Must be one of the fixed lexicon values from X_PC_CALC_METHOD | |
| DESCRIPTION | Varchar2(50) | ||
| WAGE_RATE | Number(18) | ||
| WAGE_RATE_OVERRIDE | Number(18) | ||
| RATE_BASIS | Varchar2(30) | Validation: Must be one of the fixed lexicon values from X_RATE_BASIS | |
| RATE_BASIS_OVERRIDE | Varchar2(30) | Validation: Must be one of the fixed lexicon values from X_RATE_BASIS | |
| AMOUNT | Number(18) | ||
| AMOUNT_OVERRIDE | Number(18) | ||
| USER_VARIABLE_OVERRIDE | Number(18) | ||
| DISTRIBUTION_DR_MASK | Varchar2(50) | Validation: Must be a valid distribution mask for the GL_COMPANY_CODE indicated by the entity code provided. | |
| DISTRIBUTION_CR_MASK | Varchar2(50) | Validation: Must be a valid distribution mask for the GL_COMPANY_CODE indicated by the entity code provided. | |
| PC_RATE_SOURCE | Varchar2(30) | y | Validation: Must be one of the fixed lexicon values from X_PC_RATE_SOURCE |
| HIGHER_OF_RATE | Varchar2(4) | Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True. | |
| PAY_NUMBER | Number(5) | ||
| STAT_CODE | Varchar2(16) | ||
| 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. | |
| THIRD_PARTY_TO_DISBURSE | VARCHAR2(4) | ||
| PAID_TO_ORDER_OF | VARCHAR2(30) | ||
| PAYMENT_SCHEDULE_TYPE | VARCHAR2(30) | ||
| PAYMENT_SCHEDULE_ACCRUING | VARCHAR2(30) | ||
| MEMORANDUM1 | VARCHAR2(50) | ||
| MEMORANDUM2 | VARCHAR2(50) | ||
| AGENCY_CASE_IDENTIFICATION | VARCHAR2(30) | ||
| COURT_STATE_PROVINCE | VARCHAR2(16) | ||
| DEPENDANT_MEDICAL_COVERAGE | VARCHAR2(4) | ||
| LIEN_DEDUCTION | VARCHAR2(30) | ||
| EXTERNAL_DOCUMENT_ID | VARCHAR2(16) | ||
| LIEN_NUMBER | NUMBER(5,0) | ||
| PAYEE_PERSON_CODE | VARCHAR2(16) | ||
| SUNDRY_STATUS | VARCHAR2(30) |
