Alias: DGD#

Unique Keys: _
Child Table:
_
Parent Table: _

Date Sensitive Group information.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DGR_IDNumber(10)IDYlink to P2K_CM_GROUPS
EFFECTIVEDate()EFFECTIVEY
DES_IDNumber(10)IDYlink to P2K_CM_EMPLOYMENT_STATUSES
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
DES_ID_ENDNumber(10)ID link to P2K_CM_EMPLOYMENT_STATUSES
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
PPA_IDNumber(10)ID link to P2K_PR_PAYROLLS
SWSR_IDNumber(10)ID link to P2K_SA_WAGE_STEP_RULES
DCL_IDNumber(10)ID link to P2K_CM_CALENDARS
MUC_IDNumber(10)ID link to P2K_AM_USER_CALCS for FLSA computation
EXPIRYDate()EXPIRYY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
GROUP_TYPEVarchar2(2)X_GROUP_TYPE
PAY_TYPEVarchar2(2)X_PAY_TYPE
CONTRACT_TYPEVarchar2(2)X_CONTRACT_TYPE
EMPLOYMENT_TYPEVarchar2(2)X_EMPLOYMENT_TYPE
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
WEEKS_PER_YEARNumber(9)AMT5V4
MONTHS_PER_YEARNumber(9)AMT5V4
HOURLY_ROUNDINGNumber(18)AMT12V6
DAILY_ROUNDINGNumber(18)AMT12V6
USE_FTE_WAGESVarchar2(1)TOGGLE
ACCRUAL_METHODVarchar2(2)X_ACCRUAL_METHOD
GOVT_REGIST_NUMBERVarchar2(30)VARCHAR30
CDN_EI_REDUCED_RATENumber(18)AMT12V6
PAY_BY_CHECKVarchar2(2)X_PAY_BY_METHOD
FLSA_FACTORNumber(9)AMT5V4
FLSA_HOURSNumber(9)AMT5V4
W2_EMPLOYMENT_TYPEVarchar2(1)X_W2_EMPLOYMENT_TYPE
DGV_IDNumber(10)ID link to P2K_CM_GOVT_REGISTRATIONS
FED_REGIST_TYPEVarchar2(4)X_GOVT_REGIST_TYPE
STATE_REGIST_TYPEVarchar2(4)X_GOVT_REGIST_TYPE
LOCAL_REGIST_TYPEVarchar2(4)X_GOVT_REGIST_TYPE
DGVS_ID_FEDNumber(10)ID link to P2K_CM_GOVT_REGIST_SETS
DGVS_ID_STATENumber(10)ID link to P2K_CM_GOVT_REGIST_SETS
DGVS_ID_LOCALNumber(10)ID link to P2K_CM_GOVT_REGIST_SETS
MUC_ID_FUNDNumber(10)ID link to P2K_AM_USER_CALCS for G/L Fund Computation
WC_REGIST_TYPEVarchar2(4)X_WC_REGIST_TYPE
ENABLE_OE_ELECTIONSVarchar2(1)TOGGLE
BYPASS_ORG_CHARTVarchar2(1)TOGGLE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page