New Degree Audit Database

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 and replacement requirement titles)

Subrequirement (includes requirement names and each subrequirement definition)

Subrequirement_title (includes subrequirement titles and 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 exception types and 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 DataWarehouse Access web page, http://ais.its.psu.edu/data_warehouse/dw_request_access.html.

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.html

If you have any comments, suggestions or concerns please contact Debbie Diercks, at dzd4@registrar.psu.edu

Available: October 2006


in:	AIS HOME \| ABOUT US \| CONTACT US \| HELP INDEX \| FAQ INDEX \| SITE INDEX \| GLOSSARY \| AIS INTRANET