Penn Computing

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

ST_HOLD table

(dwngss_ps.st_hold)

Explanation

Information on registration, transcript, graduation, and other types of holds put on students' records, along with the effective dates.

Source

The warehouse ST_HOLD table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The ODS source tables are UPENN_ODS.SATURN_SPRIDEN and UPENN_ODS.SATURN_SPRHOLD. In the online Pennant system, the data about students' holds can be viewed on the SOAHOLD form.

Common Uses

  • Find all students on hold at a specific point in time.
  • Join to other information for students on a specific type of hold.

 

Primary Key Indexed Data Elements Related Tables
ST_HOLD_PK
 

STUDENT

Cautions and notes

  • When holds are placed on a student's record, they have a start date and a projected "to" date. They are not term-specific, although a term can be derived from the dates.
ST_HOLD 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