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

Field: DESCR

Field Name: DESCR

Relevant Tables:

Table	Field Name	Field Descr
ACAD_GROUP_TBL	DESCR	Academic Group description
ACAD_ORG_TBL	DESCR	Academic Organization description
ACAD_PLAN_TBL	DESCR	Academic Plan description
ACAD_PROG_TBL	DESCR	Academic Program description
ACAD_SUBPLN_TBL	DESCR	Academic Sub Plan description
BLDG_TBL	DESCR	Building description
CITIZEN_STS_TBL	DESCR	Description for a citizenship status code
CLASS_TBL	DESCR	Class description
COUNTRY_TBL	DESCR	Country name
CRSE_ATTR_TBL	DESCR	Course Attribute description
CRSE_ATTR_VALUE	DESCR	Course Attribute Value description
CRSE_CATALOG	DESCR	Course description (short)
DEGR_HONORS_TBL	DESCR	Degree Honors description
DEGREE_TBL	DESCR	Degree description
EXT_COURSE	DESCR	External Course description
EXT_ORG_SCHL_VW	DESCR	External Organization description
EXT_SUBJECT_TBL	DESCR	External Subject description
FACILITY_TBL	DESCR	Facility ID description (building and room)
ITEM_LINE_SF	DESCR	Line Item (charge of payment) description
ITEM_LNDDT_VW	DESCR	Line Item (charge of payment) description
ITEM_TYPE_FA	DESCR	Financial Aid description
ITEM_TYPE_TBL	DESCR	Line Item (charge of payment) description
PROG_ACTION_TBL	DESCR	Program action description
PROG_RSN_TBL	DESCR	Reason description for a program action
REL_PREF_TBL	DESCR	Religious Preference description
SRVC_IMPACT_TBL	DESCR	Service Impact description
SRVC_IN_RSN_TBL	DESCR	Service Indicator (hold) Reason description
SRVC_IND_CD_TBL	DESCR	Service Indicator (hold) description
STATE_TBL	DESCR	State name
STDNT_GROUP_TBL	DESCR	Student Group description
STUDY_FIELD_TBL	DESCR	Department description
TERM_TBL	DESCR	Term description
U_SA_AUTH_AREA	DESCR	Authorized Area description
U_SL_OR_ARO_SES	DESCR	AARO Session description
U_SR_CEN_CLASS	DESCR	Class description (short title)
U_SR_CENCAP_TBL	DESCR	Census Capture description

For updates, corrections or questions Email Stephen Forrest.