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

Table: U_AD_SLATE_DATA - SLATE Data Dump Table

Short Description: Application and admissions data from the undergratdaute instance of Slate

Long Description: Data is updated daily from Slate, which is a supplement to native PeopleSoft tables in my.SMU which is consider the system of record for applicants, with Slate being the operational home for Admissions.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ADM_APPL_NBR	PeopleSoft admission's application number
PROG_ACTION	Admission action from Slate (will not show martriculation)
PROG_REASON	Action reason from Slate
ACTION_DATE	Action date from Slate
U_AD_ADMT_RLEASEDT	Admit Date
DEPOSIT_DATE	Deposit Date
RECRUITER_NAME	Name of the Admission recruiter
MAJOR_NAME	Primary academic interest (the code is EXT_SUBJECT)
MAJOR_NAME_2ND	Secondary academic interest (the code is EXT_SUBJECT)
U_AD_SAT_SR_V	Superscore for SATR, includes any self-reported scores
U_AD_SAT_V	Superscore for SATR, excludes any self-reported scores
U_AD_ACT_SR_V	Superscore for ACT, includes any self-reported scores
U_AD_ACT_V	Superscore for ACT, excludes any self-reported scores
HS_GRAD_DT	High school graduation date
CONVERT_GPA	High School GPA, recalcualted by admissions
RATING_CMP_VALUE5	Admission rating
RATING_VALUE	Scholarship Rating

Criteria Notes:

Always begin with ADM_MC_VW, and then join to U_AD_SLATE_DATA by EMPLID and ADM_APPL_NBR.

Matriculation actions do appear in Slate, and thus not on U_AD_SLATE_DATA.

Slate for undergraduates began in 2014. When pulling history, then outerjoin from ADM_MC_VW to U_AD_SLATE_DATA.

Join to EXT_SUBJECT_TBL for descriptions of Academic Interest. Effective dated Academic Interests are on ADM_INTERESTS.

Related Tables: ADM_MC_VW  EXT_SUBJECT_TBL  ADM_INTERESTS 

For updates, corrections or questions Email Stephen Forrest.