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

Table: TRNS_CRSE_SCH - Student Transfer Credit School

Short Description: Transfer school credit

Long Description: Transfer credit parent record showing source, no course details

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
MODEL_NBR	Reference Number for group of a student's transfer courses
EXT_ORG_ID	External Organization ID

Criteria Notes:

Join to TRNS_CRSE_DTL to get transfer course credits

Join to an external organization record for details on the source institution

Related Tables: TRNS_CRSE_DTL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.