Wiki: P 2 K_CM_WORK_RULE

Alias: DWRD#

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

Hours per specific day of a period

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DWR_ID	Number(10)	ID	Y	link to P2K_CM_WORK_RULES
DHC_ID	Number(10)	ID		link to P2K_CM_HOLIDAY_CALENDARS
DCR_ID	Number(10)	ID		link to P2K_CM_CHANGE_REASONS
DWC_ID	Number(10)	ID		link to P2K_CM_WORK_CALENDARS
EFFECTIVE	Date()	EFFECTIVE	Y
EXPIRY	Date()	EXPIRY	Y
DESCRIPTION	Varchar2(50)	DESCRIPTION
FIRST_DAY_OF_WEEK	Varchar2(3)	X_DAY_OF_WEEK
PIECES_PER_DAY	Number(9)	AMT5V4
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
PAYS_PER_CONTRACT	Number(5)	NUMBER5
FLSA_METHOD	Varchar2(2)	X_FLSA_CALC_METHOD
FLOAT_DAYS_ALLOWED	Number(5)	NUMBER5
WORK_IS_SCHEDULED	Varchar2(1)	TOGGLE
MUST_BE_ACKNOWLEDGED	Varchar2(1)	TOGGLE
TIME_ROUNDING_RULE	Varchar2(2)	X_TIME_ROUNDING_RULE
TIME_ROUNDING_FACTOR	Number(9)	AMT5V4
PAY_STARTING_DATE	Date()	DATE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
GROUP_SOURCE	Varchar2(2)	X_GROUP_SOURCE
WORK_IN_RESTRICTION_RULE	Varchar2(2)	X_WORK_IN_RESTRICTION_RULE
TRACK_WORK_PUNCHES	Varchar2(1)	TOGGLE
TRACK_MEAL_PUNCHES	Varchar2(1)	TOGGLE
FLSA_HOURS	Number(9)	AMT5V4
DCL_ID_FLSA	Number(10)	ID		link to P2K_CM_WORK_CALENDARS

User Fields: Allowed
Audit Logging: Allowed

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