My Resource Vacation – SQL

Special Instructions

Special Instructions:

1. Create a new number type field on the resource object called Annual Vacation Allowance (rego_annual_vacation).
2. Create an Other Work project to capture resource vacation and set the ID to “Vacation”.
3. Create a resource record for every calendar in the system with the following fields:
   1. First name = BaseCalendar
   2. Last name = the name of the Calendar
   3. Active = no
   4. Include in Datamart = yes
   5. Date of Hire is prior to current year
   6. Date of Termination = blank
   7. Set calendar on the calendar tab to the name of the Calendar in the last name field
4. 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.
5. Requires the DAILYRESOURCEACTCURVE (ID: 2) to be setup to have at least a year’s worth of past data.
6. Requires the WEEKLYRESOURCEACTCURVE(ID: 55559) to be setup to have at least a year’s worth of past data.
7. Requires the MONTHLYRESOURCEACTCURVE(ID: 7) to be setup to have at least a year’s worth of past data.
8. Requires the DAILYRESOURCEAVAILCURVE (ID: 1) to be setup to have at least a year’s worth of past data.