Understanding Advisement Report Result Tables

Major structural changes were implemented for release 9.0 to allow for easier customization of advisement reports. One of these changes created a new set of output tables known as the Advisement Report Result Tables. These tables are loosely based on the old Analysis Database tables from previous releases. The new Report Result tables contain all of the information from the Analysis Database tables and new data elements added to enhance the data available for the advisement reports.

All tables will have the key structure changed from the old records. The new primary key on all records will have the EMPLID, ANALYSIS_DB_SEQ, and SAA_CAREER_RPT. All records that contain "order specific" information from a specific report will have the field SAA_ENTRY_SEQ as a key. This field was changed from ENTRY_SEQ so the field could be expanded to 4 digits. In the Analysis Database tables, the field ENTRY_SEQ was used inconsistently. In some cases, the field was needed to join a table with a corresponding table in order to match the correct attributes. In the Report Results tables, this key is used consistently throughout the processing, always keeping the results table (SAA_ADB_RESULTS) matched against the child tables such as courses used (SAA_ADB_CRSEUSE) and conditions used (SAA_ADB_CONDUSE)."

The table SAA_ADB_REPORT will contain the primary unique index plus have 4 alternate search keys defined – INSTITUTION, TSCRPT_TYPE, RPT_DATE, and SAA_RPT_IDENTIFIER. These search keys will be needed when trying to identify the correct report from the on-line process. These alternate keys (with the exception of INSTITUTION) are also carried down into the children records. These indexes are used by the purge process. In the listing below, the primary index is listed as "Pri" and any alternate index is listed as "Alt".