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.
| Normal MON – FRI | No dates need to be supplied. Wiki will assume that the days paid are Monday through Friday and will take the hours per day from the employee’s assignment record. |
| Relative to Period | The dates indicate will be ignored. Wiki will look at the ‘relative day #’ and use it to populate the days to be generated for that pay period. i.e. If it is a biweekly pay period then only the 1 through 14 relative days will be used. |
| Relative to Date | Wiki will ‘cycle’ through the dates provided and then project them for the pay period being created. |
| School Year | Wikiwill ‘cycle’ through the dates provided and then project them for the pay period being created. |
- 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.
