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

Table: EXT_ORG_TBL_ADM - External Org Admissions

Short Description: Data on high schools and colleges

Long Description: This view has type, and CEEP code (field ATP_CD)

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.)
ATP_CD	Also called CEEP code.

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_SCHL_VW  EXT_ORG_TBL  EXT_SUBJECT_TBL  U_SR_CEN_TRN 

For updates, corrections or questions Email Stephen Forrest.