IC4 MPA Loan Schedule and Custodial Certifications

2009-2010 Loan Purchase --Ensured Continued Access to Student Loans Act of 2008

Att_MPA.Loan.Schedule.Data.File.Fields.Definitions.with.Layout.041009

Documents Associated with the Notice of Terms and Conditions of Additional Purchase of Loans under the "Ensuring Continued Access to Student Loans Act of 2008"

OMB: 1845-0091

Document [pdf]

Download: pdf | pdf

United States Department of Education
Federal Family Education Loan Program
Loan Participation Program Under a
Master Participation Agreement

LOAN SCHEDULE AND CUSTODIAL CERTIFICATION
DATA FILE FIELDS - DEFINITIONS AND
SUBMISSION PROCEDURES

This document provides information and guidance to FFEL Custodians under a Master
Participation Agreement with the U.S. Department of Education (the Department).
In conjunction with the Loan Schedule and Custodial Certification data file transmission, this
document defines the data fields that should appear in the data file transmission. Capitalized
words in the body of the definitions are defined in the Master Participation Agreement (MPA).
The format of Loan Schedule and Custodial Certification will be used for two reporting
purposes: 1) as a part of the Participation Purchase Funding Requests (the “Weekly Loan
Schedule”), and 2) to report the total pool of loans supporting the Class A Participation
Certificate held by the Department as of month end (the “Month-End Loan Schedule”). The
Month-End Loan Schedule may not be used to request funding. If funding is requested on the
last day of a month, please use a separate Weekly Loan Schedule.
The revised file format for the Loan Schedule and Custodial Certification attached to this
Electronic Announcement should be used for all submissions, either for the Weekly Loan
Schedule or the Month-End Loan Schedule beginning October 6, 2008. Servicers may submit a
test file of the revised file format beginning October 3, 2008.
In order to assist Sponsors, Custodians and their designated Servicers in reporting the data on the
Weekly Loan Schedule and the Month-End Loan Schedule, Federal Student Aid has established
two new message classes on the Student Aid Internet Gateway (SAIG). They are: Weekly Part
Funding Request (WKPARTIN) and Monthly Participation Report (MOPARTIN). Custodians
and Servicers should use these message classes when reporting to FSA. Please send the file(s) to
FMS Mailbox # TG79363 using the message classes.

The Custodian and Servicer must determine how they wish to communicate with Federal Student
Aid (FSA) within SAIG. This can be done in two ways:
1. To Use an Established SAIG TG Mailbox (for example: LaRS reporting TG mailbox):
a. The Servicer must go to www.fsawebenroll.ed.gov and add the new Custodian
Lender ID (LID) to the TG mailbox. Once at the website, the Servicer will select
“Enroll for SAIG Mailbox” and then select “Modify existing services for a
Destination Point” to add the new Custodian LID.
2. To Establish a New SAIG TG Mailbox for the Loan Participation program:
a. The Servicer will go to www.fsawebenroll.ed.gov and select “Enroll for SAIG
Mailbox” and then select “Initial application” to create the relationship and TG
mailbox.
In order to submit the Weekly Loan Schedule or the Month-End Loan Schedule, either
EDconnect v7.2 software for Windows systems or TDClient software on a mainframe or
midrange system can be used. To download the EDconnect software, go to the following
location:
https://www.fsadownload.ed.gov/softedconnect.htm.
For further assistance with the EDconnect or TDClient software, call CPS/SAIG Technical
Support at (800) 330-5947 (TDD/TTY (800) 511-5806), or contact by e-mail at
CPSSAIG@ed.gov.

Data File Transmission of the Loan Schedule and Custodial Certification
Electronic Data File Name: When naming the data file, the Custodian must use the following
file naming convention:
LSR########DDMMYYYY999
LSR = Loan Schedule Report
######## = LID/RID for the Sponsor (8 digits)
DDMMYYYY = Day, month, year the file was created
999 = Batch number

Example: LSR8765430009292008001
Batch number 001 for Sponsor 00876543 on 9/29/2008
The batch in the file name should match the unique identifier in the subject line.
The file name is for transmission/identification purposes only and should not appear as a value in
the data file.

Page 2 of 16

Header Record Layout
Field 0

RecordTypeIndicator

A one character code to distinguish between a Header Record and a Loan Level detail
record. The Header Record indicator = H.
Field 1

BatchID

The unique 3-digit number assigned by the Custodian for each new data transmission.
Each new transmission will use the next sequential number.
For example – first batch is numbered 001; next batch is 002; next is 003, etc.
Field 2

CustodianIDNumber(LID/RID)

The unique LID/RID assigned by the Department to the Custodian for this program and
Sponsor.
Field 3

ServicerID

The unique LID/RID of to the Servicer for the loans in this submission. If the loans are
self-serviced, fill field with eight zeros.
Field 4

PCFundingRequest (US$)

Amount of initial or additional Participation Certificate funding requested for new or
reissued disbursements. This is the total of all amounts entered into Field 18 of the Loan
Level detail. Do not round as the cents (¢) information is needed. For the Month-End
Loan Schedule, this will be zero-filled. This field and Field 5 should not be netted.
Maximum amount per each PC Funding Request is $99,999,999.99.
Field 5

CashCollections (US$)
Amounts received by the Custodian/Sponsor that represent cash payments and collections
generated from the student loans. This amount ties to the total available cash in the
collection account to be used for distributions. This field should be the total of the
amounts from Loan Level Fields 32, 34, 37, 38, 39, 40, and 41. This field and Field 4
should not be netted. This field does not include SAP, interest subsidies and other
payments made by the Department. In addition, this field does not include investment
income received on investment in Permitted Investments of funds in the Collection
Account.

Page 3 of 16

Field 6

FileCreationDate
The date the Custodian created the file. For Monthly loan schedule files, this date should
be the last date of the reporting month. Please generate this file on that exact date.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081130 (November 30, 2008)
Single-digit years, months, and days must be padded with a leading zero.

Field 7

RecordCount
The total count of loans in the file submission.

Field 8

FundingYear
The funding year the Custodian has been approved to submit the file. This data is
required.
Loan Program
2008-2009 academic year loan
2009-2010 academic year loan

Field 9

Funding Year
2009
2010

ReportingPeriod
The reporting period the Custodian submitted the file. This data is required.
The period must be in the following format:
YYYYMM
YYYY = Year
MM = Month
Example: 200903 (March 2009)

Page 4 of 16

Loan Level Layout
Field 0

RecordTypeIndicator
A one character code to distinguish between a Header Record and a Loan Level detail
record. The Loan Level detail record indicator = L.

Field 1

LoanNumber
This data is required and is the Commonline Unique Identifier. It is the unique code
(maximum of 17 characters) identifying each loan by the Sponsor/Servicer. It also
includes the Commonline Loan Sequence number which is a unique 2-digit identification
number assigned by the guarantor at the time of guarantee. This field is a total of 19
alphanumeric characters.

Field 2

DataFlag
This data is required.
Table (1)
Data Flag
New Loan
Updated Loan: New or additional information from prior
Loan Schedule submission (e.g., increases in accrued
interest, changes to borrower information (such as name
change) or change in terms (such as reallocation
between subsidized and unsubsidized))
No change to this loan for this report

Field 3

Code
N
U

SSN
The borrower’s 9-digit Social Security Number. For parent PLUS loans, this is the
parent’s SSN. This data is required.
NOTE: This must be a valid SSN (do not send pseudo SSN’s). It must not begin with an
8 or 9, and the first three numbers must not be 000.

Page 5 of 16

Field 4

BirthDate
The date of birth of the borrower. For parent PLUS loans, this is the parent.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.

Field 5

LastName
The last name of the borrower identified in SSN (Field 3). For parent PLUS loans, this is
the parent. Do not include an endorser name.
Examples:

SMITH JR (John W. Smith, Jr.)
JONES (Mark Jones, M.D.)
ST THOMAS (Susan H. St. Thomas)
JOHNSON-HALL (Laura Johnson-Hall)
O’CONNER (Patrick O’Conner)

NOTE: Hyphens, apostrophes, and spaces are acceptable data. Periods and commas
should not be used. The first character of the name must be alphabetic and cannot be
blank.
This data is required if First Name (Field 6) does not contain a name. If the borrower’s
last name is not provided and there is a first name given in Field 6, then populate this
field with NLN (no last name).
Field 6

FirstName
The first name of the borrower identified in SSN (Field 3). For parent PLUS loans, this
is the parent.
Examples:

JOHN (John W. Smith, Jr.)
MARK (Mark Jones, M.D.)
SUSAN (Susan H. St. Thomas)
LAURA (Laura Johnson-Hall)
PATRICK (Patrick O’Conner)

NOTE: Hyphens, apostrophes, and spaces are acceptable data. Periods and commas
should not be used. The first character of the name must be alphabetic and cannot be
blank.

Page 6 of 16

This data is required if Last Name (Field 5) does not contain a name. If the borrower’s
first name is not provided and there is a last name given in Field 5, then populate this
field with NFN (no first name).
Field 7

PLUS/AlternativeSSN
This is the nine-digit Social Security Number of the student on whose behalf the parent
PLUS borrower is taking a PLUS loan. This data is required for parent PLUS loans. Fill
the field with zeros if it is not needed. If included, this must be a valid SSN and must not
begin with an 8 or 9, and the first three numbers must not be 000.

Field 8

PLUS/AlternativeBirthDate
The date of birth of the student on whose behalf the parent PLUS borrower is taking a
PLUS loan. This data is required for parent PLUS loans, otherwise fill in with zeroes.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.

Field 9

PLUS/AlternativeStudentLastName
The last name of the student on whose behalf the parent PLUS borrower is taking a PLUS
loan. This data is required for parent PLUS loans, otherwise leave blank.
Examples:

SMITH JR (John W. Smith, Jr.)
JONES (Mark Jones, M.D.)
ST THOMAS (Susan H. St. Thomas)
JOHNSON-HALL (Laura Johnson-Hall)
O’CONNER (Patrick O’Conner)

NOTE: Hyphens, apostrophes, and spaces are acceptable data. Periods and commas
should not be used. The first character of the name must be alphabetic and cannot be
blank.
This data is required if this is a PLUS loan, and if the student’s First Name (Field 10)
does not contain a name. If the student’s last name is not provided and there is a first
name given in Field 10, then populate this field with NLN (no last name).

Page 7 of 16

Field 10

PLUS/AlternativeStudentFirstName

The first name of the student on whose behalf the parent PLUS borrower is taking a
PLUS loan. This data is required for parent PLUS loans, otherwise leave blank.
Examples:

JOHN (John W. Smith, Jr.)
MARK (Mark Jones, M.D.)
SUSAN (Susan H. St. Thomas)
LAURA (Laura Johnson-Hall)
PATRICK (Patrick O’Conner)

NOTE: Hyphens, apostrophes, and spaces are acceptable data. Periods and commas
should not be used. The first character of the name must be alphabetic and cannot be
blank.
This data is required if student’s Last Name (Field 9) does not contain a name. If the
borrower’s first name is not provided and there is a last name given in Field 9, then
populate this field with NFN (no first name).
Field 11

SchoolID

The unique 8-digit Office of Postsecondary Education (OPE) identification number
assigned by ED to the school associated with the loan. The last 2 digits identify the
branch campus, if any. This data is required.
Field 12

GuarantyAgencyCode

The 3-digit code assigned by the Department and used to identify the guarantor
associated with the loan. This data is required.
Field 13

GuarantyDate

The date of the guaranty. This data is required.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.

Page 8 of 16

Field 14

TotalNumberOfScheduledDisbursements

A two-digit code indicating the number of disbursements originally scheduled for the
loan. This data is required.
NOTE: The number of disbursements is established at the time of the school certification
and may be altered due to subsequent changes (e.g., reissues or reinstatements).
Field 15

FirstDisbursementDate

Date of the first disbursement of the loan. This data is required.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.
Field 16

MostRecentDisbursementDate

Date of the most recent disbursement on the loan. This data is required – complete this
field even if Field 15 is the same.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.
Field 17

DisbursementNumber

A two-digit code to identify the actual disbursement for which the Custodian, on behalf
of the Sponsor, is requesting new funding from the Department. This data is required for
new or reissued disbursements, when requesting funding from the Department. If the
request for funding in a single file submission is for multiple disbursements of one loan,
aggregate the disbursement amount in Field 18 and list the most recent disbursement
number in this field.
On a Weekly Loan Schedule, fill the field with zeros if no funds are being requested for a
loan in Field 18. Fill this field with zeros for the Month-End Loan Schedule.
Page 9 of 16

Field 18

DisbursementAmount (US$)

The gross amount of the most recent disbursement, including all borrower fees. This
field is not cumulative. This data is required for new or reissued disbursements for which
the Custodian, on behalf of the Sponsor, is requesting new funding from the Department
with the file submission. If the request for funding in a single file submission is for
multiple disbursements of one loan, aggregate the disbursement amount in this field and
list the most recent disbursement number in Field 17. Maximum disbursement amount
that can be entered is $99,999.99 (due to restricted field length of 8 digits, including the
decimal place).
On a Weekly Loan Schedule, fill the field with zeros if no funds are being requested for a
loan in this field. Fill this field with zeros for the Month-End Loan Schedule.
Field 19

AnticipatedFinalDisbursementDate

The date that is, or is anticipated to be, the final disbursement of the loan. This date may
be the same as Field 15 or Field 16. This data is required.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.
Field 20

LoanType

This data is required.
Table (2)
Loan Type
FFEL Stafford Subsidized Loan
FFEL Stafford Unsubsidized Loan
PLUS Loan - Parent
PLUS Loan - Graduate/Professional
Field 21

Code
SF
SU
PL
GB

OriginalLenderID(LID/RID)

This is the lender who made the initial disbursement of the loan to the borrower. It is the
unique 8-character identification number assigned by the Department to this lender. This
data is required.

Page 10 of 16

Field 22

SponsorID(LID/RID)

This is the current holder/Sponsor who has placed or will place this loan in the
Participation. It is the unique 8-character identification number assigned by the
Department to the Sponsor. If the original lender is still the current lender, then this will
be the same as Field 21. This is not the Custodian LID/RID.
Field 23

OriginationFee (US$)

The total amount of borrower origination fee paid or due, as of the file creation date.
This data is required for new or reissued disbursements. Report this fee as a cumulative
amount.
Field 24

GuaranteeFee (US$)

The total amount of the default fee paid or due, as of the file creation date. This data is
required for new or reissued disbursements. Report this fee as a cumulative amount.
Field 25

OriginalLoanAmount (US$)

The original principal amount of the loan, net of cancellations, as of the file creation date.
This includes increases in the original amount of loans, such as reallocations between
subsidized loans and unsubsidized loans which will decrease one and increase the other.
This data is required.
Field 26

LenderFeeAmount (US$)

The total amount of the 1% lender fee paid or due, as of the file creation date. This data
is required for new or reissued disbursements. Report this fee as a cumulative amount.
Field 27

ActualInterestRate

Actual Interest Rate on the loan as charged to the borrower. Submit with five digits after
the decimal. Pad with zeros if not reporting to five digits. This data is required.
Field 28

OutstandingPrincipalBalance (US$)

Outstanding borrower principal balance on the loan, as of the file creation date. Include
capitalized interest in this balance. This data is required.
Field 29

OutstandingInterestBalance (US$)

Outstanding borrower interest balance on the loan, as of the file creation date. This data
is required.

Page 11 of 16

Field 30

LoanPeriodBeginDate

The beginning date of the loan period as provided by the school in its loan certification.
This data is required.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.
Field 31

LoanStatus

Please use the established NSLDS Loan Status Codes per Appendix B of the NSLDS
Guaranty Agency Data Provider Instructions. This data is required.
Field 32

ReductionAmountSchool

New reductions in the outstanding loan principal balance since the last submission of this
loan on the Month-End Loan Schedule for the reasons listed in the table of codes to be
used in Field 33. Collections of cancellations or school refunds should be reported as a
positive number. A reversal of a cancellation or refund (due to error and not a
cancellation and reissue) should be reported as a negative number. The use of negative
numbers for reversals is expected to be rare. This field is only used on the Month-End
Loan Schedule. Please fill with zeroes if there are no reductions to report and for the
Weekly Loan Schedule.
Field 33

ReductionReasonCodeSchool

This data is required for any reduction in outstanding loan principal balance resulting
from school payments to the lender.
Table (3)
Reduction Reason Code School
Cancellation
School Refund
Field 34

Code
CA
RF

GuarantyAgencyClaims

New reductions in the outstanding loan principal balance due to claim payment amounts
made by the guaranty agency to the lender, since the last submission of this loan on the
Month-End Loan Schedule. Collections of claims paid should be reported as a positive
number. A reversal of a guaranty agency claim payment should be reported as a negative
number. The use of negative numbers for reversals is expected to be rare. This field is
Page 12 of 16

only used on the Month-End Loan Schedule. Please fill with zeroes if there are no claims
to report and for the Weekly Loan Schedule.
Field 35

ReductionReasonCodeGA

This data is required for any reduction in outstanding loan principal balance resulting
from claims paid to the lender. Otherwise, pad this field with “AA.”
Table (4)
Reduction Reason Code GA
Claims paid to Lender for Bankruptcy
Claims paid to Lender for Closed
School/False Certification
Claims paid to Lender for Death
Claims paid to Lender for Disability
Claims paid to Lender for Discharged or
Forgiven
Claims paid to Lender for Unpaid Refund
Guaranty fee reimbursement paid by
Guarantor
Field 36

Code
BK
FC
DE
DI
DH
UR
GF

DateLoanRemovedFromPC

The date the loan balance was redeemed from the Participation Certificate through a loan
sale or exercise of a put option, if applicable. If no date to report, fill the field with zeros.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.
Field 37

LoanProceeds

Proceeds from loan sales to third parties and proceeds from redemptions from the
Sponsor, since the last submission of this loan on the Month-End Loan Schedule.
Proceeds should be reported as a positive number. A reversal of proceeds should be
reported as a negative number. The use of negative numbers for reversals is expected to
be rare. This field is only used on the Month-End Loan Schedule. Please fill with zeroes
if there are no proceeds to report and for the Weekly Loan Schedule.

Page 13 of 16

Field 38

LoanPutToDepartment (US$)

Total proceeds received from the Department for a loan Put to the Department, since the
last submission of this loan on the Month-End Loan Schedule. The Put amount should be
reported as a positive number. A reversal of a Put amount should be reported as a
negative number. The use of negative numbers for reversals is expected to be rare. This
field is only used on the Month-End Loan Schedule. Please fill with zeroes if there are
no puts to report and for the Weekly Loan Schedule.
Field 39

BorrowerPrincipalCollection

Amount of principal paid by the borrower or a third party (such as for loan forgiveness
programs), or payoffs or consolidations for this loan since the last Month-End Loan
Schedule. This amount should be reported as a positive number. A reversal, such as for
a NSF charge, should be reported as a negative number. The use of negative numbers for
reversals is expected to be rare. This field is only used on the Month-End Loan Schedule.
Please fill with zeroes if there are no principal collections to report and for the Weekly
Loan Schedule.
Field 40

BorrowerInterestCollection

Amount of interest paid by the borrower or a third party (such as for loan forgiveness
programs), or payoffs or consolidations for this loan since the last Month-End Loan
Schedule. This amount should be reported as a positive number. A reversal, such as for
a NSF charge, should be reported as a negative number. The use of negative numbers for
reversals is expected to be rare. This field is only used on the Month-End Loan Schedule.
Please fill with zeroes if there are no interest collections to report and for the Weekly
Loan Schedule.
Field 41

OtherCash

Cash transactions affecting the loan made by the servicer (e.g., late fees, attorney fees,
collection fees) since the last submission of this loan on the Month-End Loan Schedule.
This can be reported as a negative number. In Field 43, provide a brief description of this
amount. This field is only used on the Month-End Loan Schedule. Please fill with zeroes
if there is no other cash to report and for the Weekly Loan Schedule.
Field 42

Lienholder

This data is required.
Table (5)
Lienholder
If the Eligible Loan is subject to a lien due to
financing
If the Eligible Loan is not subject to a lien

Code
Y
N

Page 14 of 16

Field 43 OtherCashExplanation
If an amount is reported in Field 41 “OtherCash”, please provide a brief description of
this amount.
Field 44

ClaimDate

This data is required.
The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.
Field 45

CancelDate

Field 46

RefundDate

Field 47

LoanPeriodEndDate

The date must be in the following format:
CCYYMMDD
CC = Century
YY = Year
MM = Month
DD = Day
Example: 20081105 (November 5, 2008)
Single-digit years, months, and days must be padded with a leading zero.

Field 48

LoanStatusDate

Field 49

Filler

Page 16 of 16

Paperwork Burden Statement

According to the Paperwork reduction Act of 1995, no persons are required to respond to a
collection of information unless such collection displays a valid OMB control number. The valid
OMB control number for this information collection is 1845-NEW. The time required to
complete this information collection is estimated to average 2 hours per response, including the
time to review instructions, search existing data resources, gather the data needed, and complete
and review the information collection. If you have any comments concerning the accuracy of
the time estimate(s) or suggestions for improving this form, please write to: U.S. Department
of Education, Washington, D.C. 20202-4537. If you have comments or concerns regarding
the status of your individual submission of this form, write directly to: Policy Liaison and
Implementation, Federal Student Aid, U.S. Department of Education, 400 Maryland Avenue,
S.W., UCP3, 11th floor, Washington D.C. 20202-4537.

Page 16 of 16

DRAFT
United States Department of Education
Federal Family Education Loan Program
Loan Participation Program Under a Master Participation Agreement
Loan Schedule and Custodial Certification
See "Loan Schedule Data File Definitions" for definitions and guidance on the field names, formats and purpose, and for submission instructions.
All negative numbers must contain a negative sign. For Example: -$1,123.55 = -00000001123.55 (for a Field length of 15).
Only Fields 32, 34 and 37-41 can be negative.
When submitting cents, a decimal point must be used.
Header Record
Field
0
1

Field Name
RecordTypeIndicator
BatchID

Start Position
1
2

Length
1
3

Data Type
X(001)
9(003)

Justify
Left
Left

Padding
Zeroes to Left

Required?
Yes; H = Header Record
Yes; Unique to each transmission. The first batch would be 001.

CustodianIDNumber(LID/RID)

X(008)

Left

Spaces to Right Yes

ServicerID (LID/RID)

X(008)

Left

Spaces to Right Yes

PCFundingRequest

9(08).99

Right

Zeroes to Left

Yes, even if zero. Maximum amount is 99999999.99 (Field length of 11)

CashCollections

9(012).99

Right

Zeroes to Left

Yes, even if zero. Example: $1,233.55 would be submitted as 000000001233.55

FileCreationDate

9(008)

Left

RecordCount

9(007)

Right

8
9

FundingYear
ReportingPeriod

62
66

4
6

9(004)
9(006)

Start Position
1
2

Length
1
19

Data Type
X(001)
X(019)

Justify
Left
Left

Zeroes to Right Yes; CCYYMMDD
Zeroes to Left

Yes
Yes; YYYY
Yes; YYYYMM

Loan Level Detailed Record
Field
0
1

Field Name
RecordTypeIndicator
LoanNumber

Padding
Required?
Yes; L = Loan Level Detail
Spaces to Right Yes

2
3
4

DataFlag
SSN
BirthDate

21
22
31

1
9
8

X(001)
9(009)
9(008)

Left
Right
Left

LastName

X(035)

Left

Spaces to Right Yes

FirstName

X(020)

Left

Spaces to Right Yes

April 9, 2009

Yes; See Table (1)
Yes
Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

Page 1 of 4

DRAFT
Field
7

Field Name
PLUS/AlternativeSSN

Start Position
94

Length
9

Data Type
9(009)

Justify
Right

Padding

Required?
Yes, if this is a PLUS loan. Otherwise fill with zeroes.

PLUS/AlternativeBirthDate

103

9(008)

Left

Zeroes to Right Yes, if this is a PLUS loan (CCYYMMDD), otherwise, fill with zeroes.

PLUS/AlternativeStudentLastName

111

X(035)

Left

Spaces to Right Yes, if this is a PLUS loan. Otherwise leave blank.

PLUS/AlternativeStudentFirstName

146

X(020)

Left

Spaces to Right Yes, if this is a PLUS loan. Otherwise leave blank.

11
12
13

SchoolID
GuarantyAgencyCode
GuarantyDate

166
174
177

8
3
8

9(008)
9(003)
9(008)

Left
Left
Left

Yes
Yes
Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

TotalNumberOfScheduledDisbursements

185

9(002)

Right

FirstDisbursementDate

187

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

MostRecentDisbursementDate

195

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

DisbursementNumber

203

9(002)

Right

Zeroes to Left

Yes, if requesting funding with this submission.

DisbursementAmount

205

9(05).99

Right

Zeroes to Left

Yes, if requesting funding with this submission. Maximum amount is 99999.99 (Field length of
8)

AnticipatedFinalDisbursementDate

213

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

20
21

LoanType
OriginalLenderID(LID/RID)

221
223

2
8

X(002)
X(008)

Left
Left

Yes; See Table (2)
Spaces to Right Yes

SponsorID(LID/RID)

231

X(008)

Left

Spaces to Right Yes

OriginationFee

239

9(012).99

Right

Zeroes to Left

Yes. Example: $10.12 should be submitted as 000000000010.12

GuarantyFee

254

9(012).99

Right

Zeroes to Left

Yes

OriginalLoanAmount

269

9(012).99

Right

Zeroes to Left

Yes

LenderFeeAmount

284

9(012).99

Right

Zeroes to Left

Yes

ActualInterestRate

299

9(001).99999

Right

Zeroes to Left

Yes; Example: 6.8% should be submitted as 0.06800

OutstandingPrincipalBalance

306

9(012).99

Right

Zeroes to Left

Yes

OutstandingInterestBalance

321

9(012).99

Right

Zeroes to Left

Yes

LoanPeriodBeginDate

336

9(008)

Left

LoanStatus

344

X(002)

Left

April 9, 2009

Zeroes to Left

Yes

Zeroes to Right Yes; CCYYMMDD
Yes

Page 2 of 4

DRAFT
Field
32

Field Name
ReductionAmountSchool

Start Position
346

Length
15

Data Type
9(012).99

Justify
Right

Padding
Zeroes to Left

Required?
Yes. Report cash collections for reductions as a positive number. Only reversals should be
reported as a negative number.

ReductionReasonCodeSchool

361

X(002)

Left

GuarantyAgencyClaims

363

9(012).99

Right

ReductionReasonCodeGA

378

X(002)

Left

DateLoanRemovedFromPC

380

9(008)

Right

Zeroes to Left

LoanProceeds

388

9(012).99

Right

Zeroes to Left

LoanPutToDepartment

403

9(012).99

Right

Zeroes to Left

Yes, if loans are sold to the Department under the Put Option. Report Put amount as a positive
number. Only reversals should be submitted as a negative number.

BorrowerPrincipalCollection

418

9(012).99

Right

Zeroes to Left

Yes, if the borrower has made principal payments. Report collection amount as a positive
number. Only reversals should be submitted as a negative number.

BorrowerInterestCollection

433

9(012).99

Right

Zeroes to Left

Yes, if the borrower has made interest payments. Report collection amount as a positive
number. Only reversals should be submitted as a negative number.

OtherCash

448

9(012).99

Right

Zeroes to Left

Yes, if there are adjustments. Provide a brief explanation in Field 43.

42
43

Lienholder
OtherCashExplanation

463
464

1
15

X(001)
X(015)

Left
Left

Yes. See Table (5)
Spaces to Right If amount reported in Field #41, provide a brief explanation here.

ClaimDate

479

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

CancelDate

487

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

RefundDate

495

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

LoanPeriodEndDate

503

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

LoanStatusDate

511

9(008)

Left

Zeroes to Right Yes; CCYYMMDD [Must be 8 digits]

Filler

519

X(010)

Left

Spaces to Right

April 9, 2009

Spaces to Right Yes, if the Participation Certificate balance has been reduced for this loan. See Table (3)
Zeroes to Left

Yes, if there are GA claims. Report cash collections for claims as a positive number. Only
reversals should be submitted as a negative number.

Spaces to Right Yes, if the Participation Certificate balance has been reduced for this loan. See Table (4)
Yes, if the loan has or is being removed from the corpus of the Participation Certificate.
CCYYMMDD
Yes, if funds are being returned. Report cash collections for proceeds as a positive number.
Only reversals should be submitted as a negative number.

Page 3 of 4

DRAFT
For Field 2 - Loan Level Detail
Table (1)
Data Flag
New Loan
Updated Loan: New or additional information from prior Loan Schedule submission (e.g., increases in accrued
interest, changes to borrower information (such as name change) or change in terms (such as reallocation
between subsidized and unsubsidized))

Code
N
U

No change to this loan for this report
For Field 20 - Loan Level Detail
Table (2)

Code
SF
SU
PL
GB

Loan Type
FFEL Stafford Subsidized Loan
FFEL Stafford Unsubsidized Loan
PLUS Loan - Parent
PLUS Loan - Graduate/Professional
For Field 33 - Loan Level Detail
Table (3)

Code
CA

Reduction Reason Code School
Cancellation
School Refund

RF
For Field 35 - Loan Level Detail
Table (4)
Code
BK
FC
DE
DI
DH
UR

Reduction Reason Code GA
GA Claim for Bankruptcy
GA Claim for Closed School/False Certification
GA Claim for Death
GA Claim for Disability
GA Claim for Discharged or Forgiven
GA Claim for Unpaid Refund

Guaranty Fee Reimbursement
For Field 42 - Loan Level Detail
Table (5)
Lienholder
If the Eligible Loan is subject to a lien due to financing
If the Eligible Loan is not subject to a lien

April 9, 2009

Code
Y
N

Page 4 of 4

File Type	application/pdf
File Title	United States Department of Education
Author	Patterson, Marlene E
File Modified	2009-04-10
File Created	2009-04-10