Loss Mitigation Loan Level Data Collection - Home Equity

Field
No.

Field Name

OCC
(Y/N)

Description

Allowable Values

1

Loan Number

Y

An identifier for
this loan that will
be the same from
month to month. It
must identify the
loan for its entire
life and must be
unique (piggybacks should be
separated)

A contributor-defined alpha-numeric value up
to 32 characters.

2

Lien Position At
Origination

Y

1st, 2nd, 3rd

3

Loan / Line
Owner

Y

The investor in the
loan.

1
2
3
1
2
3
4

4

Home Equity
Type

Y

Loan vs. Line

1 Home Equity Loan
2 Home Equity Line of Credit
3 Other

5

Interest Type
at Origination

Y

Fixed, Variable.

1 Fixed
2 Variable

6

Interest Type
in current
month

Y

Fixed, Variable

1 Fixed
2 Variable

7

Loan Closing
Date

Y

The date the loan
originally closed.
Will use this date
to determine the
loan’s vintage.

mm/dd/yyyy

First Lien
Second Lien
Third Lien
Securitized
Portfolio
Serviced For Others
Other

Fidelity
Screen
Name

INV1

OCC Loan-Level Data Collection

Field
No.
8

Field Name
Original Loan
/ Line Amount

OCC
(Y/N)
Y

Description
Amount of loan or
Credit Line at
Origination
rounded to the
nearest whole
dollar

Allowable Values

Fidelity
Screen
Name

e.g, 125000 for $125,000.00

For Lines of Credit
this should be
original line
amount, NOT
original draw.
9

Current Credit
Line Amount

Y

Dollar amount of
the Credit Line in
the reporting
month.

e.g, 125000 for $125,000.00

10

Unpaid
Principal
Balance
(Gross)

Y

Current gross
unpaid balance at
end of the
reporting month
rounded to the
nearest dollar.

e.g, 125000 for $125,000.00

11

Original
Interest Rate

Y

Interest rate at
origination

Provide as a decimal. E.g.:
0.0575 for 5.75%
0.06125 for 6.125%

12

Current
Interest Rate

Y

Interest rate in the
reporting month

Provide as a decimal. E.g.:
0.1075 for 10.75%

MAS1/
COL2

0.06125 for 6.125%

February 13th 2013

Page 1

OCC Loan-Level Data Collection

Field
No.
13

14

15

16

Field Name
Original
Combined LTV

Current
Combined LTV

Original FICO

Current FICO

February 13th 2013

OCC
(Y/N)
Y

Y

Y

Y

Description

Allowable Values

The committed
loan amount
(considering all
senior liens and
the subject loan)
divided by the
property value at
the time of the HE
origination.

Provide as a decimal. E.g.:

The current
combined LTV
includes the
updated loan-tovalue using the
current
commitment of the
HE loan or line. If
the bank has not
refreshed the
value since loan
origination, then
use the origination
value.

Provide as a decimal. E.g.:

The credit score of
the borrower at
origination using
the FICO scaling
from 300 to 899.
Report the score
on which the
underwriting
decision was
based.

Provide as a whole number, e.g.:

The most recently
determined FICO
score of the
borrower.

Provider as a whole number, e.g.:

Fidelity
Screen
Name

0.8 for 80%
1.05 for 105%
Please populate with NULL if unavailable

0.511 for 51.1%
Please populate with NULL if unavailable

759

723

Page 2

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

Description

Allowable Values

17

Interest Only
at Origination

Y

Indicates whether
the loan required
interest only at
origination. That is,
at origination, was
the minimum
monthly payment
for the loan just
interest.

N Was not I/O in reporting
month
Y Was I/O in reporting
month

18

Interest Only
in Reporting
Month

Y

Indicates whether
the loan required
interest only for
the reporting
month. That is, at
end-of-month for
the reporting
month, was the
minimum monthly
payment for the
loan just interest.

N Was not I/O in reporting
month
Y Was I/O in reporting
month

19

Income
Documentation

Y

Whether income
was verified. How
borrower income
was documented
at origination.

1
2
3
4
5

Verified
Stated – Lender
Stated – Borrower
Stated – Unknown
Unknown

20

Asset
Documentation

1
2
3
4
5
6
7
8

Full / Verified
Alt / Low – Lender
Alt / Low – Borrower
Alt / Low – Unknown
Stated – Lender
Stated – Borrower
Stated – Unknown
Unknown / NotApplicable

February 13th 2013

How borrower
asset levels were
documented at
origination.

Fidelity
Screen
Name

Page 3

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

21

Property State

Y

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).

Two-letter postal codes for the state.

22

Property ZIP
code

Y

Nine-digit ZIP
code of the
property or fivedigit ZIP code if
nine-digit is not
available. Please
be sure to provide
the property ZIP
code (not the
billing address).

Five-digit or nine-digit number. Include
leading zeroes, e.g.:

The current
foreclosure status
in the reporting
month.

0 Not in foreclosure
(including cured from
foreclosure)
1 In foreclosure
2 Post-sale / REO

23

Foreclosure
status

February 13th 2013

Y

Description

Allowable Values

Fidelity
Screen
Name

00901
10101

FOR1

Page 4

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

Description

Allowable Values

24

Foreclosure
Referral Date

Y

mm/dd/yyyy
If the property
securing the loan is
currently in
foreclosure or
REO, supply the
referral date for
the current
foreclosure
proceedings. If the
loan is not in
foreclosure
(whether cured or
never in
foreclosure) this
field should be
blank.

25

Liquidation
Status

Y

Whether and how
a loan was paidin-full.

0 Not paid-in-full
1 Voluntary payoff
2 Involuntary liquidation
(see definitions for
details)
3 Servicing transfer

26

Foreclosure
Sale Date

Y

The date of the
foreclosure
(sheriff’s) sale for
loans in
foreclosure. If the
loan’s foreclosure
status (field 23) is
0, this should be
blank.

mm/dd/yyyy

February 13th 2013

Fidelity
Screen
Name
FOR3

FOR3

Page 5

OCC Loan-Level Data Collection

Field
No.
27

Field Name
Workout Type
Completed /
Executed

OCC
(Y/N)
Y

Description
The type of loss
mitigation activity.
Please see the
definitions
document for full
instructions on how
to populate this
field.

Allowable Values
0
1
2
3
4
5
6
7
8

No Workout
Plan Performed
Modification
Payment Plan
Deed in Lieu
Short Sale
Stipulated
Repayment /
stip to mod
Do not Use
Settlement
Other

28

Next Payment
Due Date

Y

The due date of
the next payment.
This is not the next
billing date, but
when the next
payment is due. It
will be in the past
for delinquent
loans.

mm/dd/yyyy

29

Bankruptcy
Flag

Y

Whether the
borrower is in
bankruptcy as of
the end of the
reporting month.

0 Not in bankruptcy in
reporting month
1 In bankruptcy in
reporting month

30

Reason for
Default

Y

What was the
reason the loan
defaulted.

0
1
2
3
4
5
6

February 13th 2013

Fidelity
Screen
Name
LMT1

Has Not Defaulted
Excessive obligations
Death
Unemployment
Other
Medical
Reduction of Income

Page 6

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

Description

Allowable Values

31

Loan Source

Y

The source of the
loan origination

1
2
3
4

32

Owner
Occupancy
Flag

Y

The occupancy
status at
origination

1 Owner Occupied
2 Non-Owner Occupied

33

Notice of
Default
(Breach Letter)

Y

Identification that
bank has issued a
formal notice of
default, breach
letter or similar
communication,
notifying borrower
that loan is in
default (don’t
include payment
reminder letters)

mm/dd/yyyy

34

Third Party
Sale Flag

Y

Identification of
Third Party Sales
at time of
Foreclosure Sale

Retail (Branch, Internet)
Wholesale
Correspondent
Servicing Rights
Purchased
5 Bulk Purchased
6 Wealth Management /
Private Banking

0

1

The property was not
sold to a third party
(also code zero loans
not in foreclosure)
The property was sold
to a third party at
foreclosure sale

35

Credit Class

Y

Prime, Subprime,
Alt-A Designation
(Servicer defined
values)

1 Prime
2 Alt-A
3 Non-prime

36

Property Type

Y

Number of units

Whole number. If the number of specific
units is not identifiable for multi-family
properties please code as 9.

February 13th 2013

Fidelity
Screen
Name

PL05

FOR3

Page 7

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

Description

Modification
Type

Y

38

Original Loan
Term

Y

Original Term in
1 – 600
Months. The
Original Term for
‘Evergreen’ HELOCs, or lines with no end of
a HELOC should
draw, should be reported as 999.
include both the
draw period and
the amortized
repayment period.

39

Loss /
Writedown
Amount

Y

Home Equity credit e.g, 125000 for $125,000.00
related losses and
Principal Writedowns and Losses should be
principal write
expressed as positive numbers.
downs incurred
during the month,
including all writeoffs of principal,
interest,
receivables, or
accruals that are
deemed
uncollectible.

40

Loss /
Writedown
Date

Y

Date on which the
loss or writedown
was incurred.

mm/dd/yyyy

41

Debt To
Income

Y

DTI (Back-end) At
Origination

Whole Number

37

February 13th 2013

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.

Allowable Values
0

Not Modified

7
8
9
10

2MP
Proprietary Systematic
Proprietary Other
HAMP

Fidelity
Screen
Name

Page 8

OCC Loan-Level Data Collection

Field
No.
42

Field Name
Foreclosure
Suspended

OCC
(Y/N)
Y

Description
Flag indicating an
active foreclosure
suspension

Allowable Values

Fidelity
Screen
Name

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.

43

Last Modified
Date

Y

Date of most
recent
Modification

mm/dd/yyyy

Report for all
loans with a value
in Field 37.
44

Troubled Debt
Restructure

Y

Date the loan was
classified as a TDR
by the bank.

45

1st Mortgage
Serviced in
House

Y

Junior Lien where
the Bank services
the First
Mortgage. Leave
NULL for any first
lien home equities.

Draw Period

Y

46

47

Settlement
Negotiated
Amount

February 13th 2013

Y

Draw period
expressed in
months

mm/dd/yyyy

N
Y

No the first mortgage
is not serviced in house
Yes, the first mortgage
is serviced in house.

1 - 360
‘Evergreen’ HELOCs, or lines with no end of
draw, should be reported as 999.

The settlement
e.g, 125000 for $125,000.00
amount (portion of
the outstanding
UPB) agreed to be
paid by the
customer

Page 9

OCC Loan-Level Data Collection

Field
No.
48

Field Name
Credit Line
Frozen Flag

OCC
(Y/N)
Y

Description
Flag to indicate
line of credit
frozen in the
reporting month.

Allowable Values
N
Y

No the line of credit
was not frozen
Yes the line of credit
was frozen in the
reporting month

49

Locked Amount
– Amortizing LOC

Y

Amount of credit
line that has been
locked and is now
amortizing.

e.g, 125000 for $125,000.00

50

Locked Amount
– Interest Only
– LOC

Y

Amount of credit
line that has been
locked. (Interest
Only)

e.g, 125000 for $125,000.00

51

Last Draw
Date

Y

Date of Last Draw
against a Line of
Credit

mm/dd/yyyy

52

Re-modified
Flag

Y

Flag any loan that
has been modified
more than once in
the last 24 months.

53

Repayment
Plan Start
Date

Y

Date repayment
plan was entered
into.

mm/dd/yyyy

54

Minimum
Payment
Amount

Y

Minimum payment
due in the
reporting month.

e.g, 1000 for $1,000.00

55

Actual
Payment
Amount

Y

Actual dollar
amount of
payment received
during the
reporting month.

e.g, 1000 for $1,000.00

56

Lockout
Feature Flag

Y

Lines of credit that
have a lockout
feature

February 13th 2013

N
Y

N
Y

Fidelity
Screen
Name

No
Yes

No
Yes

Page 10

OCC Loan-Level Data Collection

Field
No.
57

Field Name
Repayment
Plan
Performance
Status

OCC
(Y/N)
Y

Description
Repayment Plan
performance as of
month-end.

Allowable Values
0

Loan does not have an active
repayment plan as of monthend and did not have the
terms of a repayment plan
broken or cancelled

1
2
3
4

Stip to Mod Active
Stip to Mod Broken/Cancelled
Repayment Plan Active
Repayment Plan Broken

5

8

Repayment Plan Cancelled by
Servicer
Repayment Plan Cancelled at
borrower’s request
2MP/HAMP Trial Period
Active
2MP/HAMP Trial Broken

9

2MP/HAMP Trial Cancellation

6
7

Servicer
Advances

Y

59

Original
Property
Value

60

Refreshed
Property
Value

58

February 13th 2013

Including
Corporate and
Escrow Advances

e.g. 125000 for $125,000.00

Y

Property Value at
time of loan
Origination

e.g. 125000 for $125,000.00

Y

Most recent (nonoriginal) property
value

e.g. 125000 for $125,000.00

Fidelity
Screen
Name

If no servicer advances exist, please
populate as 0.

Page 11

OCC Loan-Level Data Collection

Field
No.
61

Field Name
Property
Valuation
Method at
Origination

OCC
(Y/N)
Y

Description
Method used to
determine the
property value at
time of origination

Allowable Values
1 Full Appraisal – Prepared
by a licensed appraiser

Fidelity
Screen
Name

2 Limited appraisal-Driveby Prepared by a
licensed appraiser
3 Broker Price Opinion
“BPO”-Prepared by a
real estate broker or
agent
4 Desktop Valuation –
Prepared by a bank
employee or nonappraiser
5 Automated Valuation
Model “AVM”
6 Unknown
7 TAV – tax assessed value
8 Purchase Price
9 Other

February 13th 2013

Page 12

OCC Loan-Level Data Collection

Field
No.
62

63

Field Name
Refreshed
Property
Valuation
Method

Most Recent
Property
Valuation
Date

February 13th 2013

OCC
(Y/N)
Y

Y

Description
The valuation
method for any
refreshed values in
field #59.
Identifies the
method by which
the value of the
property was
determined

Date of most
recent property
valuation.

Allowable Values
0

Not Refreshed

1

Full Appraisal – Prepared by a
licensed appraiser

2

Limited appraisal-Drive-by Prepared by a licensed appraiser

3

Broker Price Opinion “BPO”Prepared by a real estate broker or
agent

4

Desktop Valuation – Prepared by a
bank employee or non-appraiser

5

Automated Valuation Model “AVM”

6

Unknown

7

TAV – tax assessed value

8

HPI or other Index

9

Other

Fidelity
Screen
Name

mm/dd/yyy

Page 13

OCC Loan-Level Data Collection

Field
No.
64

65

Field Name
Loss Mitigation
Performance
Status

Credit Line
Closed Flag

February 13th 2013

OCC
(Y/N)
Y

Y

Description
Identifies the
appropriate
performance
status of a loan
that is under a loss
mitigation
program. Applies
to all loans
regardless of
workout type
(Field 27). Please
see the definitions
document for full
instructions on how
to populate this
field.
Identifies any line
of credit where
the credit line has
been closed,
allowing no further
draws or increase
in principal
balance
outstanding. The
status code should
remain on the line
until paid in full.
Important: Leave
NULL for home
equity loans.

Allowable Values
0
1
2
3

N
Y

Fidelity
Screen
Name

No loss mitigation
action in place.
Active and Performing
Active and Nonperforming
Broken

No
Yes

Page 14

OCC Loan-Level Data Collection

Field
No.
66

67

Field Name
Property Type
Descriptors

Rate Reduction

OCC
(Y/N)
Y

Y

Description

Allowable Values

Fidelity
Screen
Name

Property Type

The interest rate
on the loan was
lowered.

1

SFR – Single Family Residence

2

Multi – Multi family property

3

Condo – Condominium

4

Coop – Cooperative

5

PUD – PUD/Townhouse

6

MFG – Manufactured Housing

7

Other

8

Unknown

N
Y

No
Yes

N
Y

No
Yes

N
Y

No
Yes

Report for all
loans with a value
in Field 37.
68

Term
Modification

Y

A term
modification is one
in which there was
a change to the
rate reset date
balloon feature
and/or maturity
date.
Report for all
loans with a value
in Field 37.

69

Principal
Write Down

Y

Report all loans
where an
adjustment to the
unpaid principal
balance has
occurred.
Report for all
loans with a value
in Field 37.

February 13th 2013

Page 15

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

70

Capitalization

Y

Description
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.

Allowable Values
N
Y

No
Yes

N
Y

No
Yes

N
Y

No
Yes

Fidelity
Screen
Name

Report for all
loans with a value
in Field 37.
71

Principal
Deferred

Y

Report on any
loans where
principal payment
or amortization
has been deferred
to a later date.
Report for all
loans with a value
in Field 37.

72

Interest Rate
Frozen

Y

Report on all loans
where a floating
interest rate was
frozen at a fixed
rate.
Report for all
loans with a value
in Field 37.

February 13th 2013

Page 16

OCC Loan-Level Data Collection

Field
No.
73

Field Name
Other
Modification
Action

OCC
(Y/N)
Y

Description
Report any
modification type
not covered by the
previous
categories.

Allowable Values
N
Y

No
Yes

Fidelity
Screen
Name

Report for all
loans with a value
in Field 37.
74

SOP-03-03

Y

Identify any loans
that are accounted
for under SOP-0303 purchase
accounting

N
Y

No
Yes

75

Line Re-age

Y

Line of Credit has
been re-aged, but
terms have not
been modified.

N
Y

No
Yes

If record is loan please leave blank (NULL)

Answer “Yes” here
for lines that have
been re-aged but
have not been
modified. Lines
that have had a
draw period or
amortization
change as part of
a modification
should be “N”
here and be “Y”
on field 68.

February 13th 2013

Page 17

OCC Loan-Level Data Collection

Field
No.

Field Name

OCC
(Y/N)

76

Loan Extension

Y

Description
This field should
be coded Y for
loans that have
been extended
but have not been
modified.

Allowable Values
N
Y

Fidelity
Screen
Name

No
Yes

If record is line please leave blank (NULL)

This field should
be “Y” for loans
that have been
extended but
have not been
modified. Loans
that have an
amortization
change as part of
a modification
should be “N”
here and be “Y”
on field 68.
77

Unpaid
Principal
Balance (Net)

78

Accrual Status

February 13th 2013

Y

Current net unpaid
balance at end of
the reporting
month rounded to
the nearest dollar.

e.g, 125000 for $125,000.00

Accrual Status of
the loan or line of
credit as of the
reporting month.

0

Accrual

1
2

Non-Accrual
Serviced for
Others/Securitized

Page 18