Loan Liquidation File, V 1.2 2/1/2021

1

MBS Single Family Loan Liquidation (Payoffs) Disclosure File

Version 1.2: Effective for the Loan Liquidation File beginning with February 2021 Data

See Version History for details
Loan Liquidation File, V 1.2 2/1/2021

2

Introduction:

The purpose of this file is to provide investors with Mortgage Backed Securities (MBS) Single Family Loan Level Liquidation data. This layout had 

previously been applied to the preliminary, 4th Business Day file; beginning in May 2019, the layout applies to:

• Historical, one-time Single Family Loan Liquidation file with data from these periods: October 2009 – March 2019.

• Monthly Single Family Loan Liquidation file with Issuer Reported data as of the 4th Business Day of the month.

• Monthly Single Family Loan Liquidation file with Issuer Reported data as of the 6th Business Day of the month (beginning with April 2019 

period).

The format of the file will be pipe bar delimited “|”.

Document Version History 

Version 1.0 8/15/2018 Initial Version

Version 1.1 5/1/2019 Version 1.0 with this addition: This version applies the layout to two additional files:

• Applying the layout to the one-time file of SF Loan Liquidations from the October 2009 – March 2019 

periods.

• Applying the layout to the monthly, 6th Business Day Disclosure

There is no change to the monthly, 4th Business Day Disclosure file. 

Version 1.2 2/1/2021 Version 1.1 with this revision: Addition of a new value, “Re-performing”, Loan Purpose 5 in the 

LR Record, Field LR-011, Loan Purpose. This is effective beginning with February 2021 data and is the only change

from Version 1.1.
Loan Liquidation File, V 1.2 2/1/2021

3

Summary of Records in the File:

Record Type Short Description Occurs in the File

HH Overall File Header Record One Record Per File

LR Loan Liquidation Record One Record Per Liquidating Loan

TT Overall File Trailer Record One Record Per File

• Files will contain one Header Record (“HH”), multiple Loan Liquidation Records (“LR”), and one Trailer Record (“TT”).

• All records are sorted first by Pool ID and then by Disclosure Sequence Number and are listed in ascending order. This applies to:

o One-time File

o Monthly Files

Header Record

Item Data Element Type Max Length Format Definition

HH-001 Record Type = HH Character 2 File Header Record

HH-002 Report Period Numeric 6 YYYYMM Reporting Period of the data in the file (the “as of” month 

and year). For the One-time file, this will be “201903”.

HH-003 Date File Generated Numeric 8 YYYYMMDD The Date the file was created

Loan Liquidation Record

Item Data Element Type Max Length Format Definition

LR-001 Record Type = LR Character 2 Loan Liquidation Record

LR-002 CUSIP Number Character 9 The CUSIP is a unique identification number permanently 

assigned by the Committee on Uniform Securities 

Identification Procedures (CUSIP) to each publicly traded 

security at the time of issuance.

LR-003 Pool ID Character 6 The Pool identifier assigned by Ginnie Mae at pooling.
Loan Liquidation File, V 1.2 2/1/2021

4

LR-004 Pool Indicator Character 1 Identifies the Issue Type of the pool. Values are X, C, or 

M.

LR-005 Pool Type Character 2 Two-character pool type for the pool (see Ginnie Mae 

Guide, Chapter 1).

LR-006 Pool Issue Date Numeric 8 YYYYMMDD The date the pool was issued

LR-007 Disclosure Sequence Number Numeric 10 A number used for each loan to identify it distinctly for 

data disclosures

LR-008 Issuer ID Numeric 4 The four-digit identifier for the current issuer 

responsible for the loan

LR-009 Report Period Numeric 6 YYYYMM Reporting Period of the data in the file.

LR-010 Agency Type Character 1 Identifier of the government agency. Values are:

F = Federal Housing Administration

V = Veterans Administration

R = Rural Development

N = Native American

9 = Not Available

LR-011 Loan Purpose Numeric 1 Purpose of the loan. Values are:

1 = Purchase

2 = Refinance

3 = Loan Modification (HAMP)

4 = Loan Modification (non-HAMP)

5 = Re-performing

9 = Not Available

LR-012 Original Principal Balance (OPB) Numeric 16 13.2 The Original Principal Balance of the loan at pool 

issuance. The value is truncated to the thousandths 

place.

LR-013 Unpaid Principal Balance (UPB) Numeric 16 13.2 The Unpaid Principal Balance (UPB) of the loan as of 

the reporting period. This field will be blank if the loan 

is removed within 6 months of pool issuance.

LR-014 Liquidation Balance (principal 

pass through)

Numeric 16 13.2 The unscheduled remaining principal of the loan that 

is being passed through, after taking into account 
Loan Liquidation File, V 1.2 2/1/2021

5

scheduled principal remitted. This field will be blank if 

the loan is removed within 6 months of pool issuance.

LR-015 Removal Reason Code Numeric 1 Reason for removal of the loan. Values are:

1 = Mortgagor Payoff 

2 = Repurchase of Delinquent Loan 

3 = Foreclosure with Claim Payment 

4 = Loss Mitigation 

5 = Substitution 

6 = Other Removal

Trailer Record

Item Data Element Type Max Length Format Definition

TT-001 Record Type = TT Character 2 File Trailer Record

TT-002 Report Period Numeric 6 YYYYMM Reporting Period of the data in the file. For the 

One-time file, this will be “201903”.

TT-003 Loan Count Numeric 9 The number of loans/LR Records contained in the 

file

MBS Single Family Loan Liquidation (pay-offs) Layout Notes:

• This layout applies only to Single Family loans.

• This layout applies to Single Family loan liquidations in these files:

1. One-time file with loan liquidations from Oct 2009 – March 2019. The File Naming Convention is: “llmonliqot_201903.zip”.

2. Monthly files, for all loan liquidations in the report month. File Naming Convention: “llmonliq_YYYYMM.zip”, where “YYYY” is the 

four-year digit year and “MM” is the month. The monthly File Naming Convention applies to both the 4th Business Day and 6th

Business Day files.