!!!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|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|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|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. [{$applicationname}] 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. [{$applicationname}] 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|[{$applicationname}] will ‘cycle’ through the dates provided and then project them for the pay period being created.
|School Year|[{$applicationname}]will ‘cycle’ through the dates provided and then project them for the pay period being created.

;[Description|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|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|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 #|RELATIVE_DAY_NUMBER]: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|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|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|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|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.