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

Table: TRNS_CRSE_DTL - Student Transfer Course Detail

Short Description: Transfer class credits

Long Description: Transfer classes showing the SMU course ID

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
ARTICULATION_TERM	Tem in which transfer work was articulated to SMU
EXT_COURSE_NBR	Reference Number for a student's group of external courses
TERM_YEAR	Calendar year of term
EXT_TERM	External Term (fall, spring, summer, etc.)
UNT_TAKEN	Units (hours) for transfer work
CRSE_ID	Course ID number
CRSE_GRADE_OFF	Official Grade
GRD_PTS_PER_UNIT	Grade points per unit (hour)
EARN_CREDIT	Earned Credit (Y or N)
INCLUDE_IN_GPA	Transfer work taken for GPA (Y or N)

Criteria Notes:

Table U_SR_TRN_CRS_VW is a better alternative if you want more than just what transferred

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 TRNS_CRSE_SCH (parent record) to get the source institution (EXT_ORG_ID)

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

Related Tables: CRSE_OFFER  TRNS_CRSE_SCH  U_SR_CUM_GPA  U_SR_TRN_CRS_VW  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.