Tables: V [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Tables: V ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

  * [[database:tables:pears_vacancy|pears.vacancy]] - Header record for Vacancies.
  * [[database:tables:pears_vacancy_team|pears.vacancy_team]] - Allows additional Staff records to be linked to Vacancy records
  * [[database:tables:pears_vacancyclass|pears.vacancyclass]] - Erroneous table name. Should be Source.  Superceded by origin
  * [[database:tables:pears_vacancycopyshortlist|pears.VacancyCopyShortList]] - Used when copying Vacancy short lists 
  * [[database:tables:pears_vacancycopyshortlisttemp|pears.VacancyCopyShortListTemp]]
  * [[database:tables:pears_vacancyetip|pears.VacancyEtip]] - Link to ETip Vacancies / shifts
  * [[database:tables:pears_vacancykeywords|pears.VacancyKeyWords]]
  * [[database:tables:pears_vacancylimit|pears.VacancyLimit]] - Spending Limits for Vacancies
  * [[database:tables:pears_vacancyoverrideratescheme|pears.VacancyOverrideRateScheme]] - For use by non-maintained function TempCustomRateGenerator() - not otherwise used by IQX
  * [[database:tables:pears_vacancyposition|pears.VacancyPosition]] - Frequently used position names - job titles.
  * [[database:tables:pears_vacancyrole|pears.VacancyRole]] - Capacities in which Staff records are related to a Vacancy (eg HR Manager etc)
  * [[database:tables:pears_vacancyroleallocation|pears.VacancyRoleAllocation]] - Link table between VacancyRole - Vacancies and Staff
  * [[database:tables:pears_vacancysearchtemp|pears.VacancySearchTemp]]