This page (revision-7) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
7 26-Nov-2021 10:22 5 KB jmyers to previous WORK_RULE_CODE ==> WORK_RULE (Field)
6 26-Nov-2021 10:22 5 KB JMyers to previous | to last
5 26-Nov-2021 10:22 5 KB JEscott to previous | to last
4 26-Nov-2021 10:22 5 KB JEscott to previous | to last
3 26-Nov-2021 10:22 5 KB JEscott to previous | to last
2 26-Nov-2021 10:22 2 KB JEscott to previous | to last
1 26-Nov-2021 10:22 2 KB JEscott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed one line
!!!Alias: IVDGR
!!!Alias: [IVDGR]
At line 3 removed 2 lines
\\
Date Sensitive Group information.
At line 4 added 5 lines
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)
At line 8 changed 56 lines
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[UNIT_CODE]|Varchar2(16)|[CODE]|Y|
|[GROUP_CODE]|Varchar2(16)|[CODE]|Y|
|[STANDING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[EFFECTIVE]|Date()|[EFFECTIVE]| |
|[EXPIRY]|Date()|[EXPIRY]| |
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[STATUS_CODE_STARTED]|Varchar2(16)|[CODE]| |
|[STATUS_CODE_ENDED]|Varchar2(16)|[CODE]| |
|[WORK_RULE_CODE]|Varchar2(16)|[CODE]| |
|[PAYROLL_CODE]|Varchar2(16)|[CODE]| |
|[WAGE_STEP_RULE_CODE]|Varchar2(16)|[CODE]| |
|[GROUP_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[PAY_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[STD_HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| |
|[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| |
|[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
|[USE_FTE_WAGES]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[HOURLY_ROUNDING]|Number(18)|[AMT12V6|AMTnn]| |
|[DAILY_ROUNDING]|Number(18)|[AMT12V6|AMTnn]| |
|[WEEKS_PER_YEAR]|Number(9)|[AMT5V4|AMTnn]| |
|[MONTHS_PER_YEAR]|Number(9)|[AMT5V4|AMTnn]| |
|[ACCRUAL_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[GOVT_REGIST_NUMBER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CDN_EI_REDUCED_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[PAY_BY_CHECK]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[CONTRACT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[FLSA_FACTOR]|Number(9)|[AMT5V4|AMTnn]| |
|[FLSA_HOURS]|Number(9)|[AMT5V4|AMTnn]| |
|[FLSA_CALENDAR]|Varchar2(16)|[CODE]| |
|[FLSA_USER_CALC]|Varchar2(16)|[CODE]| |
|[W2_EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[FED_REGIST_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[STATE_REGIST_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[LOCAL_REGIST_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[GOVT_REGIST_SET_FED]|Varchar2(16)|[CODE]| |
|[GOVT_REGIST_SET_STATE]|Varchar2(16)|[CODE]| |
|[GOVT_REGIST_SET_LOCAL]|Varchar2(16)|[CODE]| |
|[FUND_USER_CALC]|Varchar2(16)|[CODE]| |
|[WC_REGIST_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ALLOCATION_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[BURDEN_PERCENT]|Number(5)|[PERCENT]| |
|[DISTRIBUTION_DR_MASK]|Varchar2(50)|[DISTRIBUTION]| |
|[DISTRIBUTION_CR_MASK]|Varchar2(50)|[DISTRIBUTION]| |
|[ELEMENT_CODE_PRORATED_BY]|Varchar2(16)|[CODE]| |
|[ELEMENT_CODE_BASE_OF]|Varchar2(16)|[CODE]| |
|[DISTR_MASK_RULE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[BURDEN_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
||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|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'}]