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

Table: U_SR_TRN_CRS_VW - SMU Trnsfr Crse Detail Sum

Short Description: Transfer class credits

Long Description: A view of transfer credits

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_COURSE_NBR	Reference Number for a student's group of external courses
EXT_ORG_ID	External Organization ID
ARTICULATION_TERM	Tem in which transfer work was articulated to SMU
UNT_TAKEN	Transfer Hours
CRSE_GRADE_OFF	Official Grade
CRSE_ID	Course ID number
UNT_TRNSFR	Transfer Hours
TERM_YEAR	Calendar year of term
EXT_TERM	External Term (fall, spring, summer, etc.)

Criteria Notes:

An alternative to pulling transfer work from TRNS_CRSE_DTL

For transfer credits set TRNSFR_STAT = P, EARN_CREDIT = Y, and join to CRSE_OFFER by CRSE_ID to get the SMU credit

Join to EXT_COURSE to get details on the "transfer from" course

Related Tables: STDNT_CAR_TERM  TRNS_CRSE_DTL  U_SR_CUM_GPA 

For updates, corrections or questions Email Stephen Forrest.