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

Table: SRVC_IN_RSN_TBL - Service Indicator Reason

Short Description: Setup table for reasons codes used with a service indicator (hold)

Long Description: Setup table for reasons codes used with a service indicator (hold)

Useful Fields:

Field Name	Field Descr
SRVC_IND_CD	Code for Service Indicator, or Hold
EFFDT	Date the data or action takes effect
SRVC_IND_REASON	Code for service indicator (hold) reason
DESCR	Service Indicator (hold) Reason description
DESCRLONG	Service Indicator (hold) description (very long)
DEPTID	Department associated with a Hold (service indicator)

Criteria Notes:

To see descriptions for reason code, join from SRVC_IND_DATA

Related Tables: SERVICE_IMPACT  SRVC_IMPACT_TBL  SRVC_IND_CD_TBL  SRVC_IND_DATA 

For updates, corrections or questions Email Stephen Forrest.