FINAID BUDGET COMPONENT Table
Contains the estimated amount of the standard financial aid budget items (eg. Tuition, Room and Board, Book and Supplies) for the different budget types (FEDR, INST, or PELL), aid periods (eg. Full Academic Year, Fall Term only, Spring Term only) and budget groups (eg. Regular Undergraduates, International Undergraduates, Regular Graduate Students) of a financial aid year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AID_PERIOD |
The period of which the student is eligible for financial aid. Values are: Full Academic Year, Fall Term Only, Spring Term Only, Summer Term Only, Summer/Fall (7.5 Month), and Twelve-Month. |
VARCHAR2 |
30 |
AID_YEAR |
Financial aid year. |
VARCHAR2 |
4 |
BUDGET_AMOUNT |
The estimated amount for a budget item (eg. Tuition, Room, Books) in a financial aid year. |
NUMBER |
22 |
BUDGET_CATEGORY |
The categories of the different financial aid budget items. Examples: Tuition, Room and Board Allowance, Travel and Personal Expenses, Books/Supplies Allowance. |
VARCHAR2 |
30 |
BUDGET_COMPONENT |
Financial aid budget items, including: Tuition, Room, Books & Materials, Medical Expenses, Personal Expenses, Travel. |
VARCHAR2 |
30 |
BUDGET_COMPONENT_KEY |
Key indentifying an entry in the Financial Aid Budget Component Table. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
24 |
BUDGET_GROUP |
The budget group assigned to the student for the aid year. In each financial aid year, aid applicants are assigned an appropriate budget group for the need analysis process to determine the amount of financial aid a student is eligible for. Some of the budget groups are: Undergraduate Regular, Undergraduate Commuter, Undergraduate International, Graduate Regular, Graduate Non-Resident, etc. |
VARCHAR2 |
30 |
BUDGET_TYPE |
The budget type codes: FEDR=Federal, INST=Institutional, PELL=Pell. The method applied in calculating the total budget amount (or the total cost of attendance) of the student for an aid year. |
VARCHAR2 |
4 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |