Wiki: P 2 K_CM_GROUP

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	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	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
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 for G/L Fund Computation
WC_REGIST_TYPE	Varchar2(4)	X_WC_REGIST_TYPE
ENABLE_OE_ELECTIONS	Varchar2(1)	TOGGLE
BYPASS_ORG_CHART	Varchar2(1)	TOGGLE

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page