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
BACA_ID	Number(10)	ID		link to P2K_BE_ACA_CATEGORIES for ACA category identification

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor