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

DATE_SELECT Table

(dwstarrez.date_select)

Explanation
Table for selecting "as-of" date when reporting. Contains all dates from Jan1 2000 thru Dec 32 2079.

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

None
 

BOOKING
ROOM_CONFIGURATION
ROOMSPACE_CLOSED
 

• Date range selection is necessary for BOOKING, ROOM_CONFIGURATION, and ROOMSPACE_CLOSED table usage. This is enforced by both universes.
• If you write your own queries and use any of those 3 tables, you must join to the Date-Select table.

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