(NSLDS Record Layouts) Loan Repayment Info for Schools File Layout

SFA Information for Financial Aid Professionals
U.S. Department of Education

PublicationDate: 3/15/2000 ChapterNumber: ChapterTitle: Loan Repayment Info for Schools File Layout SectionNumber: SectionTitle: PageNumbers: 1-11 This file layout should be used when an extract is requested from the Report Function on the NSLDS Web Site for Financial Aid Professionals (www.nsldsfap.ed.gov). This layout should be used for extract requests of the loan record detail reports entitled "Student Loan Repayment Information for Schools" and "FY98 Draft CDR Loan Detail Report". The extract data will be sent to the user's TIVWAN mailbox for retrieval. Beginning next Fiscal Year, the Cohort Default Rate Loan Record Detail Report will be available for multiple years, thus the title of this report will change accordingly. LRDR Header Record LRECL-335 Position fromPosition toField LengthField FormatNameDescription Field Content 12020CharacterFillerFiller 21211NumericRecord TypeIndicator used to identify the header record. Value must be "1" (one). 22298NumericOrganization ID NumberThe eight-digit ED OPE code used to identify the school receiving the LRDR. 30143114CharacterFillerFiller 14420360CharacterOrganization NameSchool’s name. 20425350CharacterAddressSchool’s address. 25427320CharacterCitySchool’s city. 2742752CharacterStateSchool’s state. 27629520CharacterCountrySchool’s country. 2963049NumericZip CodeSchool’s Zip Code. 3053128DateRequest DateIdentifies the request date of the LRDR report; format is CCYYMMDD. 3133208DateRate Calculation DateIdentifies the date the rate was calculated; format is CCYYMMDD. 3213244DateCohort YearIdentifies the cohort period associated with the report; format is CCYY. 3253317CharacterTitle IV ProgramIdentifies the program type of loans included in the Loan Record Detail Report. 3323343CharacterFillerFiller 3353351NumericFillerFiller LRDR Detail Record LRECL-335 Position fromPosition toField LengthField FormatNameDescription Field Content 12020CharacterFillerFiller 21211CharacterRecord TypeIndicator used to identify the detail record. Value must be "2" (two). 22298CharacterSchool CodeAn eight-digit ED Office of Postsecondary Education (OPE) code used to identify the school submitting the LRDR request. 30378CharacterFillerFiller 38469CharacterSSNTitle IV recipient’s or beneficiary’s Social Security Number. 47471CharacterDefault Rate Usage CodeIdentifies how the loan is counted in the school’s cohort default rate calculation. 486518CharacterFillerFiller 6610035CharacterCurrent Last NameTitle IV recipient’s or beneficiary’s current last name. 10111212CharacterCurrent First NameTitle IV recipient’s or beneficiary’s current first name. 1131131CharacterStudent Middle InitialTitle IV recipient’s or beneficiary’s middle initial. 1141218NumericStudent Date of BirthTitle IV recipient’s or beneficiary’s date of birth. 1221298CharacterOriginal School CodeED OPE code for school that certified/originated the loan for the borrower. 1301378NumericBegin Class DateThe date classes were scheduled to begin for the loan period covered by the loan. 1381458NumericEnd Class DateThe date classes were scheduled to end for the loan period covered by the loan. 1461461CharacterAcademic LevelStudent’s academic or grade level in school at the beginning of the specific period covered by the loan. 1471526CharacterOriginal Lender/Servicer CodeCode for entity that provided the loan to the student; identifies the originating holder of the loan. 1531564CharacterFillerFiller 1571626CharacterCurrent Lender/Servicer CodeCurrent lender code. LRDR Detail Record LRECL-335 Position fromPosition toField LengthField FormatNameDescription Field Content 1631664CharacterCurrent Lender/Servicer BranchCurrent lender branch. 1671682CharacterLoan TypeThe type of loan. 1691702Character Loan Status CodeThe status of the borrower’s loan. 1711788NumericLoan Status Code DateEffective date of the loan status code. 1791868NumericRepay DateDate loan entered repayment. 1871926NumericAmountFull amount of the loan. 1931953CharacterCode for Guarantor/ ServicerEntity that guaranties the loan on behalf of the Department or entity that the Department contracts with to service Direct Loans. The code for DL Servicer is 101. 1962038NumericGuaranty Loan DateDate that the guaranty agency insured an FFEL Program loan or the first date of disbursement for a Direct Loan Program. 2042118NumericDefault NegAm DateDate that a default claim was paid on an FFEL Program loan or the day of default, for cohort default rate purposes, for Direct Loan Program loans or the day certain Direct Loan Program loans are considered in default, for cohort default rate purposes, if the loan has been in an income contingent repayment plan with payments of less than $15 per month that resulted in negative amortization for a certain period of time. 2122132CharacterClaim Reason CodeIdentifies the reason a claim was paid on an FFEL Program loan or if a Direct Loan Program has defaulted or, for some Direct Loan Program loans, if the loan entered into an income contingent repayment plan that resulted in negative amortization. 21423421CharacterFillerFiller 2352351CharacterEnrollment Code Student’s enrollment status at the time the cohort default rate was calculated. 2362438NumericEnrollment Code DateEffective date of the Enrollment Status Code. If no data is available, the guaranty agency or Direct Loan servicer may use 01/01/1900. 2442441CharacterProgram TypeIdentifies loan program type "F" (FFEL) or "D" (Direct Loan). 2452495CharacterFillerFiller 2502556NumericClaim AmountThe claim amount. 2562616NumericOutstanding Principal BalanceThe original dollar amount of the loan. 2622632CharacterUsage TwoIdentifies how the loan is counted in each individual loan program (i.e., the FFEL Program and/or the Direct Loan Program). 26432057CharacterFillerFiller 3213244Character Cohort YearIdentifies the cohort year; format is CCYY. 32533511CharacterFillerFiller LRDR Trailer Record LRECL-335 Position fromPosition toField LengthField FormatNameDescription Field Content 12020CharacterFillerFiller 21211CharacterRecord TypeIndicator used to identify the trailer record. Value must be "3" (three). 22298CharacterSchool CodeAn eight-digit ED OPE code used to identify the school receiving the LRDR. 30312CharacterFillerFiller 32398NumericActual Numerator CountThe total number of unduplicated borrowers reported in the numerator of the cohort default rate. The report count for the numerator represents the unduplicated report with a "B" in the usage code 1 field. 40478NumericActual Denominator CountThe total number of unduplicated borrowers reported in the denominator of the cohort default rate. The report count for the denominator represents the unduplicated borrower listed on the Loan Record Detail Report with a "D" or "B" in the usage code 1 field. 48558NumericReport CountIdentifies the unduplicated number of borrowers included in the numerator of the cohort default rate calculation. 56638NumericReport CountIdentifies the unduplicated number of borrowers included in the denominator of the cohort default rate calculation. 64718NumericICIdentifies the number of borrowers meeting income contingency repayment conditions on the Loan Record Detail Report. 72798NumericIndividual Program TallyThe total number of unduplicated borrowers counted in the numerator of the FFEL Program. 80878NumericIndividual Program Tally The total number of unduplicated borrowers counted in the denominator of the FFEL Program. 88958NumericIndividual Program Tally The total number of unduplicated borrowers counted in the numerator of the Direct Loan Program. 961038NumericIndividual Program Tally The total number of unduplicated borrowers counted in the denominator of the Direct Loan Program. 10413532NumericFillerFiller 1361361CharacterAppealed Rate FlagIdentifies if the cohort default rate has been revised due to an appeal. 13714610Numeric Dual Total Dollars in DefaultTotal dollars in default. The FFEL Program and Direct Loan Program entries within this field indicate the total dollar volume of defaulted loans included in the cohort default rate calculation. 14715610NumericDual Total Dollars in RepaymentTotal dollars in repayment. The FFEL Program and Direct Loan Program entries within this field indicate the total dollar volume for loans that have entered into repayment during the cohort period in question. 15716610NumericFFEL Total Dollars in Default Dollars in default on FFEL Program. 16717610NumericFFEL Total Dollars in RepaymentDollars in repayment on FFEL Program. 17718610NumericDirect Total Dollars in DefaultDollars in default on Direct Loan Program. 18719610NumericDirect Total Dollars in RepaymentDollars in repayment on Direct Loan Program. 19720610NumericTotal Insurance Claim PaymentsIdentifies the total dollar amount for insurance claim payments. 207320114CharacterFillerFiller 3213244DateTrailer Sort Cohort YearIdentifies the cohort year; format is CCYY. 32533511CharacterFillerFiller File Layout Codes Usage Code 1-Cohort Default Rate Usage CodeDescription DDenominator only BBoth Numerator and Denominator NNot Used EEligible, but not counted Usage Code 2-FFEL Program and/or Direct Loan Program Usage CodeDescription FDFFEL Program Denominator only FBFFEL Program Numerator and Denominator DDDirect Loan Program Denominator only DBDirect Loan Program Numerator and Denominator ICDirect Loan Program NegAm/ICR Numerator and Denominator NNot Used (FFEL Program and/or Direct Loan Program) EEligible, but not counted (FFEL Program and/or Direct Loan Program) For additional information refer to the Department’s Cohort Default Rate Guide. Loan Type Codes CodeDescription CLFFEL Consolidated Loan D1Direct Loan Subsidized Stafford Loan D2Direct Loan Unsubsidized Stafford Loan D4Direct Loan PLUS Loan D5Direct Loan Consolidated Unsubsidized Stafford Loan D6Direct Loan Consolidated Subsidized Stafford Loan D7Direct Loan Consolidated PLUS Loan PLFFEL PLUS Loan SFFFEL Subsidized Stafford Loan SLFFEL Supplemental Loans for Students Loan SUFFEL Unsubsidized Stafford Loan Loan Status Codes CodeDescription AEAssigned to the U.S. Department of Education BCBankruptcy Claim, Discharged BKBankruptcy Claim, Active CACancelled DADeferred DBDefaulted, then Bankrupt, Active, Chapter 13 DCDefaulted, Compromise DDDefaulted, then Died DEDeath DIDisability DKDefaulted, then Bankrupt, Discharged, Chapter 13 DLDefaulted, in Litigation DODefaulted, then Bankrupt, Active, Other DPDefaulted, Paid-In-Full DSDefaulted, then Disabled Loan Status Codes CodeDescription DTDefaulted, Collection Terminated DUDefaulted, Unresolved DWDefaulted, Write-Off DXDefaulted, Six Consecutive Payments FBForbearance IDIn School or Grace Period ODDefaulted, then Bankrupt, Discharged, Other PCPaid-In-Full through Consolidation Loan PFPaid-In-Full RFRefinanced RPIn Repayment UIUninsured Claim Reason Codes CodeStatus BCFFEL Bankruptcy, Chapter 13 BOFFEL Bankruptcy, Other CSFFEL Closed School DEFFEL Death DFFFEL Default DIFFEL Disability EXFFEL Exempt FCFFEL False Certification INDirect Loan, Income Contingent Negative Amortization for non-degree granting proprietary schools IXDirect Loan, Defaulted Loan Academic Levels CodeDescription 1Freshman/First Year 2Sophomore/Second Year 3Junior/Third Year 4Senior/Fourth Year 5Fifth Year/Other AFirst Year Graduate/Professional BSecond Year Graduate/Professional CThird Year Graduate/Professional DBeyond Third Year Graduate/Professional GGraduate/Professional NNot Available Enrollment Status Codes CodeDescription AApproved leave of absence DDeceased FFull time GGraduated HHalf time or more, but less than full time LLess than half time NNot available WWithdrawn XNever attended ZNo record found