Resource Vacation – Postgres

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 “Vacations”.
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. Time entry = no
   5. Include in Datamart = yes
   6. Date of Hire is prior to current year
   7. Date of Termination = blank
   8. Set calendar on the calendar tab to the name of the Calendar in the last name field
4. Resources must have Annual Vacation Allowance set.
5. 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.
6. Requires the DAILYRESOURCEACTCURVE (ID: 2) to be setup to have at least a year’s worth of past data.
7. Requires the DAILYRESOURCEAVAILCURVE(ID: 1) to be setup to have at least a year’s worth of data.