My Resource Vacation – SQL
The My Resource Vacation portlet allows a resource to view the current logged in users’ annual vacation allowance, as set by the resource manager, against the resource vacation calendar hours and actual posted timesheet hours. The portlet is useful for determining the amount of hours a resource has requested off and has remaining. The 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: EX0259
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 “Vacation”.
- 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
- 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
- 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 WEEKLYRESOURCEACTCURVE(ID: 55559) to be setup to have at least a year’s worth of past data.
- Requires the MONTHLYRESOURCEACTCURVE(ID: 7) 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 past data.
