Data Dictionary Keyword Search

This Data Dictionary contains student related Access.SMU database tables commonly used in the query tool. In the keyword search below you may enter the table name, field name, or the common name for the information you are seeking.

| List All Tables

Table Information for U_SA_AUTH_GRANT:

Table: U_SA_AUTH_GRANT - Auth Accounts - Self-Service

Short Description: History of student actions under Release of Education Records

Long Description: Shows all the times (date/time stamp) a student granted or removed access

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
DTTM_STAMP_SEC	Date/Time stamp of change to Release of Education Records
U_SA_AUTH_ID	ID number of the relation
U_SA_AUTH_AREA	Release of Education Records Authorized Area
U_SA_AUTH_ACTN	Action taken: grant or remove

Criteria Notes:

Join to U_SA_AUTH_AREA for descriptions

EMPLID is the student ID, U_A_AUTH_ID is the relation

Related Tables: RELATIONSHIPS  U_SA_AUTH_ACCT  U_SA_AUTH_AREA 

For updates, corrections or questions Email Stephen Forrest.