Penn Computing

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

CLASSIFICATION Table

(dwstarrez.classification)

Explanation
Lookup table for Classifications, which can be associated with a room or person.

1 = Incoming Freshman
2 = Transfer
3 = Returning Undergraduate
4 = Non-resident Undergraduate
5 = Undergraduate - LPS
6 = Undergraduate - Exchange
7 = New Graduate
8 = Returning Graduate
9 = Other
10 = SPGA
11 = Faculty/Staff

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

Primary Key Indexed Data Elements Related Tables
CLASSIFICATIONID
   
ENTRY_DETAIL
ROOMLOCATION_CLASSIFICATION
 

Cautions
  • The classification field on the entry record is updated daily for active students. There are rules to determine how housing assignments wants to classify a student, the rules are different from what SRS may use. Ex. A new student may be first classified as a freshman the spring prior to their arrival, but starting late December/January, housing may want them classified as a returning-undergraduate in order for the student to be able to access the appropriate housing application process.

CLASSIFICATION 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