!!!Alias: IVDGR (INF_CV_GROUPS) \\ Date Sensitive Group information. !!Table Columns \\ ||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]| |