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

ENTRY_STATUS Table

(dwstarrez.entry_status)

Explanation
Lookup table for "entry status", which appears in the Booking table as BOOKING_ENTRYSTATUS and in the Entry table as ENTRYSTATUSENUM.

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

ENTRYSTATUSENUM
 

 BOOKING
 
 

• When writing your own queries, use "entry status" from the BOOKING table (BOOKING_ENTRYSTATUS), not ENTRYSTATUSENUM from ENTRY table.
• The value in the entry table is less reliable and sometimes inconsistent with the value in the booking table.
• The universe does not join from Entry table to Entry_Status table.

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