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 (Field) | 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. | |
| 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. | |
| 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. |
