Federal Student Aid - IFAP
   
IFAP
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
12020
CharacterFillerFiller
21211
NumericRecord TypeIndicator used to identify the header record. Value must be "1" (one).
22298
NumericOrganization ID NumberThe eight-digit ED OPE code used to identify the school receiving the LRDR.
30143114
CharacterFillerFiller
14420360
CharacterOrganization NameSchool’s name.
20425350
CharacterAddressSchool’s address.
25427320
CharacterCitySchool’s city.
2742752
CharacterStateSchool’s state.
27629520
CharacterCountrySchool’s country.
2963049
NumericZip CodeSchool’s Zip Code.
3053128
DateRequest DateIdentifies the request date of the LRDR report; format is CCYYMMDD.
3133208
DateRate Calculation DateIdentifies the date the rate was calculated; format is CCYYMMDD.
3213244
DateCohort YearIdentifies the cohort period associated with the report; format is CCYY.
3253317
CharacterTitle IV ProgramIdentifies the program type of loans included in the Loan Record Detail Report.
3323343
CharacterFillerFiller
3353351
NumericFillerFiller






LRDR Detail Record
LRECL-335


Position fromPosition toField LengthField FormatNameDescription Field Content
12020
CharacterFillerFiller
21211
CharacterRecord TypeIndicator used to identify the detail record. Value must be "2" (two).
22298
CharacterSchool CodeAn eight-digit ED Office of Postsecondary Education (OPE) code used to identify the school submitting the LRDR request.
30378
CharacterFillerFiller
38469
CharacterSSNTitle IV recipient’s or beneficiary’s Social Security Number.
47471
CharacterDefault Rate Usage CodeIdentifies how the loan is counted in the school’s cohort default rate calculation.
486518
CharacterFillerFiller
6610035
CharacterCurrent Last NameTitle IV recipient’s or beneficiary’s current last name.
10111212
CharacterCurrent First NameTitle IV recipient’s or beneficiary’s current first name.
1131131
CharacterStudent Middle InitialTitle IV recipient’s or beneficiary’s middle initial.
1141218
NumericStudent Date of BirthTitle IV recipient’s or beneficiary’s date of birth.
1221298
CharacterOriginal School CodeED OPE code for school that certified/originated the loan for the borrower.
1301378
NumericBegin Class DateThe date classes were scheduled to begin for the loan period covered by the loan.
1381458
NumericEnd Class DateThe date classes were scheduled to end for the loan period covered by the loan.
1461461
CharacterAcademic LevelStudent’s academic or grade level in school at the beginning of the specific period covered by the loan.
1471526
CharacterOriginal Lender/Servicer CodeCode for entity that provided the loan to the student; identifies the originating holder of the loan.
1531564
CharacterFillerFiller
1571626
CharacterCurrent Lender/Servicer CodeCurrent lender code.





LRDR Detail Record
LRECL-335


Position fromPosition toField LengthField FormatNameDescription Field Content


1631664
CharacterCurrent Lender/Servicer BranchCurrent lender branch.
1671682
CharacterLoan TypeThe type of loan.
1691702
Character Loan Status CodeThe status of the borrower’s loan.
1711788
NumericLoan Status Code DateEffective date of the loan status code.
1791868
NumericRepay DateDate loan entered repayment.
1871926
NumericAmountFull amount of the loan.
1931953
CharacterCode 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.
1962038
NumericGuaranty Loan DateDate that the guaranty agency insured an FFEL Program loan or the first date of disbursement for a Direct Loan Program.
2042118
NumericDefault 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.
2122132
CharacterClaim 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.
21423421
CharacterFillerFiller
2352351
CharacterEnrollment Code Student’s enrollment status at the time the cohort default rate was calculated.
2362438
NumericEnrollment 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.
2442441
CharacterProgram TypeIdentifies loan program type "F" (FFEL) or "D" (Direct Loan).
2452495
CharacterFillerFiller
2502556
NumericClaim AmountThe claim amount.
2562616
NumericOutstanding Principal BalanceThe original dollar amount of the loan.
2622632
CharacterUsage TwoIdentifies how the loan is counted in each individual loan program (i.e., the FFEL Program and/or the Direct Loan Program).
26432057
CharacterFillerFiller
3213244
Character Cohort YearIdentifies the cohort year; format is CCYY.
32533511
CharacterFillerFiller




LRDR Trailer Record
LRECL-335


Position fromPosition toField LengthField FormatNameDescription Field Content
12020
CharacterFillerFiller
21211
CharacterRecord TypeIndicator used to identify the trailer record. Value must be "3" (three).
22298
CharacterSchool CodeAn eight-digit ED OPE code used to identify the school receiving the LRDR.
30312
CharacterFillerFiller
32398
NumericActual 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.
40478
NumericActual 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.
48558
NumericReport CountIdentifies the unduplicated number of borrowers included in the numerator of the cohort default rate calculation.
56638
NumericReport CountIdentifies the unduplicated number of borrowers included in the denominator of the cohort default rate calculation.
64718
NumericICIdentifies the number of borrowers meeting income contingency repayment conditions on the Loan Record Detail Report.
72798
NumericIndividual Program TallyThe total number of unduplicated borrowers counted in the numerator of the FFEL Program.
80878
NumericIndividual Program Tally The total number of unduplicated borrowers counted in the denominator of the FFEL Program.
88958
NumericIndividual Program Tally The total number of unduplicated borrowers counted in the numerator of the Direct Loan Program.
961038
NumericIndividual Program Tally The total number of unduplicated borrowers counted in the denominator of the Direct Loan Program.
10413532
NumericFillerFiller
1361361
CharacterAppealed Rate FlagIdentifies if the cohort default rate has been revised due to an appeal.
13714610
Numeric 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.
14715610
NumericDual 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.
15716610
NumericFFEL Total Dollars in Default Dollars in default on FFEL Program.
16717610
NumericFFEL Total Dollars in RepaymentDollars in repayment on FFEL Program.
17718610
NumericDirect Total Dollars in DefaultDollars in default on Direct Loan Program.
18719610
NumericDirect Total Dollars in RepaymentDollars in repayment on Direct Loan Program.
19720610
NumericTotal Insurance Claim PaymentsIdentifies the total dollar amount for insurance claim payments.
207320114
CharacterFillerFiller
3213244
DateTrailer Sort Cohort YearIdentifies the cohort year; format is CCYY.
32533511
CharacterFillerFiller




File Layout Codes


Usage Code 1-Cohort Default Rate Usage


CodeDescription
D
Denominator only
B
Both Numerator and Denominator
N
Not Used
E
Eligible, but not counted




Usage Code 2-FFEL Program and/or Direct Loan Program Usage


CodeDescription
FD
FFEL Program Denominator only
FB
FFEL Program Numerator and Denominator
DD
Direct Loan Program Denominator only
DB
Direct Loan Program Numerator and Denominator
IC
Direct Loan Program NegAm/ICR Numerator and Denominator
N
Not Used (FFEL Program and/or Direct Loan Program)
E
Eligible, 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


CL
FFEL Consolidated Loan
D1
Direct Loan Subsidized Stafford Loan
D2
Direct Loan Unsubsidized Stafford Loan
D4
Direct Loan PLUS Loan
D5
Direct Loan Consolidated Unsubsidized Stafford Loan
D6
Direct Loan Consolidated Subsidized Stafford Loan
D7
Direct Loan Consolidated PLUS Loan
PL
FFEL PLUS Loan
SF
FFEL Subsidized Stafford Loan
SL
FFEL Supplemental Loans for Students Loan
SU
FFEL Unsubsidized Stafford Loan





Loan Status Codes


CodeDescription
AE
Assigned to the U.S. Department of Education
BC
Bankruptcy Claim, Discharged
BK
Bankruptcy Claim, Active
CA
Cancelled
DA
Deferred
DB
Defaulted, then Bankrupt, Active, Chapter 13
DC
Defaulted, Compromise
DD
Defaulted, then Died
DE
Death
DI
Disability
DK
Defaulted, then Bankrupt, Discharged, Chapter 13
DL
Defaulted, in Litigation
DO
Defaulted, then Bankrupt, Active, Other
DP
Defaulted, Paid-In-Full
DS
Defaulted, then Disabled


Loan Status Codes


CodeDescription


DT
Defaulted, Collection Terminated
DU
Defaulted, Unresolved
DW
Defaulted, Write-Off
DX
Defaulted, Six Consecutive Payments
FB
Forbearance
ID
In School or Grace Period
OD
Defaulted, then Bankrupt, Discharged, Other
PC
Paid-In-Full through Consolidation Loan
PF
Paid-In-Full
RF
Refinanced
RP
In Repayment
UI
Uninsured





Claim Reason Codes


CodeStatus
BC
FFEL Bankruptcy, Chapter 13
BO
FFEL Bankruptcy, Other
CS
FFEL Closed School
DE
FFEL Death
DF
FFEL Default
DI
FFEL Disability
EX
FFEL Exempt
FC
FFEL False Certification
IN
Direct Loan, Income Contingent Negative Amortization for non-degree granting proprietary schools
IX
Direct Loan, Defaulted Loan




Academic Levels


CodeDescription
1
Freshman/First Year
2
Sophomore/Second Year
3
Junior/Third Year
4
Senior/Fourth Year
5
Fifth Year/Other
A
First Year Graduate/Professional
B
Second Year Graduate/Professional
C
Third Year Graduate/Professional
D
Beyond Third Year Graduate/Professional
G
Graduate/Professional
N
Not Available





Enrollment Status Codes


CodeDescription
A
Approved leave of absence
D
Deceased
F
Full time
G
Graduated
H
Half time or more, but less than full time
L
Less than half time
N
Not available
W
Withdrawn
X
Never attended
Z
No record found