Penn Computing

University of Pennsylvania
Penn Computing << go backback
SNAPSHOT Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home

SNAPSHOT Table

(dwstarrez.snapshot)

Explanation
Snapshot definition table for StarRez Housing data collection. Join from SNAP_ID in this table to the snapshot tables.

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

Primary Key Indexed Data Elements Related Tables 
SNAP_ID
 
   
      
BOOKING_OCCUPANT_SNAP
BOOKING_SNAP
ENTRY_ADDRESS_SNAP
ENTRY_DETAIL_SNAP
ENTRY_ENROLLMENT_SNAP
ENTRY_SNAP
ROOMBASE_SNAP
ROOMCONFIGURATION_PROFILE_SNAP
ROOMCONFIGURATION_SNAP
ROOMSPACE_CLOSED_SNAP
ROOMSPACE_DETAIL_SNAP
ROOMSPACE_SNAP

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