Postcode Distance Configuration

The data will be kept up to date by the Static Data Download facility of IQXHub. Ensure that you have a hub configured to do this.

In the VACANCY SEARCHRESULT view add a custom column of Data Type 'Number' with Descriptor

round(DistanceBetweenPostCodes(Person.PostCode,:Q_SitePostCodeForMap,'Mi'),1)

Set the Database Function: Vacancy Shift Matcher Numeric Custom Column to

( in @PersonID char(20),in @VacancyID char(20) ) 
returns double
begin
  declare rv double;
  set rv = DistanceBetweenPostCodes(
    (select Person.PostCode from Person where Person.PersonID = @PersonID),
    (select isnull(vacancy.postcode,company.postcode) from Vacancy key join Employment key join Company where Vacancy.VacancyID = @VacancyID),'Mi');
  if rv < 1 then
    return round(rv,1)
  else 
    return round(rv,0)
  end if
end

Set the General Setting 'Caption for Shift Matcher Custom Column' to 'Distance'.