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_CALENDARS

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page