BOOKING_TYPE Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home

BOOKING_TYPE Table

(dwstarrez.booking_type)

Explanation
Lookup table for Booking type. ie 0 (Please Select Type), 1=Academic, 2=Conference, 3=SPGA
NOTE: BookingTypeID=0 was used prior to 2018 and is equivalent to BookingTypeID=1

Common Uses
Report on data as it appeared in StarRez at end-of-day yesterday.

BOOKINGTYPEID
 

BOOKING
BOOKING_SNAP 

• All records prior to 2018 have BookingTypeID =0 ,as this column was not in-use and defaulted to zero.

BOOKING_TYPE Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home