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.
Table Information for
STDNT_AWRD_DISB :
Table: STDNT_AWRD_DISB - Student Award Disbursements Short Description : Financial aid awardedLong Description : Sums a balance amount for each item typeUseful Fields :Field Name Field Descr EMPLID Student/Person ID number AID_YEAR Aid Year for financial aid data (begins with a fall term) STRM Term ACAD_CAREER Code for Academic Career. Value attached to the student. ITEM_TYPE Item Number code that describes the transaction OFFER_BALANCE Financial Aid amount offered to the student (may not be accepted) ACCEPT_BALANCE Financial amount accepted by the student (may not be disbursed) DISBURSED_BALANCE Financial amount disbursed to the student DISBURSEMENT_ID Disbursement ID
Criteria Notes :An aid year begins with the fall term Balances to show total amount offered to a student (OFFER_BALANCE). The student agrees to the amount (ACCEPT_BALANCE). The amount is disbursed to the student's account (DISBURSED_BALANCE) Join to ITEM_TYPE_FA for details on ITEM_TYPE
Related Tables : ACAD_CALTRM_TBL ISIR_CONTROL ISIR_PARENT ISIR_STUDENT ITEM_TYPE_FA ITEM_TYPE_TBL STDNT_AWARDS STDNT_AWRD_DISB U_CC_PDATA_TBL XLATTABLE_VW
For updates, corrections or questions Email
Stephen Forrest .