Return to Navigation

Auditing Degree Changes

This section provides an overview of degree change audits, lists prerequisites, and discusses how to:

Degrees are among the most sensitive data within the Student Records application. As such, the PeopleSoft system offers Degree Change Audit functionality that captures and displays detailed information about student degree postings or changes to postings. Changes include online changes to the Student Degrees page that occur when you click the Update Degrees button on the Student Degrees page and changes to any of the pages in the Student Degrees component. Inserts, updates, or deletions on these pages cause the system to write an audit record to the degree change audit table. The degree change audit table captures the entire record for ACAD_DEGR, ACAD_DEGR_HONS, ACAD_DEGR_PLAN, and ACAD_DEGR_SPLN, storing an image of each record before and after any change. The system date/time stamps and marks each record in the audit table as an "insert" or "delete," or as a "before" or "after" in the case of updates.

Use the Degree Change Audit component to search your database for details about degree changes. An option on the Search Criteria page enables you to filter out the "before" image.

To record the degree changes that the Degree Change Audit functionality audits, your IT team must first install and execute delivered SQL trigger files.

See Supplemental Installation Guide link on the Campus Solutions 9.0 Documentation Home page on My Oracle Support (note ID 751540.1)

SeeUnderstanding CS-to-HCM Integration

To view degree changes, you must first click the Search button on the Search Criteria page.

Page Name

Definition Name

Navigation

Usage

Degree Change Audit - Search Criteria

DEGREE_AUDIT

select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Search Criteria

Define your degree change audit search parameters. All of the fields on this page are optional.

Degree

AUD_ACAD_DEGR

select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree

Review detailed information about degree changes that match the selection criteria specified on the Search Criteria page.

The elements on this page are the same as those found on the Degree page.

Degree Honors

AUD_ACAD_DEGR_H

select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree Honors

Review detailed information about changes to degree honors that match the selection criteria specified on the Search Criteria page.

Degree Plan

AUD_ACAD_DEGR_P

select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree Plan

Review detailed information about degree plan changes that match the selection criteria specified on the Search Criteria page.

Degree Subplan

AUD_ACAD_DEGR_S

select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree Subplan

Review detailed information about degree subplan changes that match the selection criteria specified on the Search Criteria page.

The elements of all four tabs on this page are the same as those found on the Degree Sub-Plan page.

Access the Degree Change Audit - Search Criteria page (select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Search Criteria).

Image: Degree Change Audit - Search Criteria page

This example illustrates the fields and controls on the Degree Change Audit - Search Criteria page. You can find definitions for the fields and controls later on this page.

Degree Change Audit - Search Criteria page

Field or Control

Definition
ID

The ID for the student who you want to audit. Leave this field blank to have the system retrieve all values for this field (wild card).
User ID

The ID for the user who you want to audit. Leave this field blank to have the system retrieve all values for this field (wild card).
Start Date

The earliest date to audit. Leave this field blank to have the system retrieve all values for this field (wild card).
End Date

The latest date to audit. Leave this field blank to have the system retrieve all values for this field (wild card).
View Changes Only

If cleared, the system returns all records with an action of Insert, Before, After, or Delete. If selected, the system does not return records with an action of Before and returns only records with an action of Insert, After, or Delete.

Search

After you enter your search parameters, click this button to return audit data to the Degree page. To change the data that the system returns, update the selection criteria and search for data again.

Note: When you click the Search button, the retrieval process begins. If the system finds changes to any of the records within your search criteria, the system automatically takes you to the first page where changes exist. If no changes are found, the system remains on the Search Criteria page.

Access the Degree page (select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree).

Image: Degree Change Audit - Degree page: Degree Info tab

This example illustrates the fields and controls on the Degree Change Audit - Degree page: Degree Info tab. You can find definitions for the fields and controls later on this page.

Degree Change Audit - Degree page: Degree Info tab

Note: Multiple views of this page are available by clicking the tabs in the scroll area. We document fields common to all views first.

Field or Control

Definition
User ID

The ID of the individual who made changes to the ACAD_DEGR record. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.
Date/Time

When changes to the ACAD_DEGR record were made.
Action

Action types include the following:

Insert: User inserted a new row (a row was added to the database).

Delete: User deleted a row out of the database. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.

Before: Image of the record before it was updated.

After: Image of the record after it was updated.
ID

The ID of the student whose degree was changed.
Degree Nbr (degree number)

Students can have more than one degree, and each degree is assigned a degree number.
Degree

The student's degree.
Institution

The academic institution associated with the degree.

Completion Info Tab

Select the Completion Info tab.

Image: Degree page: Completion Info tab

This example illustrates the fields and controls on the Degree page: Completion Info tab. You can find definitions for the fields and controls later on this page.

Degree page: Completion Info tab

Field or Control

Definition
Career

The career under which the student earns the degree.
Completion Term

The completion term of the degree.
Confer Date

The date the degree was conferred. This is the date when the degree is official.
Degr Stat (degree status)

The status of the degree. Choices are A (active) and R (revoked).
Degr Dt (degree date)

The date the degree is updated to a status of awarded or revoked. This date may differ from the actual confer date.

Honors/Rank Tab

Select the Honors/Rank tab.

Image: Degree page: Honors/Rank tab

This example illustrates the fields and controls on the Degree page: Honors/Rank tab. You can find definitions for the fields and controls later on this page.

Degree page: Honors/Rank tab

Field or Control

Definition
Hon Prefix (honors prefix)

The degree honors prefix for the degree.
Hon Suffix (honors suffix)

The degree honors suffix for the degree.
Degree GPA (degree grade point average)

The degree grade point average.
Class Rank Of

The student's class rank and class size.

Access the Degree Honors page (select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree Honors).

Image: Degree Honors page: Degree Info tab

This example illustrates the fields and controls on the Degree Honors page: Degree Info tab. You can find definitions for the fields and controls later on this page.

Degree Honors page: Degree Info tab

Note: Multiple views of this page are available by clicking the tabs in the scroll area. We document fields common to all views first.

Field or Control

Definition
User ID

The ID of the individual who made changes to the ACAD_DEGR_HONS record. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.
Date/Time

When changes to the ACAD_DEGR_HONS record were made.
Action

Action types include the following:

Insert: User inserted a new row (a row was added to the database).

Delete: User deleted a row out of the database. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.

Before: Image of the record before it was updated.

After: Image of the record after it was updated.
ID

The ID of the student whose degree was changed.
Degree Nbr (degree number)

Students can have more than one degree, and each degree is assigned a degree number.

Honors Info Tab

Select the Honors Info tab.

Image: Degree Honors page: Honors Info tab

This example illustrates the fields and controls on the Degree Honors page: Honors Info tab. You can find definitions for the fields and controls later on this page.

Degree Honors page: Honors Info tab

Field or Control

Definition
Honors Nbr (honors number)

Students can have multiple honors for each degree. Each honors value has a unique number.
Hon Code (honors code)

The honors code associated with the degree.
Award Date

The date the honor was awarded.
Diploma

The setting of the Print on Diploma check box on the Degree Honors page. The check box status values are Y for selected, and N for cleared.
Transcript

The setting of the Print on Transcript check box on the Degree Honors page. The check box status values are Y for selected, and N for cleared.

Access the Degree Plan page (select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree Plan).

Image: Degree Plan page: Plan Info tab

This example illustrates the fields and controls on the Degree Plan page: Plan Info tab. You can find definitions for the fields and controls later on this page.

Degree Plan page: Plan Info tab

Field or Control

Definition
User ID

The user ID of the individual who made changes to the ACAD_DEGR_PLAN record. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.
Date/Time

When changes to the ACAD_DEGR_PLAN record were made.
Action

Action types include the following:

Insert: User inserted a new row (a row was added to the database).

Delete: User deleted a row out of the database. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.

Before: Image of the record before it was updated.

After: Image of the record after it was updated.
ID

The ID of the student whose degree was changed.
Degree Nbr (degree number)

Students can have more than one degree, and each degree is assigned a degree number.
Acad Plan (academic plan)

All plans associated with the degree.

Career/Degree Tab

Select the Career/Degree tab.

Image: Degree Plan: Career/Degree tab

This example illustrates the fields and controls on the Degree Plan: Career/Degree tab. You can find definitions for the fields and controls later on this page.

Degree Plan: Career/Degree tab

Field or Control

Definition
Career

The career under which the student earns the degree.
Career Nbr (career number)

The number of the career associated with the degree. For students with more than one program in a single career, this number increments from zero.
Degr Stat (degree status)

The status of the degree. Choices are A (active) and R (revoked).
Degr Dt (degree date)

The date the degree is updated to a status of awarded or revoked. This date may differ from the actual confer date.
Override

This represents the setting of the Override check box on the Degree Plan page.

Descriptions Tab

Select the Descriptions tab.

Image: Degree Plan: Descriptions tab

This example illustrates the fields and controls on the Degree Plan: Descriptions tab. You can find definitions for the fields and controls later on this page.

Degree Plan: Descriptions tab

Field or Control

Definition
Dipl Descr (diploma description)

The academic plan diploma description, if different from the default.
Trns Descr (transcript description)

The academic plan transcript description, if different from the default.

Honors/Rank Tab

Select the Honors/Rank tab.

Image: Degree Plan: Honors/Rank tab

This example illustrates the fields and controls on the Degree Plan: Honors/Rank tab. You can find definitions for the fields and controls later on this page.

Degree Plan: Honors/Rank tab

Field or Control

Definition
Hon Prefix (honors prefix)

The degree honors prefix for the plan.
Hon Suffix (honors suffix)

The degree honors suffix for the plan.
Degree GPA (degree grade point average)

The plan grade point average.
Class Rank Of

The student's class rank and class size.
Plan Seq (plan sequence)

The number of the plan within the program.

Access the Degree Subplan page (select Records and Enrollment, then select Graduation, then select Degree Change Audit, then select Degree Subplan).

Image: Degree Subplan page: Degree Info tab

This example illustrates the fields and controls on the Degree Subplan page: Degree Info tab. You can find definitions for the fields and controls later on this page.

Degree Subplan page: Degree Info tab

Note: Multiple views of this page are available by clicking the tabs in the scroll area. We document fields common to all views first.

Field or Control

Definition
User ID

The user ID of the individual who made changes to the ACAD_DEGR_SPLN record. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.
Date/Time

When changes to the ACAD_DEGR_SPLN record were made.
Action

Action types include the following:

Insert: User inserted a new row (a row was added to the database).

Delete: User deleted a row out of the database. For rows where the action is Delete, no user ID appears. This is because when a record is deleted from the database, although the trigger can track that the record has been deleted, it cannot track the user ID of the person who deleted it. When deletes occur, the character string "********" appears in the User ID field.

Before: Image of the record before it was updated.

After: Image of the record after it was updated.
ID

The ID of the student whose degree was changed.
Degree Nbr (degree number)

Students can have more than one degree, and each degree is assigned a degree number.

Plan/SubPlan Override Tab

Select the Plan/SubPlan Override tab.

Image: Degree Subplan page: Plan/SubPlan Override tab

This example illustrates the fields and controls on the Degree Subplan page: Plan/SubPlan Override tab. You can find definitions for the fields and controls later on this page.

Degree Subplan page: Plan/SubPlan Override tab

Field or Control

Definition
Acad Plan (academic plan)

The academic plan.
Sub-Plan

The academic subplan.
Override

Represents the Override check box on the Degree Sub-Plan page.

Descriptions Tab

Select the Descriptions tab.

Image: Degree Subplan page: Descriptions tab

This example illustrates the fields and controls on the Degree Subplan page: Descriptions tab. You can find definitions for the fields and controls later on this page.

Degree Subplan page: Descriptions tab

Field or Control

Definition
Dipl Descr (diploma description)

The academic subplan diploma description, if different from the default.
Trns Descr (transcript description)

The academic subplan transcript description, if different from the default.

Honors/Plan/Sequence Number Tab

Select the Honors/Plan/Sequence Number tab.

Image: Degree Subplan page: Honors/Plan/Sequence Number tab

This example illustrates the fields and controls on the Degree Subplan page: Honors/Plan/Sequence Number tab. You can find definitions for the fields and controls later on this page.

Degree Subplan page: Honors/Plan/Sequence Number tab

Field or Control

Definition
Hon Prefix (honors prefix)

The degree honors prefix for the subplan.
Hon Suffix (honors suffix)

The degree honors suffix for the subplan.
Seq Nbr (sequence number)

The sequence number of the subplan assigned to the plan.