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

Field Information for EMPLID:

Field: EMPLID

Field Name: EMPLID

Relevant Tables:

Table	Field Name	Field Descr
ACAD_DEGR	EMPLID	Student/Person ID number
ACAD_DEGR_HONS	EMPLID	Student/Person ID number
ACAD_DEGR_PLAN	EMPLID	Student/Person ID number
ACAD_DEGR_SPLN	EMPLID	Student/Person ID number
ACAD_PLAN	EMPLID	Student/Person ID number
ACAD_PROG	EMPLID	Student/Person ID number
ACAD_STDNG_ACTN	EMPLID	Student/Person ID number
ACAD_SUBPLAN	EMPLID	Student/Person ID number
ACCOUNT_SF	EMPLID	Student/Person ID number
ADDRESSES	EMPLID	Student/Person ID number
ADDRESSES4_VW	EMPLID	Student/Person ID number
ADM_INTERESTS	EMPLID	Student/Person ID number
ADM_MC_VW	EMPLID	Student/Person ID number
CLASS_INSTR	EMPLID	Student/Person ID number
ENRL_REQ_DETAIL	EMPLID	Student/Person ID number
EXT_ACAD_DATA	EMPLID	Student/Person ID number
EXT_ACAD_SUM	EMPLID	Student/Person ID number
EXT_COURSE	EMPLID	Student/Person ID number
GRADE_ROSTER	EMPLID	Student/Person ID number
INSTR_ADVISOR	EMPLID	Student/Person ID number
ISIR_CONTROL	EMPLID	Student/Person ID number
ISIR_PARENT	EMPLID	Student/Person ID number
ISIR_STUDENT	EMPLID	Student/Person ID number
ITEM_LINE_SF	EMPLID	Student/Person ID number
ITEM_LNDDT_VW	EMPLID	Student/Person ID number
ITEM_SF	EMPLID	Student/Person ID number
RELATIONSHIPS	EMPLID	Student/Person ID number
RELIGIOUS_PREF	EMPLID	Student/Person ID number
SCC_CITIZEN_QVW	EMPLID	Student/Person ID number
SCC_DIV_ETH_QVW	EMPLID	Student/Person ID number
SCC_EMAIL_QVW	EMPLID	Student/Person ID number
SCC_EMERG_C_QVW	EMPLID	Student/Person ID number
SCC_EMERG_P_QVW	EMPLID	Student/Person ID number
SCC_NAMES_QVW	EMPLID	Student/Person ID number
SCC_PER_EFF_QVW	EMPLID	Student/Person ID number
SCC_PERS_NI_QVW	EMPLID	Student/Person ID number
SCC_PERS_PH_QVW	EMPLID	Student/Person ID number
SCC_PERS_SA_VW	EMPLID	Student/Person ID number
SCC_VISA_P_QVW	EMPLID	Student/Person ID number
SRVC_IND_DATA	EMPLID	Student/Person ID number
STDNT_ADVR_HIST	EMPLID	Student/Person ID number
STDNT_AWARDS	EMPLID	Student/Person ID number
STDNT_AWRD_DISB	EMPLID	Student/Person ID number
STDNT_CAR_TERM	EMPLID	Student/Person ID number
STDNT_CAREER	EMPLID	Student/Person ID number
STDNT_ENRL	EMPLID	Student/Person ID number
STDNT_GRPS_HIST	EMPLID	Student/Person ID number
STDNT_TEST_COMP	EMPLID	Student/Person ID number
TRNS_CRSE_DTL	EMPLID	Student/Person ID number
TRNS_CRSE_SCH	EMPLID	Student/Person ID number
TRNS_TEST_DTL	EMPLID	Student/Person ID number
U_CC_PDATA_TBL	EMPLID	Student/Person ID number
U_SA_ACTCMAX_VW	EMPLID	Student/Person ID number
U_SA_ACTEMAX_VW	EMPLID	Student/Person ID number
U_SA_ACTMMAX_VW	EMPLID	Student/Person ID number
U_SA_ACTRMAX_VW	EMPLID	Student/Person ID number
U_SA_AUTH_ACCT	EMPLID	Student/Person ID number
U_SA_AUTH_GRANT	EMPLID	Student/Person ID number
U_SA_SATMMAX_VW	EMPLID	Student/Person ID number
U_SA_SATVMAX_VW	EMPLID	Student/Person ID number
U_SA_SATWMAX_VW	EMPLID	Student/Person ID number
U_SA_TOEFMAX_VW	EMPLID	Student/Person ID number
U_SL_OR_STD_ARO	EMPLID	Student/Person ID number
U_SL_OR_STD_CAN	EMPLID	Student/Person ID number
U_SL_OR_STD_GST	EMPLID	Student/Person ID number
U_SR_CARTERM_VW	EMPLID	Student/Person ID number
U_SR_CEN_PROG	EMPLID	Student/Person ID number
U_SR_CENSUS_CLS	EMPLID	Student/Person ID number
U_SR_CENSUS_TRM	EMPLID	Student/Person ID number
U_SR_CENSUS_TRN	EMPLID	Student/Person ID number
U_SR_CUM_GPA	EMPLID	Student/Person ID number
U_SR_HONORS_TBL	EMPLID	Student/Person ID number
U_SR_TRN_CRS_VW	EMPLID	Student/Person ID number
U_AD_SLATE_DATA	EMPLID	Student/Person ID number

For updates, corrections or questions Email Stephen Forrest.