!!!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]
|[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]| |
|[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4]| |
|[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4]| |
|[WEEKS_PER_YEAR]|Number(9)|[AMT5V4]| |
|[MONTHS_PER_YEAR]|Number(9)|[AMT5V4]| |
|[HOURLY_ROUNDING]|Number(18)|[AMT12V6]| |
|[DAILY_ROUNDING]|Number(18)|[AMT12V6]| |
|[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]| |
|[PAY_BY_CHECK]|Varchar2(2)|[X_PAY_BY_METHOD]| |
|[FLSA_FACTOR]|Number(9)|[AMT5V4]| |
|[FLSA_HOURS]|Number(9)|[AMT5V4]| |
|[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]
|[WC_REGIST_TYPE]|Varchar2(4)|[X_WC_REGIST_TYPE]| |
|[ENABLE_OE_ELECTIONS]|Varchar2(1)|[TOGGLE]| |

User Fields: Allowed\\
Audit Logging: Allowed\\