Resource Vacation – SQL
The Resource Vacation portlet allows a resource manager to view a resource’s current annual vacation allowance, as set by the resource manager, against the resource’s vacation calendar hours and actual posted timesheet hours. This portlet is useful for determining the amount of hours a resource has requested off and has remaining. This portlet also ensures the resource has accounted for all annual vacation allowance hours in the calendar and has posted time for all past calendar request hours.
Download Details
RegoXchange Content ID: EX0105
Submission Date:
Submitter:
Content Type: Clarity Studio
Related Modules: Resource Management
Company: Rego Consulting
Version Support
Versions Supported: 15.x, 16.x
Special Instructions
Special Instructions:
- Create a new number type field on the resource object called Annual Vacation Allowance (rego_annual_vacation).
- Create an Other Work project to capture resource vacation and set the ID to “Vacations”.
- Create a resource record for every calendar in the system with the following fields:
- First name = BaseCalendar
- Last name = the name of the Calendar
- Active = no
- Time entry = no
- Include in Datamart = yes
- Date of Hire is prior to current year
- Date of Termination = blank
- Set calendar on the calendar tab to the name of the Calendar in the last name field
- Resources must have Annual Vacation Allowance set.
- Resource ID of Admin must be set to a Standard Calendar that has no holidays, in order to determine what days on the other calendars are holidays.
- Requires the DAILYRESOURCEACTCURVE (ID: 2) to be setup to have at least a year’s worth of past data.
- Requires the DAILYRESOURCEAVAILCURVE(ID: 1) to be setup to have at least a year’s worth of data.
