Arizona State University Provost | Institutional Analysis | Strategic Planning & Policy Analysis | ASSIST 
 DA & DWData AdministrationData WarehouseAffiliateStaffContact

 Resources:
• WUG Meeting Handouts
• Data Diagrams
• Data Warehouse Overview
• How to get Access
• Ask a Question
• Brio Query
• Data Documentation

 Resources:
• DSTA 105–01: Release of Student Information

• Student Educational Records - FERPA

• Access to or Disclosure of ASU Personnel Records or Information

• ACD 811: Access to and Release of Official Personnel Records Information

• SPP 1101: Personnel Records

• ASU’s Privacy Statement
 Course Database


TABLE: CLASS FOOTNOTE
WUG March 1995

What is the Class Footnote table?
This table contains current information on the footnotes that appear in the ASU Schedule of Classes. These footnotes give information about special requirements for the class, if the class is an honors class, if it is an Instructional Television fixed service course, if special fees are required, if course requirements edits will prevent registration in it and more. It is frozen at the end of the semester. This table has multiple records if a class has more than one footnote associated with it.

What is the key (unique identifier for a row) for Registered Student?
Semester, SLN, and Footnote Code.

What is the timing of the table?
This table is updated weekly until the last day of classes when it is frozen.

Why would you use it?
To select courses that have certain footnotes.

Why would you NOT want to use it?

What should you watch out for?
If a class has more than one footnote, there will be a separate record for each.

WHS 102 - Accessing ASU Data Warehouse

Copyright © 2002 Arizona Board of Regents
Having problems with the site?
contact webmaster: ware-q@asu.edu