!!!Alias: DGD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Date Sensitive Group information. !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[DGR_ID]|Number(10)|[ID]|Y|link to [P2K_CM_GROUPS] |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[DES_ID]|Number(10)|[ID]|Y|link to [P2K_CM_EMPLOYMENT_STATUSES] |[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS] |[DES_ID_END]|Number(10)|[ID]| |link to [P2K_CM_EMPLOYMENT_STATUSES] |[DWR_ID]|Number(10)|[ID]| |link to [P2K_CM_WORK_RULES] |[PPA_ID]|Number(10)|[ID]| |link to [P2K_PR_PAYROLLS] |[SWSR_ID]|Number(10)|[ID]| |link to [P2K_SA_WAGE_STEP_RULES] |[DCL_ID]|Number(10)|[ID]| |link to [P2K_CM_CALENDARS] |[MUC_ID]|Number(10)|[ID]| |link to [P2K_AM_USER_CALCS] for FLSA computation |[EXPIRY]|Date()|[EXPIRY]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[GROUP_TYPE]|Varchar2(2)|[X_GROUP_TYPE]| | |[PAY_TYPE]|Varchar2(2)|[X_PAY_TYPE]| | |[CONTRACT_TYPE]|Varchar2(2)|[X_CONTRACT_TYPE]| | |[EMPLOYMENT_TYPE]|Varchar2(2)|[X_EMPLOYMENT_TYPE]| | |[STD_HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| | |[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| | |[WEEKS_PER_YEAR]|Number(9)|[AMT5V4|AMTnn]| | |[MONTHS_PER_YEAR]|Number(9)|[AMT5V4|AMTnn]| | |[HOURLY_ROUNDING]|Number(18)|[AMT12V6|AMTnn]| | |[DAILY_ROUNDING]|Number(18)|[AMT12V6|AMTnn]| | |[USE_FTE_WAGES]|Varchar2(1)|[TOGGLE]| | |[ACCRUAL_METHOD]|Varchar2(2)|[X_ACCRUAL_METHOD]| | |[GOVT_REGIST_NUMBER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CDN_EI_REDUCED_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[PAY_BY_CHECK]|Varchar2(2)|[X_PAY_BY_METHOD]| | |[FLSA_FACTOR]|Number(9)|[AMT5V4|AMTnn]| | |[FLSA_HOURS]|Number(9)|[AMT5V4|AMTnn]| | |[W2_EMPLOYMENT_TYPE]|Varchar2(1)|[X_W2_EMPLOYMENT_TYPE]| | |[DGV_ID]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGISTRATIONS] |[FED_REGIST_TYPE]|Varchar2(4)|[X_GOVT_REGIST_TYPE]| | |[STATE_REGIST_TYPE]|Varchar2(4)|[X_GOVT_REGIST_TYPE]| | |[LOCAL_REGIST_TYPE]|Varchar2(4)|[X_GOVT_REGIST_TYPE]| | |[DGVS_ID_FED]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGIST_SETS] |[DGVS_ID_STATE]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGIST_SETS] |[DGVS_ID_LOCAL]|Number(10)|[ID]| |link to [P2K_CM_GOVT_REGIST_SETS] |[MUC_ID_FUND]|Number(10)|[ID]| |link to [P2K_AM_USER_CALCS] for G/L Fund Computation |[WC_REGIST_TYPE]|Varchar2(4)|[X_WC_REGIST_TYPE]| | |[ENABLE_OE_ELECTIONS]|Varchar2(1)|[TOGGLE]| | User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_CM_GROUP_DETAILS] [{InsertPage page='Internal.P2K_CM_GROUP_DETAILS' default='Click to create a new notes page'}]