FM SFLP Template

From Open Risk Manual

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.[1]

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.

References