- DATA VIEW NAME
- FA_APPLICATION_DETAIL
- OVERVIEW
- All active financial aid applicants who have gone though need analysis and have been awarded, or are in an application status that indicates they are ready to be awarded. Please note that some applications will contain estimates or other changes (assumptions) based upon the professional judgment of a Financial Aid counselor.
This data view does not contain records for aid applicants whose applications are still being reviewed and/or processed.
The aid application process is separate from the admissions and enrollment processes. At certain times of the year, records may exist on this data view for people who were admitted but never enrolled. For this reason, you should always use this data view in conjunction with an enrollment or admission data view in order to correctly determine your population of interest.
- LOAD FREQUENCY
- Data will be refreshed nightly (Monday through Friday).
- DATA CUSTODIAN
- Student Financial Aid
Contact: John Dreger - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 04/2009 – New view created.
- DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
FormatDescription
| Column Name | Format | Description | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| *ID | Varchar2 (11) | ISIS personal Identifier. The ID will never be changed throughout the individual’s relationship with the University. Only 10 characters are in use. | |||||||||
| *Fin_Aid_Year | Varchar2 (4) | Financial Aid year equals the second year of an academic year (same as the fiscal year). For example, aid year 2008 is the 2007-08 academic year. | |||||||||
| Parent_AGI | Integer | Adjusted Gross Income of the parent(s) as reported on their Federal Tax Return for the year prior to the Financial Aid year. | |||||||||
| Parent_SSI_Income_Ind | Varchar2 (1) | Indicates whether the parent(s) received SSI (Supplemental Security Income) benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Parent_Food_Stamps_Ind | Varchar2 (1) | Indicates whether the parents(s) received Food Stamp benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Parent_School_Lunch_Ind | Varchar2 (1) | Indicates whether the parent(s) received Free or Reduced Price School Lunch benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Parent_TANF_Benefits_Ind | Varchar2 (1) | Indicates whether the parent(s) received TANF (Temporary Assistance for Needy Families) benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Parent_WIC_Benefits_Ind | Varchar2 (1) | Indicates whether the parents(s) received WIC (Woman, Infant and Children) benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Parent_Marital_Status | Varchar2 (1) | Parent(s) marital status as of the date of the Financial Aid application. 1 = Married/Remarried 2 = Single 3 = Divorced/Separated 4 = Widowed NULL |
|||||||||
| Parent_Nbr_in_Family | Varchar2 (2) | Number of people in the parental household for which the parent(s) provide at least 50% support. | |||||||||
| Parent_Nbr_in_College | Varchar2 (1) | Number of people in the parental household attending college at least half-time. Note: this does not include parent(s). | |||||||||
| Parent_Father_Grade_Level | Varchar2 (1) | Highest educational level attained by father. 1 = Middle School/Junior High 2 = High School 3 = College or Beyond 4 = Other/unknown NULL |
|||||||||
| Parent_Mother_Grade_Level | Varchar2 (1) | Highest educational level attained by mother. 1 = Middle School/Junior High 2 = High School 3 = College or Beyond 4 = Other/unknown NULL |
|||||||||
| Student_AGI | Integer | Adjusted Gross Income of the student as reported on their Federal Tax Return for the year prior to the Financial Aid year. | |||||||||
| Stuent_SSI_Income_Ind | Varchar2 (1) | Indicates whether the student received SSI (Supplemental Security Income) benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Student_Food_Stamps_Ind | Varchar2 (1) | Indicates whether the student received Food Stamp benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Student_School_Lunch_Ind | Varchar2 (1) | Indicates whether the student received Free or Reduced Price School Lunch benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Student_TANF_Benefits_Ind | Varchar2 (1) | Indicates whether the student received TANF (Temporary Assistance for Needy Families) benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Student_WIC_Benefits_Ind | Varchar2 (1) | Indicates whether the student received WIC (Women, Infant and Children) benefits for the year prior to the Financial Aid year. Y = Yes N = No NULL |
|||||||||
| Student_Marital_Status | Varchar2 (1) | Student marital status as of date of Financial Aid application. 1 = Unmarried (single, divorced, widowed) 2 =Married/Remarried 3 = Separated NULL |
|||||||||
| Student_Nbr_in_Family | Varchar2 (2) | Number of people in the student household for which the student provides at least 50% support. | |||||||||
| Student_Children_IND | Varchar2 (1) | Indicates whether the student has any children for which they provide at least 50% support. Y = Yes N = No NULL |
|||||||||
| Student_Dependents_IND | Varchar2 (1) | Indicates whether the student has any dependents for which they provide at least 50% support and also that live with the student. Y = Yes N = No NULL |
|||||||||
| Student_Dependency_Status | Varchar2 (1) | Student’s dependency status for purposes of Financial Aid as determined by Federal methodology. I = Independent D = Dependent NULL |
|||||||||
| FISAP_Total_Income | Integer | For an independent student: same as total income (TI).
For a dependent student: sum of STI and TI (Parental Total Income). |
|||||||||
| Pell_Eligibility_Ind | Varchar2 (1) | Student’s eligibility for a Federal Pell Grant as determined by Federal methodology. Y = Eligible for Pell Grant Blank = Ineligible for Pell Grant |
|||||||||
| Primary_EFC | Integer | Expected Family Contribution as determined by Federal methodology. | |||||||||
| Formula_Type | Varchar2 (1) | Federal Methodology Formula used to calculate EFC
|
|||||||||
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |