!!!Alias: [IVDGR]
(INF_CV_GROUPS)

The INF_CV_GROUPS table is used to import group codes and their attendant data into the software data structures.  A group divides a unit into subsections which have a common set of processing policies.

Tables loaded:
*[P2K_CM_GROUPS] (first record for each group code only)
*[P2K_CM_GROUP_DETAILS] (first record and subsequent effective splits)
!!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|Validation: 	Must be a valid entity code defined on [P2K_CM_ENTITIES]
|[UNIT_CODE]|Varchar2(16)|Y|Validation: 	Must be a valid unit code defined on [P2K_CM_UNITS]
|[GROUP_CODE]|Varchar2(16)|Y|Validation:	Must be a unique group code for the unit provided.
|[STANDING]|Varchar2(30)| |Validation:	Must be either a valid lexicon code, or a valid lexicon description from [X_STANDING]. Suggestion:	Normally, you would only load active groups, so you could populate this field with a constant value of “A”.
|[EFFECTIVE]|Date()| |Validation:	Must be a valid date format. Suggestion:	If you are not loading multiple date-effective records for the same code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
|[EXPIRY]|Date()| |Validation:	Must be a valid date format, with a date after the effective date. Suggestion:	If you are not loading multiple date-effective records for the same group code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
|[CHANGE_CODE]|Varchar2(16)| |Validation:	The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS]
|[DESCRIPTION]|Varchar2(50)| |
|[STATUS_CODE_STARTED]|Varchar2(16)| |Validation:	Must be an Employment Status code defined on [P2K_CM_EMPLOYMENT_STATUSES]
|[STATUS_CODE_ENDED]|Varchar2(16)| |Validation:	Must be an Employment Status code defined on [P2K_CM_EMPLOYMENT_STATUSES].  
|[WORK_RULE_CODE]|Varchar2(16)| |Validation:	Must be a Work Rule Code defined on [P2K_CM_WORK_RULES].
|[PAYROLL_CODE]|Varchar2(16)| |Validation:	Must be a payroll code defined on [P2K_PR_PAYROLLS]
|[WAGE_STEP_RULE_CODE]|Varchar2(16)| |Validation:	Must be a wage step code defined on [P2K_SA_WAGE_STEP_RULES]. 
|[GROUP_TYPE]|Varchar2(30)| |Validation:	Must be either a valid lexicon code, or a valid lexicon description from [X_GROUP_TYPE]
|[PAY_TYPE]|Varchar2(30)| |Validation:	Must be either a valid lexicon code, or a valid lexicon description from [X_PAY_TYPE]
|[STD_HOURS_PER_DAY]|Number(9)| |Validation:	May not exceed 24
|[STD_HOURS_PER_PAY]|Number(9)| |Validation:	May not exceed 744.
|[STD_HOURS_PER_WEEK]|Number(9)| |Validation:	May not exceed 168.
|[USE_FTE_WAGES]|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.
|[HOURLY_ROUNDING]|Number(18)| |
|[DAILY_ROUNDING]|Number(18)| |
|[WEEKS_PER_YEAR]|Number(9)| |
|[MONTHS_PER_YEAR]|Number(9)| |
|[ACCRUAL_METHOD]|Varchar2(30)| |Validation: 	This field must  be one of the following fixed lexicon values from [X_ACCRUAL_METHOD]
|[GOVT_REGIST_NUMBER]|Varchar2(30)| |
|[CDN_EI_REDUCED_RATE]|Number(18)| |
|[PAY_BY_CHECK]|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.
|[CONTRACT_TYPE]|Varchar2(30)| |
|[EMPLOYMENT_TYPE]|Varchar2(30)| |Validation: 	This field must  be one of the following fixed lexicon values from [X_EMPLOYMENT_TYPE].
|[FLSA_FACTOR]|Number(9)| |
|[FLSA_HOURS]|Number(9)| |
|[FLSA_CALENDAR]|Varchar2(16)| |
|[FLSA_USER_CALC]|Varchar2(16)| |
|[W2_EMPLOYMENT_TYPE]|Varchar2(30)| |
|[FED_REGIST_TYPE]|Varchar2(30)| |
|[STATE_REGIST_TYPE]|Varchar2(30)| |
|[LOCAL_REGIST_TYPE]|Varchar2(30)| |
|[GOVT_REGIST_SET_FED]|Varchar2(16)| |
|[GOVT_REGIST_SET_STATE]|Varchar2(16)| |
|[GOVT_REGIST_SET_LOCAL]|Varchar2(16)| |
|[FUND_USER_CALC]|Varchar2(16)| |
|[WC_REGIST_TYPE]|Varchar2(30)| |
|[ALLOCATION_TYPE]|Varchar2(30)| |Validation: 	This field must  be one of the following fixed lexicon values from [X_ALLOCATION_TYPE]
|[BURDEN_PERCENT]|Number(5)| |
|[DISTRIBUTION_DR_MASK]|Varchar2(50)| |Validation:	The [DISTRIBUTION_MASK] is validated against the [DISTRIBUTION_FORMAT] specified for the GLCOMPANY that is associated with the [ENTITY_CODE_SUB_DIVISION|ENTITY_CODE].
|[DISTRIBUTION_CR_MASK]|Varchar2(50)| |Validation:	The [DISTRIBUTION_MASK] is validated against the [DISTRIBUTION_FORMAT] specified for the GLCOMPANY that is associated with the [ENTITY_CODE_SUB_DIVISION|ENTITY_CODE].
|[ELEMENT_CODE_PRORATED_BY]|Varchar2(16)| |:	Must be a valid element defined on [P2K_PR_ELEMENTS].
|[ELEMENT_CODE_BASE_OF]|Varchar2(16)| |:	Must be a valid element defined on [P2K_PR_ELEMENTS].
|[DISTR_MASK_RULE]|Varchar2(30)| |
|[BURDEN_METHOD]|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.


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