Work Calendars#

Work Calendars allow specific work schedules or contract periods to be created. Work Calendars are created and maintained through the Define Work Calendars (IDWC) form.

In order to create a new calendar, click the Calendar Utility button.

‘Define Work Calendars’ Usage and Examples#

Work Calendar data is stored in the P2K_CM_WORK_CALENDARS and P2K_CM_WORK_CALENDAR_DETAILS table.

Work Calendar Code

This is a user-defined time code that uniquely identifies the work calendar. Work_Calendar_Code is a mandatory 16-character alphanumeric field.

Work Calendar Type

This indicates the type of work calendar. Work_Calendar_Type is a mandatory fixed lexicon (X_WORK_CALENDAR_TYPE) the user may use to look up the value.

Description

This field holds the user-defined description of the use and purpose of the work calendar. Description is an optional 50-character alphanumeric field.

Starting Date

This field identifies the first date the calendar begins. This field will be used to populate the details. Starting_Date is an optional (but recommended) date field.

Days in Cycle

This field indicates the number of days to be created for the work calendar. Days_In_Cycle is an optional numeric field that you may manually enter.

Relative Day #

This field indicates the relativity to the starting date. Relative_Day_Number is a mandatory numeric field.

Date

This field automatically populated based on Starting Date and Relative Day # fields.

Work Day Type

This field indicates if the day is designated as a workday, paid day, paid from bank, or day off. Work_Day_Type is a mandatory fixed lexicon (X_WORK_DAY_TYPE) that you may use to look up the value.

Hours Per Day

This field displays the number of hours to be paid/tracked for the day (leave blank if employee’s assignment hours are to be used). Hours_Per_Day is an optional numeric field.

Time Code

This field holds the time code to be used by time entry, work scheduling and pay generation processes to link with payroll. Time_Code from P2K_CM_TIME_CODES is an optional field.

Assigned To

This field identifies the shift that the day is assigned to. Assigned_To is an optional user-defined lexicon that you may use to select a value.