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

Table: EXT_ORG_SCHL_VW - External Organization Schl VW

Short Description: Data on high schools and colleges

Long Description: This view has description, type, city, state and country.

Useful Fields:

Field Name	Field Descr
EXT_ORG_ID	External Organization ID
EFFDT	Date the data or action takes effect
LS_SCHOOL_TYPE	School Type (HS, 2YI, 2YO, etc.)
DESCR	External Organization description
CITY	City
STATE	State
COUNTRY	Country

Criteria Notes:

Join to this record from other records by EXT_ORG_ID, LAST_SCH_ATTEND, or SOURCE_ID.

Related Tables: ADM_MC_VW  EXT_ACAD_DATA  EXT_ACAD_SUM  EXT_COURSE  EXT_ORG_TBL  EXT_ORG_TBL_ADM  EXT_SUBJECT_TBL  U_SR_CEN_TRN 

For updates, corrections or questions Email Stephen Forrest.