Wiki: IDHC

Holiday Calendars#

The Holiday Calendar defines the annual holiday schedules that are used by the organization. It specifies the dates and names of the public holidays employees may take, as well as any organization specific holiday arrangements. Holiday calendars are used by time entry, work scheduling and pay generation processes to determine any default holiday rules that should be applied.

Holiday Calendars may be created and maintained the Define Holiday Calendars (IDHC) form.

‘Define Holiday Calendars’ Usage and Examples#

Holiday Calendar data is stored in the P2K_CM_HOLIDAY_CALENDARS and P2K_CM_HOLIDAY_DETAILS table.

Holiday Calendar: This field holds the user-defined time code that uniquely identifies the holiday calendar

Holiday_Calendar_Code is a mandatory 16-character alphanumeric field.

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

Holiday Date: This field displays the calendar date of the holiday. Holiday_Date is a mandatory date field,

Holiday Identity: This field identifies the name, occasion or reason for the holiday. Holiday_Identity is a mandatory user-defined lexicon (X_HOLIDAY_IDENTITY) that you may use to look up the value.

Holiday Type: This field indicates if the holiday is a legal/statutory, religious, or company holiday. Holiday_Type is an optional partially fixed lexicon (X_HOLIDAY_TYPE) you may use to look up the value.

Holiday Rule: This field indicates whether the holiday is designated as a paid day off, scheduled workday, or if it varies by work schedule. Holiday_Rule is an optional fixed lexicon (X_HOLIDAY_RULE) you may use to look up the value.

Hours per Day: This field displays the number of hours to be paid for the holiday. Hours_Per_Day is an optional numeric field.

Holiday OT Factor: This field displays the premium factor that is to be applied for any time worked on this day.

Overtime_Factor is an optional numeric field.

Generate Time: If the Generate Time toggle is ON, the holiday time will be generated under the time code(s) indicated. Generate_Time is an optional toggle field.

Override TS Generation: If the Override TS Generation toggle is ON, holidays will not be awarded from Time Scheduling. Override_TS_Generation is an optional toggle field.

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

Earned Holiday TC: This time code is used to identify how the holiday will be recorded if an employee works that day. Earned_Holiday_TC is an optional user-defined lexicon that you can use to select a value.

Observed On: This field allows you to change the dated a holiday is observed on. For example, a statutory holiday is on a Friday, but you wish to set it on the system for the next scheduled work day.