OCOG Eligibility Query ASCII File Format (prior to AY 2015)

Field Names Field Attributes and Procedures Data Format
SSN The federally assigned Social Security Number (SSN) for this student. Alphanumeric 
9 characters 
Columns 1-9 
Last Name The last name of the student. Alphabetic
15 characters Columns 10-24 Uppercase
First Name The first name of the student. Alphabetic
10 characters Columns 25-34 Uppercase
Middle Initial The student's middle initial. Alphabetic
1 character Column 35 Uppercase
Filler 1   Columns 36-42
Filler 2 (RANK) AY 2010: FF = First Time Freshman, FP = Previously Enrolled Freshman, SO = Sophomore, JR = Junior, SR = Senior, SF = 5th Year Student Alphabetic
2 characters Columns 43-44
Uppercase

Dependency Status

D = Dependent, I = Independent. Alphabetic
1 character
Column 45 Uppercase
Eligibility Status D = Denied, E = Eligible, F = Failed, I = Incomplete. Alphabetic
1 character
Column 46 Uppercase
Date Posted Date given student for award in correspondence. (Reported in yymmdd format). Numeric 6 characters Columns 47-52
Filler 3 (Ohio Public School Amt.) AY 2010: Maximum amount possible for an Ohio Public School. Numeric
4 characters Columns 53-56
Filler 4 (Ohio Private School Amt.) AY 2010: Maximum amount possible for an Ohio Private School. Numeric
4 characters Columns 57-60
Filler 5 (Ohio Proprietary School Amt.) AY 2010: Maximum amount possible for an Ohio Proprietary School. Numeric
4 characters Columns 61-64
Expected Family Contribution The EFC used in determining the award. Numeric
5 characters Columns 65-69
Filler 6 (Total Grant Units) AY 2010: Units of eligibility ranging from 0.250 - 1.000 for each quarter or 0.375 -1.500 for each semester (based upon enrollment status) for which benefits have already been paid, decimal implied. (For example, a student who has received the grant for 10 quarters and has utilized 10 units, this will display as 10000). Numeric
5 characters Columns 70-74
Transaction Number Indicates the specific FAFSA application that determined the award amount. Numeric
2 characters Columns 75-76
Incomplete / Disqualifying Items 3 - Character error message codes. Numeric
30 characters Columns 77-106
FISAP Total Income The FISAP Total Income used in determining the award. Numeric
7 characters Columns 107 - 113