Wiki: INF_CV

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.

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.