Toggle navigation

Masterdatabase

<
  • Dashboard
  • Airports
  • Cities
  • Hotels
    • Hotel chains
    • Hotel descriptions
    • Hotel consolidated
    • Hotel crossreferences
  • Services
    • PluginController
    • HotelConsolidator
  • Reports

Help - Tables

  1. Home
  2. Help
  3. Tables

HotelDescription

dtModified   Gets set everytime a property changes value since the last update.
HotelConsolidator service uses this to determine if the hotel has changed since last consolidation.
LastConsolidated   Gets set everytime the Hotelconsolidator service processed the hotel. HotelConsolidator service uses this in combination with dtModified to determine if the hotel is new or updated.
LastSupplied  Gets set to now everytime the Hotelupdaterservice retrieves this hotel.
Is set to NULL when hotel has been manually entered.
NeedsRematch   Everytime a hotelname changes, this flag gets set.
The HotelConsolidator service unmatches this hotel when necessary. It will try to re-match it on the next consolidation run.
RequestLocationId   Hotels get processed by city or state, but the determined cityId might end up different.
This field is used in combination with the Hotelproviderprocessingtime table to track when it was last supplied.

HotelConsolidated

ReplacedWithHotel   Gets set with HotelConsolidatedId when a consolidated hotel gets matched against another HotelConsolidated.
Meaning that this HotelConsolidated entry is inactive.
When a crossreference gets unmatched this value will get reset back to NULL, so that the previously consolidated hotel gets reinstated.
This logic was put into place, so we would could better retain the MasterId (HotelConsolidatedId) link to SOL.