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

Table: TRNS_TEST_DTL - Student Transfer Test Detail

Short Description: Test class credits

Long Description: Test credits 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.
ARTICULATION_TERM	Tem in which test credits was articulated to SMU
TEST_ID	Test ID (SAT, ACT, etc.)
TEST_COMPONENT	Component associated with a Test ID
TEST_DT	Testing Date
SCORE	Test Score
CRSE_ID	Course ID number
UNT_TRNSFR	Units (hours) for test credit
CRSE_GRADE_OFF	Official Grade
EARN_CREDIT	Earned Credit (Y or N)

Criteria Notes:

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

TEST_ID and TEST_COMPONENT do not populate for every row, only the first sequence number (TRNSFR_EQVLNCY_SEQ) in a group has a value for test ID and component.

Related Tables: CRSE_OFFER  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.