Producing a Database Tables Report

Create a Database Table report to retrieve all of the data stored in each academic advisement table for a specific student on a specific date.

Here's how to create a Database Tables report:

  1. Specify the as of date, ID, and report type on the Database Tables Report page.

    Leave the ID and Report Type fields blank for the system to return all of the values (wild card).

  2. Click the Run button to process the report.

This section lists prerequisites and discusses how to enter database table information.

Before you can run the Database Tables report, you must first populate the database tables by running a transcript with the report format of analysis database for the student or group of students in whom you are interested.

Page Name

Definition Name

Navigation

Usage

Database Tables Report

RUNCTL_SRDBTBLS

Academic Advisement > Advisement Reports > Database Tables

Retrieve all of the data stored in each academic advisement table for a specific student on a specific date. Before creating a modified report, you can run this report to view the data that is available for the student.

On any specific day, you can run one standard and one special report for the same student.

Access the Database Tables Report page (Academic Advisement > Advisement Reports > Database Tables).

Field or Control

Description

As of Date

The database tables report accurately reflects the contents of each academic advisement table for the designated student as of this date. This field value automatically populates to the current date, but you can modify it. A value in this field is required.

ID

Enter the student's ID number.

Report Type

Enter the report. Values are:

SPC (special): Indicates a special advising report using a special requirement usage.

STD (standard): Indicates a standard advising report.