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

Table: XLATTABLE_VW - Translate Value View

Short Description: Translate values

Long Description: Descriptions for codes that do not have setup data

Useful Fields:

Field Name	Field Descr
FIELDNAME	Database Field Name
FIELDVALUE	The field value to translate
EFFDT	Date the data or action takes effect
XLATLONGNAME	Description for a translated value

Criteria Notes:

You may need to manually translate values in a field

Join from the table that has a code in the source field

Set FIELDNAME equal to the name of the field from the source table.

Join FIELDVALUE to the source field

Most field names match. One exception is academic level. From STDNT_CAR_TERM join ACAD_LEVEL_BOT to the FIELDVALUE, set FIELDNAME = 'ACADEMIC_LEVEL'

Related Tables: ACAD_CALTRM_TBL  ACAD_DEGR  ACAD_DEGR_HONS  ACAD_DEGR_PLAN  ACAD_DEGR_SPLN  ACAD_PLAN  ACAD_PLAN_OWNER  ACAD_PROG  ACAD_PROG_TBL  ACAD_STDNG_ACTN  ACAD_SUBPLAN  ACAD_SUBPLN_TBL  ACCOUNT_SF  ADDRESSES  ADDRESSES4_VW  ADM_INTERESTS  ADM_MC_VW  CLASS_INSTR  CLASS_MTG_PAT  CLASS_TBL  CRSE_CATALOG  CRSE_OFFER  DEGREE_TBL  ENRL_REQ_DETAIL  INSTR_ADVISOR  ISIR_CONTROL  ISIR_PARENT  ISIR_STUDENT  ITEM_LINE_SF  ITEM_LNDDT_VW  ITEM_SF  ITEM_TYPE_FA  ITEM_TYPE_TBL  RELATIONSHIPS  SCC_CITIZEN_QVW  SCC_EMERG_C_QVW  SCC_EMERG_P_QVW  SERVICE_IMPACT  STDNT_ADVR_HIST  STDNT_AWARDS  STDNT_AWRD_DISB  STDNT_CAR_TERM  STDNT_CAREER  STDNT_ENRL  STDNT_GROUP_TBL  STDNT_GRPS_HIST  STDNT_TEST_COMP  STUDY_FIELD_TBL  TERM_TBL  TRNS_CRSE_DTL  TRNS_CRSE_SCH  TRNS_TEST_DTL  U_CC_PDATA_TBL  U_SL_OR_ARO_SES  U_SL_OR_STD_ARO  U_SL_OR_STD_CAN  U_SL_OR_STD_GST  U_SR_CARTERM_VW  U_SR_CEN_CLASS  U_SR_CEN_PROG  U_SR_CENCAP_TBL  U_SR_CENSUS_CLS  U_SR_CENSUS_TRM  U_SR_CENSUS_TRN  U_SR_CUM_GPA 

For updates, corrections or questions Email Stephen Forrest.