This page (revision-10) was last changed on 26-Nov-2021 10:22 by rthiruppathy

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 1 KB rthiruppathy to previous
9 26-Nov-2021 10:22 1 KB rthiruppathy to previous | to last
8 26-Nov-2021 10:22 1 KB JEscott to previous | to last
7 26-Nov-2021 10:22 1 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 3 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
IDWC
IDWC

Version management

Difference between version and

At line 5 changed 3 lines
Calendar Utility
In order to create a new calendar, click the Calendar Utility button.
You will be presented with the following form which you may use to define the calendar details.
In order to create a new calendar, click the [Calendar Utility|CALENDAR UTILITY] button.
At line 9 changed 6 lines
Manually add the first seven days of the calendar.
In the Duplicate Range section enter the From Relative Day as 1 and the To Relative Day as 7.
In the Create Range section, enter the first day to create (8) and enter the last day of school in the To Date (which calculates the To Relative Day field).
Select the ‘OK’.
After the calendar is complete, go into the Query mode, select Work Day from the LOV, and execute the Count Matching Records function (Shift + F2) or select the function from the Query pull down menu. This will display the current total workdays, which may be incorrect. The user must then modify the non-work days, (unpaid holidays, spring break, Christmas break, etc.).
This is accomplished by changing the Work Day Type to Day Off.
!!‘Define Work Calendars’ Usage and Examples
At line 9 added 27 lines
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.
This page (revision-10) was last changed on 26-Nov-2021 10:22 by rthiruppathyTop