Housing Data Collection

This data collection is no longer being refreshed.  The data in the Warehouse Housing Data Collection comes from Business Services' StarRez application. The collection contains descriptive information about on-campus buildings and rooms, and the associated vacancy or occupancy by students, faculty/staff, and other guests or family members.   

ATTENTION: All users of Student Data, whether they write their own queries, or use data or reports extracted by someone else, agree to abide by University policy regarding confidentiality of student records, and by the Family Educational and Right to Privacy Act. Failure to abide by the policies and laws governing student data can result in disciplinary action, including termination.
Tables and Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

Looking for a specific element or caution? Try the searching the collection documentation for particular keywords (search page will open in a new tab).

Tables
Booking **
Table Elements		 Roombase **
Table Elements
Booking Occupant **
Table Elements		 Room Configuration **
Table Elements
Entry **
Table Elements		 Room Configuration Profile **
Table Elements
Entry Address **
Table Elements		 Roomspace **
Table Elements
Entry Custom Field **
Table Elements		 Roomspace Closed **
Table Elements
Entry Detail **
Table Elements		 Roomspace Detail **
Table Elements
Entry Enrollment **
Table Elements		 Snapshot
Table Elements

** Snapshot versions of thse tables are also available (named similarly with _SNAP suffix). Snapshot tables have SNAP_ID and SNAPSHOT_DATE columns; All other columns are the same.
Lookup Tables 
Address Type
Table Elements		 Room Type
Table Elements
Booking Type
Table Elements		 Room Configuration Term Type
Table Elements
Classification
Table Elements		 Room Location
Table Elements
Custom Field Definition
Table Elements		 Room Location Area 
Table Elements
Date Select
Table Elements		 Room Location Classification
Table Elements
Entry Status
Table Elements		 Room Location Floor Suite
Table Elements
Field Datatype
Table Elements		 Room Location Section
Table Elements
Gender
Table Elements		 Roomspace Type
Table Elements
Gender Type
Table Elements		 Setting
Table Elements
Profile Item
Table Elements		 Term
Table Elements
Profile Type
Table Elements		 Term Session
Table Elements
Record Type
Table Elements		 Term Type
Table Elements

The Housing Data Collection tables are refreshed daily, with weekly Snapshots.

  1. Nightly refresh - at midnight 7 days a week.   (Jobname is RD03000J)
  2. Snapshot  - every Friday at 11:00PM.  (Jobname is RD03100J) 

NOTE: This collection stopped being refreshed in October 2023.

Source
StarRez is the source for data in the Housing collection. 

Time Span Covered
Fall 2018 - Spring 2024. Snapshots were taken August 2018 through October 2023.

The Housing data collection is described by two Business Objects universes.   

  • Housing - use this universe to create queries or reports on the most recent data. 
  • Housing Snapshot - use this universe to create queries or reports based on data saved at a certain point-in-time.

Clicking the links will open a new browser window with a diagram of the tables and their join criteria.

The Business Objects Public Folders provide access to pre-defined, prompt-driven reports that you can run to retrieve a standardized perspective on your data.

Reports based on most recent data  (Housing universe)

OCC01:  Occupancy by College House. 
STAT01: Occupancy statistics by College House, by building, by expected year of graduation.
VAC01:  Vacancy by College House, building and room. 

Reports based on Snapshot data    (Housing_Snapshot universe)

OCC01-SNAP: Same as the OCC01, from a selected snapshot.STAT01-SNAP: Same as the STAT01, from a selected snapshot.  

Which snapshot to use in the report is determined by user-supplied "as-of" date. Date must be in the past.

Individuals who plan to use the Housing Data collection must submit a starRez Access Request eForm and obtain supervisor and school access administrator approval. 

Regulations and Policies on Student Data
Federal regulations regarding access to student data are spelled out in the Family Educational Right to Privacy Act (Buckley Amendment), commonly known as FERPA. For more information, see the FERPA information on the Penn Privacy site.

The University's policy on the Confidentiality of Student Records is available at http://www.upenn.edu/privacy/policies_publications.htm.

Releasing Data Outside the University 
The only two offices that may disclose Student Data outside the University are the Office of the University Registrar and Institutional Research. If you do not work for those offices and you receive a request for data to be sent outside the University, refer the requester to the Office of the University Registrar.

Releasing Data Within the University
Within the University, Student Data may be disclosed only if it is needed to do the business of the University, and only to those who need to know the information in order to do their jobs. If you are not sure whether to fulfill a request for Student Data, contact the Office of the University Registrar.

Query Results
If you save your query results in Excel, pdf, or any other local file type, you must see to it that any sensitive data stored on your peronal computer is safeguarded through physical security, access control software, or encryption. When a computer is left signed to an account, it is easy for someone to gain unauthorized access. Either sign off from your account before you leave your computer or restrict access by some other means (physical security or access control software).

For more information on security and privacy, contact the Office of Information Security.

If you have a question about the Housing data, or if you notice some documentation that needs updating, please contact Enterprise Information & Analytics. For documentation published on the Web, please specify the URL for the documentation that needs to be updated.