IDWC
Back to current versionRestore this version

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 – FRINo 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 PeriodThe 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 DateWiki will ‘cycle’ through the dates provided and then project them for the pay period being created.
School YearWikiwill ‘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.