Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
ENTRYSTATUSENUM
  
      
 BOOKING
 
 

Cautions
  • 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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania