!!!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: *[P2K_PR_SUNDRY_LINES] *[P2K_PR_SUNDRY_LINE_DETAILS] !!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|PC_CODE]|Number(4)|Y|Validation: Must be a valid [pay component|PAY COMPONENTS] 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 from[X_PAY_POINT_TYPE] |[PAY_POINT_TASK]|Varchar2(30)|Y|Validation: Must be one of the fixed lexicon values from[X_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 from[X_TIME_BASIS] |[WCB_CLASS]|Varchar2(30)| |Validation: Must be one of the fixed lexicon values from[X_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|REFERENCE_INFO PSL]|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|PC_CODE]|Number(4)| |Validation: Must be a valid [Pay Component|PAY COMPONENTS] 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|PAY ELEMENTS] 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)| | ---- ![Notes|Edit:Internal.INF_CV_SUNDRYLINES] [{InsertPage page='Internal.INF_CV_SUNDRYLINES' default='Click to create a new notes page'}]