Tables: V
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
- pears.vacancy - Header record for Vacancies.
- pears.vacancy_team - Allows additional Staff records to be linked to Vacancy records
- pears.vacancyclass - Erroneous table name. Should be Source. Superceded by origin
- pears.VacancyCopyShortList - Used when copying Vacancy short lists
- pears.VacancyEtip - Link to ETip Vacancies / shifts
- pears.VacancyLimit - Spending Limits for Vacancies
- pears.VacancyOverrideRateScheme - For use by non-maintained function TempCustomRateGenerator() - not otherwise used by IQX
- pears.VacancyPosition - Frequently used position names - job titles.
- pears.VacancyRole - Capacities in which Staff records are related to a Vacancy (eg HR Manager etc)
- pears.VacancyRoleAllocation - Link table between VacancyRole - Vacancies and Staff
127.0.0.1