Instructions to Obtain Course Lists Used on the Degree Audit

The instructions below step you through 3 queries needed in order to obtain the course list for a sub-requirement(s) on the degree audit. In this example, the course lists for the major requirements for the Bachelor of Arts in Advertising, Advertising option will be obtained.

Step 1: Program Definition Query

Query Description

This query shows the requirements created for the Bachelor of Arts in Advertising and Public Relations, Advertising option degree audit.

Database Used:

degreeaud

Tables Used:

dbo_program
dbo_program_requirement

Link Tables with Fields:

program_name
program_effective_date

Fields Selected from the dbo_program table:

program_name
program_effective_date
program_end_date

Fields Selected from the dbo_program table:

requirement_name
group_code1
group_code2
or_indc
optional_indc
summary_group_indc
crosslink_indc
alternate_catalog_indc
sort_indc

Criteria Used:

Field Name: program_name                   Criteria Entered: B A  AD PRADVT
Field Name: program_end_date            Criteria Entered: 9999

Once you have run the query, make a note of the name of the requirement you want to look at to obtain the course lists.

Notes:

•The program_name field is 15 characters long. Spaces 1-5 are for the degree code. Spaces 6-10 are for the major code. Spaces 11-15 are for the option code (if applicable).

•By entering 9999 in the program_end _date field, it will return the most current version of the program definition requirements.

•Results from the query:
Major requirements usually start with the first 2 letters of "MJ," "MK," "ML," "MM," or "M" followed by a number (1-9). Usually the next 4 spaces are the first 4 letters of the major code. For example, MJADPR is the major requirement for the Bachelor of Arts in Advertising and Public Relations degree audit. Typically, if the major has options, the major requirements are the same for all options associated with the major.

Option requirements usually start with the first 2 letters of "ON," "OM," "OP," "OO," or "O" followed by a number (1-9). Usually the next 4 spaces are the first 4 letters of the major code and the last 2 spaces are the first 2 letters of the option code. For example, ONADPRAD are the option requirements for the Advertising option of the Bachelor of Arts in Advertising and Public Relations degree audit

**There could be more than one major and/or option requirement created for a program.**

Step 2: Requirement Definition

Query Description:

This query shows the major requirement (MJADPR) created for the Bachelor of Arts in Advertising and Public Relations, Advertising option degree audit. This query will show you the effective and end dates of the requirement, the number of sub-requirements within the requirement, and the minimum number of credits needed to complete the requirement. The major requirement was found by running the Program Definition query in Step 1.

Database Used:

degreeaud

Tables Used:

dbo_requirement

Fields Selected from the dbo_requirement table:

requirement_name
requirement_effective_date
requirement_end_date
requirement_subrequirement_count_rq
required_credits_rq
pseudo_name_rq
requirement_type
required_course_count_rq
requirement_title1
requirement_title2

Criteria Used:

Field Name: requirement_name                   Criteria Entered: MJADPR
Field Name: requirement_end_date            Criteria Entered: 9999

Once you have run the query, make a note of the beginning date of the version(s) of the major requirement for which you want to obtain the course lists.

Notes:

•By entering 9999 in the requirement_end_date field, it will return the most current version of the requirement. If you want to see the beginning date and end date of all versions of the MJADPR requirement, leave the requirement_end_date field blank.

 

Step 3: Sub-Requirement Course List

Query Description:

This query shows the sub-requirements and course lists created for the MJADPR requirement in the Bachelor of Arts in Advertising and Public Relations, Advertising option degree audit. This query also shows the minimum credits needed to complete each sub-requirement, the maximum number of credits accepted for each sub-requirement, and the number of courses needed to complete each sub-requirement (if applicable). The major requirement and effective date were found by running the Program Definition and Requirement Definition queries in Steps 1 and 2.

Database Used:

degreeaud

Tables Used:

dbo_subrequirement
dbo_subrequirement_course

Fields Selected from the dbo_subrequirement table:

internal_sequence_numb_sr
requirement_name
requirement_effective_date
subrequirement_sequence_numb
required_credits_sr
maximum_credits_sr
required_course_count_sr

Fields Selected from the dbo_subrequirement_course table:

accept_or_reject_type
course_sr
match_control_indc_st
course_effective_date_range_sr

Link Tables with Fields:

internal_sequence_numb_sr

Criteria Used:

Field Name: requirement_name                       Criteria Entered: MJADPR
Field Name: requirement_effective_date         Criteria Entered: 2002

In order to see all fields available in each table and a description of each field, go to:
https://www.warehouse.ais.psu.edu/datadict/datadict2.ASP?database_name=degreeaud