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

Table: ITEM_TYPE_FA - FA Item Type Table

Short Description: Item Type setup for Financial Aid

Long Description: FA item types are setup by Aid Year.

Useful Fields:

Field Name	Field Descr
ITEM_TYPE	Item Number code that describes the transaction
AID_YEAR	Aid Year for financial aid data (begins with a fall term)
EFFDT	Date the data or action takes effect
DESCR	Financial Aid description
FA_SOURCE	Source of funds for Financial Aid (federal, institution, etc.)
FEDERAL_ID	Federal designation of Financial Aid
FIN_AID_TYPE	Type of Financial Aid (scholarship, loan, etc.)
REPORT_CODE	Reporting category for financial aid item types

Criteria Notes:

Field REPORT_CODE is used to categorize financial aid item types.

Here is a expression to translate REPORT_CODE

(Case

When A.REPORT_CODE = 'AA' Then 'Emplymt - Fed Work Study'

When A.REPORT_CODE = 'AB' Then 'Emplymt - Tx Work Study'

When A.REPORT_CODE = 'BA' Then 'Emplymt - Dept Unrestricted'

When A.REPORT_CODE = 'BX' Then 'Emplymt - Univ Unrestricted'

When A.REPORT_CODE = 'CA' Then 'Need - Univ Unrestricted'

When A.REPORT_CODE = 'CB' Then 'Need - Univ Restricted'

When A.REPORT_CODE = 'CE' Then 'Need - Pell Grants'

When A.REPORT_CODE = 'CF' Then 'Need - Othr Fed Grants'

When A.REPORT_CODE = 'CG' Then 'Need - State Grants'

When A.REPORT_CODE = 'DC' Then 'Loans - Stafford Sub/Unsub'

When A.REPORT_CODE = 'DD' Then 'Loans - Perkins'

When A.REPORT_CODE = 'DE' Then 'Loans - State'

When A.REPORT_CODE = 'DF' Then 'Loans - Priv/Alternative'

When A.REPORT_CODE = 'DG' Then 'Loans - University'

When A.REPORT_CODE = 'DH' Then 'Loans - Grad Plus'

When A.REPORT_CODE = 'DP' Then 'Loans - PLUS'

When A.REPORT_CODE = 'DR' Then 'Loans - Remaining Elig'

When A.REPORT_CODE = 'EA' Then 'Merit - Pres Scholar'

When A.REPORT_CODE = 'EB' Then 'Merit - Univ Unrestricted'

When A.REPORT_CODE = 'EC' Then 'Merit - Univ Restricted'

When A.REPORT_CODE = 'ED' Then 'Merit - Dept Unrestricted'

When A.REPORT_CODE = 'EE' Then 'Merit - Dept Restricted'

When A.REPORT_CODE = 'EF' Then 'Merit - Hunt Scholar'

When A.REPORT_CODE = 'EG' Then 'Merit - Byrd Scholar'

When A.REPORT_CODE = 'EH' Then 'Merit - State Scholar'

When A.REPORT_CODE = 'EI' Then 'Merit - External Scholar'

When A.REPORT_CODE = 'EX' Then 'Merit - Dept Sch Estimate'

When A.REPORT_CODE = 'FA' Then 'Athletic Aid'

When A.REPORT_CODE = 'GA' Then 'Misc - Dept Unrestricted'

When A.REPORT_CODE = 'GB' Then 'Misc - Dept Restricted'

When A.REPORT_CODE = 'GC' Then 'Misc Univ Unrestricted'

When A.REPORT_CODE = 'GD' Then 'Misc Federal'

When A.REPORT_CODE = 'GE' Then 'Misc State'

When A.REPORT_CODE = 'HA' Then 'Tuition Benefits'

When A.REPORT_CODE = 'HB' Then 'Estimated Tuition Benefits'

When A.REPORT_CODE = 'HC' Then 'Outside Tuition Remission'

End)

Related Tables: ITEM_LINE_SF  ITEM_LINE_SF  ITEM_LINE_SF  STDNT_AWARDS  STDNT_AWRD_DISB  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.