FM SFLP Template

Definition

The Agency Single Family Loan Performance Template is an enumeration of data fields that document the credit performance of a portion of Fannie Mae’s single-family book of business.

Background

In support of its credit risk transfer programs, Fannie Mae released an extensive dataset beginning in 2013 that provides insight into the credit performance of a portion of Fannie Mae’s single-family book of business. The dataset provides monthly loan-level detail and is offered to help investors gain a better understanding of the credit performance of a portion of single-family loans owned or guaranteed by Fannie Mae. The public dataset includes a subset of Fannie Mae’s 30-year, fixed-rate, fully documented, single-family amortizing loans that the company owned or guaranteed on or after January 1, 2000. In October 2020, Fannie Mae enhanced the data offering to include additional credit performance data.

Version History

• Current Entries are based on the October 2020 release

Structure

The FM SFLP template in a single table of data fields that captures all available loan data. The following is a summary table. Click through for more detailed information.

Template Fields

Field	Column Label	Description
Reference Pool ID	POOL_ID	A unique identifier for the reference pool.
Loan Identifier	LOAN_ID	A unique identifier for the mortgage loan.
Monthly Reporting Period	ACT_PERIOD	The month and year that pertains to the servicer’s cut-off period for mortgage loan information.
Channel	CHANNEL	The origination channel used by the party that delivered the loan to the issuer.
Seller Name	SELLER	The name of the entity that delivered the mortgage loan to Fannie Mae.
Servicer Name	SERVICER	The name of the entity that serves as the primary servicer of the mortgage loan.
Master Servicer	MASTER_SERVICER	Fannie Mae
Original Interest Rate	ORIG_RATE	The original interest rate on a mortgage loan as identified in the original mortgage note.
Current Interest Rate	CURR_RATE	The rate of interest in effect for the periodic installment due.
Original UPB	ORIG_UPB	The dollar amount of the loan as stated on the note at the time the loan was originated.
UPB at Issuance	ISSUANCE_UPB	The unpaid principal balance of the loan as of the cut-off date of the reference pool.
Current Actual UPB	CURRENT_UPB	The current actual outstanding unpaid principal balance of a mortgage loan, reflective of payments actually received from the related borrower.
Original Loan Term	ORIG_TERM	For fixed-rate, adjustable-rate and Interest-only mortgages, the number of months in which regularly scheduled borrower payments are due at the time the loan was originated.
Origination Date	ORIG_DATE	The date of each individual note.
First Payment Date	FIRST_PAY	The date of the first scheduled mortgage loan payment to be made by the borrower under the terms of the mortgage loan documents.
Loan Age	LOAN_AGE	The number of calendar months since the mortgage loan's origination date. For purposes of calculating this data element, origination means the date on which the first full month of interest begins to accrue.
Remaining Months to Legal Maturity	REM_MONTHS	The number of calendar months remaining until the mortgage loan is due to be paid in full based on the maturity date as defined in the mortgage documents.
Remaining Months To Maturity	ADJ_REM_MONTHS	The number of calendar months remaining until the outstanding unpaid principal balance of the mortgage loan amortizes to a zero balance, taking into account any additional prepayments, which could lead to the loan paying off earlier than its maturity date.
Maturity Date	MATR_DT	The month and year in which a mortgage loan is scheduled to be paid in full as defined in the mortgage loan documents.
Original Loan to Value Ratio	OLTV	The ratio, expressed as a percentage, obtained by dividing the amount of the loan at origination by the value of the property.
Original Combined Loan to Value Ratio	OCLTV	The ratio, expressed as a percentage, obtained by dividing the amount of all known outstanding loans at origination by the value of the property.
Number of Borrowers	NUM_BO	The number of individuals obligated to repay the mortgage loan.
Debt-To-Income	DTI	DTI. The ratio obtained by dividing the total monthly debt expense by the total monthly income of the borrower at the time the loan was originated.
Borrower Credit Score at Origination	CSCORE_B	A numerical value used by the financial services industry to evaluate the quality of borrower’s credit. Credit scores are typically based on a proprietary statistical model that is developed for use by credit data repositories. These credit repositories apply the model to borrower credit information to arrive at a credit score. When this term is used by Fannie Mae, it is referring to the "Classic" FICO score developed by Fair Isaac Corporation.
Co-Borrower Credit Score at Origination	CSCORE_C	A numerical value used by the financial services industry to evaluate the quality of borrower’s credit. Credit scores are typically based on a proprietary statistical model that is developed for use by credit data repositories. These credit repositories apply the model to borrower credit information to arrive at a credit score. When this term is used by Fannie Mae, it is referring to the "Classic" FICO score developed by Fair Isaac Corporation.
First Time Home Buyer Indicator	FIRST_FLAG	An indicator that denotes if the borrower or co-borrower qualifies as a first-time homebuyer.
Loan Purpose	PURPOSE	An indicator that denotes whether the mortgage loan is either a refinance mortgage or a purchase money mortgage. Purpose may be the purchase of a new property or refinance of an existing lien (with cash out or with no cash out).
Property Type	PROP	An indicator that denotes whether the property type secured by the mortgage loan is a condominium, co-operative, planned urban development (PUD), manufactured home, or single-family home.
Number of Units	NO_UNITS	The number of units comprising the related mortgaged property (one, two, three, or four).
Occupancy Status	OCC_STAT	The classification describing the property occupancy status at the time the loan was originated.
Property State	STATE	A two-letter abbreviation indicating the state or territory within which the property securing the mortgage loan is located.
Metropolitan Statistical Area	MSA	The numeric Metropolitan Statistical Area Code for the property securing the mortgage loan. MSAs are established by the US Office of Management and Budget. An area usually qualifies as an MSA if it is defined by the Bureau of the Census as an urbanized area and has a population of 50,000 or more in a total metropolitan area of at least 100,000. An MSA may consist of one or more counties.
Zip Code Short	ZIP	Limited to the first three digits of the code designated by the U.S. Postal Service where the subject property is located.
Mortgage Insurance Percentage	MI_PCT	The original percentage of mortgage insurance coverage obtained for an insured conventional mortgage loan and used following the occurrence of an event of default to calculate the insurance benefit, as defined by the underlying master primary insurance policy.
Amortization Type	PRODUCT	The classification of the loan as having either a fixed- or an adjustable-interest rate at the time the loan was originated.
Prepayment Penalty Indicator	PPMT_FLG	An indicator that denotes whether the borrower is subject to a penalty for early payment of principal.
Interest Only Loan Indicator	IO	An indicator that denotes whether the loan only requires interest payments for a specified period of time beginning with the first payment date.
Interest Only First Principal And Interest Payment Date	FIRST_PAY_IO	For interest-only loans, the month and year that the first monthly scheduled fully amortizing principal and interest payment is due.
Months to Amortization	MNTHS_TO_AMTZ_IO	For interest-only loans, the number of months from the current month to the first scheduled principal and interest payment date.
Current Loan Delinquency Status	DLQ_STATUS	The number of months the obligor is delinquent as determined by the governing mortgage documents.
Loan Payment History	PMT_HISTORY	The coded string of values that describes the payment performance of the loan over the most recent 24 months. The most recent month is located to the right.
Modification Flag	MOD_FLAG	An indicator that denotes if the mortgage loan has been modified.
Mortgage Insurance Cancellation Indicator	MI_CANCEL_FLAG	An indicator that denotes if the mortgage insurance (MI) has been cancelled since origination.
Zero Balance Code	Zero_Bal_Code	A code indicating the reason the loan's balance was reduced to zero or experienced a credit event, if applicable.
Zero Balance Effective Date	ZB_DTE	Date on which the mortgage loan balance was reduced to zero.
UPB at the Time of Removal	LAST_UPB	The unpaid principal balance of the loan at the time of removal.
Repurchase Date	RPRCH_DTE	The date on which a Reversed Credit Event Reference Obligation occurs with respect to a loan.
Scheduled Principal Current	CURR_SCHD_PRNCPL	The minimum principal payment the borrower is obligated to pay for the corresponding reporting period, based on the terms provided in the related mortgage loan documents, provided that the payment is collected from the borrower by the servicer and reported to Fannie Mae for the corresponding reporting period.
Total Principal Current	TOT_SCHD_PRNCPL	The change between the prior reporting period’s disclosed Current Actual UPB and the current reporting period’s disclosed Current Actual UPB.
Unscheduled Principal Current	UNSCHD_PRNCPL_CURR	The principal amount received in excess of the scheduled principal payment collected from the borrower by the servicer and reported to Fannie Mae for the corresponding reporting period.
Last Paid Installment Date	LAST_PAID_INSTALLMENT_DATE	The due date of the last paid installment that was collected for the mortgage loan.
Foreclosure Date	FORECLOSURE_DATE	The date on which the completion of the legal action of foreclosure occurred.
Disposition Date	DISPOSITION_DATE	The date on which Fannie Mae’s interest in a property ends through either the transfer of the property to a third party or the satisfaction of the mortgage obligation.
Foreclosure Costs	FORECLOSURE_COSTS	Expenses associated with obtaining title to property from the mortgagor, valuing the property, and maintaining utility services to the property. Such costs include costs and fees associated with bankruptcy and foreclosure.
Property Preservation and Repair Costs	PROPERTY_PRESERVATION_AND_REPAIR_COSTS	The expenses associated with securing and preserving the property including two major categories: maintenance and repairs. Maintenance costs are associated with preserving the property through normal upkeep, while repairs are associated with either avoiding deterioration of the asset or a marketing decision to help maximize sales proceeds upon final disposition.
Asset Recovery Costs	ASSET_RECOVERY_COSTS	Expenses associated with removing occupants and personal property from an occupied property post foreclosure. Such expenses include relocation assistance, deed-in-lieu fee, and fees and costs associated with eviction actions.
Miscellaneous Holding Expenses and Credits	MISCELLANEOUS_HOLDING_EXPENSES_AND_CREDITS	Expenses and credits associated with preserving the property, including Homeowners Association and other dues; flood, hazard, and MI premiums and refunds; rental income; and title insurance costs.
Associated Taxes for Holding Property	ASSOCIATED_TAXES_FOR_HOLDING_PROPERTY	Payment of taxes associated with holding the property.
Net Sales Proceeds	NET_SALES_PROCEEDS	Total cash received from the sale of the property net of any applicable selling expenses, such as fees and commissions, allowable for inclusion under the terms of the property sale, as currently reported on the HUD-1 or other settlement statement.
Credit Enhancement Proceeds	CREDIT_ENHANCEMENT_PROCEEDS	Proceeds from claims on primary and certain other limited mortgage insurance policies, and recourse and indemnification payments from lenders under arrangements designed to limit credit exposure to Fannie Mae.
Repurchase Make Whole Proceeds	REPURCHASES_MAKE_WHOLE_PROCEEDS	Amounts received by Fannie Mae under the terms of our representation and warranty arrangements for the repurchase of the mortgage loan or the subject property or loss reimbursement subsequent to property disposition.
Other Foreclosure Proceeds	OTHER_FORECLOSURE_PROCEEDS	Amounts, other than sale proceeds, received by Fannie Mae following foreclosure of a property, including redemption proceeds received from the mortgagor.
Non-Interest Bearing UPB	NON_INTEREST_BEARING_UPB	A portion of the UPB, as a result of an eligible loan modification, that will not accrue interest.
Principal Forgiveness Amount	PRINCIPAL_FORGIVENESS_AMOUNT	A reduction of the UPB owed on a mortgage by a borrower that is formally agreed to by the lender and the borrower, usually in conjunction with a loan modification.
Original List Start Date	ORIGINAL_LIST_START_DATE	The agreed upon date, between a property seller and a broker, authorizing the broker to begin the process to procure a buyer or tenant for the property seller’s real property.
Original List Price	ORIGINAL_LIST_PRICE	The initial price at which a real property is offered for sale by the property seller.
Current List Start Date	CURRENT_LIST_START_DATE	The agreed upon date, between a property seller and a broker, authorizing the broker to begin the process to procure a buyer or tenant for the property seller’s real property.
Current List Price	CURRENT_LIST_PRICE	The price at which a real property is offered for sale.
Borrower Credit Score At Issuance	ISSUE_SCOREB	A numerical value used by the financial services industry to evaluate the quality of borrower credit. Credit scores are typically based on a proprietary statistical model that is developed for use by credit data repositories. These credit repositories apply the model to borrower credit information to arrive at a credit score. When this term is used by Fannie Mae, it is referring to FICO Score 5(1) developed by Fair Isaac Corporation and provided by Equifax Inc. and is distinct from the FICO Score referenced in Fannie Mae's Selling Guide, which may be provided by any of the three major credit repositories
Co-Borrower Credit Score At Issuance	ISSUE_SCOREC	A numerical value used by the financial services industry to evaluate the quality of borrower credit. Credit scores are typically based on a proprietary statistical model that is developed for use by credit data repositories. These credit repositories apply the model to borrower credit information to arrive at a credit score. When this term is used by Fannie Mae, it is referring to FICO Score 5(1) developed by Fair Isaac Corporation and provided by Equifax Inc and is distinct from the FICO Score referenced in Fannie Mae's Selling Guide.
Borrower Credit Score Current	CURR_SCOREB	A numerical value used by the financial services industry to evaluate the quality of borrower credit. Credit scores are typically based on a proprietary statistical model that is developed for use by credit data repositories. These credit repositories apply the model to borrower credit information to arrive at a credit score. When this term is used by Fannie Mae, it is referring to FICO Score 5(1) developed by Fair Isaac Corporation and provided by Equifax Inc and is distinct from the FICO Score referenced in Fannie Mae's Selling Guide, which may be provided by any of the three major credit repositories.
Co-Borrower Credit Score Current	CURR_SCOREC	A numerical value used by the financial services industry to evaluate the quality of borrower credit. Credit scores are typically based on a proprietary statistical model that is developed for use by credit data repositories. These credit repositories apply the model to borrower credit information to arrive at a credit score. When this term is used by Fannie Mae, it is referring to FICO Score 5(1) developed by Fair Isaac Corporation and provided by Equifax Inc and is distinct from the FICO Score referenced in Fannie Mae's Selling Guide.
Mortgage Insurance Type	MI_TYPE	The entity that is responsible for the Mortgage Insurance premium payment.
Servicing Activity Indicator	SERV_IND	An indicator that denotes a change in servicing activity during the corresponding reporting period.
Current Period Modification Loss Amount	CURRENT_PERIOD_MODIFICATION_LOSS_AMOUNT	The loss amount calculated for a mortgage loan resulting from a modification event for the corresponding reporting period.
Cumulative Modification Loss Amount	CUMULATIVE_MODIFICATION_LOSS_AMOUNT	The cumulative loss amount calculated for a mortgage loan resulting from a modification event.
Current Period Credit Event Net Gain or Loss	CURRENT_PERIOD_CREDIT_EVENT_NET_GAIN_OR_LOSS	The net realized gain or loss amount calculated for a mortgage loan resulting from a credit event for the corresponding reporting period.
Cumulative Credit Event Net Gain or Loss	CUMULATIVE_CREDIT_EVENT_NET_GAIN_OR_LOSS	The cumulative net realized gain or loss amounts for a mortgage loan resulting from a credit event.
Special Eligibility Program	HOMEREADY_PROGRAM_INDICATOR	A mortgage program with expanded eligibility criteria designed to increase and maintain home ownership.
Foreclosure Principal Write-off Amount	FORECLOSURE_PRINCIPAL_WRITE_OFF_AMOUNT	Amounts that Fannie Mae or its loan servicers have determined to be uncollectable under applicable state laws, due to foreclosure statute of limitations.
Relocation Mortgage Indicator	RELOCATION_MORTGAGE_INDICATOR	An indicator that denotes whether or not the type of mortgage loan is a relocation mortgage loan, made to borrowers whose employers relocate their employees.
Zero Balance Code Change Date	ZERO_BALANCE_CODE_CHANGE_DATE	The most recent date in which a loan status change was identified, resulting from corresponding change to the Zero Balance Code.
Loan Holdback Indicator	LOAN_HOLDBACK_INDICATOR	An indicator that denotes if a loan has been moved temporarily into a ‘hold’ status to allow Fannie Mae to further evaluate unique situations that may otherwise result in a credit event or loan removal. Such situations may include loans with reported data anomalies, loans currently in forbearance due to a natural disaster or loans refinanced under the High LTV program that will continue to be included in the reference pool.
Loan Holdback Effective Date	LOAN_HOLDBACK_EFFECTIVE_DATE	The date of the latest Loan Holdback indicator change.
Delinquent Accrued Interest	DELINQUENT_ACCRUED_INTEREST	The lost accrued interest amount calculated for a mortgage loan that becomes subject to a credit event for the corresponding reporting period.
Property Valuation Method	PROPERTY_INSPECTION_WAIVER_INDICATOR	An indicator that denotes the method by which the value of the subject property was obtained.
High Balance Loan Indicator	HIGH_BALANCE_LOAN_INDICATOR	An indicator that denotes if the original principal balance of a mortgage loan is greater than the general conforming loan limit and up to the high-cost area loan limit.
ARM Initial Fixed-Rate Period Less Than 5 YR	ARM_5_YR_INDICATOR	For an adjustable-rate mortgage loan, an indicator that denotes if the Initial Fixed-Rate Period is less than or equal to five years.
ARM Product Type	ARM_PRODUCT_TYPE	For an adjustable-rate mortgage loan, a string that denotes the Initial Fixed-Rate Period, the subsequent Interest Rate Adjustment Frequency, and the Original Loan Term.
Initial Fixed-Rate Period	MONTHS_UNTIL_FIRST_PAYMENT_RESET	For an adjustable-rate mortgage loan, the number of months between the first full month the mortgage loan accrues interest and the initial interest rate change date.
Interest Rate Adjustment Frequency	MONTHS_BETWEEN_SUBSEQUENT_PAYMENT_RESET	For an adjustable-rate mortgage loan, the number of months between scheduled rate changes. For loans with an Initial Fixed-Rate Period, the number of months between subsequent rate adjustments.
Next Interest Rate Adjustment Date	INTEREST_RATE_CHANGE_DATE	For adjustable-rate loans, the month and year that the interest rate is next subject to change.
Next Payment Change Date	PAYMENT_CHANGE_DATE	For an adjustable-rate mortgage loan, the next date on which the payment amount due from the borrower is subject to change.
Index	ARM_INDEX	For adjustable-rate loans, the description of the index on which adjustments to the interest rate are based.
ARM Cap Structure	ARM_CAP_STRUCTURE	For an adjustable-rate mortgage loan, a numeric string that explains the interest rate caps on the ARM. The first number is the Initial Interest Rate Cap Up Percent (i.e., the maximum percentage points the interest rate can adjust upward at the initial rate change date). The second number is the Periodic Interest Rate Cap Up Percent (i.e., the maximum percentage points the interest rate can adjust upward at each interest rate change date after the initial interest rate change date). The third number is the Lifetime Interest Rate Cap Up Percent (i.e., the maximum percentage points that the interest rate can adjust upward over the life of the loan relative to the initial interest rate).
Initial Interest Rate Cap	INITIAL_INTEREST_RATE_CAP	For an adjustable-rate mortgage loan, the maximum percentage points the interest rate can adjust upward at the initial interest rate change date.
Periodic Interest Rate Cap	PERIODIC_INTEREST_RATE_CAP	For an adjustable-rate mortgage loan, the maximum percentage points the interest rate can adjust upward at each interest rate change date after the initial interest rate change date.
Lifetime Interest Rate Cap	LIFETIME_INTEREST_RATE_CAP	For an adjustable-rate mortgage loan, the maximum percentage points that the interest rate can adjust upward over the life of the loan relative to the initial interest rate.
Mortgage Margin	MARGIN	For an adjustable-rate mortgage loan, the rate that is added to the index value to establish the new interest rate (after applying all applicable caps and floors) accruing on the loan at each interest rate change date.
ARM Balloon Indicator	BALLOON_INDICATOR	For an adjustable-rate mortgage loan, a code that denotes if the loan has a balloon feature.
ARM Plan Number	PLAN_NUMBER	For an adjustable-rate mortgage loan, a code identifying the standardized plan under which the mortgage loan was delivered to Fannie Mae. The ARM plan outlines the characteristics of the adjustable-rate mortgage loan, including the ARM Index, the Initial Fixed-Rate Period, the Cap Structure, look-back days, assumability, and the option to convert to a fixed-rate mortgage loan..
Borrower Assistance Plan	FORBEARANCE_INDICATOR	An indicator that denotes the type of assistance plan that the borrower is enrolled in that provides temporary mortgage payment relief or an opportunity for the borrower to cure a mortgage delinquency over a defined period.
High Loan to Value Refinance Option Indicator	HIGH_LOAN_TO_VALUE_HLTV_REFINANCE_OPTION_INDICATOR	An indicator that denotes if an eligible original reference loan is refinanced under Fannie Mae’s HLTV refinance option, which results in such mortgage loan remaining in the Reference Pool, as further defined in each individual CRT document, if applicable.
Deal Name	DEAL_NAME	The title of the series issuance.
Repurchase Make Whole Proceeds Flag	RE_PROCS_FLAG	Indicates if Fannie Mae received proceeds under the terms of its representation and warranty arrangements for the repurchase of the mortgage loan.
Alternative Delinquency Resolution	ADR_TYPE	An indicator that denotes the loss mitigation solution designed to resolve delinquencies and help homeowners remain in their homes in accordance with the servicer’s contractual obligation, while allowing the loan to remain in the security.
Alternative Delinquency Resolution Count	ADR_COUNT	The total number of Alternative Delinquency Resolutions as reported by the servicer for a specific loan.
Total Deferral Amount	ADR_UPB	The total non-interest-bearing deferral amount related to one or more Alternative Delinquency Resolutions.

Disclaimers

The definitions of terms provided under the FM SFLP Template category are the exclusive property of Fannie Mae and/or its licensors. The FM SFLP Template documentation has been converted into online hyperlinked content that is embedded within the Open Risk Manual. There is no guarantee that the conversion is faithful to the original, up-to-date or otherwise fit-for-purpose. When in doubt, consult the documentation and templates provided by the original sources.