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_SATWMAX_VW:

Table: U_SA_SATWMAX_VW - AD - SAT Max WRIT score

Short Description: SAT writing score

Long Description: A view that has the highest SAT writing score for students

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
WRITMAX	SAT writing score (max)

Criteria Notes:

Outer join to this view to keep in the output students who do not have the SAT score

To get overall SAT score, sum the components.

Related Tables: STDNT_TEST_COMP  U_SA_SATMMAX_VW  U_SA_SATVMAX_VW 

For updates, corrections or questions Email Stephen Forrest.