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

Table: SRVC_IMPACT_TBL - Service Impact Table

Short Description: Setup table for service impacts

Long Description: Description details what is impacted by a service indicator (Hold)

Useful Fields:

Field Name	Field Descr
SERVICE_IMPACT	Code for Service Impact (restrict enrollment, etc.)
EFFDT	Date the data or action takes effect
DESCR	Service Impact description

Criteria Notes:

Join from SRVC_IND_DATA to SERVICE_IMPACT to SRVC_IMPACT_TBL to understand the impact of a hold.

Related Tables: SERVICE_IMPACT  SRVC_IN_RSN_TBL  SRVC_IND_CD_TBL 

For updates, corrections or questions Email Stephen Forrest.