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

Table: STDNT_TEST_COMP - Student Test Components

Short Description: Test scores

Long Description: Scores for SAT, ACT, AP, GRE, GMAT, etc.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
TEST_ID	Test ID (SAT, ACT, etc.)
TEST_COMPONENT	Component associated with a Test ID
TEST_DT	Testing Date
SCORE	Test Score

Criteria Notes:

A student may have multiple scores for the same test. Pull the maximum for a single value, or use SA views (related tables)

Some tests have multiple versions. For example, SATI verses SATII verses SATR

Related Tables: U_SA_ACTCMAX_VW  U_SA_ACTEMAX_VW  U_SA_ACTMMAX_VW  U_SA_ACTRMAX_VW  U_SA_SATMMAX_VW  U_SA_SATVMAX_VW  U_SA_SATWMAX_VW  U_SA_TOEFMAX_VW  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.