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

Table: ENRL_REQ_DETAIL - Enrollment Request Detail Line

Short Description: Log of ALL enrollment requests

Long Description: Each enrollment request, success or failed, is logged here. Includes grade changes, not the initial grade posted, which comes from GRADE_ROSTER

Useful Fields:

Field Name	Field Descr
ENRL_REQUEST_ID	Enrollment Request ID, can have multiple requests (sequences)
ENRL_REQ_DETL_SEQ	Sequence Number of an enrollment request (one request ID can have multiple requests)
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
STRM	Term
CLASS_NBR	Class Number, a unique value within each term for a class section.
ENRL_REQ_ACTION	Enrollment Request Action
ENRL_ACTION_REASON	Enrollment Request Action Reason
CLASS_NBR_CHG_TO	For a swap enrollment request, this represents into which class section a student swapped
ENRL_REQ_DETL_STAT	Resulting status of an enrollment request ID/sequence
OPRID	ID of administrative user who performed this action
DTTM_STAMP_SEC	Date/Time stamp of enrollment request

Criteria Notes:

If joining to CLASS_TBL then join by STRM and CLASS_NBR

If joining to STDNT_ENRL then join by EMPLID, STRM, and CLASS_NBR

Set field ENRL_REQ_DETL_STAT in ('M','S') to pull successful requests

OPRID field is the user who performed the action. If it equals EMPLID then the student did so via self-service

Fields that begin with OVRD will show if an admin user employed an override to complete the request.

Field ENRL_REQ_ACTION will denote if a add, drop or swap. Or grade change.

Field CLASS_NBR_CHG_TO will have the class number for the "swap to" class section.

Field DTTM_STAMP_SEC shows the date/time of request.

Related Tables: ACAD_CALTRM_TBL  CLASS_TBL  GRADE_ROSTER  STDNT_ENRL  TERM_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.