(NSLDS Record Layouts) FAT Batch Results Data File Layout

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 111CharacterRecord Type IndicatorIndicator used to identify the header record. Value = ‘0’ (zero). 2109CharacterFillerDummy SSN for header record. Value is spaces. 115242CharacterHeader TitleTitle used to identify the header record. Value = ‘FINANCIAL AID TRANSCRIPT HEADER’. 53608CharacterSchool 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 61688CharacterServicer 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. 69691CharacterReport TypeType of format in which the FAT is provided. ‘E’= extract data file. 70778DateSubmittal DateDate (year, month, and day) on which the FAT was requested. Format is CCYYMMDD. 78858DateProcess DateDate (year, month, and day) on which the FAT was processed by NSLDS. Format is CCYYMMDD. 8616075CharacterFillerFiller 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 111CharacterRecord Type IndicatorIndicator used to identify the record. Value = ‘1’. 2109CharacterStudent’s SSNCurrent SSN of the student for whom the FAT information is provided. 112212CharacterCurrent First NameCurrent first name of the student for whom the FAT information is provided. Value = ‘NFN’ if student has no first name. 235735CharacterCurrent Last NameCurrent last name of the student for whom the FAT information is provided. Value = ‘NLN’ if student has no last name. 58658DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT information is provided. Format is CCYYMMDD. 66738CharacterSchool 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 74741CharacterDefaulted Loan FlagIndicates one or more defaulted loans. Value = ‘Y’ or ‘N’. 75751CharacterDischarged Loan FlagIndicates one or more discharged loans. Value = ‘Y’ or ‘N’. 76761CharacterLoan Satisfactory Repayment Arrangements FlagIndicates one or more loans with satisfactory repayment arrangements. Value = ‘Y’ or ‘N’. 77771CharacterActive Bankruptcy FlagIndicates one or more active bankruptcy loans. Value = ‘Y’ or ‘N’. 78836CharacterAggregate Subsidized Outstanding Principal BalanceOutstanding principal balance for subsidized loan types (D1, D6, or SF). Value = ‘N/A’ if no applicable loans. 84896CharacterAggregate 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. 90956CharacterAggregate 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. 961016CharacterAggregate FFEL Consolidation Outstanding Principal BalanceOutstanding principal balance for FFELP consolidation loan type CL. Value = ‘N/A’ if no applicable loans. 1021076CharacterAggregate Subsidized Pending DisbursementPending disbursements for subsidized loan types (D1, D6, or SF). Value = ‘N/A’ if no applicable loans. 1081136CharacterAggregate Unsubsidized Pending DisbursementPending disbursements for unsubsidized loan types (D2, D5, RF, non-subsidized SF, SL, and SU). Value = ‘NA’ if no applicable loans. 1141196CharacterAggregate 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 1201256CharacterAggregate Subsidized TotalTotal for subsidized loan types (D1, D6, or SF). Value = ‘N/A’ if no applicable loans. 1261316CharacterAggregate Unsubsidized TotalTotal for unsubsidized loan types (D2, D5, RF, non-subsidized SF, SL, and SU). Value = ‘NA’ if no applicable loans. 1321376CharacterAggregate 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. 1381436CharacterAggregate FFEL Consolidation TotalTotal for FFELP consolidation loan type CL. Value = ‘N/A’ if no applicable loans. 1441496CharacterPerkins Total Disbursement AmountTotal Perkins outstanding principal balance (DU, EU, NU, or PU). Value = ‘N/A’ if no applicable loans. 1501556CharacterPerkins Current Award Year Disbursement AmountTotal Perkins disbursements (DU, EU, NU, or PU) for award year (July–June). Value = ‘N/A’ if no applicable loans. 1561561CharacterError Code 1Reflects SSN error. Value = ‘1’: SSN must not be spaces. 1571571CharacterError Code 2Reflects name error. Value = ‘2’: First and last names must not be spaces. 1581581CharacterError Code 3Reflects date of birth error. Value = ‘3’: Invalid date of birth. 1591591CharacterError 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 1601601CharacterMatch 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 111CharacterRecord Type IndicatorIndicator used to identify the Name History record. Value = ‘2’. 2109CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided. 112212CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name. 235735CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name. 58658DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD. 66738CharacterSchool 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. 748512CharacterFirst Name HistoryOther first name used by the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name. 86861CharacterMiddle 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 8712135CharacterLast Name HistoryOther last name used by the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name. 12216039CharacterFillerFiller 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 111CharacterRecord Type IndicatorIndicator used to identify the Overpayment record. Value = ‘3’. 2109CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided. 112212CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name. 235735CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name. 58658DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD. 66738CharacterSchool 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. 74752CharacterOverpayment TypeOverpayment types: PE = Pell SE = FSEOG PK = Perkins (PU, NU, EU, or DU) 76761CharacterOverpayment IndicatorIndicates overpayment: Y = Yes N = No S = Satisfactory Arrangements 77804CharacterAward YearAward year on which the overpayment was disbursed. 81888CharacterContactCode 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 8916072CharacterFillerFiller 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 111CharacterRecord Type IndicatorIndicator used to identify the Pell Payment record. Value = ‘4’. 2109CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided. 112212CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value is ‘NFN’ if student has no first name. 235735CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value is ‘NLN’ if student has no last name. 58658DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD. 66738CharacterSchool 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. 74796NumericScheduled AmountScheduled amount of the Federal Pell Grant award. 80856NumericAmount Paid To DateThe amount of the Federal Pell Grant the school has disbursed to the student. 86916NumericRemaining 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. 92954CharacterAward YearThe academic year for the Federal Pell Grant program, beginning July 1 and ending June 30 of the following year. 961005NumericPercent of Eligibility UsedPercent of eligibility the student used. Format 999V99. For example, 10000 represents 100.00% 1011022CharacterTransaction 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 1031108CharacterAs of DateDate disbursement was made or will be made to student. Format is CCYYMMDD. 1111133CharacterVerification Code Provided by SchoolResult of verification by school. 1141174NumericExpected Family ContributionIndex produced by the Congressional Methodology (CM) needs analysis assessment. 1181214NumericAward 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. 12215231CharacterFillerFiller 1531608CharacterSchool 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 111CharacterRecord Type IndicatorIndicator used to identify the detail record. Value = ‘5’. 2109CharacterStudent’s SSNCurrent SSN of the student for whom the FAT is provided. 112212CharacterCurrent First NameCurrent first name of the student for whom the FAT is provided. Value = ‘NFN’ if student has no first name. 235735CharacterCurrent Last NameCurrent last name of the student for whom the FAT is provided. Value = ‘NLN’ if student has no last name. 58658DateDate of BirthDate of birth (year, month, and day) of the student for whom the FAT is provided. Format is CCYYMMDD. 66738CharacterSchool 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. 74752CharacterLoan TypeCode indicating the type of loan. Results Data File Detail Record Type 5 (Loan Detail Record) Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content 76772CharacterCurrent Loan Status CodeCode used to identify the current status of a student’s loan, as determined by the current loan holder. 78858DateCurrent Loan Status DateDate (year, month, and day) the current loan status code became effective. Format is CCYYMMDD. 86916CharacterOutstanding Principal BalanceThe cumulative dollar value of the outstanding principal balance due on the loan. Value = ‘N/A’ if outstanding principal balance is not available. 92998CharacterOutstanding 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. 1001078CharacterLoan 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. 1081158CharacterLoan 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. 1161183CharacterCurrent GA CodeCurrent GA Code. Value = ‘N/A’ if not available. 1191191CharacterAcademic LevelStudent’s academic- or grade-level at the school when the loan was disbursed. 1201223CharacterContact 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 1231286NumericNet Loan AmountAmount of loan/guaranty minus total amount of cancellations. 1291368CharacterContactCode indicating the agency to be contacted for this loan. Value = ‘N/A’ if contact is not available. 1371448CharacterSchool CodeAn eight-digit ED OPE Code used to identify the school attended by the student when the loan was originated. 14516016CharacterFillerFiller 4.3 Results Data File Trailer Record Results Data File Trailer Record Position FromPosition ToField LengthField FormatAttributeDescription / Valid Field Content 111CharacterRecord Type IndicatorIndicator used to identify the trailer record. Value must be ‘9’. 2109CharacterFillerDummy SSN for trailer record. Value = ‘999999999’. 115242CharacterTrailer TitleTitle used to identify the trailer record. Value = ‘FINANCIAL AID TRANSCRIPT TRAILER’. 53608NumericMatch CountTotal count of detail records for which matches were found using the three identifiers of SSN, date of birth, and name. 61699NumericRecord CountTotal count of requested detail records processed on this file (excluding header and trailer). 70778NumericError CountTotal count of detail records with errors. 7816083CharacterFillerFiller