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. | |
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. |