Understanding Advisement Report Result Tables

The Advisement Report Result Tables allow for easier customization of advisement reports.

The primary key on all records has the EMPLID, ANALYSIS_DB_SEQ, and SAA_CAREER_RPT fields. All records that contain "order specific" information from a specific report have the field SAA_ENTRY_SEQ as a key. 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 contains the primary unique index plus 4 alternate search keys: 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 child 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".