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

Table: U_SR_CUM_GPA - SMU Cum Transfer GPA

Short Description: Transfer GPA

Long Description: Transfer GPA, with grade points and GPA hours

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
LS_GPA	Transfer GPA
GRADE_POINTS	Grade points for transfer work
UNT_TRNSFR	Transfer Hours included in transfer GPA

Criteria Notes:

To get all-college GPA take the GRADE_POINTS and UNT_TRNSFR and combine with points (TOT_GRADE_POINTS) and hours (TOT_TAKEN_GPA) from STDNT_CAR_TERM

Related Tables: STDNT_CAR_TERM  TRNS_CRSE_DTL  U_SR_TRN_CRS_VW  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.