!!!Alias: IVDGR 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.