Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_ATTRIBUTE column definitions . Pennant Student Records Home . Data Warehouse Home
. Data Warehouse Home

ST_ATTRIBUTE table

(dwngss_ps.st_attribute)

Explanation

Contains information about term-based attributes that are assigned to students. Students can have multiple attributes in a term, and attributes can sometimes change from term-to-term. Examples: Attributes can identify the student's Penn-assigned classification, or whether they are a provisional admit, or whether they are a PhD student on Dissertation, etc.

Source

The warehouse ST_ATTRIBUTE table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The ODS source table is UPENN_ODS.SATURN_SGRSATT. In the online Pennant system, the data about students' addresses can be viewed on the SGASADD form.

Common Uses

  • Identify a students' attributes in a give term.
  • Find all students assigned to a specific attribute.

 

Primary Key Indexed Data Elements Related Tables
ST_ATTRIBUTE_PK
 

ST_TERM
V_STDNT_ATTR

Cautions and notes

  • When a student goes from having one or more attributes in a term to having no attributes in the next term, the next term will have a record for that student in the ST_ATTRIBUTE table with an attribute code of "NONE".
ST_ATTRIBUTE column definitions . Pennant Student Records 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