Resource Vacation Details – SQL
The Resource Vacation Details portlet allows a resource manager, or administrator, to see a resource’s calendar at a glance, displayed by week or month for a selected time period. This portlet shows the Resource Name, Resource Manager, Calendar, H (holiday), and V (vacation) hours for the select time frame.
Download Details
RegoXchange Content ID: EX0106
Submission Date:
Submitter:
Content Type: Clarity Studio
Related Modules: Administrative Support
Company: Rego Consulting
Version Support
Versions Supported: 15.x, 16.x
Special Instructions
Special Instructions:
- 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
- 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 DAILYRESOURCEAVLCURVE (ID: 1) to be setup to have at least a year’s worth of past data.
