Download:
pdf |
pdfFR Y-14M: First Lien Closed-end 1-4 Family Residential Loan
Data Dictionary
Loan Population
•
•
The active loan population includes all loans directly held on the BHC’s portfolio and all loans serviced by the
BHC in that period.
o Portfolio loans are defined as all loans meeting the definition of FR Y-9C, Schedule HC-C, item 1.c.(2)(a)
(first lien closed-end loans secured by 1-4 family residential real estate).
o Serviced loans include those meeting the definition of loans reported in FR Y-9C, Schedule HC-S, Item
1.(column A), Schedule HC-S Item M.2.a, Schedule HC-S, Item M.2.b, and all first lien loans meeting the
definition of loans reported in Schedule HC-S, Item M.2.d.
In addition to loans that are currently active during the reporting period, the following loans should also be
included:
o All inventory that has been transferred to another servicer, but only if transferred during the reporting
month.
o All inventory that was liquidated, but only if liquidated during the reporting month.
Additional Formatting
•
•
•
•
•
•
•
•
The collection includes both loan level and portfolio level variables.
The institutions should provide the loan level data each month in a single text file. This will be a “month-end”
file produced each month and reported no later than thirty (30) calendar days after the end of the reporting
month. This file will contain one record per active loan in the contributor’s inventory.
Institutions should provide a separate text file for the portfolio level variables. This will be a “month-end” file
produced each month and reported no later than thirty (30) calendar days after the end of the reporting month.
This file will contain one record per portfolio segment. Portfolio segments are defined as:
1. Serviced – All serviced loans
2. Portfolio HFI Purchased Impaired – All portfolio loans held for investment and accounted for in
accordance with ASC subtopic 310-30; loans and debt securities acquired with deteriorated credit
quality (formerly AICPA statement of position 03-3, accounting for certain loans or debt securities
acquired in a transfer).
3. Portfolio HFI FVO / HFS – All portfolio loans held for investment measured at fair value under a fair
value option or held for sale.
4. Other Portfolio – All portfolio loans not measured at fair value and not purchase impaired
Options for all fields are comprehensive in identifying a valid value for all loans regardless of status. If a
mandatory field is unknown or unavailable and the field definition does not indicate ‘Unknown’ as a valid field
option, the field should be left NULL and it will be treated as missing data.
Optional and best efforts fields are noted in the instructions in the table below.
No quotation marks should be used as text identifiers.
Please do not provide a header row.
For any field with a format of ‘character’, please provide the code values as listed in the data dictionary. Do not
add a leading or trailing zero or any other character to the data unless specified. It is required that the data
formats and code values as listed in this document be strictly followed.
•
Page 1 of 35
•
Example: A variable listed as Character (2) with a data value of 1 will be made available with a value of 1. It will
not be coded as 01 or or <1space> or any other combination.
•
Inactive inventory that was paid off in one manner or another (servicing transfer, involuntary liquidation or paidin-full by borrower) before the beginning of the reporting month should not be included.
The tables on the following pages give more information the fields that should be contained in each of the files.
•
Page 2 of 35
File Naming Convention:
The standard data files which the Federal Reserve will receive from the data aggregator will follow the following file
naming conventions. BHCs will use this naming convention to send the data files to the data aggregator.
FRY14_FIRSTLIEN_LOANLEVEL___.TXT
FRY14_FIRSTLIEN_PORTFOLIOLEVEL___.TXT
SUBMISSION_NUMBER indicates the file received by the Federal Reserve, and will be populated as a two-digit number
NN (example: for the first submission for a particular period, use 01. If the bank has to resubmit the same file, then use
02 for the next submission, and so on).
In the case of the First Lien, Home Equity, and Address Matching Schedules, the BHCs should provide the data each
month in a single bar‐delimited text file. This is also referred to as a pipe‐delimited text file. Fields should be delimited
with a vertical bar (|, ASCII decimal 124, ASCII hexadecimal 7C).
Example:
Institution A has ID_RSSD equal to 999999. For the First Lien Loan level data file submitted for period 201206, the file
would be named as FRY14_FIRSTLIEN_LOANLEVEL_999999_201206_01.TXT. Any subsequent revised Home Equity Loan
level file submitted by the institution for the same period will be named as
FRY14_FIRSTLIEN_LOANLEVEL_999999_201206_02.TXT, and so on.
Loan Level Table
Field No.
1
Variable Name
Detailed Description
Allowed Values
Format
Loan Number
Loan Number - An identifier for a loan that
will be the same from month to month.
Reference numbers may be used in lieu of
actual loan numbers as long as it meets these
criteria.
A contributor-defined alphanumeric value up to 32
characters.
Character
(32)
This loan identifier must uniquely identify
any loan in the file. It must identify the loan
for its entire life and most be unique (piggybacks should be separated).
If the BHC is already submitting data to the
OCC as part of the OCC Mortgage Metrics
Data or OCC Home Equity Data, it is required
that the BHC use the same loan number for
the FR Y‐14M data schedules.
Please note that the FR Y‐14M data
population may include additional loans,
which may not be part of the OCC data
Page 3 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
YYYYMMDD
YYYYMMDD
YYYYMMDD
YYYYMMDD
Two-letter postal codes for the
state.
Character
(2)
Five-digit, Include leading
zeroes, e.g.: 00901, 10101
Character(5)
e.g., 125000 for $125,000.00
Use banker’s rounding.
Whole
Number
sample, and for such loans the general
requirements listed in the schedule
instructions will be applicable. Overall, the
entire data file sent by a BHC should have
unique loan numbers across the entire
submission.
2
Loan Closing
Date
Loan Closing Date - The date the loan
originally closed.
If the loan closing date is not available, then
the origination date on the loan can be used
instead to populate this field.
This field will be used to determine the loan’s
vintage.
3
4
First Payment
Date
Property State
5
Property ZIP
Code
6
Original Loan
Amount
First Payment Date - The date the borrower
was scheduled to make the first payment on
the loan, or first started making payments on
the loan.
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
Property State - The state in which the
property is located.
Contributors should be careful to provide the
property state (not the billing address state
of the borrower), as the two may differ for
non-Owner Occupied properties.
Property Zip - Five-digit ZIP code. Be sure to
provide the property ZIP code (not the billing
address).
Original Loan Amount - The dollar amount of
the funds disbursed to the borrower at the
time of loan closing.
Amount of loan rounded to the nearest
whole dollar.
Page 4 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
7
Original
Property Value
Original Property Value – The property value
in dollars at the time the loan was originated,
defined as the lesser of selling price or the
appraised value of the property securing the
mortgage at origination.
e.g., 125000 for $125,000.00
Use banker’s rounding.
Whole
Number
Provide as a fraction. E.g.:
0.8 for 80%
1.05 for 105%
Numeric, to
2 decimals.
Please see
"Allowed
Values"
Provide as a fraction. E.g.:
0.8 for 80%
1.05 for 105%
Numeric, to
2 decimals.
Please see
"Allowed
Values"
Income Documentation Coding
1 Full
2 Alt/Low –Lender
3 Alt/Low – Borrower
4 Alt/Low - Unknown
5 Stated – Lender
6 Stated – Borrower
7 Stated – Unknown
Character
(1)
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
8
Original LTV
The original property value reported in the
field should be the value used to calculate
the loans LTV at origination.
Original LTV – The original loan-to-value (LTV)
ratio is the original loan amount divided by
the lesser of the selling price or the appraised
value of the property securing the mortgage
at origination.
Restrict this field to LTV at origination. If
original LTV is not available then leave the
field blank.
9
Original
Combined LTV
Original Combined LTV – The original
combined loan-to-value (CLTV) ratio is the
original first loan amount and any junior liens
at the time of origination divided by the
lesser of the selling price or the appraised
value of the property securing the mortgage
at origination.
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
10
Income
Documentation
Describes how the borrower’s income levels
were documented at time of origination.
• Full – The borrower provided full
verification of income levels via W2, pay
stubs, tax returns, etc.; assets were verified;
and other underwriting criteria were
documented.
• Alt / Low - The mortgages qualified and
underwritten under lender programs
designed without requiring verification of
employment, assets, mortgage/rental history
and/or DTI of the borrower. This
categorization applies to any combination of
the aforementioned limited documentation
Page 5 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Whole Number, e.g.,: 36, 42
Whole
Number
standards, excluding Stated Income
programs.
• Stated - Stated Income includes all
mortgages where the borrower was qualified
for approval based on representation of
income, without direct verification of either
the source or amount of said income by the
lender. Assets were not verified.
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
Note:
The “Alt/Low - Lender” or "Stated - Lender"
categories should be used for those
situations in which the BHC’s automated
underwriting system suggested to a
particular customer a low/no doc or stated
income loan.
“Alt/Low - Borrower” or "Stated - Borrower"
refers to situations in which a borrower
him/herself requested a low/no doc loan or a
broker suggested one.
We do request you sub‐classify. If you do not
know how to sub classify them, report using
the "7 Stated Unknown" option.
11
DTI Ratio--Backend at
Origination
Debt to Income (DTI) - This ratio is the
percent of a borrower’s total monthly debt
payments (including proposed housing
expenses) divided by his or her gross monthly
income, used to determine the mortgage
amount that qualifies a borrower.
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
Back-end DTI ratios give the percentage of
monthly income necessary to cover all of the
borrower’s debt obligations.
Restrict this field to DTI at origination. If
original DTI is not available then leave this
field blank.
Page 6 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
12
DTI Ratio Frontend at
Origination
DTI Ratio (Front-end) at origination – Report
the Front-end DTI (PITI Housing Ratio) at
origination of the mortgage
Whole Number, e.g.,: 36, 42
Whole
Number
The credit score of the
borrower at origination using
the FICO scaling from 300 to
899.
Provide as a whole number,
e.g.:759
Whole
Number
Occupancy Coding
1 = Primary
2 = Second Home
3 = Non Owner / Investment
U = Unknown
Character(1)
1 = Prime
2 = Alt-A
3 = Non-prime
4=Government Owned
Character(1)
Front-end DTI ratios give the percentage of a
borrower’s monthly income that would go
toward housing expenses (mortgage
payment, real estate taxes, homeowner’s
insurance, association dues, etc.)
Restrict this field to DTI at origination. If
original DTI is not available then leave this
field blank.
13
Origination FICO
14
Occupancy
15
Credit Class
FICO Score – original
The credit score of the borrower at
origination using the FICO scaling from 300 to
899.
The statistically calculated credit score of all
borrowers developed by the Fair Isaac
Corporation used to evaluate the
creditworthiness of the borrower. The FICO
score can be based on the credit bureau
service the institution uses as its source.
Original FICO reflects the score upon which
the mortgage underwriting decision was
based.
Restrict this field to FICO at origination. If
original FICO is not available then leave this
field blank.
Report Occupancy related information
available on the mortgage at the time of
origination
Credit Class – Servicer defined Prime, Alt-A
and Non-prime designation.
Please note that this is a servicer defined
field
Note: Many government programs are
constructed outside the conventional market
where these definitions apply. For this
reason, we have added a new code value of
'4' for government loans, since they are
difficult to classify within these definitions.
Although the Credit Class fields in the FR Y14M First Lien and Home Equity schedules
Page 7 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Loan Type Coding
1 = FHA Residential
2 = VA Residential
3 = Conventional without
Private Mortgage Insurance
4 = CRA, House America
5 = FHA Project
6 = Conventional with Private
Mortgage Insurance
7 = HUD 235 Loans
Y = Other
U = Unknown
Character(1)
1 = First lien
2 = Second lien
3 = Third lien or greater
U = Unknown
Character(1)
allow servicer-defined categories of Prime,
Non-Prime and Alt-A mortgages, these
definitions should be consistent across
time periods within a single FR Y-14M
submission and consistent across multiple
FR Y-14M submissions submitted over
time.
16
Loan Type
Indicate the product group (i.e. loan type)
• FHA Residential - Loans insured by the
Federal Housing Administration
• VA Residential - Loans insured by the
Department of Veterans Affairs
• Conventional without Private Mortgage
Insurance - Conventional w/o PMI –
Mortgages with neither government nor
private mortgage insurance
• CRA, House America
•FHA Project
•Conventional with Private Mortgage
Insurance - Conventional with PMI – Nongovernment insured mortgages insured by a
private (non-government) insurer
• HUD 235 Loans
• Other
17
Lien Position at
Origination
• Unknown
Lien Position at Origination – The position of
this loan relative to any additional liens on
the property.
If there are no additional liens, loan is in first
position. If lien position is greater than 3,
then code as 3.
Page 8 of 35
Field No.
18
Variable Name
Detailed Description
Allowed Values
Format
Loan Source
Identifies the source by which the servicer
originated or otherwise acquired the
mortgage. At the servicer's discretion,
acquired servicing may be reported as retail,
broker, or correspondent originations to the
extent the information is available.
1 = Retail (Branch, Internet)
2 = Wholesale
3 = Correspondent
4 = Servicing Rights Purchased
5 = Bulk Purchased
6 = Wealth Management /
Private Banking
U = Unknown
Character(1)
• Retail – Report all mortgages originated
through the reporting institution’s retail,
including branch or internet, production
channel.
• Wholesale (Broker) - Report all mortgages
originated through the reporting institution's
wholesale/broker production channel.
Report as broker originated all third-party
originated loans where the bank cannot
distinguish between broker and
correspondent originated.
• Correspondent - Mortgages acquired
through the reporting institution's
correspondent production channel. This
includes all mortgage whole loans purchased
on a recurring basis (flow) from another
correspondent institution, eligible for
securitization into the secondary markets or
portfolio retention on the bank's balance
sheet. Report as broker originated all thirdparty originated loans when the bank cannot
distinguish between broker and
correspondent originated.
• Bulk Purchase – Pools of mortgage whole
loans purchased from a third party originator
for the right to securitize or retention in the
bank-owned portfolio. Residential Mortgages
acquired for the Servicing Portfolio in this
manner are typically negotiated as one-time
transactions between a Mortgage Institution
and an independent third party originator
(Mortgage Company or Correspondent).
Report all bulk acquisitions and
correspondent flow acquisitions as
correspondent originated when the
institution cannot distinguish between these
categoriesDo not label bank acquisitions as
Bulk Purchases.
• Servicing Rights Purchased - Refers to a
separately negotiated purchase of mortgage
Page 9 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Product Type
1 = Fixed 30
2 = Fixed 20
3 = Fixed 15
4 = ARM 2
5 = ARM 3
6 = ARM 5
7 = ARM 7
8 = ARM 10
9 = ARM Other
10 = Other
Character(2)
servicing rights (PMSR) from a third party.
When the servicer cannot distinguish
between bulk whole loan and bulk servicing
acquisitions, the servicer should report all of
these acquisitions consistently in the
category that represents the majority of the
servicer's acquisitions. Note: This reporting
category applies exclusively to the Servicing
Portfolio.
• Wealth Management/Private Banking –
report all loans originated through a
servicer’s private wealth management or
private banking division.
19
Product Type
Product Type –
Identifies the product type of the mortgage
including the interest type, amortization
term and initial fixed period for hybrid
products.
20
Loan purpose
coding
The purpose for the loan origination
Loan Purpose Coding
1 = Purchase
4 = Rate / Term Refinance
5 = Cash-Out Refinance
6 = Other Refinance
7 = Home Improvement
8 = Debt Consolidation
9 = Education
A = Medical
Y = Other
U = Unknown
Character(1)
21
Number of units
Number of units to the property – Provide
the number of units of the property. If the
actual number of units is not available for
multi-family properties please code this field
with a U.
1 = one unit
2 = two units
3 = three units
4 = four units
U = Unknown
Character(1)
Note: If the property is 1‐4 family and details
Page 10 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
relating to the exact number of units is not
known, use the code value U = Unknown.
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
22
Mortgage
Insurance
Coverage
Percent at
Origination
For loans with loan level mortgage insurance
coverage, provide the mortgage insurance
coverage percent at origination
Provide as a fraction. E.g.:
0.8 for 80%
1.05 for 105%
Numeric, to
2 decimals.
Please see
"Allowed
Values"
23
Property Type
Indicate the type of the property
1 = SFR
2 = Condo
3 = Co-Op
4 = 2-4 Units
5 = Townhouse
6 = PUD
7 = 5+ Units
E = Commercial
F = Mixed Use
M = Manufactured Housing
Z = Other
U = Unknown
Character(1)
24
Balloon Flag
Balloon Flag
Y=Yes
N=No
U=Unknown
Character(1)
Indicate if the mortgage has a balloon
payment.
25
Balloon Term
Balloon Term (In Months) – For mortgages
with a final balloon payment, the term in
months between the loan closing date and
the due date for the final payment before the
note resets (e.g., 84 months for a 7-year
balloon).
Whole Number
Whole
Number
26
Buydown Flag
An indicator to identify loans that are buy
downs
Y=Yes
N=No
U=Unknown
Character(1)
Page 11 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
27
Interest Only at
Origination
Interest Only at Origination Flag - Indicates if
the loan was an IO loan at the time of
origination.
Y=Yes
N=No
U=Unknown
Character(1)
Y=Yes
N=No
P=Portfolio Loan
U=Unknown
Character(1)
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Whole Number
Whole
Number
That is, at origination, was the normal
monthly payment for the loan just interest.
An interest only (IO) mortgage is a
nontraditional mortgage which allows the
borrower to pay only the interest due on the
loan for a specified number of years, and
whose interest rate may fluctuate or be
fixed. After the interest-only period, the rate
may be fixed or fluctuate based on the
prescribed index, with payments including
both principal and interest.
28
Recourse flag
Recourse Flag
Please note that codes 'Y' and 'N' would only
apply to loans not on a bank's portfolio. For
Portfolio loans, please use a code ‘P’ to
indicate portfolio loans.
A “recourse” loan has contractual provisions
that allow the lender in case of default to
pursue legal remedies that are in addition to
the standard repossession of the mortgage
collateral.
29
ARM Initial Rate
Don’t use this flag to merely identify the loan
as being in a recourse state, but only if the
mortgage contract itself is specifically drawn
to allow additional lender recourse.
Initial interest rate on the loan
30
ARM Initial Rate
Period
ARM initial rate adjustment period (In
months)
Identifies the term, in months, from the time
of origination to the first interest rate change
date for ARMs.
Page 12 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
31
ARM Periodic
Interest Reset
Period
ARM Periodic Interest Reset Period (In
Months)
Whole Number
Whole
Number
32
Arm Index
Arm Index – Report the index used as the
basis for determining the monthly interest
rate
07 = COSI - Cost of Savings
Index
10 = Tbill Unknown Type
11 = Tbill 3mo
12 = Tbill 6mo
13 = Tbill 1yr
14 = Tbill 3yr
15 = Tbill 5yr
1Z = Tbill Other
20 = COFI Unknown Type
21 = COFI 11th District
22 = COFI NM
2Z = COFI Other
30 = LIBOR Unknown Type
31 = LIBOR 3mo
32 = LIBOR 6mo
33 = LIBOR 1yr
3Z = LIBOR other
40 = FHLBB Ntl Mtg Rt
50 = Bank Prime Rate
60 = Certificate of Deposit
70 = FNMA/FHLMC
80 = MTA (Moving Treasury
Avg)
81 = LAMA(LIBOR Annual
Moving Avg)
ZZ = Other
UU = Unknown
Character(2)
33
ARM Margin at
Origination
ARM margin
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Identifies the term, in months, from the end
of the initial reset period to the next for the
remaining life of the mortgage.
Represents margin for adjustable rate loans
Report the rate that is added to the index to
determine the monthly interest rate at
origination of the loan.
Page 13 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
34
ARM negative
amortization %
limit
ARM negative amortization % limit.
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
ARM periodic
rate cap
ARM periodic rate cap
Periodic interest rate cap for adjustable rate
loans
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
35
Represents negative amortization limit
expressed as a percent of original loan
amount.
Absolute rate cap (not spread from original)
Only report known valid numerical values in
this field. Leave the fields blank if cap data is
unknown.
36
ARM Periodic
Rate Floor
ARM Periodic Rate Floor
Periodic interest rate floor for adjustable rate
loans
Absolute rate floor (not spread from original)
37
38
39
ARM Lifetime
Rate Cap
Only report known valid numerical values in
this field. Leave the fields blank if floor data
is unknown.
ARM Lifetime Rate Cap
Represents lifetime interest rate for
adjustable rate mortgages. Absolute rate cap
(not spread from original)
ARM Lifetime
Rate Floor
ARM Lifetime Rate Floor
ARM Periodic
Pay Cap
Represents cap on monthly payments for
adjustable rate mortgages
Represents minimum lifetime interest rate
for adjustable rate mortgages. Absolute rate
floor (not spread from original)
Note: The periodic pay cap refers to the
maximum percentage point increase over the
previous payment. So for a $1,000 principal
Page 14 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
and interest (P&I) payment in the previous
month, a 7.5% pay cap implies that the P&I
payment next month cannot exceed $1,075
at the adjustment. Note that the 7.5% pay
cap should be reported as a fraction, in this
case 0.0750.
40
ARM Periodic
Pay Floor
Represents floor on monthly payments for
adjustable rate mortgages
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
41
Option ARM
Flag
Option ARM at Origination - A payment
Option ARM is a nontraditional mortgage
that allows the borrower to choose from a
number of different payment options.
Y=Yes
N=No
Character(1)
Y=Yes
N=No
Character(1)
For example, each month, the borrower may
choose: a minimum payment option based
on a ‘‘start’’ or introductory interest rate, an
interest-only payment option based on the
fully indexed interest rate, or a fully
amortizing principal and interest payment
option based on a 15-year or 30-year loan
term, plus any required escrow payments.
Payments on the minimum payment option
can be less than the interest accruing on the
loan, resulting in negative amortization. The
interest-only option avoids negative
amortization, but does not provide for
principal amortization. After a specified
number of years, or if the loan reaches a
certain negative amortization cap, the
required monthly payment amount is recast
to require payments that will fully amortize
the outstanding balance.
42
Negative
Amortization
Flag
Negative amortization flag - Indicate all
mortgages that have or potentially can have
a feature that allows the borrower to pay an
amount that is less than the interest accruing
on the mortgage, resulting in negative
amortization.
Page 15 of 35
Field No.
43
Variable Name
Detailed Description
Allowed Values
Format
Original Loan
Term
Original Loan Term – The term in months on
the original loan. -
Whole Number
Allowable values: 0 – 600
Whole
Number
Note: Do not change the original loan term in
the case of loan modifications. This field is
intended to capture the loan term at loan
origination.
44
Original Interest
Rate
Original Interest Rate – The annual
percentage rate as specified on the mortgage
note at the time of origination.
Provide as a fraction. E.g.:
0.0575 for 5.75%
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
45
Principal and
Interest (P&I)
Amount at
Origination
Principal and Interest (P&I) Amount at
Origination – Report the scheduled principal
and interest amount at the origination of the
loan.
Whole Number
e.g.,
5123 for $5,122.81
Use banker’s rounding.
Whole
Number
Y=Yes
N=No
U=Unknown
Character(1)
Whole number in months. E.g.,
36 for 36 months (3 years).
Whole
Number
Provider as a whole number,
e.g.:723
Whole
Number
46
Pre-payment
Penalty Flag
47
Pre-Payment
Penalty Term
This field may be provided on a best efforts
basis for loans serviced for others and loans
acquired through mergers and acquisitions.
Pre-payment Penalty Flag - A flag to indicate
if the loan carries a penalty if the borrower
prepays the loan during a specified period of
time.
Pre-Payment Penalty Term (In Months)
The time period from loan origination that a
prepayment penalty applies (if applicable).
This is an origination field and should specify
the time period from origination for which a
prepayment penalty would have applied. It
should not change with the reporting month.
48
Current FICO
FICO/Credit Score – Current
The Current FICO reflects the refreshed score
based on the Fair Isaac calculation. The most
recently determined FICO score of the
borrower.
This field is optional for all loans.
Page 16 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
49
Interest Only in
Reporting
Month
The current value for the IO Flag – indicates if
the loan is currently an IO loan or not.
N = Was not I/O in reporting
month
Y = Was I/O in reporting month
U = Unknown
Character(1)
Investor Type
Identifies the owner of the mortgage
Investor Coding
1 = GNMA
2 = FNMA
3 = FHLMC
4 = Private Securitized
5 = GNMA Buyout Loans
6 = Local Housing Authority
7 = Portfolio
0 = Federal Home Loan Bank
(FHLB)
U = Unknown
Character(1)
e.g., 125000 for $125,000.00
If no servicer advances exist,
please populate as 0.
Whole
Number
50
Identifies whether the minimum mortgage
payment in the reporting month represents
only the interest due on the loan.
• GNMA - Serviced mortgages that are
owned by GNMA
• FNMA - Serviced mortgages that are owned
by FNMA
• FHLMC - Serviced mortgages that are
owned by FHLMC
• Private Securitized - Loans securitized by
private-label (non-Government, non-GSE)
issuers.
• GNMA Buyout Loans-- Loans bought out of
GNMA securities pools
• Local Housing Authority-Loans bought by
LHAs
• Portfolio - Mortgages owned and held on
the bank’s balance sheet. Include both Held
for Sale or Held for Investment in this
category.
• Federal Home Loan Bank (FHLB)-Loans or
securities bought by FHLBs
• Unknown
51
Servicer
Advances
Servicer Advances – Total delinquent
advances made by the servicer on past due
mortgages. Include both corporate (including
maintenance and property preservation
costs) and escrow advances in this amount.
Page 17 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
52
Option ARM in
Reporting
Month
Option ARM in Reporting Month – Identifies
whether a mortgage allows a borrower a
choice of payment options in the reporting
month.
N = Was not Option ARM in the
reporting month
Y = Was Option ARM in the
reporting month
Character(1)
53
Bankruptcy flag
Bankruptcy flag – Flag all loans where the
servicer has been notified of the borrower’s
bankruptcy declaration.
Indicates whether the borrower is in
bankruptcy as of the end of the reporting
month.
N = Not in bankruptcy in
reporting month
Y = In bankruptcy in reporting
month
Character(1)
54
Bankruptcy
Chapter
Bankruptcy Chapter - For all the loans with a
Bankruptcy Flag, indicate the Bankruptcy
Chapter Type.
7 = Chapter 7
9 = Chapter 9
11 = Chapter 11
12 = Chapter 12
13 = Chapter 13
U = Unknown
Character(2)
Note: If the Bankruptcy Flag (Field #53) is
coded with a value of ‘N’, then the
Bankruptcy Chapter (Field #54) should be
blank, i.e. null value. Do not populate this
field with any other value.
55
Next Payment
Due Date
Next payment due date – The due date for
the next outstanding payment on the
mortgage. For delinquent loans this date will
be in the past.
YYYYMMDD
YYYYMMDD
56
Current Interest
Rate
Current Interest Rate – The annual
percentage rate of the mortgage as of the
last day of the reporting month.
Provide as a fraction. E.g.:
0.1075 for 10.75%
57
Remaining Term
Report the remaining term of the loan in
months.
Whole Number
Numeric, up
to 5
decimals.
Please see
"Allowed
Values"
Whole
Number
Note: For the Remaining Term fields in the FR
Y‐14M First Lien and Home Equity schedules,
a value of 0 should be assigned if a loan is
past maturity.
58
Scheduled
principal
balance amount
Report the scheduled principal balance
amount for the borrower
Whole Number
e.g.,
The scheduled principal balance amount
should reflect the balance outstanding based
on the scheduled payment which is due from
the borrower in the reporting month (not the
5123 for $5,122.81
Use banker’s rounding.
Whole
Number
Page 18 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Whole
Number
actual payment made by the borrower).
There will be a difference in the scheduled
versus actual only in cases of delinquency or
curtailments.
59
60
61
Principal and
Interest (P&I)
Amount Current
Principal and Interest (P&I) Amount Current –
Report the scheduled principal and interest
due from the borrower in the reporting
month.
Whole Number
e.g.,
Principal
Balance
Unpaid Principal Balance – The total principal
amount outstanding as of the end of the
month. The UPB should not reflect any
accounting based write-downs and should
only be reduced to zero when the loan has
been liquidated – either paid-in-full, chargedoff, REO sold or Service transferred
Current unpaid balance at end
of the reporting month rounded
to the nearest dollar.
Report the date that the foreclosure sale
occurs on the subject property. This is
typically the end of the foreclosure process,
unless the borrower is in a state that allows
for the right of redemption.
YYYYMMDD
YYYYMMDD
YYYYMMDD
YYYYMMDD
Foreclosure Sale
Date
5123 for $5,122.81
Use banker’s rounding.
Whole
Number
e.g., 32123 for $32,122.81
Use banker’s rounding
Note: If a loan is not in foreclosure, then the
Foreclosure Sale Date field (Field #61),
Foreclosure Referral Date field (Field # 62)
should be blank, i.e. null value. Do not
populate this field with a 0 date value, or
with any other value.
62
Foreclosure
Referral Date
Populate the date for any loan that has
completed foreclosure sale whether or not
the title was acquired by the bank. For the
borrower that is in a state that allows for
right of redemption, you should still report
the appropriate foreclosure sale date on that
loan.
Foreclosure Referral Date – Provide the date
that the mortgage was referred to an
attorney for the purpose of initiating
foreclosure proceedings. This date should
reflect the referral date of currently active
foreclosure process. Loans cured from
foreclosure should not have a referral date.
Note: If a loan is not in foreclosure, then the
Foreclosure Sale Date field (Field #61),
Foreclosure Referral Date field (Field # 62)
should be blank, i.e. null value. Do not
Page 19 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
N = Foreclosure was not
suspended in the reporting
month (also code for loans not
in foreclosure).
Y = Foreclosure was suspended
as of the last day of the
reporting month.
Character(1)
0 = Not Paid-In-Full
1 = Paid-In-Full This Month by
home owner
2 = Foreclosure Completed This
Month
3 = Servicing Transferred This
Month
Character(1)
Allowable Code values 0 = Not in foreclosure
1 = In foreclosure, pre-sale
2 = Post-sale foreclosure,
Redemption, non-REO (if
available, otherwise REO)
3 = REO
Character(1)
populate this field with a 0 date value, or
with any other value.
63
Foreclosure
Suspended
Foreclosure Suspended – Report all loans
where foreclosure activities are being
suspended due to loss mitigation or
bankruptcy proceedings.
Flag indicating an active foreclosure
suspension
Note: The code value for this field should
follow public reporting of this item.
64
Paid-in-full
coding
Indicates whether and how the loan was paid
in full
Provide the method for any loan that was
paid-in-full during the reporting month.
• Paid-in-full this month by home owner –
Code all instances where the loan has been
paid in full by the borrower either through
refinance of the mortgage, sale of the
property or principal payment in full.
• Foreclosure Completed This Month
• Servicing Transfer – Code all instances
where the servicing of the mortgage has
been transferred or sold to another
institution during the reporting month.
65
Foreclosure
Status
Foreclosure Status – Identifies the current
foreclosure status as of the end of the
reporting month.
• In foreclosure, pre-sale – Coded for any
mortgage that has been referred to an
attorney for loss mitigation proceedings but
has not yet gone to foreclosure sale.
• Post-sale Foreclosure – Coded for any loan
where the bank has obtained title at
foreclosure sale, but the property is not yet
actively being marketed. Typically this will
include loans that are in redemption or being
Page 20 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Code values:
0 = None
1 = In Process
2 = Complete & Repurchased
3 = Complete and NO
Repurchase
Character(1)
YYYYMMDD
YYYYMMDD
Do not report where the
refreshed property value was
not obtained within the last
year.
Whole
Number
repaired. If this information is not available,
please code the loan as OREO.
• REO – Coded for any mortgage where the
bank has obtained title at foreclosure sale
and the property is on the market and
available for sale. Also code instances where
the bank has obtained title but the
availability for sale is not known.
66
67
68
Repurchase
Type
Loan Repurchase Type
Repurchase
Request Date
Repurchase Request Date
Refreshed
Property Value
The code value of ‘1: In Process’ means that a
request has been made for repurchase of the
loan by counterparty. Include both loans
where repurchase is being finalized and loans
where agreement to repurchase has not yet
occurred.
Note: The repurchase request date is the
date of repurchase requested by the
counterparty.
Refreshed property value – Provide the most
current property value if updated subsequent
to loan origination. Only provide a refreshed
value when it is based on a property-specific
valuation method (i.e., do not provide a
refreshed property value based solely on
applying a broad valuation index to all
properties in geographic area.)
The refreshed LTV refers to the servicer
periodically updating the estimate of value to
recalculate loan-to-value using the current
loan balance.
The Refreshed Property Value, Refreshed
Property Valuation Method, and Most Recent
Property Valuation Date fields refer to the
same refreshed property valuation instance.
If the property has been valued subsequent
to origination, please provide the most
recent property valuation date, the valuation
method, and the property value.
Page 21 of 35
Field No.
69
Variable Name
Detailed Description
Allowed Values
Format
Refreshed
Property
Valuation
Method
The valuation method for any refreshed
values. Identifies the method by which the
value of the property was determined.
Options are:
Code Values:
1 = Full Appraisal
2 = Limited Appraisal
3 = Broker Price Opinion
4 = Desktop Valuation
5 = Automated Valuation Model
6 = Unknown
7 = TAV – Tax Assessed Value
Character(1)
YYYYMMDD
YYYYMMDD
Provide as a fraction. E.g.:
0.85 for 85%
Numeric, up
to 2
decimals.
Please see
"Allowed
Values"
• Full appraisal – Prepared by a certified
appraiser
• Limited appraisal – Prepared by a certified
appraiser
• Broker Price Opinion “BPO” – Prepared by
a real estate broker or agent
• Desktop Valuation – Prepared by bank
employee
• Automated Valuation Model “AVM”
The Refreshed Property Value, Refreshed
Property Valuation Method, and Most Recent
Property Valuation Date fields refer to the
same refreshed property valuation instance.
If the property has been valued subsequent
to origination, please provide the most
recent property valuation date, the valuation
method, and the property value.
70
71
Most Recent
Property
Valuation Date
The date on which the most recent refreshed
property value was obtained.
Refreshed CLTV
After
Modification
Refreshed CLTV After Modification – Report
the calculated combined loan-to-value ratio
after the modification.
The Refreshed Property Value, Refreshed
Property Valuation Method, and
Most Recent Property Valuation Date fields
refer to the same refreshed
property valuation instance. If the property
has been valued subsequent to
origination, please provide the most recent
property valuation date, the
valuation method, and the property value.
Note: The Refreshed CLTV After Modification
field (Field #71) on the FR Y‐14M First
Lien schedule is only applicable for loans that
have been modified. Only provide this field
for loans that have been modified.
Page 22 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Whole Number
Whole
Number
Whole Number
Whole
Number
0 = Loan has not been modified
6 = ASF Streamline
8 = FHFA Streamline (Specific to
program announced 12/15/08)
9 = FDIC Streamline (“Mod in a
Box”)
10 = Proprietary Systematic
Program
11 = Proprietary Other
12 = Home Affordable
Modification
Numeric
Provide the CLTV that was used to evaluate
and approve the modification.
This could be done during the modification
process or soon afterward. Do not
continue to update it.
72
73
74
Refreshed DTI
Ratio (Back-end)
Refreshed DTI
Ratio (Frontend)
Modification
Type
Include all outstanding liens in the calculation
of refreshed CLTV. If the property only has
one lien outstanding at the time of
modification, then this field would be
equivalent to refreshed LTV.
Refreshed DTI Ratio (Back-end) – Report the
refreshed Back -end DTI Ratio.
Back-end DTI ratios give the percentage of
monthly income necessary to cover all of the
borrower’s debt obligations.
Refreshed DTI Ratio (Front-end) – Report the
refreshed Front-end DTI (PITI Housing Ratio).
Front-end DTI ratios give the percentage of a
borrower’s monthly income that would go
toward housing expenses (mortgage
payment, real estate taxes, homeowner’s
insurance, association dues, etc.)
Modification Type – This field should be
populated for any loan that is currently
operating under modified terms and
identifies the specific terms that were altered
through loss mitigation efforts.
This field is independent of investor and
speaks only to the nature of the program. For
example a FNMA loan may be modified
under either a FDIC or proprietary
modification program – in these cases this
field would be populated with either the FDIC
or proprietary codes while the Investor field
would identify the modification as being
performed on a FNMA loan.
• Loan has not been modified.
• ASF Streamline - Report all loan
modifications in conformance with the ASF's
December 6, 2007 “Streamlined Foreclosure
and Loss Avoidance Framework for
Securitized Subprime Adjustable Rate
Mortgage Loans.”
• FHFA Streamline – Report all loan
Page 23 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
YYYYMMDD
Do not populate for loans that
have not been modified.
YYYYMMDD
modifications pursuant to the FHFA
streamline modification program that
became effective 12/15/08. FHFA investor
loans modified under an alternative plan
should be coded in accordance with those
plans.
• FDIC Streamline (“Mod in a Box”) – Report
all loan modifications that include any third
party investor and/or proprietary
systematical modifications that are patterned
on the FDIC program.
• Proprietary Systematic Program – Report all
other proprietary systematic programs target
at applicable segments of mortgage
borrowers. The “proprietary” nature of this
field references the modification program
and not the investor, any loan modified
under a proprietary systematic program
should receive this code regardless of
investor.
• Proprietary Other – Report any
modification type not covered by the
previous categories. As with the proprietary
systematic modifications, this field is
independent of the investor.
• Home Affordable Modification Program –
Report any loans modified under the Home
Affordable Modification Program Guidelines
released March 4, 2009. Do not report the
transaction as a modified loan until
successful completion of the stipulated trial
plan.
75
Last Modified
Date
Last Modified Date – Provide the date on
which the loan terms were most recently
modified
Page 24 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
76
Active
Repayment Plan
Flag
Active Repayment Plan Flag – Code as "Y" all
loans that are active and performing
according to the terms of a repayment plan
as of the end of the reporting month. Do not
code as active any loan currently operating
under a stip-to-mod plan where the loan is
scheduled to be modified if the terms of the
stipulated repayment plan are met.
N = No repayment plan is in
effect in the reporting month.
Y = The loan is actively
performing under a repayment
plan.
Character(1)
0 = No workout completed or
unsuccessful resolution of a loss
mitigation effort.
1 = Modification
2 = Repayment Plan
3 = Deed in Lieu
4 = Short Sale
5 = FHA Partial Claim
6 = FHA Secured
7 = VA Refund
8 = Stipulated Repayment /
Stip-to-Mods
9 = Forbearance plan
10 = MI Claim Advance
11 = FHA Refinances - Other
12 = Other
13 =
Reaged/Deferred/Extended
14 = Home Affordable
Refinance
15 = FNMA HomeSaver
Forbearance, Payment
Reduction Plan, or other GSEsponsored forbearance
program.
Numeric
A loan is “performing” for the purposes of
this field if the borrower is meeting the terms
of the repayment plan in the reporting
month.
A “repayment plan” would encompass any
kind of workout arrangement made with the
borrower, not just a loan modification.
77
Workout Type
Completed
The type of loss mitigation workout. Only
coded for loans that successfully completed
the loss mitigation workout in the current
month.
Workout Type Completed – This field should
be coded for any loan where a loss mitigation
effort has been successfully completed in the
current month. Successful completion is
defined as the closing of loss mitigation
activities where the borrower has no
remaining delinquent obligations to the
servicer. The field should be coded in only
the reporting month when the workout type
was completed and not in subsequent
months.
Specific coding instructions follow:
• Code 1 Modification - Populate in the
month that the modification is completed
and the new loan terms are in effect. Do not
include modifications, such as those
performed under the Home Affordable
program that were completed following a
trial or stipulated repayment period – these
should receive a value of 8 (see below).
• Code 2 Repayment Plan - Populate in the
month that the repayment plan was
completed successfully and the borrower has
been returned to a current and performing
Page 25 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
status.
• Codes 3 and 4 – Deeds In Lieu and Short
Sales – Populate in the month the loan is
liquidated through a deed in lieu, short sale
(or payoff) negotiated settlement.
• Code 6, 11, 14 – FHA and Home Affordable
Refinances – Populate these fields in the
month that the loan was liquidated under an
FHA or Home Affordable refinance program.
This field should be coded in the same month
the loan has a Voluntary Payoff / Refinance.
• Code 8 – Stipulated Repayment / Stip to
Mods – Code this field in the month that a
loan is modified after having completed a
stipulated or trial payment period. This
should include loans modified under the
Home Affordable Modification program.
• Code 13 – Reaged/Deferred/Extended –
include loans where there has been an
agreement with the borrower to defer
principal and interest but with no other
terms to enhance affordability.
• Code 15 – FNMA HomeSaver Forbearance,
Payment Reduction Plan, or other GSEsponsored forbearance program - Include
loans that have made the initial payment in
the FNMA HomeSaver Forbearance program
or similar program.
Note: The Field Workout Type Completed
should only be coded for any loan where a
loss mitigation effort has been successfully
completed in the current month. Code value
of 0 should be entered only in the case where
no workout is completed or there is an
unsuccessful resolution of a loss mitigation
effort.
Do not enter a code value of 0 if loss
mitigation efforts are ongoing but not
completely resolved. For the cases where
loss mitigation efforts are ongoing but not
completely resolved, this field should be left
blank. Also, if a loan has never been in loss
mitigation, the value should be left blank.
Page 26 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
78
Repayment Plan
Performance
Status
Repayment Plan Performance Status – This
field tracks the performance of repayment
and stip-to-mod plans. If a repayment plan or
stip-to-mod was completed successfully
during the month it should be coded as such
in the work-out type completed field), this
field is only to be populated for repayment
plans that were active as of the end of the
month or broken during the month. Broken
plans should only be reported in the month
the plan breaks.
0 = No active plan as of monthend and did not have a plan
broken or cancelled during the
month.
1 = Stip to Mod Active
2 = Stip to Mod Broken
3 = Repayment Plan Active
4 = Repayment Plan Broken
5 = Repayment Plan Cancelled
by Servicer
6 = Repayment Plan Cancelled
at borrower’s request
7 = Home Affordable Trial
Period Active
8 = Home Affordable Trial
Period Broken
9 = Home Affordable Trial
Cancellation
10 = Home Affordable Trial
Extended / Mod Pending
Numeric
• Stip-to-Mod Active – The borrower is
performing as scheduled on a stipulated
repayment agreement that, if successful will
result in a modification.
• Stip-to-Mod Broken – The borrower has
broken the terms specified by a stip-to-mod
agreement and the modification was not
executed.
• Repayment Plan Active – The borrower is
performing as scheduled according to the
terms of an executed repayment plan.
• Repayment Plan Broken – The borrower
has defaulted on the terms of an executed
repayment plan during the month.
• Repayment Plan Cancelled by Servicer –
The borrower was on a repayment plan that
was cancelled by the mortgage servicer
during the month.
• Repayment Plan Cancelled at Borrower’s
Request – The borrower was on a repayment
plan that was cancelled at their request
during the month.
• Home Affordable Modification Trial Period
Active – Report all Home Affordable program
pre-modifications that are performing as
scheduled under a trial period plan and the
plan is not broken.
• Home Affordable Modification Trial Period
Broken – Report all Home Affordable
program pre-modifications where the
borrower has not complied with the terms of
the schedule such that the modification will
Page 27 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Y=Yes
N=No
Character(1)
not be executed.
• Home Affordable Trial Cancellation – The
Home Affordable Trial was cancelled due to
borrower ineligibility or other reason.
• Home Affordable Trial Extended / Mod
Pending – All payments made as agreed and
performing but awaiting documentation
and/or a final underwriting decision.
Note: Only report a broken plan in the month
it was broken, not in subsequent months. In
subsequent months, leave it blank.
79
“Home
Affordable
Refinance”
Program Flag
Identifies if a loan was originated under the
Home Affordable Refinance program.
80
“Home
Affordable
Refinance”
Program loan id
“Home Affordable Refinance” Program loan
id - Identify the loan id all loans originated as
part of the Home Affordable Refinance
Program announced March 4, 2009. Use the
exact same loan id and format provided in
the HAMP data sent to the data aggregator.
Use the exact same loan id and
format provided in the HAMP
data sent to the data
aggregator
81
Capitalization
Capitalization – Report whether a delinquent
amount (PITI or fees) were capitalized and
added to the outstanding principal balance.
Y=Yes
N=No
“Home Affordable Refinance” Program Flag Identify all loans originated as part of the
Home Affordable Refinance Program
announced March 4, 2009. Loans should be
flagged as such regardless of whether the
loan was serviced in-house prior to refinance.
Character(1)
Capitalization – Capitalization is defined as
instances where accrued and/or deferred
principal, interest, servicing advances,
expenses, fees, etc. are capitalized into the
unpaid principal balance of the modified
loan. If accrued and/or deferred principal,
interest, servicing advances, expenses, fees,
etc. are capitalized into the unpaid principal
balance during modification this field should
be “Y” otherwise it should be “N”.
This field should only be populated for loans
Page 28 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
Whole Number
e.g.,
5123 for $5,122.81
Use banker’s rounding.
Whole
Number
Whole Number
Whole
Number
Y=Yes
N=No
Character(1)
with a value in Field #74 Modification Type
indicating that a loan has been modified.
82
Delinquent
Amount
Capitalized
Delinquent Amount Capitalized – Report the
total amount in dollars of the delinquent
amount that was capitalized and added to
the principal balance through loss mitigation.
If the loan hasn’t been modified, this field
should be left blank.
83
Duration of
Modification
Duration of Modification – Report the
number of months the modified terms will be
in effect.
If the loan hasn’t been modified, this field
should be left blank.
84
Step
Modification
Flag
Step Modification Flag – Report whether a
rate modification has a “stepped” or gradual
return to non-modified rate.
If the loan hasn’t been modified, this field
should be left blank.
Page 29 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
85
Loss Mitigation
Performance
Status
Loss Mitigation Performance Status –
Identifies whether a loan is being actively
handled by the servicer’s loss mitigation
department. Refers to all loans where the
servicer has initiated loss mitigation
procedures whether or not a particular
course of action or workout type has been
executed.
0 = No loss mitigation action in
place.
1 = Active and Performing
2 = Active and Non-performing
3 = Broken
Character(1)
Y=Yes
N=No
Character(1)
• Active and performing – Refers to any
mortgage that is currently in loss mitigation
and is performing to the terms of a selected
plan.
• Active and Non-performing – Refers to
instances where a servicer is actively
pursuing loss mitigation with a borrower who
is not currently making all payments on the
mortgage.
• Broken – Populated for situations where
the borrower has defaulted on the terms of
loss mitigation plan and the servicer has
removed the loan from loss mitigation and is
proceeding with the default process.
Note: If loss mitigation efforts have been
initiated but no plan has been executed as of
the month‐end, the Loss Mitigation
Performance Status should be coded as 2:
Active and Non‐Performing.
If a loan is not in loss mitigation, then it
should be coded as 0: No loss mitigation
action in place and should not be left blank.
86
Principal
Deferred
Principal Deferred – Report whether a loan
had principal deferred through loss
mitigation.
This field should only be populated for loans
with a value in Field #74 Modification Type
indicating that a loan has been modified.
Page 30 of 35
Field No.
87
Variable Name
Detailed Description
Allowed Values
Format
Principal
Deferred
Amount
Principal Deferred Amount: Report the total
amount in dollars of the principal that was
deferred through loss mitigation.
Whole Number
e.g.,
5123 for $5,122.81
Use banker’s rounding.
Whole
Number
Y=Yes
N=No
Character(1)
Whole Number
e.g.,
5123 for $5,122.81
Use banker’s rounding.
Whole
Number
1 = Full Appraisal
2 = Limited Appraisal
3 = Broker Price Opinion
4 = Desktop Valuation
5 = Automated Valuation Model
6 = Unknown
Character(1)
This field should only be populated for loans
with a value in Field #74 Modification Type
indicating that a loan has been modified.
Note: In cases where the principal deferral is
monthly, they should be reported as
aggregated. Principal deferrals are generally
done at once. Only the amount of principal
that is deferred should be reported. Report
the aggregate amount of deferred principal
provided over the life of the loan assuming
that the borrower performs as agreed.
88
Principal Writedown
Principal Write-down – Report whether
principal was forgiven through loss
mitigation.
This field should only be populated for loans
with a value in Field #74 Modification Type
indicating that a loan has been modified.
89
Principal WriteDown Amount
Principal Write-Down Amount– Report the
principal write-down amount for the loans
where the principal was forgiven through loss
mitigation.
This field should only be populated for loans
with a value in Field #74 Modification Type
indicating that a loan has been modified
Note: Report the aggregate amount of
principal write-down provided over the life of
the loan assuming that the borrower
performs as agreed. Performance incentive
payments offered to all borrowers should not
be included as principal write-downs (i.e., the
annual HAMP forgiveness payments should
not be flagged as principal reductions).
90
Property
Valuation
Method at
Modification
Property Valuation Method at Modification –
Report the method used to determine the
property value prior to loan modification.
• Full appraisal – Prepared by a certified
appraiser
Page 31 of 35
Field No.
Variable Name
Detailed Description
Allowed Values
Format
0 = Not converted to Fixed Rate
1 = Converted to Fixed Rate for
1-36 Months
2 = Converted to Fixed Rate for
37-60 Months
3 = Converted to Fixed Rate for
61-120 Months
4 = Converted to Fixed Rate for
Greater than 120 Months
Character(1)
• Limited appraisal – Prepared by a certified
appraiser
• Broker Price Opinion “BPO” – Prepared by a
real estate broker or agent
• Desktop Valuation – Prepared by bank
employee
• Automated Valuation Model “AVM”
This field should only be populated for loans
with a value in Field #74 Modification Type
indicating that a loan has been modified
91
Interest Type
Conversion
Duration
Indicates whether the interest type was
converted from ARM to Fixed through loss
mitigation, and the duration of the fixed rate
period.
This field should only be populated for loans
with a value in Field #74 Modification Type
indicating that a loan has been modified
92
SOP 03-3 Status
SOP-03-03 - Identify any loans that are
accounted for under SOP-03-03 purchase
accounting. If the loan is accounted for
under SOP-03-03 purchase accounting this
field should be “Y” otherwise it should be
“N”. Note: None of the records should
contain a NULL.
N = No
Y = Yes
Character(1)
93
Total Debt at
Time of REO
Total Debt is comprised of:
Whole Number
e.g.,
2123 for $2,122.81
Use banker’s rounding.
Whole
Number
1) Unpaid Principal Balance;
2)Interest pass through Amount (interest
paid to the Investor to purchase loan out of
pool or any prior years interest charged off at
non-accrual status);
3) Total Corporate Advance (incl. Property
Preservation and Attorney’s fees);
4) Total Escrow Advance (taxes and insurance
paid)
Page 32 of 35
Field No.
94
Variable Name
Detailed Description
Allowed Values
Format
Net Recovery
Amount
Sales price net of costs of sales (e.g., sales
commissions and buyer concessions)
Whole Number
e.g.,
2123 for $2,122.81
Use banker’s rounding.
Whole
Number
Whole Number
e.g.,
2123 for $2,122.81
Use banker’s rounding.
Whole
Number
Y=Yes
N=No
Character(1)
Report net recoveries on loans that
terminate in the month the loan becomes
inactive. Examples are short sales or other
instances in which the sale takes place in the
same month as the foreclosure sale. “Costs
of sale” shoulde include all costs incurred
disposing of the property including
commissions, taxes, insurance payments, and
general closing costs.
95
Credit enhanced
amount
Total amount of credit enhancement
received that offset the loss. Could come
from mortgage insurance proceeds, pool
arrangements in deals, or other features of
securities structures.
Report credit enhancements received in a
month in which the loan is active or the
month in which the loan becomes inactive.
REO is not to be included as part of the
submission.
Credit enhancements should be taken to
include loan-level mortgage insurance and
pool-level or security-level coverage, not
hazard insurance.
96
Has Had
Troubled Debt
Restructure
Troubled Debt Restructure – A flag
designating whether a loan was modified as a
Troubled Debt Restructuring (TDR). All TDRs
must be evaluated for impairment under
Statement of Financial Accounting Standards
No. 114 (Accounting by Creditors for
Impairment of a Loan), as part of the
Allowance for Loan and Lease Losses analysis.
Page 33 of 35
Field No.
97
Variable Name
Detailed Description
Allowed Values
Format
Reported as
Bank Owned
Flag
Reported as Bank-Owned Flag – Indicates
whether the serviced for others loan is
recorded on the bank's own balance sheet
for accounting purposes. Applies only to
loans with an Investor Code other than
"Portfolio". Should be coded as Y for the
following loans:
Y=Yes
N=No
Character(1)
• GNMA Eligible Repurchases – In accordance
with FAS 140, GNMA loans that are subject to
Removal of Accounts Provisions (ROAPs) and
eligible for repurchase.
• Other Loans Reported On-Balance Sheet
under FAS 140 – To reflect bank-supported
securitizations and/or other
indemnifications.
Page 34 of 35
Portfolio Level Table
Field No.
Variable Name
Detailed Description
Allowed Values
Format
1
Portfolio
Segment ID
Identification of which portfolio segment is
being reported.
1 = Serviced
2 = Portfolio HFI Purchased
Impaired
3 = Portfolio HFI FVO / HFS
4 = Other Portfolio
Character(1)
2
Principal
Balance
Unpaid Principal Balance – The total principal
amount outstanding as of the end of the
month for the portfolio segment. The UPB
should not reflect any accounting based
write-downs and should only be reduced to
zero when the loan has been liquidated –
either paid-in-full, charged-off, REO sold or
Service transferred
Current unpaid balance at end
of the reporting month.
Whole
Number
Loss / Write-down Amount – For all active
loans, report all cumulative lifetime writedowns and reversals of loan principal and
interest recorded as charge-offs against the
Allowance for Loan and Leases Losses (ALLL)
pursuant to FFIEC Call Report instructions.
Also include all reversals of accrued but not
collected interest, not directly changed
against the ALLL.
Cumulative lifetime loss or
principal write-down on loans in
the portfolio segment for all
active loans in that segment.
3
Loss / Writedown Amount
Report in millions of dollars.
Whole
Number
Principal Write downs and
Losses should be expressed as
positive numbers.
Report in millions of dollars.
Page 35 of 35
| File Type | application/pdf |
| Author | c1vrn02 |
| File Modified | 2012-09-28 |
| File Created | 2012-09-28 |