The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

Degree Audit Database

Posted: Monday, October 09, 2006

A new degree audit database called degreeaud has been added to the Data Warehouse. This database contains the degree audit program requirements, course lists and student exception information used in the production of degree audits. There are 10 tables in the database:

program: includes program code, effective/end years, program titles
program_requirement: includes the requirement names associated with a program
requirement: includes requirement names, effective/end years, requirement titles
requirement_additional_titles: includes additional/replacement requirement titles
subrequirement: includes requirement names/each subrequirement definition
subrequirement_title: includes subrequirement titles/replacement titles
subrequirement_course: includes the courses associated with each subrequirement
student_master: includes PSUID of students with exceptions
student_exception: includes exception code for all types/actions for CP, CR, CS, HW, RC
student_exception_course: includes the exception actions for AD, CC, DE, DL, DR, EX, RM, RS, SC

Access to this database is available through the Data Warehouse web page:
http://ais.its.psu.edu/services/warehouse/default.asp

A listing of the tables, fields, and their descriptions can be found at:
https://www.warehouse.ais.psu.edu/datadict/datadict2.ASP?database_name=degreeaud

Sample query instructions are being developed and will be posted at:
http://www.registrar.psu.edu/staff/training/training_index.cfm

Content Questions: Data Warehouse