ST_THESIS_DISSERTATION column definitions . Pennant Student Records Home . Data Warehouse Home

ST_THESIS_DISSERTATION table

(dwngss_ps.st_thesis_dissertation)

Explanation

For candidates for the Masters' degree, this table contains Masters' Thesis information. For candidates for a doctoral degree, this table contains Dissertation information.

Source

The warehouse ST_THESIS_DISSERTATION 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_SHRQPNM.

Common Uses

• Get the title of a student's dissertation.

Cautions and notes

• For dissertation students, the committee member information is not found in this table. Likewise for masters' degree students, the supervisor information in not found in this table. See instead the ST_THESIS_DISS_COMMITTEE table.

ST_THESIS_DISSERTATION column definitions . Pennant Student Records Home . Data Warehouse Home