!!!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)| |Validation:	Must be one of the fixed lexicon values from[X_PAY_POINT_TYPE]
|[PAY_POINT_TASK]|Varchar2(30)| |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)| | 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.


----
![Notes|Edit:Internal.INF_CV_SUNDRYLINES] 	
[{InsertPage page='Internal.INF_CV_SUNDRYLINES' default='Click to create a new notes page'}]