Maintained for Historical Purposes

This resource is being maintained for historical purposes only and is not currently applicable.

(FINAL FAT Batch Record Layout) FAT Batch Results Data File Layout

IFAP
SFA Information for Financial Aid Professionals
U.S. Department of Education
PublicationDate: 1/21/2000
ChapterNumber: 4
ChapterTitle: FAT Batch Results Data File Layout
SectionNumber:
SectionTitle:
PageNumbers: 8-17


Section 4: FAT Batch Results Data File Layout

The following record layouts describe the results header, detail, and trailer records for the FAT Batch data file that is returned to schools or school servicers. The file contains one header record, a set of detail records for each requested student, and one trailer record as indicated below:

Header Record
Detail record(s) for student 1
Detail record(s) for student 2
:
Detail record(s) for student n
Trailer Record

All records have the same length, which is 160 bytes.

Each set of detail records contains one or more detail records for a student. Detail records consist of the following types:

Record Type 1: Aggregates, Perkins Record, Error Codes, Flags
Record Type 2: Name History Record
Record Type 3: Overpayment Record
Record Type 4: Pell Payment Record
Record Type 5: Loan Detail Record

In each set of detail records for a student, there are exactly one record type 1 and zero or more record types 2 through 5, depending on the data in NSLDS for the student. If errors are indicated on record type 1, there are not any record types 2 through 5 for the student.



4.1 Results Data File Header Record
Results Data File Header Record


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the header record. Value = ‘0’ (zero).
2109
CharacterFillerDummy SSN for header record. Value is spaces.
115242
CharacterHeader TitleTitle used to identify the header record. Value = ‘FINANCIAL AID TRANSCRIPT HEADER’.
53608
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch submitting the FAT request. Last two digits equal 00 if no branch code.




Results Data File Header Record


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
61688
CharacterServicer CodeAn eight-digit code for the FAT servicer; populated if a servicer for a school is submitting the request on behalf of one or more schools. For schools, this field will be populated with zeros. If field contains a value other than zero, it will contain a valid School Servicer Code.
69691
CharacterReport TypeType of format in which the FAT is provided. ‘E’= extract data file.
70778
DateSubmittal DateDate (year, month, and day) on which the FAT was requested. Format is CCYYMMDD.
78858
DateProcess DateDate (year, month, and day) on which the FAT was processed by NSLDS. Format is CCYYMMDD.
8616075
CharacterFillerFiller



4.2 Results Data File Detail Records

4.2.1 Record Type 1 (Aggregates, Perkins Record, Error Codes, and Flags)
Results Data File Detail Record Type 1 (Aggregates, Perkins Record, Error Codes, and Flags)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the record. Value = ‘1’.
2109
CharacterStudent’s SSNCurrent SSN of the student for whom the FAT information is provided.
112212
CharacterCurrent First NameCurrent first name of the student for whom the FAT information is provided. Value = ‘NFN’ if student has no first name.
235735
CharacterCurrent Last NameCurrent last name of the student for whom the FAT information is provided. Value = ‘NLN’ if student has no last name.
58658
DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT information is provided. Format is CCYYMMDD.
66738
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch submitting the FAT request. Last two digits equal 00 if no branch code.


Results Data File Detail Record Type 1 (Aggregates, Perkins Record, Error Codes, and Flags)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
74741
CharacterDefaulted Loan FlagIndicates one or more defaulted loans. Value = ‘Y’ or ‘N’.
75751
CharacterDischarged Loan FlagIndicates one or more discharged loans. Value = ‘Y’ or ‘N’.
76761
CharacterLoan Satisfactory Repayment Arrangements FlagIndicates one or more loans with satisfactory repayment arrangements. Value = ‘Y’ or ‘N’.
77771
CharacterActive Bankruptcy FlagIndicates one or more active bankruptcy loans. Value = ‘Y’ or ‘N’.
78836
CharacterAggregate Subsidized Outstanding Principal BalanceOutstanding principal balance for subsidized loan types (D1, D6, or SF). Value = ‘N/A’ if no applicable loans.
84896
CharacterAggregate Unsubsidized Outstanding Principal BalanceOutstanding principal balance for unsubsidized loan types (D2, D5, RF, non-subsidized SF, SL, and SU). Value = ‘NA’ if no applicable loans.
90956
CharacterAggregate Combined Outstanding Principal BalanceOutstanding principal balance for subsidized and unsubsidized loan types (D1, D2, D5, D6, RF, non-subsidized Stafford, SF, SL, or SU). Value = ‘N/A’ if no applicable loans.
961016
CharacterAggregate FFEL Consolidation Outstanding Principal BalanceOutstanding principal balance for FFELP consolidation loan type CL. Value = ‘N/A’ if no applicable loans.
1021076
CharacterAggregate Subsidized Pending DisbursementPending disbursements for subsidized loan types (D1, D6, or SF). Value = ‘N/A’ if no applicable loans.
1081136
CharacterAggregate Unsubsidized Pending DisbursementPending disbursements for unsubsidized loan types (D2, D5, RF, non-subsidized SF, SL, and SU). Value = ‘NA’ if no applicable loans.
1141196
CharacterAggregate Combined Pending DisbursementPending disbursements for subsidized and unsubsidized loan types (D1, D2, D5, D6, RF, non-subsidized Stafford, SF, SL, or SU). Value = ‘N/A’ if no applicable loans.


Results Data File Detail Record Type 1 (Aggregates, Perkins Record, Error Codes, and Flags)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
1201256
CharacterAggregate Subsidized TotalTotal for subsidized loan types (D1, D6, or SF). Value = ‘N/A’ if no applicable loans.
1261316
CharacterAggregate Unsubsidized TotalTotal for unsubsidized loan types (D2, D5, RF, non-subsidized SF, SL, and SU). Value = ‘NA’ if no applicable loans.
1321376
CharacterAggregate Combined TotalTotal for subsidized and unsubsidized loan types (D1, D2, D5, D6, RF, non-subsidized Stafford, SF, SL, or SU). Value = ‘N/A’ if no applicable loans.
1381436
CharacterAggregate FFEL Consolidation TotalTotal for FFELP consolidation loan type CL. Value = ‘N/A’ if no applicable loans.
1441496
CharacterPerkins Total Disbursement AmountTotal Perkins outstanding principal balance (DU, EU, NU, or PU). Value = ‘N/A’ if no applicable loans.
1501556
CharacterPerkins Current Award Year Disbursement AmountTotal Perkins disbursements (DU, EU, NU, or PU) for award year (July–June). Value = ‘N/A’ if no applicable loans.
1561561
CharacterError Code 1Reflects SSN error. Value = ‘1’: SSN must not be spaces.
1571571
CharacterError Code 2Reflects name error. Value = ‘2’: First and last names must not be spaces.
1581581
CharacterError Code 3Reflects date of birth error. Value = ‘3’: Invalid date of birth.
1591591
CharacterError Code 4Reflects school year errors. Values are:
‘4’-School year must be numeric.
‘5’-School year must not be greater than current school year.
‘6’-School year field length must be equal to 4.


Results Data File Detail Record Type 1 (Aggregates, Perkins Record, Error Codes, and Flags)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
1601601
CharacterMatch FlagReflects successful/unsuccessful match of student/PLUS borrower against search of active database. Values are:
‘0’-Successful match. No error.
‘1’-School and school servicer user association not found.
‘2’-Successful match. Student has no selectable loans but has Pell Grant(s).
‘3’-Successful match. Student has no selectable loans or Pell Grants.
‘6’-Student SSN not found.
‘7’-Matches on SSN, but not on date of birth and name.



4.2.2 Record Type 2 (Name History)
Results Data File Detail Record Type 2 (Name History)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the Name History record. Value = ‘2’.
2109
CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided.
112212
CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name.
235735
CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name.
58658
DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD.
66738
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch submitting the FAT request. Last two digits equal 00 if no branch code.
748512
CharacterFirst Name HistoryOther first name used by the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name.
86861
CharacterMiddle Initial HistoryOther middle initial used by the student for whom the FAT is provided, if available.


Results Data File Detail Record Type 2 (Name History)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
8712135
CharacterLast Name HistoryOther last name used by the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name.
12216039
CharacterFillerFiller



4.2.3 Record Type 3 (Overpayment Record)
Results Data File Detail Record Type 3 (Overpayment Data)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the Overpayment record. Value = ‘3’.
2109
CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided.
112212
CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name.
235735
CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name.
58658
DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD.
66738
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch submitting the FAT request. Last two digits equal 00 if no branch code.
74752
CharacterOverpayment TypeOverpayment types:
PE = Pell
SE = FSEOG
PK = Perkins (PU, NU, EU, or DU)
76761
CharacterOverpayment IndicatorIndicates overpayment:
Y = Yes
N = No
S = Satisfactory Arrangements
77804
CharacterAward YearAward year on which the overpayment was disbursed.
81888
CharacterContactCode indicating the agency to be contacted for this overpayment. Value = ‘N/A’ if contact is not available.



Results Data File Detail Record Type 3 (Overpayment Data)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
8916072
CharacterFillerFiller



4.2.4 Record Type 4 (Pell Payment Record)
Results Data File Detail Record Type 4 (Pell Payment Record)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the Pell Payment record. Value = ‘4’.
2109
CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided.
112212
CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value is ‘NFN’ if student has no first name.
235735
CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value is ‘NLN’ if student has no last name.
58658
DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD.
66738
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch submitting the FAT request. Last two digits equal 00 if no branch code.
74796
NumericScheduled AmountScheduled amount of the Federal Pell Grant award.
80856
NumericAmount Paid To DateThe amount of the Federal Pell Grant the school has disbursed to the student.
86916
NumericRemaining Amount To Be PaidThe amount of the Federal Pell Grant the school still expects to pay the student for the remainder of the award year.
92954
CharacterAward YearThe academic year for the Federal Pell Grant program, beginning July 1 and ending June 30 of the following year.
961005
NumericPercent of Eligibility UsedPercent of eligibility the student used. Format 999V99. For example, 10000 represents 100.00%
1011022
CharacterTransaction NumberTransaction number on the SAR or ISIR for the payment accepted by the school.



Results Data File Detail Record Type 4 (Pell Payment Record)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
1031108
CharacterAs of DateDate disbursement was made or will be made to student. Format is CCYYMMDD.
1111133
CharacterVerification Code Provided by SchoolResult of verification by school.
1141174
NumericExpected Family ContributionIndex produced by the Congressional Methodology (CM) needs analysis assessment.
1181214
NumericAward AmountThe amount of the Federal Pell Grant the school expects to pay the student based on the student’s enrollment and school’s cost of attendance.
12215231
CharacterFillerFiller
1531608
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch associated with the Pell Grant.



4.2.5 Record Type 5 (Loan Detail Record)
Results Data File Detail Record Type 5 (Loan Detail Record)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the detail record. Value = ‘5’.
2109
CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided.
112212
CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name.
235735
CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name.
58658
DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD.
66738
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school and branch submitting the FAT request. Last two digits equal 00 if no branch code.
74752
CharacterLoan TypeCode indicating the type of loan.


Results Data File Detail Record Type 5 (Loan Detail Record)


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
76772
CharacterCurrent Loan Status CodeCode used to identify the current status of a student’s loan, as determined by the current loan holder.
78858
DateCurrent Loan Status DateDate (year, month, and day) the current loan status code became effective. Format is CCYYMMDD.
86916
CharacterOutstanding Principal BalanceThe cumulative dollar value of the outstanding principal balance due on the loan. Value = ‘N/A’ if outstanding principal balance is not available.
92998
CharacterOutstanding Principal Balance DateDate (year, month, and day) the outstanding principal balance was last updated. Format is CCYYMMDD. Value = ‘N/A’ if outstanding principal balance date is not available.
1001078
CharacterLoan Period Begin DateDate (year, month, and day) the enrollment period begins for this loan. Format is CCYYMMDD. Value = ‘N/A’ if loan period begin date is not available.
1081158
CharacterLoan Period End DateDate (year, month, and day) the enrollment period ends for this loan. Format is CCYYMMDD. Format is ‘N/A’ if loan period end date is not available.
1161183
CharacterCurrent GA CodeCurrent GA Code. Value = ‘N/A’ if not available.
1191191
CharacterAcademic LevelStudent’s academic- or grade-level at the school when the loan was disbursed.
1201223
CharacterContact TypeContact type. Values are:
EDR = ED Region
LEN = Lender
SCH = School
GA = Guaranty Agency
DLS = Direct Loan Servicer
LNS = Lender Servicer
N/A = Not Applicable
1231286
NumericNet Loan AmountAmount of loan/guaranty minus total amount of cancellations.
1291368
CharacterContactCode indicating the agency to be contacted for this loan. Value = ‘N/A’ if contact is not available.
1371448
CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school attended by the student when the loan was originated.
14516016
CharacterFillerFiller


4.3 Results Data File Trailer Record
Results Data File Trailer Record


Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content
111
CharacterRecord Type IndicatorIndicator used to identify the trailer record. Value must be ‘9’.
2109
CharacterFillerDummy SSN for trailer record. Value = ‘999999999’.
115242
CharacterTrailer TitleTitle used to identify the trailer record. Value = ‘FINANCIAL AID TRANSCRIPT TRAILER’.
53608
NumericMatch CountTotal count of detail records for which matches were found using the three identifiers of SSN, date of birth, and name.
61699
NumericRecord CountTotal count of requested detail records processed on this file (excluding header and trailer).
70778
NumericError CountTotal count of detail records with errors.
7816083
CharacterFillerFiller

Last Modified: 01/31/2000