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.
