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

Table: ITEM_TYPE_TBL - Item Type Table

Short Description: Item Type setup for all charges and payments

Long Description: Setup data for all Item Types for all charges and payments, including financial aid, effective dated.

Useful Fields:

Field Name	Field Descr
ITEM_TYPE	Item Number code that describes the transaction
EFFDT	Date the data or action takes effect
DESCR	Line Item (charge of payment) description
ITEM_TYPE_CD	Item Type Code, a transaction category (charge, financial aid, etc.)
KEYWORD1	Reporting reference or category
KEYWORD2	Reporting reference or category
KEYWORD3	Reporting reference or category

Criteria Notes:

The three KEYWORD fields are used to categorize item types. KEYWORD1 is the most populated.

Related Tables: ACCOUNT_SF  ITEM_LINE_SF  ITEM_LNDDT_VW  ITEM_SF  STDNT_AWARDS  STDNT_AWRD_DISB  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.