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

Table: EXT_ACAD_DATA - External Academic Data

Short Description: Transcripts from other institutions

Long Description: This the parent, header, record for external transcripts.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
EXT_ORG_ID	External Organization ID
EXT_CAREER	Career for the external academic data
EXT_DATA_NBR	Reference row number for a student's external data (transcript)
RECEIVED_DT	Date a transcript was received

Criteria Notes:

Main purpose is to see the RECEIVED_DT

Related Tables: EXT_ACAD_SUM  EXT_COURSE  EXT_ORG_SCHL_VW  EXT_ORG_TBL  EXT_ORG_TBL_ADM  EXT_SUBJECT_TBL 

For updates, corrections or questions Email Stephen Forrest.