Making Home Affordable Program

Troubled Asset Relief Program - Making Home Affordable Participants

Copy of MHA Data Dictionaries (1505-0216).xlsx

Making Home Affordable Program

OMB: 1505-0216

Document [xlsx]
Download: xlsx | pdf

Overview

Servicing Transfers
Additional Data Elements
HAMP
2MP
HAFA
FHA HAMP
RD-HAMP


Sheet 1: Servicing Transfers













M=Mandatory; C=Conditional; O=Optional



Definition SVT Deal Setup SVT Loan Update SVT Deal Update SVT Deal Concurrence SVT Deal Cancel Condition Under Which Data Is Required Data Type/Data Length Allowable Values Associated SVT Rules
Deal Level Information
DD1033 SVT Concurrence Type Code Type of Deal Concurrence submitted by the servicer.


M
If SVT Submission Type Code is (4) SVT Deal Concurrence Numeric (4,0) Enumeration:
1. Transferor Concurrence
2. Transferor Non-Concurrence
3. Transferee Concurrence
4. Transferee Non-Concurrence
SVT-94
SVT-95
SVT-96
SVT-140
SVT-159
SVT-160
DD1034 SVT Deal Identifier Unique identifier for the servicing transfer deal in the HAMP System.
M M M M If SVT Submission Type Code is (2) SVT Loan Update, (3) SVT Deal Update, (4) SVT Deal Concurrence or (5) SVT Deal Cancel Numeric(15)
SVT-50
SVT-51
SVT-80
SVT-81
SVT-139
SVT-155
SVT-156
SVT-163
SVT-164
DD1036 SVT Submission Type Code The type of the servicing transfer transaction that is being submitted. M M M M M
Numeric (4,0) 1. SVT Deal Setup
2. SVT Loan Update
3. SVT Deal Update
4. SVT Deal Concurrence
5. SVT Deal Cancel
SVT-72
SVT-73
SVT-79
SVT-175
DD1037 SVT Transfer Reason Code The reason a loan is being transferred. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Numeric (4,0) 1. Standard Transfer
2. Merger
3. Acquisition
4. Repurchase*
5. Involuntary Transfer
6. FDIC Takeover*

* Not valid for servicer use
SVT-89
SVT-90
SVT-91
SVT-92
DD1038 Transfer or Assignment Effective Date Effective date of the servicing transfer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Date (CCYY-MM-DD) Min: 3/4/2009
Max: 6 months from current system date
SVT-77
SVT-109
SVT-110
SVT-111
SVT-112
SVT-132
SVT-149
SVT-162
SVT-164
SVT-174
DD1039 Transferee HAMP Servicer Number HAMP Servicer Number of the transferee servicer in a servicing transfer transaction. M M M M M
Numeric (9)
SVT-57
SVT-58
SVT-60
SVT-61
SVT-62
SVT-70
SVT-77
SVT-79
SVT-80
SVT-81
SVT-155
SVT-156
SVT-158
SVT-160
SVT-164
DD1040 Transferee Primary Contact E-mail Primary contact email of transferee servicer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Text(100)
SVT-126
SVT-127
SVT-168
DD1041 Transferee Primary Contact Name Primary contact name of transferee servicer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Text(100)
SVT-122
SVT-123
SVT-168
DD1042 Transferee Primary Contact Phone Primary contact phone number of transferee servicer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Text(100)
SVT-124
SVT-125
SVT-168
DD1043 Transferee Secondary Contact E-mail Secondary contact email of transferee servicer. O
O


Text(100)
SVT-130
SVT-138
SVT-170
DD1044 Transferee Secondary Contact Name Secondary contact name of transferee servicer. O
O


Text(100)
SVT-128
SVT-136
SVT-170
DD1045 Transferee Secondary Contact Phone Secondary contact phone number of transferee servicer. O
O


Text(100)
SVT-129
SVT-137
SVT-170
DD1047 Transferor HAMP Servicer Number HAMP Servicer Number of the transferor servicer in a servicing transfer transaction. M M M M M
Numeric (9)
SVT-53
SVT-55
SVT-56
SVT-57
SVT-77
SVT-78
SVT-80
SVT-81
SVT-150
SVT-152
SVT-154
SVT-155
SVT-156
SVT-157
SVT-158
SVT-159
SVT-162
SVT-164
SVT-165
DD1048 Transferor Primary Contact E-mail Primary contact email of transferor servicer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Text(100)
SVT-117
SVT-118
SVT-167
DD1049 Transferor Primary Contact Name Primary contact name of transferor servicer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Text(100)
SVT-113
SVT-114
SVT-167
DD1050 Transferor Primary Contact Phone Primary contact phone number of transferor servicer. M
O

If SVT Submission Type Code is (1) SVT Deal Setup Text(100)
SVT-115
SVT-116
SVT-167
DD1051 Transferor Secondary Contact E-mail Secondary contact email of transferor servicer. O
O


Text(100)
SVT-121
SVT-135
SVT-169
DD1052 Transferor Secondary Contact Name Secondary contact name of transferor servicer. O
O


Text(100)
SVT-119
SVT-133
SVT-169
DD1053 Transferor Secondary Contact Phone Secondary contact phone number of transferor servicer. O
O


Text(100)
SVT-120
SVT-134
SVT-169
Loan Level Information
DD9 Investor Code Owner of the mortgage. M C


If SVT Submission Type Code is (1) SVT Deal Setup
OR
If SVT Submission Type Code is (2) SVT Loan Update and SVT Loan Update Reason Code is (1) Add
Numeric(4,0) Enumeration:
1. Fannie Mae
2. Freddie Mac
3. Private
4. Portfolio
SVT-97
SVT-98
SVT-99
SVT-100
SVT-101
SVT-147
SVT-148
SVT-162
SVT-164
SVT-171
SVT-174
DD1035 SVT Loan Update Reason Code Type of loan correction that is being submitted for update.
M


If SVT Submission Type Code is (2) SVT Loan Update Numeric (4,0) 1, Add
2. Remove
3. Correction
SVT-74
SVT-83
SVT-84
SVT-86
SVT-87
SVT-88
SVT-155
SVT-156
DD1059 SVT Program Type Category The program type category for a loan that is being transferred. M C


If SVT Submission Type Code is (1) SVT Deal Setup
OR
If SVT Submission Type Code is (2) SVT Loan Update and SVT Loan Update Reason Code is (1) Add
Numeric(4,0) 1. HAMP or HAFA
2. FHA
3. RD-HAMP
4. 2MP
SVT-76
SVT-103
SVT-104
SVT-105
SVT-106
SVT-107
SVT-131
SVT-151
SVT-162
SVT-164
DD1046 Transferee Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that will be servicing the loan. M M


If SVT Submission Type Code is (1) SVT Deal Setup or (2) SVT Loan Update Text (30)
SVT-54
SVT-67
SVT-68
SVT-69
SVT-70
SVT-71
SVT-79
SVT-162
SVT-166
DD1054 Transferor Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is currently servicing the loan. M M


If SVT Submission Type Code is (1) SVT Deal Setup or (2) SVT Loan Update Text (30)
SVT-63
SVT-64
SVT-65
SVT-66
SVT-78
SVT-150
SVT-152
SVT-154
SVT-157
SVT-165
According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless it displays a valid OMB control number. The valid OMB control number for this information collection is 1505-0216. The time required to complete this information collection is estimated to average 8 hours per response.








Sheet 2: Additional Data Elements













Mandatory=M; Conditional = C Legend: 04/01/2013 Green 07/29/2013 Blue
Ref ID Name of Data Point Description Calculations ADR Transaction File Condition Under Which Data is Required Data Type (format and character limit) Allowable Values Associated Rules
Schedule I - Identifying Information







DD8 HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program.
M
Numeric(9)
ADE-19
ADE-334
ADE-340
ADE-341
ADE-415
DD14 Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan.
M
Text(30)
ADE-33
ADE-334
ADE-341
ADE-415
DD39 Borrower First Name The first name of the Borrower of record.
M
Text(100)
ADE-20
DD40 Borrower Last Name The last name of the Borrower. This is also known as the family name or surname.
M
Text(100)
ADE-21
DD43 Borrower Social Security Number The Social Security Number of the Borrower.
M
Text(9) Data Range:
Min: 000000001
Max: 999999998
ADE-116
ADE-211
ADE-367
ADE-369
DD35 Borrower Date of Birth The date of birth associated with the Borrower on the loan.
C If provided on Hardship Affidavit Date(CCYY-MM-DD) Data Range:
Min: 1889-01-01
ADE-219
ADE-220
ADE-221
DD34 Borrower Credit Score The credit score associated with the Borrower on the loan. This score should be the same score used in the NPV model.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted Numeric(3,0) Data Range:
Min: 250
Max: 900
ADE-232
DD55 Co-Borrower First Name The first name of the Co-Borrower of record.
C If Co-Borrower Social Security Number or Co-Borrower Last Name is provided. Text(100)
ADE-201
ADE-202
ADE-227
ADE-228
ADE-229
ADE-233
DD56 Co-Borrower Last Name The last name of the Co- Borrower of record.
C If Co-Borrower Social Security Number or Co-Borrower First Name is provided. Text(100)
ADE-201
ADE-202
ADE-227
ADE-228
ADE-229
ADE-233
DD53 Co-Borrower Date of Birth The date of birth associated with the Co-Borrower on the loan.
O if co-borrower on loan and if provided on Hardship Affidavit Date(CCYY-MM-DD)
ADE-225
ADE-226
DD59 Co-Borrower Social Security Number The Social Security Number of the Co-Borrower.
O If co-borrower on loan Text(9) Data Range:
Min: 000000001
Max: 999999998
ADE-117
ADE-211
ADE-368
ADE-370
DD52 Co-Borrower Credit Score The credit score associated with the Co-Borrower on the loan. This score should be the same score used in the NPV model.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Co-Borrower First Name and Co-Borrower Last Name are populated Numeric(3,0) Data Range:
Min: 250
Max: 900
ADE-233
DD153 Property Type Code A code that defines the type of property that the loan is associated with the loan.
M
Numeric(4,0) Enumeration:
1. Single Family 1 to 4 Units
2. Condominium/Planned Unit Development (PUD)
3. Coop
4. Mobile Home
5. Zero-Lot-Line
6. Unknown
ADE-255
DD148 Property Number of Units Number of units in subject property (Valid values are 1, 2, 3 or 4).
M
Numeric(4,0) Data Range:
Min: 1
Max: 4
ADE-294
ADE-613
ADE-614
ADE-615
ADE-616
DD152 Property Street Address The street address of the subject property.
M
Text(200)
ADE-303
DD145 Property City The name of the city where the subject property is located.
M
Text(100)
ADE-335
DD151 Property State The 2-character postal abbreviation of the state, province, or region of the subject property.
M
Text(2) Enumeration: WY,WV,WI,WA,VT,VI,VA,UT,TX,TN,SD,SC,RI,PR,PA,OR,OK,OH,NY,NV,NM,NJ,NH,NE,ND,NC,MT,MS,MO,MN,MI,ME,MD,MA,LA,KY,KS,IN,IL,ID,IA,HI,GU,GA,FL,DE,DC,CT,CO,CA,AZ,AR,AL,AK. ADE-305
DD161 Property Zip Code The code designated by the postal service to direct the delivery of physical mail or which corresponds to a physical location. In the USA, this can take either a 5 digit form (ZIP Code) or a 9-digit form (ZIP + 4).
M
Numeric (5 or 9)
ADE-304
ADE-342
ADE-343
ADE-344
DD162 Race/Ethnicity/Gender Source Type Code A code that specifies the method by which the race/ethnicity/gender data was collected from the Borrower by the Servicer. If code 5 - Not Available is selected, any previously collected race/ethnicity/gender data shall be removed from the system.
M
Numeric(4,0) Enumeration:
1. Face to Face Interview
2. Mail
3. Telephone
4. Internet
5. Not Available *
6. Previously Reported

* Not available means that it was not collected
ADE-222
ADE-223
ADE-224
ADE-227
ADE-228
ADE-229
ADE-230
ADE-586
ADE-587
ADE-588
ADE-589
ADE-590
ADE-591
ADE-621
DD122 NPV Model Type Code A code that specifies the type of model used to generate the NPV data.
M
Numeric(4,0) Enumeration:
1. Base NPV Model - Treasury hosted
2. Base NPV Model - Servicer hosted
3. NPV model not yet executed
4. NPV not required
5. Base NPV Model - Servicer hosted and NPV previously reported
6. NPV Data Not Available (Evidence Required in Loan File)
ADE-254
ADE-412
ADE-413
ADE-622
ADE-678
DD9 Investor Code A code identifying the investor in the loan.
M
Numeric(4,0) Enumeration:
1. Fannie Mae
2. Freddie Mac
3. Private
4. Portfolio
8. Not Available (Restricted - not valid for servicer input)
ADE-288
ADE-345
ADE-346
ADE-348
ADE-351
ADE-353
ADE-355
ADE-358
ADE-361
ADE-372
ADE-374
ADE-408
ADE-418
ADE-472
ADE-482
ADE-487
ADE-492
ADE-515
ADE-521
ADE-523
ADE-524
ADE-525
ADE-526
ADE-527
ADE-532
ADE-533
ADE-543
ADE-544
ADE-546
ADE-549
ADE-594
ADE-645
DD967 Additional Data Reporting Type Code A code indicating what type of information is being submitted.
M
Numeric (4,0) Enumerations:
1 - Tier 1
2 - Tier 2
3 - HAMP NANA
ADE-418
ADE-419
ADE-551
ADE-552
ADE-636
ADE-639
ADE-640
ADE-641
ADE-642
ADE-646
ADE-647
ADE-649
ADE-669
ADE-679
DD970 Modification Evaluation Date The date that the loan was evaluated for the HAMP modification. If submitting NPV Data, this field must match the NPV Date.
M
Date (CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2014-09-30
ADE-551
ADE-553
ADE-617
ADE-649
ADE-679
Schedule II - Government Monitoring







DD36 Borrower Ethnicity Type Code
A code that specifies the ethnicity of the borrower according to HMDA. This code corresponds to the values in the hardship affidavit.

Note: Use Code 4 for “not applicable” only when the applicant or co-applicant is not a natural person or when applicant or co-applicant information is unavailable because the loan has been purchased by your institution.

C If Race/Ethnicity/Gender Source Type Code is not equal to (5) Not Available or (6) Previously Reported Numeric(4,0) Enumeration:
1. Hispanic or Latino
2. Not Hispanic or Latino
3. Information not provided by borrower
4. Not Applicable
ADE-222
ADE-591
DD41 Borrower Race Type Code A code that specifies the race of the borrower according to HMDA. This code corresponds to the values in the hardship affidavit. For race, you may submit more than one designation. If more than one designation is applicable, then multiple occurrences of this attribute must be submitted.

Use Code 7 for “not applicable” only when the applicant or co-applicant is not a natural person or when applicant or co-applicant information is unavailable because the loan has been purchased by your institution.

C If Race/Ethnicity/Gender Source Type Code is not equal to (5) Not Available or (6) Previously Reported Numeric(4,0) Enumeration:
1. American Indian or Alaska Native
2. Asian
3. Black or African American
4. Native Hawaiian or Other Pacific Islander
5. White
6. Information not provided by borrower
7. Not Applicable
ADE-223
ADE-590
DD42 Borrower Sex Type Code A code that specifies the sex of the borrower. This code corresponds to the values in the hardship affidavit.

Note: Use Code 4 for “not applicable” only when the applicant or co-applicant is not a natural person or when applicant or co-applicant information is unavailable because the loan has been purchased by your institution.

C If Race/Ethnicity/Gender Source Type Code is not equal to (5) Not Available or (6) Previously Reported Numeric(4,0) Enumeration:
1. Male
2. Female
3. Information not provided by borrower
4. Not Applicable
ADE-224
ADE-589
DD54 Co-Borrower Ethnicity Type Code A code that specifies the ethnicity of the co-borrower according to HMDA. This codes corresponds to the values in the hardship affidavit.

Note: Use Code 4 for “not applicable” only when the applicant or co-applicant is not a natural person or when applicant or co-applicant information is unavailable because the loan has been purchased by your institution.

C If Co-Borrower First Name and Co-Borrower Last Name are populated and Race/Ethnicity/Gender Source Type Code is not equal to (5) Not Available or (6) Previously Reported Numeric(4,0) Enumeration:
1. Hispanic or Latino
2. Not Hispanic or Latino
3. Information not provided by borrower
4. Not Applicable
ADE-227
ADE-588
DD58 Co-Borrower Sex Type Code A code that specifies the sex of the co-borrower. This code corresponds to the values in the hardship affidavit.

Note: Use Code 4 for “not applicable” only when the applicant or co-applicant is not a natural person or when applicant or co-applicant information is unavailable because the loan has been purchased by your institution.

C If Co-Borrower First Name and Co-Borrower Last Name are populated and Race/Ethnicity/Gender Source Type Code is not equal to (5) Not Available or (6) Previously Reported Numeric(4,0) Enumeration:
1. Male
2. Female
3. Information not provided by borrower
4. Not Applicable
ADE-229
ADE-586
DD57 Co-Borrower Race Type Code A code that specifies the race of the co-borrower according to HMDA. This code corresponds to the values in the hardship affidavit. For race, you may submit more than one designation. If more than one designation is applicable, then multiple occurrences of this attribute must be submitted.

Note: Use Code 7 for “not applicable” only when the applicant or co-applicant is not a natural person or when applicant or co-applicant information is unavailable because the loan has been purchased by your institution.

C If Co-Borrower First Name and Co-Borrower Last Name are populated and Race/Ethnicity/Gender Source Type Code is not equal to (5) Not Available or (6) Previously Reported Numeric(4,0) Enumeration:
1. American Indian or Alaska Native
2. Asian
3. Black or African American
4. Native Hawaiian or Other Pacific Islander
5. White
6. Information not provided by borrower
7. Not Applicable
ADE-228
ADE-587
Schedule III - NPV Model Inputs







DD679 Advances/Escrow Amount Required escrow advances already paid by the servicer and any required escrow advances from the servicer that are currently due and will be paid by the servicer during the Trial Period. Report 2 decimals.
O
Currency (20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD24 Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) AND Occupancy Eligibility Type Code = 1 (Owner Occupied) Numeric(4,0) Data Range:
Min: 1
Max: 9999
ADE-316
ADE-317
ADE-387
ADE-612
DD25 Amortization Term at Origination The number of months between the scheduled first payment due date and the maturity date of the mortgage, expressed in months. Provide the term at the origination of the original loan, before any modification occurs.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(4,0) Data Range:
Min: 1
Max: 9999
ADE-241
ADE-242
DD28 ARM Reset Date The date on which the next ARM reset is due to occur.
C If ARM loan and if NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Date(CCYY-MM-DD) Data Range:
Min: 2009-02-02
ADE-252
ADE-253
DD29 Association Dues/Fees Before Modification The monthly HOA or condo fees for the property under evaluation including any future monthly escrow shortage. In addition, if a displaced borrower is requesting modification for the principal residence from which the borrower was displaced and the borrower is paying rent to live elsewhere, include the rent amount. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-256
ADE-257
ADE-271
DD45 Borrower Total Monthly Obligations Total monthly expenses as reported by the borrower. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: sum of (Association Dues/Fees Before Modification (DD29), Monthly Hazard and Flood Insurance (DD111), Monthly Real Estate Taxes (DD114), and Principal & Interest Payment Before Modification (DD135))
Max: 999999999999999999.99
ADE-271
ADE-272
ADE-389
DD66 Discount Rate Risk Premium The rate at which the discount rate is greater than the Freddie Mac Primary Mortgage Market Survey Rate (PMMS) for the 30-year conforming loan. The default value is 0. However, a servicer can override the default rate and add up to 250 bps. No premium for Fannie and Freddie loans. Report to 5 decimals. For example, 2.5% should be entered as 2.5.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(7,5) Data Range:
Min: 0
Max: 2.5
ADE-264
ADE-265
ADE-391
DD61 Data Collection Date The date on which the UPB and associated remaining term data was collected for the NPV run.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Date(CCYY-MM-DD) Data Range:
Min: Within 90 days of the NPV Date (DD119)
Max: NPV Date (DD119)
ADE-234
ADE-235
ADE-390
DD70 Estimated Default Rate The estimated probability of default in the No-mod scenario calculated as per the Base NPV Model Documentation. Report 4 decimals. For example, 20.1235% should be entered as 20.1235.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (8,5) Data Range:
Min: 0
Max: 100
ADE-275
ADE-276
ADE-593
DD73 First Payment Date at Origination The estimated date the first payment was made on the loan after origination.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Date(CCYY-MM-DD) Data Range:
Min: 1960-12-31
Max: 2009-03-01
ADE-220
ADE-226
ADE-236
ADE-237
DD5 GSE Loan Number A unique identifier assigned to each loan by a GSE (Fannie or Freddie).
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted
and Investor Code is (1) Fannie Mae or (2) Freddie Mac
Text(30)
ADE-286
ADE-287
ADE-290
ADE-291
ADE-594
DD79 Imminent Default Flag If a current or 30-day delinquent borrower is considered in imminent default, then this flag receives the value true. Otherwise, it receives the value false.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Boolean true/false ADE-273
ADE-274
ADE-419
DD83 Interest Rate After Modification The interest rate in the month after loan modification as of the Data Collection Date. This is a Tier 1 only field. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) AND Occupancy Eligibility Type Code = 1 (Owner Occupied) Numeric(6,4) Data Range:
Min: 0
Max: 25

ADE-312
ADE-313
ADE-366
ADE-384
ADE-497
DD84 Interest Rate at Origination The interest rate of the loan at origination. Report 5 decimal places. For example, 6.125% should be entered as 6.125.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (7,5) Data Range:
Min: 00.00001
Max: 25
ADE-244
ADE-245
ADE-394
DD85 Interest Rate Before Modification The interest rate on the loan before the modification. Report 5 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(6,4) Data Range:
Min: 1
Max: 25
ADE-299
ADE-300
ADE-395
DD95 LTV at Origination (1st Lien only) The ratio between the original loan amount and the lesser of the sales price or the appraised value, for first mortgages. For example, 98% should be entered as 98.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (8,5) Data Range:
Min: 000.00001
Max: 150
ADE-247
ADE-248
ADE-396
DD96 Mark to Market LTV UPB before modification divided by property valuation as-is value. Truncate the value to 5 decimal places. Do not round.

For example, for MTMLTV =66.666612%, truncate the value to 5 decimal places and report 66.66661%.
Another example, for MTMLTV =79.999998%, truncate the value to 5 decimal places and report 79.99999%.

O If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (8,5) Data Range:
Min: 0
Max: 999.99999
ADE-266
ADE-268
ADE-397
DD568 Maximum Months Past Due in Past 12 Months Maximum Months Past Due during the 12 Month period prior to the data collection date. Calculation for Loan Age:
[Number of months between First payment date at Origination (DD73) and Data Collection Date (DD61)] + 1
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Occupancy Eligibility Type Code is (1) Owner Occupied and
post-arrearage MTMLTV Percent is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Numeric (3,0) Data Range:
Min: Months Past Due (DD115)
Max: 999
ADE-348
ADE-478
ADE-609
ADE-610
ADE-644
DD106 Modification Fees Fees that will be reimbursed by the investors, including notary fees, property valuation, and other required fees. Report to 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-279
ADE-280
DD110 Monthly Gross Income Total monthly gross income as reported by the borrower and verified by the servicer. For evaluation of a non-owner-occupied property, exclude the rental income from the Monthly Gross Income for the property under evaluation. If there is income from additional rental properties, include the net income from these additional properties in the Monthly Gross Income. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-308
ADE-309
DD956 Monthly Gross Rental Income Amount For the non-owner occupied property under evaluation, the monthly gross rental income received from the property before any costs or expenses. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Occupancy Eligibility Type Code is (2) Non-Owner Occupied Currency (20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-428
ADE-429
ADE-574
DD111 Monthly Hazard and Flood Insurance The monthly hazard and flood insurance payment amount for the property under evaluation. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-258
ADE-259
ADE-271
ADE-406
ADE-509
ADE-514
ADE-517
ADE-527
ADE-557
ADE-558
DD114 Monthly Real Estate Taxes The monthly real estate taxes for the property under evaluation. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-260
ADE-261
ADE-271
ADE-406
ADE-509
ADE-514
ADE-517
ADE-527
ADE-557
ADE-558
DD115 Months Past Due A loan would be considered past due (delinquent) if the payment had not been received by the end of the day immediately preceding the loan’s next due date (generally the last day of the month which the payment was due). For example: a loan with a last paid installment date of 7/1/02 and a due date of 8/1/02, for which no payment was received by the Data Collection Date of 9/1/02, the loan would be reported as one (1) month past due. Calculation for Loan Age:
[Number of months between First payment date at Origination (DD73) and Data Collection Date (DD61)] + 1
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (3,0) Data Range:
Min: 0
Max: 999
ADE-269
ADE-270
ADE-417
ADE-518
ADE-525
ADE-526
ADE-555
ADE-556
ADE-595
ADE-609
DD102 Mortgage Insurance Coverage Percent Current non-investor primary mortgage insurance coverage percentage. Report 5 decimals. For example, 20% should be entered as 20.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (8,5) Data Range:
Min: 0
Max: 100
ADE-262
ADE-263
DD103 Mortgage Insurance Partial Claim Amount Amount paid by the MI at the time of the modification. Report to 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-281
ADE-282
DD117 Next ARM Reset Rate The expected interest rate on an ARM loan at the next ARM reset date given the reset date is within the next 120 days. Use the latest available reset rate at the time of submission. If the reset date is outside of 120 days, the use current note rate before modification.
C If ARM loan and if NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (7,5) Data Range:
Min: 00.00001
Max: 25
ADE-250
ADE-251
ADE-398
DD955 NPV Capitalized UPB Amount UPB including all capitalization (Refer to MHA Handbook for waterfall step 1-capitalization). UPB should be as of the Data Collection Date. Servicer should NOT project or estimate the amount as of a future date. Report 2 decimals.
C If NPV Date is on or after 6/01/2012 and NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Occupancy Eligibility Type Code is (1) Owner Occupied Currency (20,2) Data Range:
Min: Unpaid Principal Balance Before Modification (DD225)
Max: 999999999999999999.99
ADE-421
ADE-422
ADE-442
ADE-447
ADE-477
ADE-496
ADE-539
ADE-541
ADE-543
ADE-546
ADE-548
ADE-549
ADE-592
DD118 NPV Code Version The version of the Base NPV Model that was used in the assessment
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(7,5) Data Range:
Min: 0
Max: 5.0
ADE-267
ADE-285
ADE-604
ADE-605
ADE-606
ADE-607
ADE-608
DD119 NPV Date Date that the loan is evaluated for trial modification eligiblity for the first time.

For loans that were evaluated for HAMP prior to June 1, 2012 (NPV Date prior to June 1, 2012) and require re-evaluation under HAMP Tier 2, the servicer should use the date that the loan is evaluated under NPV 5.0 for the first time as the NPV Date. If the servicer chooses to re-run a loan through NPV 5.0 subsequently, the servicer should use the date of the first evaluation under NPV v5.0 as the NPV Date.

For loans that are evaluated for HAMP (Tier 1 or Tier 2) for the first time on or after June 1, 2012, the servicer should use the date that the loan is evaluated for HAMP for the first time as the NPV Date. This date must be used as the NPV date for subsequent NPV runs of the loan.

C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Date(CCYY-MM-DD) Data Range:
Min: 2009-04-15
Max: Today's System Date or 9-30-2014, whichever is earlier.
ADE-234
ADE-326
ADE-329
ADE-346
ADE-348
ADE-399
ADE-472
ADE-473
ADE-474
ADE-481
ADE-482
ADE-483
ADE-484
ADE-499
ADE-604
ADE-605
ADE-606
ADE-607
ADE-608
ADE-617
ADE-623
DD120 NPV Model Result Amount Post-mod The model generated Net Present Value of modifying the loan under the standard waterfall. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Occupancy Eligibility Type Code is (1) Owner Occupied Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-332
ADE-333
ADE-393
ADE-400
ADE-508
ADE-598
ADE-599
DD121 NPV Model Result Amount Pre-mod The model generated Net Present Value of not modifying the loan. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Occupancy Eligibility Type Code is (1) Owner Occupied

Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-330
ADE-331
ADE-401
ADE-406
ADE-520
ADE-597
ADE-598
ADE-599
DD123 NPV Test Result The result of the NPV test. Either positive or negative. This is a Tier 1 only field.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Occupancy Eligibility Type Code is (1) Owner Occupied Numeric(4,0) Enumeration:
1. Positive
2. Negative
ADE-283
ADE-284
ADE-598
ADE-653
ADE-654
DD957 Occupancy Eligibility Type Code Occupancy status and modification eligibility of the property being evaluated.
• Select 1 for evaluating an owner-occupied property:
i)for Tier 1 and Tier 2 evaluations on or after NPV date 6/1/2012, OR
ii)that is eligible for re-evaluation under Tier 1 (eg. due to a change in circumstances), with NPV date prior to 6/1/2012
• Select 2 for any evaluation for a non-owner-occupied property (for Tier 2 evaluation only)
• Select 3 for a re-evaluation of an owner-occupied property that was previously evaluated under HAMP Tier 1 ; and has no change in circumstance; and was deemed i) excessive forbearance or ii) with pre-mod DTI less than 31%; or, iii) with an NPV negative result (for Tier 2 evaluation only)
• Select 4 for evaluating a loan that has defaulted under the HAMP Tier 1 trial period plan or HAMP Tier 1 permanent modification (for Tier 2 evaluation only)

C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (4,0) 1- Owner occupied
2- Non- owner occupied
3- Owner occupied Excessive Forbearance/Current DTI <31%/Prior HAMP NPV Negative
4- Owner occupied Failed HAMP
5 - No value existed prior to attribute introduction (not for servicer use)
ADE-283
ADE-310
ADE-316
ADE-318
ADE-320
ADE-322
ADE-330
ADE-332
ADE-345
ADE-366
ADE-384
ADE-387
ADE-393
ADE-401
ADE-406
ADE-409
ADE-417
ADE-419
ADE-420
ADE-426
ADE-428
ADE-441
ADE-484
ADE-498
ADE-499
ADE-530
ADE-555
ADE-598
ADE-599
ADE-603
ADE-676
DD131 PMMS Rate The Freddie Mac Primary Mortgage Market Survey (PMMS) weekly rate for 30-year fixed-rate conforming loans. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(6,4) Data Range:
Min: 0
Max: 99.9999
ADE-314
ADE-315
ADE-402
DD701 Post-Arrearage MTMLTV Percent This is not a reported field. The amount resulting from the calcualtion is used in rule validations.

The mark-to-market loan to value ratio includes the capitalization of arrearage amounts in the loan amount which is divided by a recent appraised value of the subject property.
(UPB after Mod (DD222) + Principal Forbearance (DD136) + Principal Write-down (DD139))/Property Valuation As Is Value (DD157)


NA


ADE-345
ADE-346
ADE-348
ADE-351
ADE-353
ADE-355
ADE-358
ADE-361
ADE-372
ADE-374
ADE-379
ADE-480
ADE-491
ADE-509
ADE-517
ADE-518
ADE-519
ADE-520
ADE-530
ADE-531
ADE-539
ADE-541
ADE-548
ADE-550
ADE-609
ADE-610
ADE-644
DD958 Primary Residence Total Housing Expense Amount For the non-owner-occupied property under evaluation, the total monthly housing expense for the borrower’s primary residence (the PITIA). If borrower does not own a primary residence and therefore does not have principal PITIA but is paying rent to live elsewhere, use rent amount in this field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Occupancy Eligibility Type Code is (2) Non-Owner Occupied Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
ADE-426
ADE-427
ADE-575
DD132 Principal and Interest Payment After Modification The principal and interest amount after modification as of the Data Collection Date. This is a Tier 1 only field. P&I Payment After Modification = Monthly Gross Income * Front Ratio After Modification - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) AND Occupancy Eligibility Type Code = 1 (Owner Occupied) Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-318
ADE-319
ADE-600
ADE-601
DD135 Principal and Interest Payment Before Modification The sum of the contractual principal and interest payments before modification for the property under evaluation. If the loan is an IO loan in the interest only period, enter only the interest amount. If the loan is a neg-am, enter the payment amount received (without escrow) at the most recent payment date. For delinquent ARMs, the pre-mod scheduled payment should be reported, not the payment at the LPI date.
When entering for a Tier 2 modification where there was a prior (i) HAMP Tier 1 permanent modification that lost good standing (Occupancy Eligibility=4), enter the HAMP Tier 1 monthly P&I payment or (ii) a HAMP Tier 1 trial period plan that defaulted, enter the sum of the contractual principal and interest payments (i.e., before HAMP Tier 1 trial period plan).  Report 2 decimals. 
P&I Payment Before Modification = Monthly Gross Income * Front Ratio Before Modification - Escrow Payment Before Modification (if exists) - Association Dues/Fees Before Modification (if exists) C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-271
ADE-301
ADE-302
ADE-518
ADE-519
ADE-525
ADE-526
ADE-555
ADE-556
ADE-601
DD136 Principal Forbearance Amount The total amount in dollars of the principal that was deferred as of the Data Collection Date. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) AND Occupancy Eligibility Type Code = 1 (Owner Occupied) Currency(20,2) Data Range:
Min: 0
Max: NPV Capitalized UPB Amount (DD955)
ADE-320
ADE-321
ADE-408
ADE-409
ADE-422
ADE-602
DD591 Principal Reduction Alternative Amount Principal Reduction Alternative (PRA) Amount is the principal forgiveness amount for PRA that is separate and exclusive
of any other principal forgiveness that may be offered in conjunction with the HAMP modification.

C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and post-arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010 Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-346
ADE-476
ADE-477
ADE-644
DD562 Principal Reduction Alternative (PRA) Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation as generated by the principal reduction alternative (PRA) waterfall as of the Data Collection Date. Report in months. This period includes the term extension as defined in the HAMP modification waterfall. This is a Tier 1 only field.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Numeric (4,0) Data Range:
Min: 1
Max: Maximum of (480 or Remaining Term)
ADE-345
ADE-469
ADE-470
ADE-471
ADE-510
ADE-550
ADE-644
DD563 Principal Reduction Alternative (PRA) Interest Rate After Modification The interest rate in the month after loan modification as generated by the principal reduction alternative (PRA) waterfall as of the Data Collection Date. This is a Tier 1 only field. Report 4 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Numeric(6,4) Data Range:
Min: 1
Max: 25
ADE-351
ADE-479
ADE-480
ADE-644
DD570 Principal Reduction Alternative (PRA) NPV Model Result Amount Post-mod The model generated Net Present Value of modifying the loan under the PRA waterfall. This is a Tier 1 only field. Report 2 decimal places.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-358
ADE-506
ADE-508
ADE-509
ADE-510
ADE-530
ADE-531
ADE-644
DD571 Principal Reduction Alternative (PRA) NPV Model Result Amount Pre-mod The model generated Net Present Value of not modifying the loan under the PRA waterfall. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-361
ADE-516
ADE-517
ADE-518
ADE-519
ADE-520
ADE-530
ADE-531
ADE-644
DD572 Principal Reduction Alternative (PRA) NPV Test Result The result of the NPV test as generated by the principal reduction alternative (PRA) waterfall. Either positive or negative. This is a Tier 1 only field.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Numeric (4,0) Enumeration:
1. Positive
2. Negative
ADE-379
ADE-529
ADE-530
ADE-531
ADE-644
DD564 Principal Reduction Alternative (PRA) Principal and Interest Payment After Modification The principal and interest amount after modification as generated by the principal reduction alternative (PRA) waterfall as of the Data Collection Date. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-353
ADE-486
ADE-510
ADE-550
ADE-644
DD565 Principal Reduction Alternative (PRA) Principal Forbearance Amount The total amount in dollars of the principal that was deferred as generated by the principal reduction alternative (PRA) waterfall as of the Data Collection Date. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Currency (20,2) Data Range:
Min: 0
Max: NPV Capitalized UPB Amount (DD955)
ADE-372
ADE-491
ADE-510
ADE-539
ADE-540
ADE-548
ADE-644
DD566 Principal Reduction Alternative (PRA) Principal Write-down (Forgiveness) Amount of principal written-down or forgiven as generated by the principal reduction alternative (PRA) waterfall as of the Data Collection Date. This is a Tier 1 only field. Report 2 decimals.

C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Currency (20,2) Data Range:
Min: 0
Max: NPV Capitalized UPB Amount (DD955)
ADE-374
ADE-491
ADE-541
ADE-542
ADE-548
ADE-644
DD567 Principal Reduction Alternative (PRA) Unpaid Principal Balance After Modification The unpaid principal balance of a loan after the loan modification as generated by the principal reduction alternative (PRA) waterfall as of the Data Collection Date. The unpaid principal balance after modification excludes any applicable PRA forbearance amount and any PRA principal reduction amount. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Occupancy Eligibility Type Code is (1) Owner Occupied and
Post-Arrearage MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 10/01/2010
Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-355
ADE-490
ADE-491
ADE-509
ADE-548
ADE-644
DD139 Principal Write-down (Forgiveness) Amount of principal written-down or forgiven inclusive of investor forgiveness (PRA, HHF matching, etc.) and other principal forgiveness assistance (e.g. HHF) as of the Data Collection Date. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) AND Occupancy Eligibility Type Code = 1 (Owner Occupied) Currency(20,2) Data Range:
Min: 0
Max: NPV Capitalized UPB Amount (DD955)
ADE-322
ADE-323
ADE-408
ADE-409
ADE-422
ADE-602
DD142 Product Before Modification The mortgage product of the loan, based on the existing mortgage loan terms before the modification.

If product is Step Rate, only reportable value is '3. Step Rate'.

C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(4,0) Enumeration:
1. ARM
2. Fixed rate
3. Step Rate
4. One Step Variable
5. Two Step Variable
6. Three Step Variable
7. Four Step Variable
8. Five Step Variable
9. Six Step Variable
10. Seven Step Variable
11. Eight Step Variable
12. Nine Step Variable
13. Ten Step Variable
14. Eleven Step Variable
15. Twelve Step Variable
16. Thirteen Step Variable
17. Fourteen Step Variable
ADE-250
ADE-252
ADE-292
ADE-293
ADE-398
ADE-555
ADE-556
DD157 Property Valuation As is Value The property value collected through an AVM, BPO, or appraisal for the property under evaluation. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 10
Max: 999999999999999999.99
ADE-306
ADE-307
ADE-403
ADE-496
ADE-543
DD160 Property Valuation Type Code A code that denotes the type of estimate of the value of the real estate property.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(4,0) Enumeration:
1. AVM
2. Exterior BPO / Appraisal (as is value)
3. Interior BPO / Appraisal (as is value)
ADE-324
ADE-325
DD163 Re-default Rate The estimated probability of default in the Mod scenario calculated as per the Base NPV Model Documentation. Report 4 decimals. For example, 20.1235% should be entered as 20.1235.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric (8,5) Data Range:
Min: 0
Max: 100
ADE-277
ADE-278
ADE-593
DD164 Remaining Term Scheduled remaining term of the loan in months as of the data collection date. For a loan which has not already been modified prior to evaluation for a HAMP modification, it is equivalent to the amortization term minus the time since the first payment after origination to the date that the payment information (i.e., UPB) was obtained; regardless of months delinquent.

Example: First payment date for a 360-month term loan was 5/1/08. The current payment information (i.e., UPB) was reported as of 4/30/09. Remaining terms for this loan is (360-12 = 348).

C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Numeric(4,0) Data Range:
Min: 1
Max: 9999
ADE-295
ADE-296
ADE-387
ADE-500
ADE-501
ADE-502
ADE-518
ADE-525
ADE-555
ADE-612
DD961 Tier 2 Override Amortization Term If there are investor guidelines or applicable laws that restricts the amortization term of a modification, then provide a value here. If term extension is not allowed, enter the remaining term.
O
Numeric (4) Data Range:
Min: 1
Max: 600
ADE-425
ADE-444
ADE-473
ADE-474
ADE-500
ADE-501
ADE-502
ADE-554
ADE-571
DD962 Tier 2 Override Forbearance Amount If there are investor guidelines or applicable laws that restricts the forbearance amount for a modification, provide value here. If forbearance is not allowed, enter 0. Report 2 decimals.
O
Currency (20,2) Data Range;
Min: 0.01
Max: NPV Capitalized UPB Amount (DD955)
ADE-444
ADE-446
ADE-447
ADE-495
ADE-554
ADE-569
DD960 Tier 2 Override Interest Rate If there are investor guidelines or applicable laws that restricts the interest rate for a modification, then provide a value here. If a rate reduction or increase is not allowed, then enter the Interest Rate Before Modification.
O
Numeric(6,4) Data Range;
Min: 0
Max: 25
ADE-424
ADE-444
ADE-445
ADE-482
ADE-483
ADE-484
ADE-497
ADE-498
ADE-499
ADE-554
ADE-570
DD963 Tier 2 Override PRA Principal Forgiveness Amount If the investor elects to forgive principal under Tier 2 PRA in an amount other than what is calculated by the model, then provide a value here. Report 2 decimals.
O
Currency (20,2) Data Range;
Min:0
Max: NPV Capitalized UPB Amount (DD955)
ADE-444
ADE-543
ADE-544
ADE-546
ADE-547
ADE-554
ADE-585
DD979 Tier 2 Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation for Tier 2 loan modifications. This should be calculated assuming the modification starts from the Data Collection Date.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Tier 2 NPV Result is (1) Positive or (2) Negative Numeric (4,0) Data Range:
Min: 1
Max: 9999
ADE-432
ADE-449
ADE-451
ADE-455
ADE-501
ADE-502
ADE-559
ADE-620
DD978 Tier 2 Interest Rate After Modification The interest rate after modification under the Tier 2 standard waterfall as of the Data Collection Date. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Tier 2 NPV Result is (1) Positive or (2) Negative Numeric(6,4) Data Range:
Min: 0
Max: 25
ADE-431
ADE-448
ADE-451
ADE-497
ADE-498
ADE-499
ADE-562
ADE-619
DD959 Tier 2 Investor Override Indicator If there are any investor guidelines or applicable laws that restricts the terms of a modification under Tier 2, then select true. Otherwise select false.
C If NPV Date is on or after 6/01/2012 and NPV Model Type Code is (2) Base NPV Model - Servicer hosted Boolean true/false ADE-423
ADE-443
ADE-444
ADE-445
ADE-447
ADE-495
ADE-497
ADE-500
ADE-501
ADE-554
ADE-572
ADE-670
DD964 Tier 2 Non-PRA Forgiveness Amount If the investor elects to forgive principal under the Tier 2 standard waterfall as of the Data Collection Date. This is NOT Tier 2 PRA. The forgiveness will not be incented. Report 2 decimals.
O If NPV Model Type Code is (2) Base NPV Model - Servicer hosted) and the investor elects to forgive principal under Tier 2 Non-PRA Currency (20,2) Data Range:
Min: 0
Max: NPV Capitalized UPB Amount (DD955)
ADE-565
ADE-592
ADE-635
ADE-672
ADE-683
DD971 Tier 2 NPV Model Result Amount Post-mod The model generated Net Present Value of modifying the loan under the Tier 2 standard waterfall. Report 2 decimals.
C If NPV Model Type Code = (2) Base NPV Model - Servicer hosted and Tier 2 NPV Test Result is (1) Positive or (2) Negative Currency (20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-436
ADE-437
ADE-438
ADE-455
ADE-513
ADE-523
ADE-558
ADE-566
ADE-634
DD972 Tier 2 NPV Model Result Amount Pre-mod The model generated Net Present Value of not modifying the loan. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Tier 2 NPV Test Result is (1) Positive or (2) Negative Currency (20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-435
ADE-437
ADE-438
ADE-453
ADE-524
ADE-555
ADE-556
ADE-557
ADE-567
ADE-633
DD976 Tier 2 NPV Test Result The result of the NPV test for the Tier 2 standard waterfall.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 Numeric (4) Enumeration:
1 - Positive
2 - Negative
3 - Ineligible- DTI
4 - Ineligible-Payment
5 - Ineligible – DTI &Payment
ADE-437
ADE-438
ADE-439
ADE-448
ADE-449
ADE-450
ADE-451
ADE-452
ADE-453
ADE-455
ADE-456
ADE-495
ADE-496
ADE-497
ADE-498
ADE-499
ADE-501
ADE-502
ADE-505
ADE-555
ADE-556
ADE-557
ADE-558
ADE-568
ADE-592
ADE-655
ADE-656
ADE-659
ADE-660
DD984 Tier 2 PRA Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation for Tier 2 PRA loan modifications. This should be calculated assuming the modification starts from the Data Collection Date.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calculated MTMLTV is greater than 115% and Tier 2 NPV Test Result is (1) Positive or (2) Negative and Investor Code is (3) Private or (4) Portfolio Numeric (4,0) Data Range:
Min: 1
Max: 9999
ADE-472
ADE-473
ADE-474
ADE-475
ADE-488
ADE-515
ADE-577
ADE-626
DD983 Tier 2 PRA Interest Rate After Modification The interest rate after modification under the Tier 2 PRA waterfall as of the Data Collection Date. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calulated MTMLTV is greater than 115% and Tier 2 NPV Test Result is (1) Positive or (2) Negative and Investor Code is (3) Private or (4) Portfolio Numeric(6,4) Data Range:
Min: 0
Max: 25
ADE-481
ADE-482
ADE-483
ADE-484
ADE-485
ADE-488
ADE-578
ADE-625
DD973 Tier 2 PRA NPV Model Result Amount Post-mod The model generated Net Present Value of modifying the loan under the Tier 2 PRA waterfall. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calculated MTMLTV is greater than 115% and Tier 2 NPV Test Result is (1) Positive or (2) Negative and Investor Code is (3) Private or (4) Portfolio Currency (20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-511
ADE-512
ADE-513
ADE-514
ADE-515
ADE-533
ADE-534
ADE-581
ADE-629
DD974 Tier 2 PRA NPV Model Result Amount Pre-mod The model generated Net Present Value of not modifying the loan. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calculated MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and Tier 2 NPV Test Result is (1) Positive or (2) Negative Currency (20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
ADE-521
ADE-523
ADE-524
ADE-525
ADE-526
ADE-527
ADE-528
ADE-533
ADE-534
ADE-582
ADE-630
DD975 Tier 2 PRA NPV Test Result The result of the NPV test for the Tier 2 PRA waterfall.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calculated MTMLTV is greater than 115% and Tier 2 NPV Test Result is (1) Positive or (2) Negative and Investor Code is (3) Private or (4) Portfolio Numeric (4) Enumeration:
1 - Positive
2 - Negative
3 - Ineligible- DTI
4 - Ineligible-Payment
5 - Ineligible – DTI &Payment
ADE-472
ADE-473
ADE-474
ADE-481
ADE-483
ADE-484
ADE-492
ADE-511
ADE-513
ADE-514
ADE-521
ADE-523
ADE-524
ADE-525
ADE-526
ADE-527
ADE-532
ADE-533
ADE-534
ADE-538
ADE-543
ADE-544
ADE-546
ADE-549
ADE-583
ADE-624
ADE-625
ADE-626
ADE-627
ADE-628
ADE-629
ADE-630
DD985 Tier 2 PRA Principal and Interest Payment After Modification The principal and interest payment amount under the Tier 2 PRA waterfall as of the Data Collection Date. Report 2 decimals. To determine Payment Reduction for Tier 2:

1 - [ Tier 2 PRA P&I Payment After Mod (DD985) / P&I Payment Before Mod (DD135) ]

Round to the nearest .0000001
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calculated MTMLTV is greater than 115% and Tier 2 NPV Test Result is (1) Positive or (2) Negative and Investor Code is (3) Private or (4) Portfolio Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-487
ADE-488
ADE-489
ADE-515
ADE-579
ADE-627
DD982 Tier 2 PRA Principal Write-down (Forgiveness) The amount of principal written-down or forgiven as generated by the Tier 2 PRA waterfall as of the Data Collection Date. Report 2 decimals.
O If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and MTMLTV is greater than 115% Currency (20,2) Data Range:
Min: 0.01
Max: NPV Capitalized UPB Amount (DD955)
ADE-543
ADE-544
ADE-545
ADE-549
ADE-584
ADE-624
DD986 Tier 2 PRA Unpaid Principal Balance After Modification The unpaid principal balance that is net of any forgiveness under the Tier 2 PRA waterfall as of the Data Collection Date. Report 2 decimals. Calculation to reduce the Tier 2 Unpaid Principal Balance After Modification (DD222) to 115% of the Property Valuation As Is Value (DD157):

= [NPV Capitalized UPB Amount (DD955) - Tier 2 PRA Principal Write-down (Forgiveness) (DD982)] - [Property Valuation As Is Value (DD157) * 1.15]
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and NPV Date is on or after 6/01/2012 and calculated MTMLTV is greater than 115% and Investor Code is (3) Private or (4) Portfolio and Tier 2 PRA NPV Test Result is (1) Positive or (2) Negative Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-488
ADE-492
ADE-493
ADE-514
ADE-543
ADE-549
ADE-580
ADE-628
DD980 Tier 2 Principal and Interest Payment After Modification The principal and interest payment amount under the Tier 2 standard waterfall as of the Data Collection Date. Report 2 decimals. To determine Payment Reduction for Tier 2:

1 - [ Tier 2 P&I Payment After Mod (DD980) / P&I Payment Before Mod (DD135) ]

Round to the nearest .0000001
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Tier 2 NPV Test Result is (1) Positive or (2) Negative Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-434
ADE-450
ADE-451
ADE-455
ADE-563
ADE-631
DD977 Tier 2 Principal Forbearance Amount The total amount principal that was deferred under the Tier 2 standard waterfall as of the Data Collection Date. Report 2 decimals.
O If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency (20,2) Data Range:
Min: 0
Max: NPV Capitalized UPB Amount (DD955)
ADE-430
ADE-455
ADE-495
ADE-496
ADE-573
ADE-592
ADE-618
DD981 Tier 2 Unpaid Principal Balance After Modification The unpaid principal balance that is net of any forgiveness or forbearance under the Tier 2 standard waterfall as of the Data Collection Date. Report 2 decimals. Calculation to reduce the Tier 2 Unpaid Principal Balance After Modification (DD222) to 115% of the Property Valuation As Is Value (DD157):

= [NPV Capitalized UPB Amount (DD955) - Tier 2 Non-PRA Principal Forgiveness Amount (DD964)] - [Property Valuation As Is Value (DD157) * 1.15]
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Investor Code is (3) Private or (4) Portfolio and NPV Date is on or after 6/01/2012 and Tier 2 NPV Test Result is (1) Positive or (2) Negative Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-451
ADE-452
ADE-496
ADE-558
ADE-564
ADE-592
ADE-632
DD222 Unpaid Principal Balance After Modification The unpaid principal balance of a loan after the loan modification as of the Data Collection Date. The unpaid principal balance after modification excludes any applicable forbearance amount and can also be referred to as Net UPB Amount. This is a Tier 1 only field. Report 2 decimals.
C If NPV Model Type Code is (2) Base NPV Model - Servicer hosted and Occupancy Eligibility Type Code is (1) Owner Occupied Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-310
ADE-311
ADE-422
ADE-602
DD224 Unpaid Principal Balance at Origination The face value on the note at origination (i.e., the amount borrowed by the mortgagor). Report 2 decimal places.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-238
ADE-239
DD225 Unpaid Principal Balance Before Modification The unpaid principal balance of a loan is the contractual UPB based on the existing mortgage loan terms as of the Data Collection date. Does not include arrearage. Report 2 decimals.
C If NPV Model Type Code = 2 (Base NPV Model - Servicer hosted) Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
ADE-297
ADE-298
ADE-406
ADE-442
ADE-491
ADE-519
ADE-526
ADE-527
ADE-556
ADE-557
ADE-602
ADE-613
ADE-614
ADE-615
ADE-616
Schedule IV - Reason Codes







DD217 Trial Fallout Reason Code A code that specifies the reason why a borrower fell out or withdrew from the trial or completed the trial and did not enter the official modification.

A trial modification with a reason that results in cancellation of the modification, means the modification may be re-submitted as a trial.

A trial modification with a reason that results in disqualification, means the modification may never be re-submitted within the same tier.

C If borrower fell out or withdrew from the trial or completed the trial but did not enter the official modification or the trial was reported in error OR if NPV Model Type Code is (6) NPV Data Not Available (Evidence Required in Loan File)
Numeric(4,0) Enumeration:
The following code results in the modification being disqualified:

14. Trial Plan Default

The following codes result in the modification being cancelled:

8. Offer Not Accepted by Borrower / Request Withdrawn
11. Loan Paid Off
18. Submission Error Correction (Incorrect transaction type)
19. Unemployment Forbearance Plan
20. Federally Declared Disaster
21. Application Discrepancy
23. Waiver Cancellations
24. Dodd Frank Certification Non-Compliance
30. Not Eligible for MHA Incentives due to Repurchase/Involuntary Transfer
ADE-212
ADE-213
ADE-218
ADE-410
ADE-639
ADE-671
ADE-675
ADE-680
ADE-681
DD218 Trial Not Approved/Not Accepted Reason Code A code that specifies the reason why a borrower was not offered or did not accept a trial plan.
C If trial not approved or not accepted (Additional Data Reporting Type Code) is (3) HAMP NANA Numeric(4,0) Enumeration:
1. Ineligible Mortgage
2. Current DTI Less than 31%
3. Property Not Owner Occupied
4. Other Ineligible Property - Property Condemned, Property > 4 units
5. Investor Guarantor Not Participating
6. Court/Public Official Declined
7. Negative NPV
8. Offer Not Accepted by Borrower / Request Withdrawn
9. Default Not Imminent-Default Status Not Eligible
10. Property and/or Borrower Exceeds Allowable Number of HAMP Modifications
11. Loan Paid Off
12. Excessive Forbearance
13. Request Incomplete
18. Submission Error Correction (Incorrect transaction type)
19. Unemployment Forbearance Plan
20. Federally Declared Disaster
21. Application Discrepancy
24. Dodd Frank Certification Non-Compliance
25. Ineligible Borrower
26. Ineligible Rental Property
27. Insufficient Monthly Payment Reduction
28. Post-Modification DTI Outside Acceptable Range
29. No Change in Circumstance
ADE-215
ADE-216
ADE-218
ADE-413
ADE-636
ADE-640
ADE-641
ADE-648
ADE-651
ADE-652
ADE-653
ADE-654
ADE-655
ADE-656
ADE-659
ADE-660
ADE-661
ADE-662
ADE-663
ADE-664
ADE-665
ADE-666
ADE-667
ADE-668
ADE-669
ADE-675
ADE-677
DD987 HAMP Tier 1 Not Offered Reason Code
A code that specifies the reason why a borrower was not offered a Tier 1 trial plan.
C If Tier 1 Trial was not offered on or after 6/01/2012 and it has not been previously reported and Additional Data Reporting Type Code is (2) Tier 2 or (3) HAMP NANA Numeric (4,0) Enumeration:
1. Ineligible Mortgage
2. Current DTI Less than 31%
3. Property Not Owner Occupied
4. Other Ineligible Property - Property Condemned, Property > 4 units
5. Investor Guarantor Not Participating
6. Court/Public Official Declined
7. Negative NPV
8. Offer Not Accepted by Borrower / Request Withdrawn
9. Default Not Imminent-Default Status Not Eligible
10. Property and/or Borrower Exceeds Allowable Number of HAMP Modifications
11. Loan Paid Off
12. Excessive Forbearance
13. Request Incomplete
18. Submission Error Correction (Incorrect transaction type)
19. Unemployment Forbearance Plan
20. Federally Declared Disaster
21. Application Discrepancy
24. Dodd Frank Certification Non-Compliance
25. Ineligible Borrower
29. No Change in Circumstance
ADE-611
ADE-642
ADE-643
ADE-647
ADE-650
ADE-661
ADE-662
ADE-663
ADE-664
ADE-665
ADE-666
ADE-669
ADE-674
ADE-677

Sheet 3: HAMP

















M=Mandatory; C=Conditional; O=Optional Legend: 12/03/2012 - Red 04/01/2013 - Green
Ref ID Name of Data Point Description Calculation Loan Set-Up /Trial Loan Set-Up Cancellation (Trial) Loan Set-Up / Official Modification Loan Set-Up Correction (Official) Loan Set-Up Cancellation (Official) Official Monthly Reporting Condition Under Which Data Is Required Data Type/Data Length Allowable Values Associated Rules
DD17 1st Trial Payment Due Date This is the date that the first trial payment is due. It is also the trial modification effective date. This date must be less than the trial loan submission date.
M
O O

If exists Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2014-06-30
LIR-169
LIR-183
LIR-198
LIR-235
LIR-251
LIR-295
LIR-344
LIR-457
LIR-502
LIR-518
LIR-529
LIR-530
LIR-531
LIR-532
DD18 1st Trial Payment Posted Date The date the first payment posted during the Trial period.
M
O O


Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2014-06-30
LIR-378
LIR-379
LIR-534
LIR-535
LIR-536
DD19 1st Trial Payment Received Amount This is the actual amount of the Payment received from the Borrower to the Servicer for the 1st Trial payment.
M
O O


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-537
LIR-538
DD20 Action Code A code reported by the lender to update the loan that indicates the action that occurred during the reporting period.





C If there is an action Numeric(4,0) Enumeration:
60 - Payoff
OMR-35
OMR-36
OMR-113
OMR-122
OMR-133
DD21 Action Code Date The effective date of the action associated with the action code specified on the incoming transaction by the servicer. The action date is required for certain action codes.





C If there is an action Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2029-01-15
OMR-36
OMR-113
OMR-123
OMR-124
OMR-134
OMR-135
OMR-148
OMR-162
OMR-165
DD24 Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation.
M M M M M

Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-71
LIR-94
LIR-95
LIR-166
LIR-432
DD26 Amortization Term Before Modification Represents the number of months on which installment payments are based under the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Example: Balloon loans have a seven year life (Loan Term = 84) but a 30 year amortization period (Amortization Term = 360). Installment payments are determined based on the 360 month.
M M M M M

Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-59
DD27 Amount Capitalized Total amount capitalized at the time of modification, including accrued interest and other advances as applicable.
For PRA and 2MP, Amount Capitalized must include delinquent interest, if not waived (delinquent and/or accrued interest payments due from the LPI date through the Official Modification Effective date), and escrow and/or advances paid to third parties. Then Subtract any amounts remaining in borrower suspense funds if applicable.

C
C C

If Principal Reduction Alternative (PRA) Code (DD592) = 2 or 3


Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
LIR-348
LIR-373
LIR-423
DD29 Association Dues/Fees Before Modification Existing monthly payment for association dues/fees before modification immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This amount should reflect the monthly amount of association dues/fees required to be paid by the borrower. In addition, if a displaced borrower is requesting modification for the principal residence from which the borrower was displaced and the borrower is paying rent to live elsewhere, the rent amount should be included with any association dues.
C
C C

If there are association fees that Servicer is withholding Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-239
LIR-240
LIR-241
DD30 Attorney Fees Not in Escrow Estimated legal fee not in escrow for advances capitalization and liquidation expense calculation.
C
C C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD31 Back Ratio After Modification The borrower's total debt-to-income ratio after modification. This is the borrower's total monthly expenses, including PITIA and other debt expenses, divided by their total monthly income. This includes Private Mortgage Insurance payments. Report to the 2nd decimal place (e.g. 50.25).
O
M M


Numeric(6,2) Data Range:
Min: 0
Max: 9999
LIR-72
LIR-139
LIR-341
LIR-472
DD32 Back Ratio Before Modification The borrower's total debt-to-income ratio based on the existing mortgage loan terms immediately prior to the Trial Period Plan Effective Date. This is the borrower's total monthly expenses, including PITIA and other debt expenses, divided by their total monthly income. This includes Private Mortgage Insurance payments.
Report to the 2nd decimal place (e.g. 50.25). Additionally, the value used in the trial loan set up data submission should reflect the income information used to establish the trial period plan terms, and the value used in the official loan set up data submission should reflect the income information used to establish the permanent modification terms.

M M M M


Numeric(6,2) Data Range:
Min: 0
Max: 9999
LIR-60
LIR-340
LIR-472
DD33 Borrower Contributions If the borrower is contributing any amounts, they must be reported here. For PRA, Borrower Contributions must include any amounts contributed by the Borrower or on behalf of the Borrower, which includes any amounts applied to the Pre-Mod UPB during Trial.
C
C C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-423
DD37 Borrower Execution Date For trial loan submission, this is the date that the borrower executed (signed) the trial documents if available. Otherwise it is the date of the first payment (through check, wire, or credit card).
For official loan submission, this is the date that the borrower signed the official loan modification documents.

M M M M M

Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2014-12-31
LIR-106
LIR-149
LIR-489
LIR-545
OMR-165
DD39 Borrower First Name The first name of the Borrower of record.
M M M M M

Text(100)
LIR-20
DD40 Borrower Last Name The last name of the Borrower. This is also known as the family name or surname.
M M M M M

Text(100)
LIR-21
DD43 Borrower Social Security Number The Social Security Number of the Borrower.
M M M M M

Text(9) Data Range:
Min: 000000001
Max: 999999998
LIR-116
LIR-209
LIR-228
LIR-336
LIR-338
LIR-449
LIR-450
LIR-451
LIR-452
LIR-519
LIR-521
LIR-527
LIR-603
LIR-604
LIR-605
LIR-606
DD55 Co-Borrower First Name The first name of the Co-Borrower of record.
C C C C C
If Co-Borrower on loan Text(100)
LIR-201
LIR-202
LIR-326
DD56 Co-Borrower Last Name The last name of the Co- Borrower of record.
C C C C C
If co-borrower on loan Text(100)
LIR-201
LIR-202
LIR-326
DD59 Co-Borrower Social Security Number The Social Security Number of the Co-Borrower.
O C O C C
If available Text(9) Data Range:
Min: 000000001
Max: 999999998
LIR-117
LIR-210
LIR-228
LIR-326
LIR-337
LIR-339
LIR-449
LIR-450
LIR-451
LIR-452
LIR-520
LIR-522
LIR-528
LIR-603
LIR-604
LIR-605
LIR-606
DD62 Date of Original Note The date the mortgage note was signed by the borrower.
M M M M M

Date(CCYY-MM-DD) Data Range:
Min: 1950-01-01
Max: 2009-01-01
LIR-36
LIR-92
LIR-296
LIR-297
DD390 Delinquency Type Code Indicates how long the loan was delinquent in the past 12 months at the time of NPV Run Date.
C
C C

If Principal Reduction Alternative (PRA) Code' is '2 or '3'.
Numeric(4,0) Enumerations:
1 = Less than or equal to 6 months delinquent in last 12 months
2 = Greater than 6 months delinquent in last 12 months
LIR-357
DD63 Delinquent Interest Delinquent interest for interest capitalization. It is the amount of delinquent interest from the delinquent loan's LPI date to the workout execution date.
O O M M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-50
LIR-139
DD64 Disbursement Forgiven If there are any forgiven disbursements for advances capitalization.
C
C C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD67 Escrow Payment After Modification Report the escrow amount expected in the first payment after loan modification. This is the amount of money that may be collected by the servicer as part of the regular monthly mortgage payment to cover, on behalf of the mortgagee, periodic payments of property taxes and hazard insurance. Any escrow shortage payment amounts must be included. Private Mortgage Insurance payments must be excluded.
M M M M M

Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-139
LIR-165
LIR-207
LIR-240
DD68 Escrow Payment Before Modification Report the monthly escrow payment amount calculated in the escrow analysis performed in conjunction with determining the borrowers eligibility for the most recent trial period plan for the modification being reported. The escrow analysis must be performed for all borrowers, including those that do not currently escrow for taxes and insurance. This is the amount of money that may be collected by the servicer as part of the regular monthly mortgage payment to cover, on behalf of the mortgagor, periodic payments of property taxes and hazard insurance. Any allowable escrow shortage payment amounts must be included. Private Mortgage Insurance payments must be excluded.
C
C C

If there is escrow amount that Servicer is withholding Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-207
LIR-239
LIR-241
DD69 Escrow Shortage for Advances Any escrow advance amounts to be capitalized.
C
C C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD72 First Lien Indicator Indicates if loan is first lien.
M M M M M
Boolean true/false LIR-43
DD74 First Payment Due Date After Modification For Trial Loan Submission, this is a projection of the first payment due date after modification. First Payment Due Date After Modification should be the same as the anticipated Modification Effective Date.

For Official Loan Submission, this is the actual first payment due date. First Payment Due Date After Modification should be the same as the actual Modification Effective Date.

M M M M M

Date(CCYY-MM-DD) Data Range:
Min: 2009-02-01
Max: 2014-09-30
LIR-83
LIR-178
LIR-191
LIR-195
LIR-494
DD593 Forbearance Plan Type Code A code indicating the type of forbearance period granted to the borrower.
O O O O


Numeric (4,0) Enumerations:
1 - Unemployment
2 - Federally Declared Disaster
3 - Unemployment and Federally Declared Disaster

LIR-308
LIR-309
LIR-310
LIR-313
LIR-316
LIR-359
LIR-360
LIR-361
LIR-363
DD75 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.
O
O O


Date(CCYY-MM-DD)
LIR-169
DD76 Front Ratio After Modification The borrower's housing-debt-to-income ratio after modification. This is the borrower's monthly housing expense divided by their total monthly income. Private Mortgage Insurance payments must be excluded. Report to the 2nd decimal place (e.g. 31.05). For Owner Occupied:
Monthly Housing Expense After Mod (DD112) / Monthly Gross Income (DD110)
For Non-Owner Occupied:
If Positive Cash Flow ( [(Gross Rental Income (DD956) * 75%) - Monthly Housing Expense After Mod (DD112) = Calculated Positive Cash Flow Value], then:
Primary Residence Total Housing Expense Amount (DD958) / [Monthly Gross Income (DD110) + Calculated Positive Cash Flow Value]
If Negative Cash Flow, or does not receive Rental Income ([[(Gross Rental Income (DD956) * 75%) - Monthly Housing Expense After Mod (DD112) = Calculated Negative Cash Flow Value], then:
[Primary Residence Total Housing Expense Amount (DD958) + Absolute Calculated Negative Cash Flow Value] / Monthly Gross Income (DD110)
Round to the nearest .0000001
M M M M M

Numeric(6,2) Data Range:
Min: 0.01
Max: 9999
LIR-73
LIR-139
LIR-341
LIR-490
LIR-491
LIR-499
LIR-500
LIR-550
DD77 Front Ratio Before Modification The borrower's housing-debt-to-income ratio based on the existing mortgage loan terms immediately prior to the Trial Period Plan Effective Date. This is the borrower's monthly housing expense divided by their total monthly income. Private Mortgage Insurance payments must be excluded. Report to the 2nd decimal place (e.g. 50.25). Additionally, the value used in the trial loan set up data submission should reflect the income information used to establish the trial period plan terms, and the value used in the official loan set up data submission should reflect the income information used to establish the permanent modification terms. For Owner Occupied:
Monthly Housing Expense Before Mod (DD113) / Monthly Gross Income (DD110)

For Non-Owner Occupied:
If Positive Cash Flow ( [(Gross Rental Income (DD956) * 75%) - Monthly Housing Expense Before Mod (DD113) = Calculated Positive Cash Flow Value], then:
Primary Residence Total Housing Expense Amount (DD958) / [Monthly Gross Income (DD110) + Calculated Positive Cash Flow Value]
If Negative Cash Flow, or does not receive Rental Income ([[(Gross Rental Income (DD956) * 75%) - Monthly Housing Expense Before Mod (DD113) = Calculated Negative Cash Flow Value], then:
[Primary Residence Total Housing Expense Amount (DD958) + Absolute Calculated Negative Cash Flow Value] / Monthly Gross Income (DD110)
Round to the nearest .0000001
M M M M M

Numeric(6,2) Data Range:
Min: 10.00
Max: 9999.99
LIR-61
LIR-244
LIR-245
LIR-246
LIR-340
LIR-498
LIR-500
LIR-501
LIR-608
DD5 GSE Loan Number A unique identifier assigned to each loan by a GSE (Fannie or Freddie).
C C C C

If GSE loan Text(30)
LIR-37
LIR-150
LIR-212
LIR-213
LIR-374
LIR-375
DD6 GSE Servicer Number The Fannie Mae or Freddie Mac unique Servicer identifier.
C
C C

If GSE loan Text(30)
LIR-153
LIR-230
DD8 HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program.
M M M M M M
Numeric(9)
LIR-19
LIR-219
LIR-249
LIR-427
LIR-429
LIR-430
LIR-431
LIR-444
LIR-445
LIR-446
LIR-454
LIR-480
LIR-518
LIR-519
LIR-520
LIR-521
LIR-527
LIR-528
LIR-603
LIR-604
LIR-605
LIR-606
OMR-19
OMR-98
OMR-119
DD78 Hardship Reason Code Identifies the reason for the borrower's hardship, on their mortgage payment obligations.
M M M M M

Numeric(4,0) Enumeration:
1. Death of borrower
2. Illness of principal borrower
3. Illness of borrower family member
4. Death of borrower family member
5. Martial difficulties
6. Curtailment of income
7. Excessive obligation
8. Abandonment of property
9. Distant employment transfer
10. Property problem
11. Inability to sell property
12. Inability to rent property
13. Military service
14. Other
15. Unemployment
16. Business failure
17. Casualty Loss
18. Energy environment costs
19. Servicing problems
20. Payment adjustment
21. Payment dispute
22. Transfer of ownership pending
23. Fraud
24. Unable to contact borrower
25. Incarceration
LIR-45
DD81 Interest Owed Or Payment Not Reported If there is Interest owed/received but not reported for interest capitalization, this field must be populated.
C
C C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD82 Interest Payment Interest portion of the principal and interest.





M
Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
OMR-31
OMR-116
DD83 Interest Rate After Modification The interest rate in the month after loan modification. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
M M M M M

Numeric(6,4) Data Range:
Min: 0
Max: 20
LIR-74
LIR-91
LIR-233
LIR-335
LIR-435
LIR-487
DD85 Interest Rate Before Modification The interest rate based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Please report as rounded to nearest 8th (e.g. 4.120% should be rounded to 4.125% and entered as 4.1250). Report 4 decimal places.
M M M M M

Numeric(6,4) Data Range:
Min: 0
Max: 99.9999
LIR-62
DD87 Interest Rate Lock Date for Modification For Trial loan submission, this is the date the borrower's trial period payment was calculated using the standard modification waterfall prior to the start of the trial period.

For Official loan submission, this is the date when the Max Interest Rate After Modification was determined in conjunction with the preparation of the Modification Agreement.

O
C C

If Program Type =
HMP1 - HMP Default
HMP2 - HMP Imminent Default
HMP7 - Current
Date(CCYY-MM-DD) Data Range:
Min: 2009-02-19
Max: 2014-09-30
LIR-108
LIR-185
LIR-434
LIR-493
LIR-528
LIR-539
LIR-545
DD9 Investor Code Owner of the mortgage.
M M M M M

Numeric(4,0) Enumeration:
1. Fannie Mae *
2. Freddie Mac *
3. Private *+
4. Portfolio * +
5. GNMA
6. FHA/VA
7. State or Local Housing
Finance Agency

* indicates Investor Codes currently eligible for HAMP and HAFA
+ indicates 3 and 4 are the only Investor Codes eligible if Program Type =
HMP21 - HMP Default
HMP22 - HMP Imminent Default
HMP27 - Current
LIR-34
LIR-93
LIR-115
LIR-211
LIR-308
LIR-319
LIR-343
LIR-374
LIR-375
LIR-380
LIR-507
LIR-620
LIR-621
LIR-623
LIR-624
DD525 Last Paid Installment Date This is the actual LPI date reported on the monthly reporting transaction.





M
Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2029-01-15
LIR-431
OMR-29
OMR-124
OMR-125
OMR-126
OMR-138
OMR-139
OMR-140
OMR-162
DD88 Last Paid Installment Date After Modification For Trial, this is the anticipated LPI Date after modification. It should be one month before the anticipated Modification Effective Date.

For the Official Modification, this is the actual LPI Date after Modification. It must be one month before the Modification Effective Date.

O
M M


Date(CCYY-MM-DD) Data Range:
Min: 2009-02-01
Max: 2014-09-30
LIR-75
LIR-177
LIR-192
LIR-196
LIR-495
DD89 Last Paid Installment Date Before Modification The due date of the last paid installment received on the loan immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.
M M M M M

Date(CCYY-MM-DD)
LIR-63
LIR-235
LIR-295
LIR-296
LIR-431
LIR-502
DD91 Length of Trial Period The length of the trial period.
M M M M M

Numeric(3,0) Data Range:
Min: 3
Max: 999
LIR-197
LIR-198
LIR-533
DD93 Loan Mortgage Type Code The code that specifies the type of mortgage being applied for or that has been granted.
M M M M M

Numeric(4,0) Enumeration:
1 - FHA - Loans insured by the Federal Housing Administration
2 - VA - Loans insured by the Department of Veterans Affairs
3 - Conventional with PMI - Non-government insured mortgages insured by a private (non-government) insurer
4 - Conventional w/o PMI - Mortgages with neither government nor private mortgage insurance.
5 - RD-HAMP - Loans guaranteed by the Department of Agriculture (Rural Development)


LIR-42
DD294 Loan Unpaid Principal Balance Amount The amount of outstanding principal (interest bearing portion only) at the end of the prior month, after accounting for all payment activity.





M
Currency (20,2) Min: 0
Max: 999999999999999999.99
OMR-28
OMR-121
OMR-122
OMR-133
DD98 Maturity Date After Modification The maturity date of the loan after modification.
O
M M


Date(CCYY-MM-DD) Data Range:
Max: 12-31-2059
LIR-76
LIR-182
LIR-505
OMR-126
DD99 Maturity Date Before Modification The date on which the mortgage obligation is scheduled to be paid off, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Maturity Date is commonly called Balloon Date for balloon loans, for which scheduled amortization does not pay off the balance of the loan, so that there is a final, large "balloon" payment at the end.
M M M M M

Date(CCYY-MM-DD) Data Range:
Min: 03-04-2009
Max: 12-31-2059
LIR-64
LIR-332
LIR-504
DD100 Max Interest Rate After Modification The interest rate cap for the loan.
Not applicable to Tier 2 loans since only Fixed Rate is allowed.

O
C C

If Program Type =
HMP1 - HMP Default
HMP2 - HMP Imminent Default
HMP7 - Current
Numeric(6,4) Data Range:
Min: 0
Max: 20
LIR-125
LIR-144
LIR-436
LIR-484
LIR-487
LIR-506
DD105 Modification Effective Date For Trial, this is the anticipated Modification Effective Date of the official loan modification. This is the first day of the month following the month when the last trial payment is due.

For Official, this is the actual Modification Effective Date of the official loan modification. This will still be the first day of the month following the month when the last trial payment is due. The Modification Effective Date on the official loan submission must be earlier than or equal to the date the official loan transaction is submitted.

M M M M M

Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2014-09-30
LIR-53
LIR-96
LIR-108
LIR-178
LIR-182
LIR-183
LIR-184
LIR-194
LIR-198
LIR-200
LIR-229
LIR-253
LIR-256
LIR-331
LIR-378
LIR-379
LIR-486
DD108 Modified Loan Term-Officer Signature Date Servicer sign off at the officer level for the loan modification. This is the date the servicer's officer approved the loan modification. This column will be populated for modification cases that need reclassification. There is no conversion needed for existing cases.
O
O O

Date(CCYY-MM-DD)
LIR-169
DD109 Monthly Debt Payments excluding PITIA Total amount of monthly debt payments excluding Principal, Interest, Taxes, Insurance and Association Dues (PITIA).




O
C C

If Program Type =
HMP1 - HMP Default
HMP2 - HMP Imminent Default
HMP7 - Current
Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-483
LIR-544
DD110 Monthly Gross Income Total monthly gross income as reported by the borrower and verified by the servicer. For evaluation of a non-owner-occupied property, exclude the rental income from the Monthly Gross Income for the property under evaluation. If there is income from additional rental properties, include the net income from these additional properties in the Monthly Gross Income. Report 2 decimals.
M M M M M

Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-46
LIR-139
LIR-207
LIR-241
LIR-499
LIR-501
LIR-550
LIR-608
DD956 Monthly Gross Rental Income Amount For the non-owner occupied property under evaluation, the monthly gross rental income received from the property before any costs or expenses. Report 2 decimals.
C
C C

Property Occupancy Status Code (DD149) is (1) Vacant or (3) Tenant Occupied Currency (20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-548
LIR-549
LIR-550
LIR-608
DD112 Monthly Housing Expense After Modification The borrower's monthly housing expense for the subject property after modification. This must include principal, interest, taxes, insurance, association dues (PITIA), and any escrow shortage payment amount. Private Mortgage Insurance payments must be excluded. Monthly Housing Expense After Modification = P&I After Modification + Escrow Payment After Modification (if exists) + Assoc Dues/Fees Before Modification (if exists) M M M M M

Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-77
LIR-139
LIR-240
LIR-497
LIR-499
LIR-550
DD113 Monthly Housing Expense Before Modification The borrower's monthly housing expense for the subject property based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This must include principal, interest, taxes, insurance, association dues (PITIA), and any escrow shortage payment amount. Private Mortgage Insurance payments must be excluded. Monthly Housing Expense Before Modification = P&I Before Modification + Escrow Payment Before Modification (if exists) + Assoc Dues/Fees Before Modification (if exists)

M M M M M

Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-65
LIR-139
LIR-239
LIR-312
LIR-497
LIR-501
LIR-608
DD119 NPV Date Date of the NPV submission used to determine trial modification eligibility. This should be the same NPV Date reported for the trial modification setup.
M M M M M

Date(CCYY-MM-DD) Data Range:
Min: 2009-02-01
Max: Today's System Date or 9-30-2014, whichever is earlier.
LIR-48
LIR-187
LIR-188
LIR-248
LIR-435
LIR-492
DD120 NPV Model Result Amount Post-mod Net Present Value amount generated from the model after modification.
M M M M M


Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
LIR-78
LIR-438
LIR-440
DD121 NPV Model Result Amount Pre-mod Net Present Value amount generated from the model before modification.
M M M M M

Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
LIR-66
LIR-438
LIR-513
DD124 Other Advances Other Advances - Other capitalized advance amounts excluding escrow fees and administrative or out-of pocket expenses. Examples include delinquency expenses or fees paid to a third party.
C
C C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD125 Other Contributions If there are any amounts contributed by the borrower due to Hazard Claims.
C
C C

If there are amounts contributed by borrower Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD126 Paydown or Payoff of Subordinate Liens Indicator of whether subordinate liens been paid off or paid down
C
C C

If subordinate liens paid off or paid down Boolean true/false
DD127 Paydown or Payoff of Subordinate Liens Amount Amount of paydown or payoff of subordinate liens.
C
C C C
If Paydown or Payoff of Subordinate Liens flag is "True" Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-57
DD958 Primary Residence Total Housing Expense Amount For the non-owner-occupied property under evaluation, the total monthly housing expense for the borrower’s primary residence (the PITIA). If borrower does not own a primary residence and therefore does not have principal PITIA but is paying rent to live elsewhere, use rent amount in this field. Report 2 decimals.
C
C C C
Property Occupancy Status Code (DD149) is (1) Vacant or (3) Tenant Occupied Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-546
LIR-547
LIR-550
LIR-608
DD132 Principal and Interest Payment After Modification The principal and interest amount after modification. P&I Payment After Modification = Monthly Gross Income * Front Ratio After Modification - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) M M M M M

Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-79
LIR-139
LIR-204
LIR-240
LIR-456
LIR-509
LIR-525
DD133 Principal and Interest Payment at 31% DTI Principal and Interest payable for a 31% Debt to Income ratio. This is equal to
i) 31% of the borrower's income less
ii) the Escrow Payment After Modification and the Association Dues.
For official, the most current verified income must be used.
P&I Payment at 31% DTI = Monthly Gross Income * 31% - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) C C C C C
If Program Type =
HMP1 - HMP Default
HMP2 - HMP Imminent Default
HMP7 - Current
Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-207
LIR-481
LIR-503
LIR-540
LIR-543
DD134 Principal and Interest Payment at 38% DTI Principal and Interest payable for a 38% Debt to Income ratio. This is equal to
i) 38% of the borrower's income less
ii) the Escrow Payment Before Modification and Association dues.
For official, the most current verified income must be used.
P&I Payment at 38% DTI = Monthly Gross Income * 38% - Escrow Payment Before Modification (if exists) - Association Dues/Fees Before Modification (if exists) C C C C C
If Program Type =
HMP1 - HMP Default
HMP2 - HMP Imminent Default
HMP7 - Current
Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-52
LIR-207
LIR-241
LIR-244
LIR-245
LIR-246
LIR-541
LIR-542
DD135 Principal and Interest Payment Before Modification The scheduled principal and interest amount based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. P&I Payment Before Modification = Monthly Gross Income * Front Ratio Before Modification - Escrow Payment Before Modification (if exists) - Association Dues/Fees Before Modification (if exists) M M M M M

Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-67
LIR-139
LIR-204
LIR-239
LIR-244
LIR-245
LIR-246
LIR-509
LIR-526
DD136 Principal Forbearance Amount The total amount in dollars of the principal that was deferred.
C
C C

if deferred Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-139
LIR-380
LIR-381
LIR-423
DD137 Principal Payment Principal portion of the principal and interest remitted monthly.





M
Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
OMR-30
OMR-117
DD138 Principal Payment Owed or Not Reported If borrower has contributed any cash or amounts in suspense.
C
C C

If borrower contributed cash or amounts in suspense Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD591 Principal Reduction Alternative Amount Principal Reduction Alternative (PRA) Amount is the principal forgiveness amount for PRA that is separate and exclusive
of any other principal forgiveness that may be offered in conjunction with the HAMP modification.

C
C C

If Principal Reduction Alternative (PRA) Code is 2 or 3. Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-346
LIR-347
LIR-348
LIR-358
LIR-437
LIR-441
DD592 Principal Reduction Alternative (PRA) Code A code indicating the waterfall used to modify the loan and if compensation is sought using the Principal Reduction Alternative Waterfall.

M
M M


Numeric(4,0) 1 - No PRA - standard waterfall
2 - PRA waterfall - incented forgiveness
3 - PRA waterfall - non-incented forgiveness
4 - No value. Record existed prior to attribute introduction (Restricted - not valid for servicer input)
LIR-342
LIR-343
LIR-344
LIR-345
LIR-346
LIR-351
LIR-352
LIR-353
LIR-354
LIR-355
LIR-357
LIR-358
LIR-373
LIR-423
LIR-437
LIR-441
LIR-517
DD570 Principal Reduction Alternative (PRA) NPV Model Result Amount Post-mod Net Present Value amount as generated by the principal reduction alternative (PRA) waterfall after modification.
C
C C

If 'Principal Reduction Alternative (PRA) Code' is '2 or '3'. Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
LIR-351
LIR-352
LIR-440
LIR-514
DD571 Principal Reduction Alternative (PRA) NPV Model Result Amount Pre-mod Net Present Value amount as generated by the principal reduction alternative (PRA) waterfall before modification.
C
C C

If 'Principal Reduction Alternative (PRA) Code' is '2 or '3'. Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
LIR-353
LIR-354
LIR-513
LIR-514
DD139 Principal Write-down (Forgiveness) Amount of principal written-down or forgiven inclusive of investor forgiveness (PRA, HHF matching, etc.) and other principal forgiveness assistance (e.g. HHF).
O
O O

if principal forgiven Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-139
LIR-358
LIR-365
LIR-380
LIR-381
LIR-423
LIR-437
LIR-517
DD140 Product After Modification The mortgage product of the loan, after the modification.
M M M M M

Numeric(4,0) Enumeration:
For First Lien Tier 1:
2. Fixed Rate
3. Step Rate

For First Lien Tier 2:
2. Fixed Rate
LIR-80
LIR-111
LIR-119
LIR-137
LIR-488
DD142 Product Before Modification The mortgage product of the loan, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.

If product is Step Rate, only reportable value is '3. Step Rate'.

M M M M M

Numeric(4,0) Enumeration:
1. ARM
2. Fixed rate
3. Step Rate
4. One Step Variable
5. Two Step Variable
6. Three Step Variable
7. Four Step Variable
8. Five Step Variable
9. Six Step Variable
10. Seven Step Variable
11. Eight Step Variable
12. Nine Step Variable
13. Ten Step Variable
14. Eleven Step Variable
15. Twelve Step Variable
16. Thirteen Step Variable
17. Fourteen Step Variable
LIR-68
DD10 Program Type/Campaign ID A program type that will identify campaign types. The unique identifier of a Loan Workout Campaign.
M M M M M
Text(14) Enumeration:
HMP1 - HMP Default
HMP2 - HMP Imminent Default
HMP7 - Current
HMP9 - FHA
HMP12 - Rural Development - HAMP
HMP21 - Tier 2 HMP Default
HMP22- Tier 2 HMP Imminent Default
HMP27 - Tier 2 Current
LIR-40
LIR-94
LIR-132
LIR-133
LIR-155
LIR-156
LIR-162
LIR-163
LIR-164
LIR-216
LIR-217
LIR-218
LIR-226
LIR-235
LIR-355
LIR-358
LIR-427
LIR-429
LIR-430
LIR-431
LIR-432
LIR-433
LIR-434
LIR-435
LIR-436
LIR-437
LIR-445
LIR-446
LIR-449
LIR-450
LIR-451
LIR-452
LIR-454
LIR-455
LIR-457
LIR-462
LIR-472
LIR-476
LIR-477
LIR-478
LIR-479
LIR-480
LIR-481
LIR-482
LIR-483
LIR-484
LIR-485
LIR-487
LIR-488
LIR-490
LIR-491
LIR-493
LIR-497
LIR-498
LIR-499
LIR-500
LIR-501
LIR-502
LIR-503
LIR-507
LIR-509
LIR-518
LIR-519
LIR-520
LIR-521
LIR-522
LIR-527
LIR-528
LIR-539
LIR-540
LIR-541
LIR-603
LIR-604
LIR-605
LIR-606
DD144 Projected Foreclosure Sale Date Projected date for foreclosure sale of subject property.
O
O O


Date(CCYY-MM-DD)
LIR-169
DD145 Property City The name of the city where the subject property is located.
M M M M M

Text(100)
LIR-28
DD146 Property Condition Code A code denoting the condition of the subject property.
M M M M M

Numeric(4,0) Enumeration:
1. Excellent
2. Good
3. Fair
4. Poor
LIR-26
DD148 Property Number of Units Number of units in subject property (Valid values are 1, 2, 3 or 4).
M M M M M

Numeric(4,0) Data Range:
Min: 1
Max: 4
LIR-23
DD149 Property Occupancy Status Code A code identifying the occupancy by the borrower of the subject property.
M M M M M

Numeric(4,0) Enumeration:
1. Vacant
2. Borrower Occupied
3. Tenant Occupied
4. Unknown
5. Occupied by Unknown
LIR-433
LIR-476
LIR-477
LIR-510
LIR-512
LIR-546
LIR-547
LIR-548
LIR-549
DD151 Property State The 2-character postal abbreviation of the state, province, or region of the subject property.
M M M M M

Text(2) Enumeration: WY,WV,WI,WA,VT,VI,VA,UT,TX,TN,SD,SC,RI,PR,PA,OR,OK,OH,NY,NV,NM,NJ,NH,NE,ND,NC,MT,MS,MO,MN,MI,ME,MD,MA,LA,KY,KS,IN,IL,ID,IA,HI,GU,GA,FL,DE,DC,CT,CO,CA,AZ,AR,AL,AK. LIR-118
DD152 Property Street Address The street address of the subject property.
M M M M M

Text(200)
LIR-27
DD155 Property Usage Type Code A code identifying the current use of the property by the borrower. For HAMP, FHA-HAMP and RD-HAMP this is determined at Loan Setup; for HAFA this is determined at the time of the HAFA Agreement Issue Date.
M M M M M

Numeric(4,0) Enumeration:
1. Principal Residence
2. Second or Vacation Home
3. Investment Property
LIR-451
LIR-452
LIR-478
LIR-479
LIR-510
LIR-512
LIR-525
LIR-526
DD157 Property Valuation As is Value Property as-is value determined by the property valuation.
M M M M M

Currency(20,2) Data Range:
Min: 1
Max: 999999999999999999.99
LIR-32
DD158 Property Valuation Date The date the property value analysis was performed.
M M M M M

Date(CCYY-MM-DD)
LIR-31
LIR-330
LIR-331
DD159 Property Valuation Method Type of value analysis.
M M M M M

Numeric(4,0) Enumeration:
1. Full appraisal - Prepared by a certified appraiser
2. Limited appraisal - Prepared by a certified appraiser
3. Broker Price Opinion “BPO” - Prepared by a real estate broker or agent
4. Desktop Valuation - Prepared by bank employee
5. Automated Valuation Model “AVM” - GSE
6. Automated Valuation Model "AVM" - Other
LIR-30
DD161 Property Zip Code The code designated by the postal service to direct the delivery of physical mail or which corresponds to a physical location. In the USA, this can take either a 5 digit form (ZIP Code) or a 9-digit form (ZIP + 4).
M M M M M

Numeric (5 or 9)
LIR-29
LIR-294
LIR-298
DD165 Remaining Term Before Modification The remaining number of months until the loan will be paid off, assuming that scheduled payments are made, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This will equal lesser of 1. The number of months until the actual balance of the loan will amortize to zero; or 2. The number of months difference between the LPI date and the Maturity Date.
M M M M M

Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-69
LIR-432
DD1003 Repurchase Type Code Identifies the status of the loan at the time of repurchase.
O
O O


Numeric (4,0) Enumerations:
1. Repurchased when a Trial
2. Repurchased when a Permanent GSE HAMP Modification
3. Repurchase Reported in Error
LIR-616
LIR-618
LIR-619
LIR-620
LIR-621
LIR-622
LIR-623
DD597 Restriction for Alternative Waterfall Type Code A code noting the restriction that prohibits principal write-down on the loan.
C
C C

If investor code is not Fannie Mae or Freddie Mac and post-arrearage MTMLTV >115% or Alternative Principal Forgiveness >0 but there is a condition associated to the loan that prevents it from being evaluated using the alternative waterfall Numeric (4,0) Enumerations:
1. Investor does not allow
LIR-345
LIR-349
LIR-365
DD14 Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan.
M M M M M M
Text(30)
LIR-33
LIR-219
LIR-427
LIR-429
LIR-430
LIR-431
LIR-444
LIR-445
LIR-446
LIR-480
LIR-518
LIR-519
LIR-520
LIR-521
LIR-527
LIR-528
LIR-603
LIR-604
LIR-605
LIR-606
OMR-20
OMR-96
OMR-119
DD201 Servicing Fee Percent After Modification Percentage of servicing Fee after loan modification ( e.g. 0.25).
O
O O


Numeric(4,2)

DD205 Step Interest Rate Step Number The sequence is used to uniquely identify and order Loan Interest Rate Adjustment schedule records specific to the loans step rate schedule.
O
C C

If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes Numeric(4) Data Range:
Min: 1
Max: 9999
LIR-122
LIR-137
LIR-179
DD209 Step New Interest Rate Duration The step duration for each corresponding step number.
O
C C

If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes Numeric(4) Data Range:
Min: 1
Max: 9999
LIR-123
LIR-129
DD206 Step Note Rate The new interest rate in the step schedule.
O
C C
C If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes Numeric(6,4) Data Range:
Min: 0
Max: 99.9999

LIR-120
LIR-125
LIR-142
LIR-148
LIR-179
OMR-132
DD208 Step Payment Effective Date The date the payment will be effective.
O
C C
C If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes Date(CCYY-MM-DD) Data Range:
Min: 2009-03-04
Max: 2029-01-15
LIR-121
LIR-128
LIR-130
LIR-141
OMR-33
OMR-112
OMR-136
OMR-137
OMR-141
DD207 Step Principal and Interest Payment The amount of the principal and/or interest payment due on the loan for each installment, beginning on the effective date.
O
C C
C If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-124
LIR-143
OMR-34
OMR-131
DD210 Submission Status The status of loan data being submitted.
M M M M M

Numeric(4,0) Enumeration
1. Trial
3. Official
5. Trial Cancel
6. Official Correction*
7. Official Cancel
LIR-35
LIR-132
LIR-133
LIR-155
LIR-156
LIR-162
LIR-163
LIR-164
LIR-216
LIR-217
LIR-218
LIR-219
LIR-220
LIR-226
LIR-231
LIR-234
LIR-238
LIR-252
LIR-253
LIR-254
LIR-255
LIR-256
LIR-427
LIR-429
LIR-430
LIR-431
LIR-444
LIR-445
LIR-446
LIR-449
LIR-450
LIR-451
LIR-452
LIR-454
LIR-457
LIR-480
LIR-482
LIR-492
LIR-518
LIR-519
LIR-520
LIR-521
LIR-522
LIR-527
LIR-528
OMR-145
OMR-146
OMR-147
DD678 Supplementary Assistance Code A code indicating the supplementary assistance provided to the borrower. This assistance may be provided to unemployed borrowers, principal reduction, funding to remove second liens, and programs that facilitate short sales and deeds-in-lieu of foreclosure.
M
M M


Numeric (4,0) Enumeration:
-None(1)
-Hardest Hit Fund(2)
- No value existed prior to attribute introduction(3) (Restricted - not valid for servicer input)

LIR-306
LIR-307
LIR-319
DD213 Term After Modification The remaining number of months until the loan will be paid off, assuming that scheduled payments are made. This will equal lesser of 1. the number of months until the actual balance of the loan will amortize to zero; or 2. the number of months difference between the LPI date and the Maturity Date. In this case, the Maturity Date is the Maturity Date after the modification and may be different from the original Maturity Date (before the modification).
O
M M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-81
LIR-95
LIR-167
DD959 Tier 2 Investor Override Indicator If there are any investor guidelines or applicable laws that restricts the terms of a modification under Tier 2, then select true. Otherwise select false.
C C C C

If Program Type =
HMP21 - Tier2 HMP Default
HMP22- Tier2 HMP Imminent Default
HMP27 - Tier2 Current
Boolean true/false LIR-432
LIR-455
LIR-462
DD401 Trial Plan Type Code Indicates if Borrowers substitute a Chapter 13 bankruptcy plan for a regular HAMP trial plan
M
M M


Numeric (4,0) 1. Standard Trial
2. Chapter 13 Bankruptcy
LIR-250
LIR-251
LIR-252
LIR-253
LIR-254
LIR-255
LIR-256
DD15 Underlying Trust Identifier This is the shelf and series security identifier associated with the security supported by the loan. A shelf offering is an SEC provision allowing an issuer to register a new issue security without selling the entire issue at once. Additionally, this may be the CUSIP identifier associated with the security. The CUSIP number is the identification number assigned to a security by CUSIP (Committee on Uniform Security Identification Procedures) for trading.
C
C C

Only for Non-GSE Text (20)
LIR-39
LIR-151
DD595 Unemployment Monthly Forbearance Amount The amount of the existing monthly mortgage payment that is not required to be paid during the Unemployment Program forbearance period.
C
C C

If Forbearance Plan Type Code is :
1-Unemployment.
or
3-Unemployment and Federally Declared Disaster.
Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-310
LIR-311
LIR-312
LIR-359
DD594 Unemployment Plan Forbearance Duration The total number of months for the completed unemployment forbearance period.
C
C C

If Forbearance Plan Type Code is :
1-Unemployment.
or
3-Unemployment and Federally Declared Disaster.
Numeric (4,0) Data Range:
Min: 1
Max: 99
LIR-313
LIR-314
LIR-315
LIR-360
DD596 Unemployment Plan Forbearance Initiation Month The first calendar day of the month in which the unemployment plan forbearance period begins
C
C C

If Forbearance Plan Type Code is :
1-Unemployment.
or
3-Unemployment and Federally Declared Disaster.
Date (CCYY-MM-DD) Data Range:
Min: 2010-05-01
Max: 2013-12-01
LIR-316
LIR-317
LIR-361
LIR-364
DD222 Unpaid Principal Balance After Modification The unpaid principal balance of a loan after the loan modification. The unpaid principal balance after modification excludes any applicable forbearance amount and can also be referred to as Net UPB Amount.
M M M M M

Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-82
LIR-423
DD225 Unpaid Principal Balance Before Modification The unpaid principal balance of a loan is the contractual UPB based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This UPB should not reflect any accounting based write-downs.
M M M M M

Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-70
LIR-90
LIR-348
LIR-423

Sheet 4: 2MP















Legend: 7/29/2013 Blue
ID Data Dictionary Definition Calculations Data Type/Data Length Condition Under Which Data is Required Allowable Values Loan Set-Up Second Lien Official Modification Second Lien Official Cancellation Loan Set-Up Second Lien Partial Extinguishment Second Lien Partial Extinguishment Cancellation Loan Set-Up Second Lien Extinguishment Second Lien Extinguishment Cancellation Second Lien Official Monthly Reporting
DD20 Action Code A code reported by the lender to update the loan that indicates the action that occurred during the reporting period.
Numeric(4,0) If there is an action Enumeration:
60 - Payoff






C
DD21 Action Code Date The effective date of the action associated with the action code specified on the incoming transaction by the servicer.
Date(CCYY-MM-DD) If there is an action Data Range:
Min: 2009-03-04
Max: 2029-01-15






C
DD297 Amortization Type After Modification The amortization type after modification.
Numeric (4,0)
Enumeration:
1. Amortizing*
2. Interest Only*
3. Partially Amortizing

*Indicates Amortization Types used in 2MP
M
M



DD299 Amortization Type Before Modification or Extinguishment The amortization type before modification or extinguishment.

Numeric (4,0)
Enumeration:
1. Amortizing
2. Interest Only
3. Partially Amortizing
M
M
M


DD27 Amount Capitalized Total amount capitalized at the time of modification, including accrued interest and other advances as applicable.
For PRA and 2MP, Amount Capitalized must include delinquent interest, if not waived (delinquent and/or accrued interest payments due from the LPI date through the Official Modification Effective date), and escrow and/or advances paid to third parties. Then Subtract any amounts remaining in borrower suspense funds if applicable.

Currency(20,2)
Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
O
O
O


DD38 Borrower Execution or Notification Date For official loan submission, this is the date that the borrower signed the official loan modification documents. For full extinguishment submission, this is the date the borrower was notified that the loan is to be extinguished.

Date(CCYY-MM-DD)

M
M
M


DD39 Borrower First Name The first name of the Borrower of record.
Text(100)

M
M
M


DD40 Borrower Last Name The last name of the Borrower. This is also known as the family name or surname.
Text(100)

M
M
M


DD43 Borrower Social Security Number The Social Security Number of the Borrower.
Text(9)
Data Range:
Min: 000000001
Max: 999999998
M
M
M


DD55 Co-Borrower First Name The first name of the Co-Borrower of record.
Text(100) If co-borrower on loan
C
C
C


DD56 Co-Borrower Last Name The last name of the Co- Borrower of record.
Text(100) If co-borrower on loan
C
C
C


DD59 Co-Borrower Social Security Number The Social Security Number of the Co-Borrower.
Text(9) If co-borrower on loan Data Range:
Min: 000000001
Max: 999999998
C
C
C


DD62 Date of Original Note The date the mortgage note was signed by the borrower.
Date(CCYY-MM-DD)
Data Range:
Min: 1950-01-01
Max: 2009-01-01
M
M
M


DD390 Delinquency Type Code Indicates how long the loan was delinquent in the past 12 months at the time of NPV Run Date.
Numeric(4,0)
Enumerations:
1 = Less than or equal to 6 months delinquent in last 12 months
2 = Greater than 6 months delinquent in last 12 months


M
M


DD75 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.
Date(CCYY-MM-DD) if foreclosure
C
C




DD8 HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program.
Numeric(9)

M M M M M M

DD80 Interest Only End Date The date on which the Interest Only loans begin to fully amortize before the modification.
Date(CCYY-MM-DD) Only if Product before Modification or Extinguishment is Interest Only
C
C




DD82 Interest Payment Interest portion of the principal and interest.
Currency(20,2)
Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99






M
DD83 Interest Rate After Modification The interest rate in the month after loan modification. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
Numeric(6,4)
Data Range:
Min: 0
Max: 20
M
M




DD86 Interest Rate Before Modification or Extinguishment The interest rate in the month prior to loan modification or extinguishment. Please report as rounded to nearest 8th (e.g. 4.125).
Numeric(6,4)

M
M
M


DD9 Investor Code Owner of the mortgage.
Numeric(4,0)
Enumeration:
1. Fannie Mae *
2. Freddie Mac *
3. Private *+
4. Portfolio * +
5. GNMA
6. FHA/VA
7. State or Local Housing
Finance Agency
M
M
M


DD525 Last Paid Installment Date This is the actual LPI date reported on the monthly reporting transaction.
Date(CCYY-MM-DD)
Data Range:
Min: 2009-03-04
Max: 2029-01-15






M
DD88 Last Paid Installment Date After Modification For the Official Modification, this is the actual LPI Date after Modification. It must be one month before the Modification Effective Date.
Date(CCYY-MM-DD)
Data Range:
Min: 2009-02-01
Max: 2014-09-30
M
M




DD90 Last Paid Installment Date Before Modification or Extinguishment The due date of the last paid installment of the loan.
Date(CCYY-MM-DD)

M
M
M


DD92 Lien Position The lien position of the loan.
Numeric(4)
Enumeration:
2
M
M
M


DD402 Loan Modification Fallout Reason Code A code that specifies the reason why a modification was not completed.
Numeric(4,0)
1. Ineligible Mortgage *+
2. Current DTI Less than 31%
3. Property Not Owner Occupied
4. Other Ineligible Property (i.e. Property Condemned, Property >4 units)
7. Negative NPV
8. Offer Not Accepted by Borrower / Request Withdrawn
11. Loan Paid off
12. Excessive Forbearance
13. Request Incomplete
14. Trial Plan Default +
15. Data Correction * +(Incorrect data)
16. Payor Request * +
17. Compliance Request * +
18. Submission Error Correction (Incorrect transaction type)* +

* Valid for 2MP

M
M
M

DD294 Loan Unpaid Principal Balance Amount The amount of outstanding principal (interest bearing portion only) at the end of the prior month, after accounting for all payment activity.
Currency (20,2)
Min: 0
Max: 999999999999999999.99






M
DD98 Maturity Date After Modification The maturity date of the loan after modification.
Date(CCYY-MM-DD)
Max: 12-31-2059 M
M




DD100 Max Interest Rate After Modification The interest rate cap for the loan.
Not applicable to Tier 2 loans since only Fixed Rate is allowed.

Numeric(6,4)
Data Range:
Min: 0
Max: 20
M
M




DD107 Modification or Extinguishment Effective Date The date on which the loan modification or extinguishment becomes effective.
Date(CCYY-MM-DD)

M
M
M


DD116 Mortgage Insurance Waiver Code For loans that have mortgage insurance coverage, this attribute indicates whether the mortgage insurer approved transaction and waives any right to collect additional sums from the borrower(s).

Numeric (4,0) If exists Enumerations:
1. Waiver approved
2. Waiver not approved
3. No mortgage insurance
C
C
C


DD128 Payment After Modification The P&I amount after modification.
Currency(20,2)

M
M




DD129 Payment Before Modification or Extinguishment The scheduled principal and interest payment in the month prior to loan modification or extinguishment. For Interest Only loans, it is only the scheduled interest payment in the month prior to loan modification or extinguishment.
Currency(20,2)

M
M
M


DD130 Percentage of Amortizing UPB Indicates the percentage of Unpaid Principal Balance of the loan that is amortized, before modification for the modification being reported.
Numeric(6,4) Only if Product before Modification or Extinguishment is 'Partially Amortizing'
C
C




DD136 Principal Forbearance Amount The total amount in dollars of the principal that was deferred.
Currency(20,2) if deferred Data Range:
Min: 0
Max: 999999999999999999.99
C
C




DD137 Principal Payment Principal portion of the principal and interest remitted monthly.
Currency(20,2)
Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99






M
DD139 Principal Write-down (Forgiveness) Amount of principal written-down or forgiven inclusive of investor forgiveness (PRA, HHF matching, etc.) and other principal forgiveness assistance (e.g. HHF).
Currency(20,2) if principal forgiven Data Range:
Min: 0
Max: 999999999999999999.99
C
M
M


DD140 Product After Modification The mortgage product of the loan, after the modification.
Numeric(4,0)
Enumeration:
2. Fixed Rate
3. Step Rate
M
M




DD143 Product Before Modification or Extinguishment The mortgage product of the loan, before the modification or extinguishment.
Numeric(4,0)
Enumeration:
1. ARM
2. Fixed rate
3. Step Rate
4. One Step Variable
5. Two Step Variable
6. Three Step Variable
7. Four Step Variable
8. Five Step Variable
9. Six Step Variable
10. Seven Step Variable
11. Eight Step Variable
12. Nine Step Variable
13. Ten Step Variable
14. Eleven Step Variable
15. Twelve Step Variable
16. Thirteen Step Variable
17. Fourteen Step Variable
M
M
M


DD10 Program Type/Campaign ID A program type that will identify campaign types. The unique identifier of a Loan Workout Campaign.
Text(14) Enumeration:
HMP8 - Second Lien Official Modifications and Not Approved / Not Accepted
HMP10 - Second Lien Full Extinguishments
HMP11 - Second Lien Partial Extinguishments
M M M M M M

DD144 Projected Foreclosure Sale Date Projected date for foreclosure sale of subject property.
Date(CCYY-MM-DD) if foreclosure
C
C




DD145 Property City The name of the city where the subject property is located.
Text(100)

M
M
M


DD151 Property State The 2-character postal abbreviation of the state, province, or region of the subject property.
Text(2)
Enumeration: WY,WV,WI,WA,VT,VI,VA,UT,TX,TN,SD,SC,RI,PR,PA,OR,OK,OH,NY,NV,NM,NJ,NH,NE,ND,NC,MT,MS,MO,MN,MI,ME,MD,MA,LA,KY,KS,IN,IL,ID,IA,HI,GU,GA,FL,DE,DC,CT,CO,CA,AZ,AR,AL,AK. M
M
M


DD152 Property Street Address The street address of the subject property.
Text(200)

M
M
M


DD153 Property Type Code A code that defines the type of property that the loan is associated with the loan.
Numeric(4,0)
Enumeration:
1. Single Family 1 to 4 Units
2. Condominium/Planned Unit Development (PUD)
3. Coop
4. Mobile Home
5. Zero-Lot-Line
6. Unknown
M
M
M


DD161 Property Zip Code The code designated by the postal service to direct the delivery of physical mail or which corresponds to a physical location. In the USA, this can take either a 5 digit form (ZIP Code) or a 9-digit form (ZIP + 4).
Numeric (5 or 9)

M
M
M


DD467 Second Lien GSE Loan Number A unique identifier assigned to each loan by a GSE (Fannie or Freddie).
Text(30) If GSE loan
C
C
C


DD468 Second Lien GSE Servicer Number The Fannie Mae or Freddie Mac unique Servicer identifier.
Text(30) If GSE loan
C
C
C


DD469 Second Lien HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program.
Numeric(9)

M M M M M M M
DD166 Second Lien Release Indicator Indicates that the lien has been released. The servicer must provide evidence of the second lien release, via this data attribute, when submitting a request for extinguishment payment.
Boolean
true/false

M
M


DD470 Second Lien Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan.
Text(30)

M M M M M M M
DD296 Second Lien Trial Type Code A code that specifies if the loan required a trial period and if the trial was performed.
Numeric(4,0)
Enumeration:
1. Trial Not Required/Trial Not Performed
2. Trial Not Required/Trial Performed
3. Trial Required/Trial Performed
M
M
M


DD14 Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan.
Text(30)

M M M M M M

DD205 Step Interest Rate Step Number The sequence is used to uniquely identify and order Loan Interest Rate Adjustment schedule records specific to the loans step rate schedule.
Numeric(4) If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes
Not applicable for FHA
Data Range:
Min: 1
Max: 9999
C
C


C
DD209 Step New Interest Rate Duration The step duration for each corresponding step number.
Numeric(4) If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes
Not applicable for FHA
Data Range:
Min: 1
Max: 9999
C
C


C
DD206 Step Note Rate The new interest rate in the step schedule.
Numeric(6,4) If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes
Not applicable for FHA
Data Range:
Min: 0
Max: 99.9999

C
C


C
DD208 Step Payment Effective Date The date the payment will be effective.
Date(CCYY-MM-DD) If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes
Not applicable for FHA
Data Range:
Min: 2009-04-01
Max: 2029-01-01
C
C


C
DD207 Step Principal and Interest Payment The amount of the principal and/or interest payment due on the loan for each installment, beginning on the effective date.
Currency(20,2) If 1MP or 2MP and Product After Modification is Step Rate and if the rate changes
Not applicable for FHA
Data Range:
Min: 0.01
Max: 999999999999999999.99
C
C


C
DD210 Submission Status The status of loan data being submitted.
Numeric(4,0)
Enumeration:
14. 2MP Official
15. 2MP Official Cancel
16. 2MP Partial Extinguishment
17. 2MP Extinguishment
18. 2MP Partial Extinguishment Cancel
19. 2MP Partial Extinguishment Correction
20. 2MP Official Correction
21. 2MP Extinguishment Cancel
22. 2MP Extinguishment Correction
23. 2MP Not Approved/Not Accepted
24. 2MP Not Approved/Not Accepted Cancel
M M M M M M

DD213 Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation.
Numeric(4,0)
Data Range:
Min: 1
Max: 480
M
M




DD214 Term Before Modification or Extinguishment Represents the number of months on which installment payments are based.
Numeric(4)
Data Range:
Min: 1
Max: 9999
M
M
M


DD15 Underlying Trust Identifier This is the shelf and series security identifier associated with the security supported by the loan. A shelf offering is an SEC provision allowing an issuer to register a new issue security without selling the entire issue at once. Additionally, this may be the CUSIP identifier associated with the security. The CUSIP number is the identification number assigned to a security by CUSIP (Committee on Uniform Security Identification Procedures) for trading.
Text (20) Only for Non-GSE
C
C
C


DD222 Unpaid Principal Balance After Modification The unpaid principal balance of a loan after the loan modification. The unpaid principal balance after modification excludes any applicable forbearance amount and can also be referred to as Net UPB Amount.
Currency(20,2)
Data Range:
Min: 0.01
Max: 999999999999999999.99
M
M




DD226 Unpaid Principal Balance Before Modification or Extinguishment The total principal amount outstanding prior to the effective date of the modification or extinguishment.
Currency(20,2)

M
M
M



Sheet 5: HAFA















M=Mandatory; C=Conditional; O=Optional

Legend: 11/1/2012 - Purple; 7/29/2013 - Blue
Ref ID Name of Data Point Descriptions Short Sale or Deed-in-Lieu Notification Loan Set-Up Short Sale Loan Set-Up Deed-in-Lieu Cancellation Condition Under Which Data is Required Data Type / Data Length Allowable Values Associated Rules
DD22 Agreement Expiration Date The expiration date of the Short Sale Notice (SSN), Pre-Approved HAFA Short Sale, Deed-in-Lieu Agreement or servicer's proprietary form DIL notice or agreement. M M M

Date(CCYY-MM-DD) Date Range:
Min: 2010-01-29
Max: 2014-09-30
HAFLIR-57
HAFLIR-58
HAFLIR-59
HAFLIR-62


DD23 Agreement Issue Date This is the date that the Short Sale Notice (SSN), Pre-Approved HAFA Short Sale, Deed-in Lieu (DIL) Agreement or servicer's proprietary form DIL notice or agreement were issued. M M M

Date(CCYY-MM-DD) Data Range:
Min:2009-10-01
Max:2013-12-31
HAFLIR-53
HAFLIR-54
HAFLIR-55
HAFLIR-56
HAFLIR-59
HAFLIR-70
HAFLIR-221
HAFLIR-222
DD37 Borrower Execution Date This is the date that the borrower signed any short sale agreement, if a servicer uses such an agreement and requires the borrower’s signature thereon, or deed-in-lieu agreement, if a servicer requires the borrower’s signature on such agreement. If the servicer uses a unilateral document to communicate terms of pre-approved HAFA short sale or deed-in-lieu of foreclosure, this is the date when that document was issued. M M M

Date(CCYY-MM-DD) Data Range:
Min: 2009-10-01
Max: No limit
HAFLIR-50
HAFLIR-51
HAFLIR-53
HAFLIR-97
HAFLIR-168

DD39 Borrower First Name The first name of the Borrower of record. M M M

Text(100)
HAFLIR-19
DD40 Borrower Last Name The last name of the Borrower. This is also known as the family name or surname. M M M

Text(100)
HAFLIR-18
DD43 Borrower Social Security Number The Social Security Number of the Borrower. M M M

Text(9) Data Range:
Min: 000000001
Max: 999999998
HAFLIR-20
HAFLIR-21
HAFLIR-23
HAFLIR-157
HAFLIR-160
HAFLIR-195
HAFLIR-197

DD55 Co-Borrower First Name The first name of the Co-Borrower of record. O O O

Text(100)
HAFLIR-26
HAFLIR-191

DD56 Co-Borrower Last Name The last name of the Co- Borrower of record. O O O

Text(100)
HAFLIR-24
HAFLIR-191

DD59 Co-Borrower Social Security Number The Social Security Number of the Co-Borrower. O O O

Text(9) Data Range:
Min: 000000001
Max: 999999998
HAFLIR-28
HAFLIR-29
HAFLIR-157
HAFLIR-161
HAFLIR-191
HAFLIR-196
HAFLIR-198

DD62 Date of Original Note The date the mortgage note was signed by the borrower. M M M

Date(CCYY-MM-DD) Data Range:
Min: 1950-01-01
Max: 2009-01-01
HAFLIR-41
HAFLIR-42
HAFLIR-43
HAFLIR-188

DD223 Final Unpaid Principal Balance Amount The final unpaid principal balance, including interest bearing principal balance, any principal forbearance amount and any outstanding capitalized interest, at the time of closing for a Short Sale or Deed-in-Lieu transaction. M M M

Currency (20,2) Data Range:
Min: 0.01
Max: 1,403,400
HAFLIR-84
HAFLIR-85
HAFLIR-86
HAFLIR-87
HAFLIR-88
HAFLIR-89

DD77 Front Ratio Before Modification The front-end DTI (principal, interest, taxes, insurance and association dues (PITIA) and any escrow shortage payment amount) housing ratio as of the HAMP modification evaluation. C C C
Required if Investor Code is either 1 (Fannie Mae) or 2 (Freddie Mac). Numeric(6,2)
HAFLIR-44
HAFLIR-45
HAFLIR-218

DD5 GSE Loan Number A unique identifier assigned to each loan by a GSE (Fannie or Freddie). O O O
If GSE loan Text(30)
HAFLIR-12
HAFLIR-13
HAFLIR-14
HAFLIR-200
HAFLIR-201

DD6 GSE Servicer Number The Fannie Mae or Freddie Mac unique Servicer identifier. O O O
If GSE loan Text(30)
HAFLIR-10
DD7 HAMP Registration Number The unique identifier for the servicer participating in the HAMP program. M M M M
Numeric(15)
HAFLIR-3
HAFLIR-4
HAFLIR-5
HAFLIR-156
HAFLIR-157
HAFLIR-174

DD8 HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program. M M M M
Numeric(9)
HAFLIR-5
HAFLIR-6
HAFLIR-7
HAFLIR-156
HAFLIR-157
HAFLIR-170
HAFLIR-186
HAFLIR-206
HAFLIR-207
HAFLIR-208
HAFLIR-209

DD9 Investor Code Owner of the mortgage. M M M

Numeric(4,0) Enumeration:
1. Fannie Mae *
2. Freddie Mac *
3. Private *+
4. Portfolio * +
5. GNMA
6. FHA/VA
7. State or Local Housing
Finance Agency

* indicates Investor Codes currently eligible for HAMP and HAFA
HAFLIR-10
HAFLIR-15
HAFLIR-16
HAFLIR-17
HAFLIR-44
HAFLIR-45
HAFLIR-100
HAFLIR-194
HAFLIR-200
HAFLIR-201
HAFLIR-213
HAFLIR-218
HAFLIR-223
HAFLIR-224

DD94 Loan Delinquency Status Type Code A code specifying whether the loan is in default, imminent default or current status as of the HAMP modification evaluation. M M M

Numeric(4,0) Enumeration:
1. Default
2. Imminent Default
3. Current
HAFLIR-48
HAFLIR-49

DD104 Minimum Net Return to Investor Amount The Minimum Net Return to Investor is the calculated Minimum Acceptable Net Proceeds amount that the investor is willing to accept from the transaction. It must be at least equal to or less than the list price minus the sum of allowable costs that may be deducted from gross sale proceeds or acceptable sale proceeds. The Minimum Net Return to Investor must be reported as a dollar amount.
C M O
Required if Program Type/Campaign ID (DD10) is HMP5 (Short Sale with Relocation Compensation) or HMP25 (Short Sale without Relocation Compensation). Currency (20,2) Data Range:
Min:0.01
Max:1403400.00
HAFLIR-79
HAFLIR-80
HAFLIR-81

DD116 Mortgage Insurance Waiver Code For loans that have mortgage insurance coverage, this attribute indicates whether the mortgage insurer approved transaction and waives any right to collect additional sums from the borrower(s).
O M M
If exists Numeric (4,0) Enumerations:
1. Waiver approved
2. Waiver not approved
3. No mortgage insurance
HAFLIR-82
HAFLIR-83
HAFLIR-166

DD10 Program Type/Campaign ID A program type that will identify campaign types. The unique identifier of a Loan Workout Campaign. M M M
Text(14) Enumeration (for HAFA):
HMP3 - Deed-in-lieu with Relocation Compensation
HMP5 - Short Sale with Relocation Compensation
HMP23 - Deed-in-lieu without Relocation Compensation
HMP25 - Short Sale without Relocation Compensation
HAFLIR-31
HAFLIR-32
HAFLIR-71
HAFLIR-74
HAFLIR-79
HAFLIR-143
HAFLIR-145
HAFLIR-172
HAFLIR-184
HAFLIR-203
HAFLIR-222
HAFLIR-223
HAFLIR-227

DD145 Property City The name of the city where the subject property is located. M M M

Text(100)
HAFLIR-36
DD147 Property List Price At notification this is the original list price of the property. At extension or correction, it is the latest list price of the property as of the extension or correction. At loan set up, it is the ending list price of the property as of the Transaction Closing Date. C M O
Required if Program Type/Campaign ID (DD10) is HMP5 (Short Sale with Relocation Compensation) or HMP25 (Short Sale without Relocation Compensation) Currency (20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
HAFLIR-71
HAFLIR-72
HAFLIR-81

DD148 Property Number of Units Number of units in subject property (Valid values are 1, 2, 3 or 4). M M M

Numeric(4,0) Data Range:
Min: 1
Max: 4
HAFLIR-86
HAFLIR-87
HAFLIR-88
HAFLIR-89
HAFLIR-105
HAFLIR-173

DD150 Property Sale or Transaction Amount The sale or transfer price of the property. O M M

Currency (20,2) Data Range
Min: 0.01
Max: 999999999999999999.99
HAFLIR-90
HAFLIR-92

DD151 Property State The 2-character postal abbreviation of the state, province, or region of the subject property. M M M

Text(2) Enumeration: WY,WV,WI,WA,VT,VI,VA,UT,TX,TN,SD,SC,RI,PR,PA,OR,OK,OH,NY,NV,NM,NJ,NH,NE,ND,NC,MT,MS,MO,MN,MI,ME,MD,MA,LA,KY,KS,IN,IL,ID,IA,HI,GU,GA,FL,DE,DC,CT,CO,CA,AZ,AR,AL,AK. HAFLIR-37
HAFLIR-38

DD152 Property Street Address The street address of the subject property. M M M

Text(200)
HAFLIR-35
DD155 Property Usage Type Code A code identifying the current use of the property by the borrower. For HAMP, FHA-HAMP and RD-HAMP this is determined at Loan Setup; for HAFA this is determined at the time of the HAFA Agreement Issue Date. M M M

Numeric(4,0) Enumeration:
1. Principal Residence
2. Second or Vacation Home
3. Investment Property
HAFLIR-46
HAFLIR-47
HAFLIR-213
HAFLIR-221
HAFLIR-227

DD156 Property Vacancy Date The written communication approving a HAFA short sale or a deed-in-lieu of foreclosure will state the date by which the property must be vacated. C C C
Required if Program Type/Campaign ID is HMP3 or HMP5. Date(CCYY-MM-DD) Data range:
Min: 2010-02-28
HAFLIR-74
HAFLIR-75

DD161 Property Zip Code The code designated by the postal service to direct the delivery of physical mail or which corresponds to a physical location. In the USA, this can take either a 5 digit form (ZIP Code) or a 9-digit form (ZIP + 4). M M M

Numeric (5 or 9)
HAFLIR-39
HAFLIR-40
HAFLIR-187
HAFLIR-189
HAFLIR-190

DD14 Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan. M M M M
Text(30)
HAFLIR-5
HAFLIR-8
HAFLIR-156
HAFLIR-157
HAFLIR-206
HAFLIR-207
HAFLIR-208
HAFLIR-209

DD202 Short Sale or Deed-in-Lieu Cancellation Reason Code A field indicating the reason why a Short Sale or Deed-in-Lieu transaction was cancelled.


M
Numeric(4,0) Enumeration:
1. Agreement Expiration
2. Agreement Termination
3. Notification Cancellation
4. Loan Set up Cancellation
5. Servicing Transfer of HAMP loan
6. Payoff of HAMP loan
7. Other
HAFLIR-102
HAFLIR-103
HAFLIR-129

DD203 Short Sale or Deed-in-Lieu Reason Code A field identifying the reason for the borrower entering into a Short Sale or Deed-in-Lieu transaction. M M M

Numeric(4,0) Enumeration:
1. Does not qualify for a Trial Period Plan
2. Does not successfully complete a Trial Period Plan
3. Is delinquent on a HAMP modification by missing at least two consecutive payments
4. Requests a Short Sale or Deed-in-Lieu
HAFLIR-63
HAFLIR-64
HAFLIR-65
HAFLIR-66
HAFLIR-148
HAFLIR-149

DD204 Short Sale or Deed-in-Lieu Reason Date For loans that do not qualify for a HAMP trial modification or the borrower declines a modification, this is the date that a trial modification was not offered to the borrower or was not accepted by the borrower. For a borrower who did not successfully complete a trial plan, this is the trial fall out date. O O O

Date(CCYY-MM-DD) Data Range:
Min: 2009-02-03
Max: 2013-12-31
HAFLIR-67
HAFLIR-69
HAFLIR-70
HAFLIR-149

DD210 Submission Status The status of loan data being submitted. M M M M
Numeric(4,0) Enumeration (for HAFA):
8. Short Sale or Deed-in-Lieu Notification
9. Short Sale Loan Set-up
10. Deed-in-Lieu Loan Set-up
11. HAFA Cancel
12. HAFA Correction
13. Short Sale or Deed-in-Lieu Extension
HAFLIR-33
HAFLIR-34
HAFLIR-82
HAFLIR-90
HAFLIR-93
HAFLIR-95
HAFLIR-99
HAFLIR-102
HAFLIR-110
HAFLIR-112
HAFLIR-113
HAFLIR-114
HAFLIR-122
HAFLIR-142
HAFLIR-143
HAFLIR-145
HAFLIR-156
HAFLIR-159
HAFLIR-169
HAFLIR-172

DD212 Subordinate Lien Release Reimbursement Amount The total amount of reimbursement paid by the servicer to the subordinate mortgage lien holder(s) to secure release of the subordinate mortgage lien(s).
O M M

Currency (20,2) Data Range:
Min: 0
Max: 8,500
HAFLIR-99
HAFLIR-100
HAFLIR-224
HAFLIR-220

DD678 Supplementary Assistance Code A code indicating the supplementary assistance provided to the borrower. This assistance may be provided to unemployed borrowers, principal reduction, funding to remove second liens, and programs that facilitate short sales and deeds-in-lieu of foreclosure. M M M

Numeric (4,0) Enumeration:
1. None
2. Hardest Hit Fund
3. No value existed prior to attribute introduction (Restricted - not valid for servicer input)
HAFLIR-192
HAFLIR-193
HAFLIR-194

DD215 Total Allowable Costs The total allowable transaction costs associated with selling the property that can be deducted from the gross sale price at closing. Allowable costs may include subordinate lien release reimbursement amount, borrower relocation assistance, sales commission, closing costs for taxes, title, attorney fees and other miscellaneous expenses. The closing costs and real estate commissions should be reasonable and customary based on the community in which the property is located. O M O

Currency (20,2) Data Range;
Min: 0
Max: 999999999999999999.99
HAFLIR-93
HAFLIR-94

DD216 Transaction Closing Date The date on which the Short Sale or Deed-in-Lieu transaction is completed. O M M

Date(CCYY-MM-DD) Data Range:
Min: No minimum
Max: 2014-09-30
HAFLIR-95
HAFLIR-96
HAFLIR-97
HAFLIR-211
HAFLIR-219
HAFLIR-220


Sheet 6: FHA HAMP

















M=Mandatory; C=Conditional; O=Optional Legend: Green 04/01/2013 Blue 7/29/2013
Ref ID Name of Data Point Description Calculation FHA Trial Set-Up FHA Trial Cancel FHA Official Set-up FHA Official Cancel Official Monthly Reporting Condition Under Which Data Is Required Data Type/Data Length Allowable Values Associated Rules
DD17 1st Trial Payment Due Date This is the date that the first trial payment is due. It is also the trial modification effective date. This date must be less than the trial loan submission date.
M
O

If exists Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-06-30

LIR-169
LIR-183
LIR-198
LIR-278
LIR-279
LIR-283
LIR-285
LIR-295
DD18 1st Trial Payment Posted Date The date the first payment posted during the Trial period.
M
O


Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-06-30

LIR-277
LIR-281
LIR-284
LIR-378
LIR-379
DD19 1st Trial Payment Received Amount This is the actual amount of the Payment received from the Borrower to the Servicer for the 1st Trial payment.
M
O


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-282
DD20 Action Code A code reported by the lender to update the loan that indicates the action that occurred during the reporting period.




C If there is an action Numeric(4,0) Enumeration:
60 - Payoff
OMR-35
OMR-36
OMR-113
OMR-122
OMR-133
DD21 Action Code Date The effective date of the action associated with the action code specified on the incoming transaction by the servicer. The action date is required for certain action codes.






C If there is an action Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2029-01-15

OMR-36
OMR-113
OMR-123
OMR-124
OMR-135
OMR-148
OMR-160
OMR-162
DD24 Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation.

M
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-71
LIR-95
LIR-166
LIR-261
DD26 Amortization Term Before Modification Represents the number of months on which installment payments are based under the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Example: Balloon loans have a seven year life (Loan Term = 84) but a 30 year amortization period (Amortization Term = 360). Installment payments are determined based on the 360 month.
M
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-59
DD29 Association Dues/Fees Before Modification Existing monthly payment for association dues/fees before modification immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This amount should reflect the monthly amount of association dues/fees required to be paid by the borrower. In addition, if a displaced borrower is requesting modification for the principal residence from which the borrower was displaced and the borrower is paying rent to live elsewhere, the rent amount should be included with any association dues.
C
C

If there are association fees that Servicer is withholding
Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

LIR-239
LIR-240
LIR-242
LIR-243
LIR-247
DD31 Back Ratio After Modification The borrower's total debt-to-income ratio after modification. This is the borrower's total monthly expenses, including PITIA and other debt expenses, divided by their total monthly income. This includes Private Mortgage Insurance payments. Report to the 2nd decimal place (e.g. 50.25).


O
M


Numeric(6,2) Data Range:
Min: 0
Max: 9999
LIR-72
LIR-341
LIR-382
DD32 Back Ratio Before Modification The borrower's total debt-to-income ratio based on the existing mortgage loan terms immediately prior to the Trial Period Plan Effective Date. This is the borrower's total monthly expenses, including PITIA and other debt expenses, divided by their total monthly income. This includes Private Mortgage Insurance payments.
Report to the 2nd decimal place (e.g. 50.25). Additionally, the value used in the trial loan set up data submission should reflect the income information used to establish the trial period plan terms, and the value used in the official loan set up data submission should reflect the income information used to establish the permanent modification terms.


M
M


Numeric(6,2) Data Range:
Min: 0
Max: 9999
LIR-60
LIR-340
LIR-382
DD33 Borrower Contributions If the borrower is contributing any amounts, they must be reported here.


C
C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD37 Borrower Execution Date For trial loan submission, this is the date that the borrower executed (signed) the trial documents if available. Otherwise it is the date of the first payment (through check, wire, or credit card).
For official loan submission, this is the date that the borrower signed the official loan modification documents.

M
M


Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-12-31
LIR-106
LIR-107
LIR-112
LIR-273
DD39 Borrower First Name The first name of the Borrower of record.
M
M


Text(100)
LIR-20
DD40 Borrower Last Name The last name of the Borrower. This is also known as the family name or surname.
M
M


Text(100)
LIR-21
DD43 Borrower Social Security Number The Social Security Number of the Borrower.
M
M


Text(9) Data Range:
Min: 000000001
Max: 999999998
LIR-116
LIR-174
LIR-209
LIR-228
LIR-232
LIR-328
LIR-329
LIR-336
LIR-338
DD55 Co-Borrower First Name The first name of the Co-Borrower of record.
C
C

If co-borrower on loan Text(100)
LIR-201
LIR-202
LIR-326
DD56 Co-Borrower Last Name The last name of the Co- Borrower of record.
C
C

If co-borrower on loan Text(100)
LIR-201
LIR-202
LIR-326
DD59 Co-Borrower Social Security Number The Social Security Number of the Co-Borrower.
C
C

If available

Text(9) Data Range:
Min: 000000001
Max: 999999998
LIR-117
LIR-174
LIR-210
LIR-228
LIR-232
LIR-326
LIR-328
LIR-329
LIR-337
LIR-339
DD62 Date of Original Note The date the mortgage note was signed by the borrower.
M
M


Date(CCYY-MM-DD) Data Range:
Min: 1950-01-01
Max: 2009-01-01
LIR-36
LIR-92
LIR-296
LIR-297
DD63 Delinquent Interest Delinquent interest for interest capitalization. It is the amount of delinquent interest from the delinquent loan's LPI date to the workout execution date.
O
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-50
LIR-139
DD64 Disbursement Forgiven If there are any forgiven disbursements for advances capitalization.
C
C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD67 Escrow Payment After Modification Report the escrow amount expected in the first payment after loan modification. This is the amount of money that may be collected by the servicer as part of the regular monthly mortgage payment to cover, on behalf of the mortgagee, periodic payments of property taxes and hazard insurance. Any escrow shortage payment amounts must be included. Private Mortgage Insurance Payments must be included.
M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-139
LIR-165
LIR-240
LIR-242
LIR-243
DD68 Escrow Payment Before Modification Report the monthly escrow payment amount calculated in the escrow analysis performed in conjunction with determining the borrowers eligibility for the most recent trial period plan for the modification being reported. The escrow analysis must be performed for all borrowers, including those that do not currently escrow for taxes and insurance. This is the amount of money that may be collected by the servicer as part of the regular monthly mortgage payment to cover, on behalf of the mortgagor, periodic payments of property taxes and hazard insurance. Any allowable escrow shortage payment amounts must be included. Private Mortgage Insurance Payments must be included.
C
C

If there is escrow amount that Servicer is withholding Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-239
LIR-247
DD72 First Lien Indicator Indicates if loan is first lien.
M
M

Boolean true/false LIR-43
DD74 First Payment Due Date After Modification For Trial Loan Submission, this is a projection of the first payment due date after modification. First Payment Due Date After Modification should be the same as the anticipated Modification Effective Date.

For Official Loan Submission, this is the actual first payment due date. First Payment Due Date After Modification should be the same as the actual Modification Effective Date.

M
M


Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-09-30
LIR-83
LIR-178
LIR-190
LIR-195
LIR-271
DD75 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.
O
O


Date(CCYY-MM-DD)
LIR-169
DD76 Front Ratio After Modification The borrower's housing-debt-to-income ratio after modification. This is the borrower's monthly housing expense divided by their total monthly income. Private Mortgage Insurance Payments must be included. Report to the 2nd decimal place (e.g. 31.05). Monthly Housing Expense After Mod (DD112) / Monthly Gross Income (DD110) M
M


Numeric(6,2) Data Range:
Min: 0.01
Max: 9999
LIR-73
LIR-176
LIR-221
LIR-222
LIR-223
LIR-243
LIR-341
DD77 Front Ratio Before Modification The borrower's housing-debt-to-income ratio based on the existing mortgage loan terms immediately prior to the Trial Period Plan Effective Date. This is the borrower's monthly housing expense divided by their total monthly income. Private Mortgage Insurance Payments must be included.Report to the 2nd decimal place (e.g. 50.25). Additionally, the value used in the trial loan set up data submission should reflect the income information used to establish the trial period plan terms, and the value used in the official loan set up data submission should reflect the income information used to establish the permanent modification terms. Monthly Housing Expense Before Mod (DD113) / Monthly Gross Income (DD110)
M
M


Numeric(6,2) Data Range:
Min: 10.00
Max: 9999.99
LIR-61
LIR-215
LIR-222
LIR-224
LIR-236
LIR-247
LIR-340
DD457 Government Agency Case Number A unique identifier assigned to each loan by the Government Agency .
M
M


Text (30)

LIR-275
DD458 Government Agency Servicer Number The Government Agency unique Servicer identifier.
M
M


Text (30)
LIR-274
LIR-291
DD5 GSE Loan Number A unique identifier assigned to each loan by a GSE (Fannie or Freddie).
C
C

If GSE loan Text(30)
LIR-37
LIR-150
LIR-212
LIR-213
LIR-374
LIR-375
DD6 GSE Servicer Number The Fannie Mae or Freddie Mac unique Servicer identifier.
C
C

If GSE loan Text(30)
LIR-153
LIR-230
DD8 HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program.
M M M M M
Numeric(9)
LIR-19
LIR-249
LIR-219
OMR-19
OMR-98
OMR-119
DD78 Hardship Reason Code Identifies the reason for the borrower's hardship, on their mortgage payment obligations.
M
M


Numeric(4,0) Enumeration:
1. Death of borrower
2. Illness of principal borrower
3. Illness of borrower family member
4. Death of borrower family member
5. Martial difficulties
6. Curtailment of income
7. Excessive obligation
8. Abandonment of property
9. Distant employment transfer
10. Property problem
11. Inability to sell property
12. Inability to rent property
13. Military service
14. Other
15. Unemployment
16. Business failure
17. Casualty Loss
18. Energy environment costs
19. Servicing problems
20. Payment adjustment
21. Payment dispute
22. Transfer of ownership pending
23. Fraud
24. Unable to contact borrower
25. Incarceration
LIR-45
DD81 Interest Owed Or Payment Not Reported If there is Interest owed/received but not reported for interest capitalization, this field must be populated.
C
C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD82 Interest Payment Interest portion of the principal and interest.




M
Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
OMR-31
OMR-116
DD83 Interest Rate After Modification The interest rate in the month after loan modification. Report 4 decimal places. For example, 6.125% should be entered as 6.125.
M
M


Numeric(6,4) Data Range:
Min: 0
Max: 20
LIR-74
LIR-110
LIR-199
LIR-266
LIR-335
DD85 Interest Rate Before Modification The interest rate based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Please report as rounded to nearest 8th (e.g. 4.120% should be rounded to 4.125% and entered as 4.1250). Report 4 decimal places.
M
M


Numeric(6,4) Data Range:
Min: 0
Max: 99.9999
LIR-62
DD87 Interest Rate Lock Date for Modification For Trial loan submission, this is the date the borrower's trial period payment was calculated using the standard modification waterfall prior to the start of the trial period.

For Official loan submission, this is the date when the Max Interest Rate After Modification was determined in conjunction with the preparation of the Modification Agreement.

O
M


Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-09-30
LIR-54
LIR-107
LIR-108
LIR-186
LIR-270
DD9 Investor Code Owner of the mortgage.
M
M


Numeric(4,0) Enumeration:
1. Fannie Mae *
2. Freddie Mac *
3. Private *+
4. Portfolio * +
5. GNMA
6. FHA/VA
7. State or Local Housing
Finance Agency
LIR-34
LIR-93
LIR-115
LIR-211
LIR-300
LIR-319
LIR-374
LIR-375
DD525 Last Paid Installment Date This is the actual LPI date reported on the monthly reporting transaction.




M
Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2029-01-15
OMR-29
OMR-124
OMR-125
OMR-126
OMR-139
OMR-140
OMR-156
OMR-162
DD88 Last Paid Installment Date After Modification For Trial, this is the anticipated LPI Date after modification. It should be one month before the anticipated Modification Effective Date.

For the Official Modification, this is the actual LPI Date after Modification. It must be one month before the Modification Effective Date.

O
M


Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-09-30
LIR-75
LIR-177
LIR-193
LIR-196
LIR-272
DD89 Last Paid Installment Date Before Modification The due date of the last paid installment received on the loan immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.
M
M


Date(CCYY-MM-DD)
LIR-63
LIR-295
LIR-296
DD91 Length of Trial Period The length of the trial period.
M
M


Numeric(3,0) Data Range:
Min: 3
Max: 999
LIR-197
LIR-198
LIR-280
DD402 Loan Modification Fallout Reason Code A code that specifies the reason why a modification was not completed.

M
M
If cancel Numeric(4,0) 1. Ineligible Mortgage *+
2. Current DTI Less than 31%
3. Property Not Owner Occupied
4. Other Ineligible Property (i.e. Property Condemned, Property >4 units)
7. Negative NPV
8. Offer Not Accepted by Borrower / Request Withdrawn
11. Loan Paid off
12. Excessive Forbearance
13. Request Incomplete
14. Trial Plan Default +
15. Data Correction * +(Incorrect data)
16. Payor Request * +
17. Compliance Request * +
18. Submission Error Correction (Incorrect transaction type)* +

* Valid for 2MP
+ Valid for FHA and RD-HAMP
LIR-287
LIR-288
LIR-293
DD93 Loan Mortgage Type Code The code that specifies the type of mortgage being applied for or that has been granted.
M
M


Numeric(4,0) Enumeration:
1 - FHA - Loans insured by the Federal Housing Administration
2 - VA - Loans insured by the Department of Veterans Affairs
3 - Conventional with PMI - Non-government insured mortgages insured by a private (non-government) insurer
4 - Conventional w/o PMI - Mortgages with neither government nor private mortgage insurance.
5 - RD-HAMP - Loans guaranteed by the Department of Agriculture (Rural Development)*

*- Applies to RD-HAMP


LIR-260
DD294 Loan Unpaid Principal Balance Amount The amount of outstanding principal (interest bearing portion only) at the end of the prior month, after accounting for all payment activity.




M
Currency (20,2) Min: 0
Max: 999999999999999999.99
OMR-28
OMR-121
OMR-122
OMR-133
DD98 Maturity Date After Modification The maturity date of the loan after modification.
O
M


Date(CCYY-MM-DD) Data Range:
Max: 12-31-2059
LIR-76
LIR-182
LIR-334
OMR-126
DD99 Maturity Date Before Modification The date on which the mortgage obligation is scheduled to be paid off, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Maturity Date is commonly called Balloon Date for balloon loans, for which scheduled amortization does not pay off the balance of the loan, so that there is a final, large "balloon" payment at the end.
M
M


Date(CCYY-MM-DD) Data Range:
Min: 08-15-2009
Max: 12-31-2059
LIR-64
LIR-333
DD100 Max Interest Rate After Modification The interest rate cap for the loan.
O
M


Numeric(6,4) Data Range:
Min: 0
Max: 99.9999
LIR-103
LIR-110
LIR-377
DD105 Modification Effective Date For Trial, this is the anticipated Modification Effective Date of the official loan modification. This is the first day of the month following the month when the last trial payment is due.

For Official, this is the actual Modification Effective Date of the official loan modification. This will still be the first day of the month following the month when the last trial payment is due. The Modification Effective Date on the official loan submission must be earlier than or equal to the date the official loan transaction is submitted.

M
M


Date(CCYY-MM-DD) Data Range:
Min: 2009-08-15
Max: 2014-09-30
LIR-53
LIR-96
LIR-108
LIR-178
LIR-182
LIR-183
LIR-189
LIR-194
LIR-198
LIR-200
LIR-229
LIR-264
LIR-378
LIR-379
DD108 Modified Loan Term-Officer Signature Date Servicer sign off at the officer level for the loan modification. This is the date the servicer's officer approved the loan modification. This column will be populated for modification cases that need reclassification. There is no conversion needed for existing cases.
O
O

Date(CCYY-MM-DD)
LIR-169
DD109 Monthly Debt Payments excluding PITIA Total amount of monthly debt payments excluding Principal, Interest, Taxes, Insurance and Association Dues (PITIA).




O
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-47
DD110 Monthly Gross Income Total monthly income in dollars for all borrowers on the loan.
M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-46
LIR-139
LIR-242
LIR-243
LIR-247
DD112 Monthly Housing Expense After Modification The borrower's monthly housing expense for the subject property after modification. This must include principal, interest, taxes, insurance, association dues (PITIA), and any escrow shortage payment amount. Private Mortgage Insurance Payments must be included. Monthly Housing Expense After Modification = P&I After Modification + Escrow Payment After Modification (if exists) + Assoc Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-77
LIR-139
LIR-208
LIR-240
DD113 Monthly Housing Expense Before Modification The borrower's monthly housing expense for the subject property based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This must include principal, interest, taxes, insurance, association dues (PITIA), and any escrow shortage payment amount. Private Mortgage Insurance Payments must be included. Monthly Housing Expense Before Modification = P&I Before Modification + Escrow Payment Before Modification (if exists) + Assoc Dues/Fees Before Modification (if exists)

M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99

LIR-65
LIR-139
LIR-208
LIR-239
DD125 Other Contributions If there are any amounts contributed by the borrower due to Hazard Claims.
C
C

If there are amounts contributed by borrower Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD459 Partial Claim Amount The amount of the partial claim made for the modification. A partial claim is the amount that the Government Agency advances to pay the past-due amount of principal, interest, insurance, and taxes owed by a delinquent borrower. The payment is in the form of a non-interest-bearing loan to the borrower.
M
M


Currency (20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-276
DD126 Paydown or Payoff of Subordinate Liens Indicator of whether subordinate liens been paid off or paid down
C
C

If subordinate liens paid off or paid down Boolean true/false
DD127 Paydown or Payoff of Subordinate Liens Amount Amount of paydown or payoff of subordinate liens.
C
C

If Paydown or Payoff of Subordinate Liens flag is "True" Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-57
DD132 Principal and Interest Payment After Modification The principal and interest amount after modification. P&I Payment After Modification = Monthly Gross Income * Front Ratio After Modification - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-79
LIR-139
LIR-204
LIR-240
LIR-243
DD133 Principal and Interest Payment at 31% DTI Principal and Interest payable for a 31% Debt to Income ratio. This is equal to
i) 31% of the borrower's income less
ii) the Escrow Payment After Modification and the Association Dues.
For official, the most current verified income must be used.
P&I Payment at 31% DTI = Monthly Gross Income * 31% - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-51
LIR-242
DD135 Principal and Interest Payment Before Modification The scheduled principal and interest amount based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. P&I Payment Before Modification = Monthly Gross Income * Front Ratio Before Modification - Escrow Payment Before Modification (if exists) - Association Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-67
LIR-139
LIR-204
LIR-239
LIR-247
DD137 Principal Payment Principal portion of the principal and interest remitted monthly.




M
Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
OMR-30
OMR-117
DD138 Principal Payment Owed or Not Reported If borrower has contributed any cash or amounts in suspense.
C
C

If borrower contributed cash or amounts in suspense Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD139 Principal Write-down (Forgiveness) Amount of principal written-down or forgiven inclusive of investor forgiveness (PRA, HHF matching, etc.) and other principal forgiveness assistance (e.g. HHF).
C
C

if principal forgiven Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-139
DD140 Product After Modification The mortgage product of the loan, after the modification.
M
M


Numeric(4,0) Enumeration:
2. Fixed Rate
LIR-80
LIR-262
DD142 Product Before Modification The mortgage product of the loan, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.
M
M


Numeric(4,0) Enumeration:
1. ARM *
2. Fixed rate *
3. Step Rate
4. One Step Variable
5. Two Step Variable
6. Three Step Variable
7. Four Step Variable
8. Five Step Variable
9. Six Step Variable
10. Seven Step Variable
11. Eight Step Variable
12. Nine Step Variable
13. Ten Step Variable
14. Eleven Step Variable
15. Twelve Step Variable
16. Thirteen Step Variable
17. Fourteen Step Variable

* only 1 and 2 are valid for FHA
LIR-68
DD10 Program Type/Campaign ID A program type that will identify campaign types. The unique identifier of a Loan Workout Campaign.
M
M

Text(14) HMP9 - FHA LIR-132
LIR-133
LIR-155
LIR-156
LIR-162
LIR-163
LIR-164
LIR-217
LIR-218
LIR-226
LIR-259
LIR-265
LIR-300
DD144 Projected Foreclosure Sale Date Projected date for foreclosure sale of subject property.
O
O


Date(CCYY-MM-DD)
LIR-169
DD145 Property City The name of the city where the subject property is located.
M
M


Text(100)
LIR-28
DD148 Property Number of Units Number of units in subject property (Valid values are 1, 2, 3 or 4).
M
M


Numeric(4,0) Data Range:
Min: 1
Max: 4
LIR-23
DD149 Property Occupancy Status Code A code identifying the occupancy by the borrower of the subject property.
M
M


Numeric(4,0) Enumeration:
1. Vacant
2. Borrower Occupied
3. Tenant Occupied
4. Unknown
5. Occupied by Unknown
LIR-24
DD151 Property State The 2-character postal abbreviation of the state, province, or region of the subject property.
M
M


Text(2) Enumeration: WY,WV,WI,WA,VT,VI,VA,UT,TX,TN,SD,SC,RI,PR,PA,OR,OK,OH,NY,NV,NM,NJ,NH,NE,ND,NC,MT,MS,MO,MN,MI,ME,MD,MA,LA,KY,KS,IN,IL,ID,IA,HI,GU,GA,FL,DE,DC,CT,CO,CA,AZ,AR,AL,AK. LIR-118
DD152 Property Street Address The street address of the subject property.
M
M


Text(200)
LIR-27
DD155 Property Usage Type Code A code identifying the current use of the property by the borrower. For HAMP, FHA-HAMP and RD-HAMP this is determined at Loan Setup; for HAFA this is determined at the time of the HAFA Agreement Issue Date.
M
M


Numeric(4,0) Enumeration:
1. Principal Residence
2. Second or Vacation Home
3. Investment Property
LIR-25
DD161 Property Zip Code The code designated by the postal service to direct the delivery of physical mail or which corresponds to a physical location. In the USA, this can take either a 5 digit form (ZIP Code) or a 9-digit form (ZIP + 4).
M
M


Numeric (5 or 9)
LIR-29
LIR-294
LIR-298
DD165 Remaining Term Before Modification The remaining number of months until the loan will be paid off, assuming that scheduled payments are made, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This will equal lesser of 1. The number of months until the actual balance of the loan will amortize to zero; or 2. The number of months difference between the LPI date and the Maturity Date.
M
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-69
DD14 Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan.
M M M M M
Text(30)
LIR-33
LIR-219
OMR-20
OMR-96
OMR-119
DD201 Servicing Fee Percent After Modification Percentage of servicing Fee after loan modification ( e.g. 0.25).
O
O


Numeric(4,2)

DD210 Submission Status The status of loan data being submitted.
M M M M

Numeric(4,0) Enumeration (for 1st Lien):
1. Trial
3. Official
5. Trial Cancel
6. Official Correction*
7. Official Cancel

* Not applicable for FHA and RD-HAMP

LIR-35
LIR-132
LIR-133
LIR-155
LIR-156
LIR-162
LIR-163
LIR-164
LIR-217
LIR-218
LIR-219
LIR-220
LIR-226
LIR-232
LIR-286
LIR-289
LIR-290
OMR-145
OMR-147
DD678 Supplementary Assistance Code A code indicating the supplementary assistance provided to the borrower. This assistance may be provided to unemployed borrowers, principal reduction, funding to remove second liens, and programs that facilitate short sales and deeds-in-lieu of foreclosure.
M
M


Numeric (4,0) Enumeration:
-None(1)
-Hardest Hit Fund(2)
- No value existed prior to attribute introduction(3) (Restricted - not valid for servicer input)

LIR-306
LIR-307
LIR-319
DD213 Term After Modification The remaining number of months until the loan will be paid off, assuming that scheduled payments are made. This will equal lesser of 1. the number of months until the actual balance of the loan will amortize to zero; or 2. the number of months difference between the LPI date and the Maturity Date. In this case, the Maturity Date is the Maturity Date after the modification and may be different from the original Maturity Date (before the modification).
O
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-81
LIR-95
LIR-167
DD15 Underlying Trust Identifier This is the shelf and series security identifier associated with the security supported by the loan. A shelf offering is an SEC provision allowing an issuer to register a new issue security without selling the entire issue at once. Additionally, this may be the CUSIP identifier associated with the security. The CUSIP number is the identification number assigned to a security by CUSIP (Committee on Uniform Security Identification Procedures) for trading.
C
C

Only for Non-GSE Text (20)
LIR-39
LIR-151
DD222 Unpaid Principal Balance After Modification The unpaid principal balance of a loan after the loan modification. The unpaid principal balance after modification excludes any applicable forbearance amount and can also be referred to as Net UPB Amount.
M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-82
DD225 Unpaid Principal Balance Before Modification The unpaid principal balance of a loan is the contractual UPB based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This UPB should not reflect any accounting based write-downs.
M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99
LIR-70
LIR-90

Sheet 7: RD-HAMP

















M=Mandatory; C=Conditional; O=Optional Legend: 12/03/2012 - Red 04/01/2013 - Green
Ref ID Name of Data Point Description Calculation RD-HAMP Trial Set-Up RD-HAMP Trial Cancel RD-HAMP Official Set-Up Official Monthly Reporting RD-HAMP Official Cancel Condition Under Which Data Is Required Data Type/Data Length Allowable Values Associated Rules
DD17 1st Trial Payment Due Date This is the date that the first trial payment is due. It is also the trial modification effective date. This date must be less than the trial loan submission date.
M
O

If exists Date(CCYY-MM-DD) Data Range
Min: 2010-09-24
Max: 2014-06-30
LIR-169
LIR-183
LIR-198
LIR-295
LIR-385
LIR-386
LIR-387
LIR-388
DD18 1st Trial Payment Posted Date The date the first payment posted during the Trial period.
M
O


Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2014-06-30
LIR-378
LIR-379
LIR-389
LIR-390
LIR-391
DD19 1st Trial Payment Received Amount This is the actual amount of the Payment received from the Borrower to the Servicer for the 1st Trial payment.
M
O


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-392
DD20 Action Code A code reported by the lender to update the loan that indicates the action that occurred during the reporting period.



C
If there is an action Numeric(4,0) Enumeration:
60 - Payoff
OMR-35
OMR-36
OMR-113
OMR-122
OMR-133
DD21 Action Code Date The effective date of the action associated with the action code specified on the incoming transaction by the servicer. The action date is required for certain action codes.




C
If there is an action Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2029-01-15
OMR-36
OMR-113
OMR-123
OMR-124
OMR-135
OMR-148
OMR-162
OMR-163
DD24 Amortization Term After Modification The number of months used to calculate the periodic payments of both principal and interest that will be sufficient to retire a mortgage obligation.

M
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-71
LIR-95
LIR-166
LIR-393
DD26 Amortization Term Before Modification Represents the number of months on which installment payments are based under the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Example: Balloon loans have a seven year life (Loan Term = 84) but a 30 year amortization period (Amortization Term = 360). Installment payments are determined based on the 360 month.
M
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-59
DD29 Association Dues/Fees Before Modification Existing monthly payment for association dues/fees before modification immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This amount should reflect the monthly amount of association dues/fees required to be paid by the borrower. In addition, if a displaced borrower is requesting modification for the principal residence from which the borrower was displaced and the borrower is paying rent to live elsewhere, the rent amount should be included with any association dues.
C
C

If there are association fees that Servicer is withholding

Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

LIR-239
LIR-240
LIR-242
LIR-243
LIR-247
DD31 Back Ratio After Modification The borrower's total debt-to-income ratio after modification. This is the borrower's total monthly expenses, including PITIA and other debt expenses, divided by their total monthly income. Private Mortgage Insurance Payments do not exist. Report to the 2nd decimal place (e.g. 50.25).
O
M


Numeric(6,2) Data Range:
Min: 0
Max: 9999
LIR-72
LIR-139
LIR-341
LIR-382
LIR-399
DD32 Back Ratio Before Modification The borrower's total debt-to-income ratio based on the existing mortgage loan terms immediately prior to the Trial Period Plan Effective Date. This is the borrower's total monthly expenses, including PITIA and other debt expenses, divided by their total monthly income. Private Mortgage Insurance Payments do not exist.
Report to the 2nd decimal place (e.g. 50.25). Additionally, the value used in the trial loan set up data submission should reflect the income information used to establish the trial period plan terms, and the value used in the official loan set up data submission should reflect the income information used to establish the permanent modification terms.

M
M


Numeric(6,2) Data Range:
Min: 0
Max: 9999
LIR-60
LIR-340
LIR-382
DD33 Borrower Contributions If the borrower is contributing any amounts, they must be reported here.


C
C

If exists Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD37 Borrower Execution Date For trial loan submission, this is the date that the borrower executed (signed) the trial documents if available. Otherwise it is the date of the first payment (through check, wire, or credit card).
For official loan submission, this is the date that the borrower signed the official loan modification documents.



M
M


Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2014-12-31
LIR-106
LIR-107
LIR-112
LIR-394
DD39 Borrower First Name The first name of the Borrower of record.
M
M


Text(100)
LIR-20
DD40 Borrower Last Name The last name of the Borrower. This is also known as the family name or surname.
M
M


Text(100)
LIR-21
DD43 Borrower Social Security Number The Social Security Number of the Borrower.
M
M


Text(9) Data Range:
Min: 000000001
Max: 999999998
LIR-116
LIR-174
LIR-209
LIR-228
LIR-232
LIR-328
LIR-329
LIR-336
LIR-338
DD55 Co-Borrower First Name The first name of the Co-Borrower of record.
C
C

If co-borrower on loan Text(100)
LIR-201
LIR-202
LIR-326
DD56 Co-Borrower Last Name The last name of the Co- Borrower of record.
C
C

If co-borrower on loan Text(100)
LIR-201
LIR-202
LIR-326
DD59 Co-Borrower Social Security Number The Social Security Number of the Co-Borrower.
C
C

If available

Text(9) Data Range:
Min: 000000001
Max: 999999998
LIR-117
LIR-174
LIR-210
LIR-228
LIR-232
LIR-326
LIR-328
LIR-329
LIR-337
LIR-339
DD62 Date of Original Note The date the mortgage note was signed by the borrower.
M
M


Date(CCYY-MM-DD) Data Range:
Min: 1950-01-01
Max: 2009-01-01
LIR-36
LIR-92
LIR-296
LIR-297
DD63 Delinquent Interest Delinquent interest for interest capitalization. It is the amount of delinquent interest from the delinquent loan's LPI date to the workout execution date.
O
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-50
LIR-139
DD67 Escrow Payment After Modification Report the escrow amount expected in the first payment after loan modification. This is the amount of money that may be collected by the servicer as part of the regular monthly mortgage payment to cover, on behalf of the mortgagee, periodic payments of property taxes and hazard insurance. Any escrow shortage payment amounts must be included. Private Mortgage Insurance Payments do not exist.
M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-139
LIR-165
LIR-240
LIR-242
LIR-243
DD68 Escrow Payment Before Modification Report the monthly escrow payment amount calculated in the escrow analysis performed in conjunction with determining the borrowers eligibility for the most recent trial period plan for the modification being reported. The escrow analysis must be performed for all borrowers, including those that do not currently escrow for taxes and insurance. This is the amount of money that may be collected by the servicer as part of the regular monthly mortgage payment to cover, on behalf of the mortgagor, periodic payments of property taxes and hazard insurance. Any allowable escrow shortage payment amounts must be included. Private Mortgage Insurance Payments do not exist.
C
C

If there is escrow amount that Servicer is withholding Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-239
LIR-247
DD72 First Lien Indicator Indicates if loan is first lien.
M
M

Boolean true/false LIR-43
DD74 First Payment Due Date After Modification For Trial Loan Submission, this is a projection of the first payment due date after modification. First Payment Due Date After Modification should be the same as the anticipated Modification Effective Date.

For Official Loan Submission, this is the actual first payment due date. First Payment Due Date After Modification should be the same as the actual Modification Effective Date.

M
M


Date(CCYY-MM-DD) Min: 2010-09-24
Max: 2014-09-30
LIR-83
LIR-178
LIR-190
LIR-195
LIR-395
DD75 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.
O
O


Date(CCYY-MM-DD)
LIR-169
DD76 Front Ratio After Modification The borrower's housing-debt-to-income ratio after modification. This is the borrower's monthly housing expense divided by their total monthly income. Private Mortgage Insurance Payments do not exist. Report to the 2nd decimal place (e.g. 31.05). Front End DTI After Modification = Monthly Housing Expense After Modification / Monthly Gross Income

M
M


Numeric(6,2) Data Range:
Min: 0.01
Max: 9999
LIR-73
LIR-139
LIR-176
LIR-221
LIR-222
LIR-223
LIR-243
LIR-341
DD77 Front Ratio Before Modification The borrower's housing-debt-to-income ratio based on the existing mortgage loan terms immediately prior to the Trial Period Plan Effective Date. This is the borrower's monthly housing expense divided by their total monthly income. Private Mortgage Insurance Payments do not exist. Report to the 2nd decimal place (e.g. 50.25). Additionally, the value used in the trial loan set up data submission should reflect the income information used to establish the trial period plan terms, and the value used in the official loan set up data submission should reflect the income information used to establish the permanent modification terms.
Front End DTI Before Modification = Monthly Housing Expense Before Mod (DD113) / Monthly Gross Income (DD110)
M
M


Numeric(6,2) Data Range:
Min: 10.00
Max: 9999.99
LIR-61
LIR-215
LIR-222
LIR-224
LIR-236
LIR-247
LIR-340
DD458 Government Agency Servicer Number The Government Agency unique Servicer identifier.
M
M


Text (30)
LIR-397
LIR-398
DD5 GSE Loan Number A unique identifier assigned to each loan by a GSE (Fannie or Freddie).
C
C

If GSE loan
Text(30)
LIR-37
LIR-150
LIR-212
LIR-213
DD6 GSE Servicer Number The Fannie Mae or Freddie Mac unique Servicer identifier.
C
C

If GSE loan Text(30)
LIR-153
LIR-230
DD8 HAMP Servicer Number A unique identifier assigned to each Servicer that is participating in the HAMP program.
M M M M M
Numeric(9)
LIR-19
LIR-249
LIR-415
OMR-19
OMR-98
OMR-119
DD78 Hardship Reason Code Identifies the reason for the borrower's hardship, on their mortgage payment obligations.
M
M


Numeric(4,0) Enumeration:
1. Death of borrower
2. Illness of principal borrower
3. Illness of borrower family member
4. Death of borrower family member
5. Martial difficulties
6. Curtailment of income
7. Excessive obligation
8. Abandonment of property
9. Distant employment transfer
10. Property problem
11. Inability to sell property
12. Inability to rent property
13. Military service
14. Other
15. Unemployment
16. Business failure
17. Casualty Loss
18. Energy environment costs
19. Servicing problems
20. Payment adjustment
21. Payment dispute
22. Transfer of ownership pending
23. Fraud
24. Unable to contact borrower
25. Incarceration
LIR-45
DD82 Interest Payment Interest portion of the principal and interest.



M

Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
OMR-31
OMR-116
DD83 Interest Rate After Modification The interest rate in the month after loan modification. Report 4 decimal places. For example, 6.125% should be entered as 6.125.

M
M


Numeric(6,4) Data Range:
Min: 0
Max: 20

LIR-74
LIR-110
LIR-199
LIR-335
LIR-401
DD85 Interest Rate Before Modification The interest rate based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Please report as rounded to nearest 8th (e.g. 4.120% should be rounded to 4.125% and entered as 4.1250). Report 4 decimal places.

M
M


Numeric(6,4) Data Range:
Min: 0
Max: 99.9999

LIR-62
DD87 Interest Rate Lock Date for Modification For Trial loan submission, this is the date the borrower's trial period payment was calculated using the standard modification waterfall prior to the start of the trial period.

For Official loan submission, this is the date when the Max Interest Rate After Modification was determined in conjunction with the preparation of the Modification Agreement.

O
M


Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2014-09-30
LIR-54
LIR-107
LIR-108
LIR-186
LIR-402
DD9 Investor Code Owner of the mortgage.

M
M


Numeric(4,0) * indicates Investor Codes currently eligible for HAMP and HAFA
Enumeration:
1. Fannie Mae *
2. Freddie Mac *
3. Private *+
4. Portfolio * +
5. GNMA
6. FHA/VA
7. State or Local Housing
Finance Agency
* indicates Investor Codes currently eligible for HAMP and HAFA
+ indicates Investor Codes eligible if Program Type =
HMP21 - HMP Default
HMP22 - HMP Imminent Default
HMP27 - Current

LIR-34
LIR-93
LIR-211
LIR-319
DD525 Last Paid Installment Date This is the actual LPI date reported on the monthly reporting transaction.



M

Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2029-01-15
OMR-29
OMR-124
OMR-125
OMR-126
OMR-139
OMR-140
OMR-162
OMR-164
DD88 Last Paid Installment Date After Modification For Trial, this is the anticipated LPI Date after modification. It should be one month before the anticipated Modification Effective Date.

For the Official Modification, this is the actual LPI Date after Modification. It must be one month before the Modification Effective Date.

O
M


Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2014-09-30

LIR-75
LIR-177
LIR-193
LIR-196
LIR-403
DD89 Last Paid Installment Date Before Modification The due date of the last paid installment received on the loan immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.
M
M


Date(CCYY-MM-DD)
LIR-63
LIR-295
LIR-296
DD91 Length of Trial Period The length of the trial period.
M
M


Numeric(3,0) Data Range:
Min: 3
Max: 999
LIR-197
LIR-198
LIR-404
DD402 Loan Modification Fallout Reason Code A code that specifies the reason why a modification was not completed.

M

M If cancel Numeric(4,0) 1. Ineligible Mortgage *+
2. Current DTI Less than 31%
3. Property Not Owner Occupied
4. Other Ineligible Property (i.e. Property Condemned, Property >4 units)
7. Negative NPV
8. Offer Not Accepted by Borrower / Request Withdrawn
11. Loan Paid off
12. Excessive Forbearance
13. Request Incomplete
14. Trial Plan Default +
15. Data Correction * +(Incorrect data)
16. Payor Request * +
17. Compliance Request * +
18. Submission Error Correction (Incorrect transaction type)* +

* Valid for 2MP
+ Valid for FHA and RD-HAMP
LIR-288
LIR-293
LIR-405
DD93 Loan Mortgage Type Code The code that specifies the type of mortgage being applied for or that has been granted.
M
M


Numeric(4,0) Enumeration:
1 - FHA - Loans insured by the Federal Housing Administration
2 - VA - Loans insured by the Department of Veterans Affairs
3 - Conventional with PMI - Non-government insured mortgages insured by a private (non-government) insurer
4 - Conventional w/o PMI - Mortgages with neither government nor private mortgage insurance.
5 - RD-HAMP - Loans guaranteed by the Department of Agriculture (Rural Development)*

*- Applies to RD-HAMP


LIR-406
DD294 Loan Unpaid Principal Balance Amount The amount of outstanding principal (interest bearing portion only) at the end of the prior month, after accounting for all payment activity.



M

Currency (20,2) Min: 0
Max: 999999999999999999.99
OMR-28
OMR-121
OMR-122
OMR-133
DD98 Maturity Date After Modification The maturity date of the loan after modification.
O
M


Date(CCYY-MM-DD) Data Range:
Max: 12-31-2059

LIR-76
LIR-182
LIR-334
OMR-126
DD99 Maturity Date Before Modification The date on which the mortgage obligation is scheduled to be paid off, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. Maturity Date is commonly called Balloon Date for balloon loans, for which scheduled amortization does not pay off the balance of the loan, so that there is a final, large "balloon" payment at the end.
M
M


Date(CCYY-MM-DD) Data Range:
Min: 09-24-2010
Max: 12-31-2059
LIR-64
LIR-333
DD100 Max Interest Rate After Modification The interest rate cap for the loan.

O
M


Numeric(6,4) Data Range:
Min: 0
Max: 99.9999
LIR-103
LIR-110
LIR-377
DD105 Modification Effective Date For Trial, this is the anticipated Modification Effective Date of the official loan modification. This is the first day of the month following the month when the last trial payment is due.

For Official, this is the actual Modification Effective Date of the official loan modification. This will still be the first day of the month following the month when the last trial payment is due. The Modification Effective Date on the official loan submission must be earlier than or equal to the date the official loan transaction is submitted.

M
M


Date(CCYY-MM-DD) Data Range:
Min: 2010-09-24
Max: 2014-09-30
LIR-53
LIR-96
LIR-108
LIR-178
LIR-182
LIR-183
LIR-189
LIR-194
LIR-198
LIR-200
LIR-378
LIR-379
LIR-407
DD108 Modified Loan Term-Officer Signature Date Servicer sign off at the officer level for the loan modification. This is the date the servicer's officer approved the loan modification. This column will be populated for modification cases that need reclassification. There is no conversion needed for existing cases.
O
O

Date(CCYY-MM-DD)
LIR-169
DD109 Monthly Debt Payments excluding PITIA Total amount of monthly debt payments excluding Principal, Interest, Taxes, Insurance and Association Dues (PITIA).




O
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-47
DD110 Monthly Gross Income Total monthly income in dollars for all borrowers on the loan.
M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99

LIR-46
LIR-139
LIR-242
LIR-243
LIR-247
DD112 Monthly Housing Expense After Modification The borrower's monthly housing expense for the subject property after modification. This must include principal, interest, taxes, insurance, association dues (PITIA), and any escrow shortage payment amount. Private Mortgage Insurance Payments do not exist. Monthly Housing Expense After Modification = P&I After Modification + Escrow Payment After Modification (if exists) + Assoc Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-77
LIR-139
LIR-208
LIR-240
DD113 Monthly Housing Expense Before Modification The borrower's monthly housing expense for the subject property based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This must include principal, interest, taxes, insurance, association dues (PITIA), and any escrow shortage payment amount. Private Mortgage Insurance Payments do not exist. Monthly Housing Expense Before Modification = P&I Before Modification + Escrow Payment Before Modification (if exists) + Assoc Dues/Fees Before Modification (if exists)

M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99

LIR-65
LIR-139
LIR-208
LIR-239
DD125 Other Contributions If there are any amounts contributed by the borrower due to Hazard Claims.
C
C

If there are amounts contributed by borrower Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

DD459 Partial Claim Amount The amount of the partial claim made for the modification. A partial claim is the amount that the Government Agency advances to pay the past-due amount of principal, interest, insurance, and taxes owed by a delinquent borrower. The payment is in the form of a non-interest-bearing loan to the borrower.
Supply the Mortgage Recovery Advance amount in the Partial Claim Amount attribute.

M
M


Currency (20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-408
DD132 Principal and Interest Payment After Modification For 1MP, FHA and RD-HAMP:
The principal and interest amount after modification.
P&I Payment After Modification = Monthly Gross Income * Front Ratio After Modification - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

LIR-79
LIR-139
LIR-204
LIR-240
LIR-243
DD133 Principal and Interest Payment at 31% DTI Principal and Interest payable for a 31% Debt to Income ratio. This is equal to
i) 31% of the borrower's income less
ii) the Escrow Payment After Modification and the Association Dues.
For official, the most current verified income must be used.
P&I Payment at 31% DTI = Monthly Gross Income * 31% - Escrow Payment After Modification - Association Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99
LIR-51
LIR-242
DD135 Principal and Interest Payment Before Modification The scheduled principal and interest amount based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.
P&I Payment Before Modification = Monthly Gross Income * Front Ratio Before Modification - Escrow Payment Before Modification (if exists) - Association Dues/Fees Before Modification (if exists) M
M


Currency(20,2) Data Range:
Min: 0
Max: 999999999999999999.99

LIR-67
LIR-139
LIR-204
LIR-239
LIR-247
DD137 Principal Payment Principal portion of the principal and interest remitted monthly.



M

Currency(20,2) Data Range:
Min: -999999999999999999.99
Max: 999999999999999999.99
OMR-30
OMR-117
DD140 Product After Modification The mortgage product of the loan, after the modification.


M
M


Numeric(4,0) Enumeration:
2. Fixed Rate
LIR-80
LIR-409
DD142 Product Before Modification The mortgage product of the loan, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported.


M
M


Numeric(4,0) Enumeration:
2 - Fixed rate
LIR-68
LIR-413
DD10 Program Type/Campaign ID A new program type that will identify campaign types. The unique identifier of a Loan Workout Campaign.
M
M

Text(14) Enumeration:
HMP12 - Rural Development - HAMP
LIR-132
LIR-133
LIR-155
LIR-156
LIR-162
LIR-163
LIR-164
LIR-217
LIR-218
LIR-226
LIR-410
LIR-411
LIR-414
LIR-416
DD144 Projected Foreclosure Sale Date Projected date for foreclosure sale of subject property.
O
O


Date(CCYY-MM-DD)
LIR-169
DD145 Property City The name of the city where the subject property is located.
M
M


Text(100)
LIR-28
DD148 Property Number of Units Number of units in subject property (Valid values are 1, 2, 3 or 4).
M
M


Numeric(4,0) Data Range:
Min: 1
Max: 4
LIR-417
LIR-418
DD149 Property Occupancy Status Code A code identifying the occupancy by the borrower of the subject property.
M
M


Numeric(4,0) Enumeration:
1. Vacant
2. Borrower Occupied
3. Tenant Occupied
4. Unknown
5. Occupied by Unknown
LIR-24
DD151 Property State The 2-character postal abbreviation of the state, province, or region of the subject property.
M
M


Text(2) Enumeration: WY,WV,WI,WA,VT,VI,VA,UT,TX,TN,SD,SC,RI,PR,PA,OR,OK,OH,NY,NV,NM,NJ,NH,NE,ND,NC,MT,MS,MO,MN,MI,ME,MD,MA,LA,KY,KS,IN,IL,ID,IA,HI,GU,GA,FL,DE,DC,CT,CO,CA,AZ,AR,AL,AK. LIR-118
DD152 Property Street Address The street address of the subject property.
M
M


Text(200)
LIR-27
DD155 Property Usage Type Code A code identifying the current use of the property by the borrower. For HAMP, FHA-HAMP and RD-HAMP this is determined at Loan Setup; for HAFA this is determined at the time of the HAFA Agreement Issue Date.
M
M


Numeric(4,0) Enumeration:
1. Principal Residence
2. Second or Vacation Home
3. Investment Property
LIR-25
DD161 Property Zip Code The code designated by the postal service to direct the delivery of physical mail or which corresponds to a physical location. In the USA, this can take either a 5 digit form (ZIP Code) or a 9-digit form (ZIP + 4).

M
M


Numeric (5 or 9)
LIR-29
LIR-294
LIR-298
DD165 Remaining Term Before Modification The remaining number of months until the loan will be paid off, assuming that scheduled payments are made, based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This will equal lesser of 1. The number of months until the actual balance of the loan will amortize to zero; or 2. The number of months difference between the LPI date and the Maturity Date.
M
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-69
DD14 Servicer Loan Number The unique (for the lender) identifier assigned to the loan by the lender that is servicing the loan.
M M M M M
Text(30)
LIR-33
LIR-415
OMR-20
OMR-96
OMR-119
DD201 Servicing Fee Percent After Modification Percentage of servicing Fee after loan modification ( e.g. 0.25).
O
O


Numeric(4,2)

DD210 Submission Status The status of loan data being submitted.
M M M
M
Numeric(4,0) Enumeration:
1. Trial
3. Official
5. Trial Cancel
6. Official Correction*
7. Official Cancel

* Not applicable for FHA and RD-HAMP
LIR-35
LIR-132
LIR-133
LIR-155
LIR-156
LIR-162
LIR-163
LIR-164
LIR-217
LIR-218
LIR-220
LIR-226
LIR-232
LIR-414
LIR-415
LIR-416
OMR-145
OMR-147
DD678 Supplementary Assistance Code A code indicating the supplementary assistance provided to the borrower. This assistance may be provided to unemployed borrowers, principal reduction, funding to remove second liens, and programs that facilitate short sales and deeds-in-lieu of foreclosure.
M
M


Numeric (4,0) Enumeration:
-None(1)
-Hardest Hit Fund(2)
- No value existed prior to attribute introduction(3) (Restricted - not valid for servicer input)

LIR-306
LIR-307
LIR-319
DD213 Term After Modification The remaining number of months until the loan will be paid off, assuming that scheduled payments are made. This will equal lesser of 1. the number of months until the actual balance of the loan will amortize to zero; or 2. the number of months difference between the LPI date and the Maturity Date. In this case, the Maturity Date is the Maturity Date after the modification and may be different from the original Maturity Date (before the modification).

O
M


Numeric(4,0) Data Range:
Min: 1
Max: 9999
LIR-81
LIR-95
LIR-167
DD15 Underlying Trust Identifier This is the shelf and series security identifier associated with the security supported by the loan. A shelf offering is an SEC provision allowing an issuer to register a new issue security without selling the entire issue at once. Additionally, this may be the CUSIP identifier associated with the security. The CUSIP number is the identification number assigned to a security by CUSIP (Committee on Uniform Security Identification Procedures) for trading.
C
C

Only for Non-GSE Text (20)
LIR-39
LIR-151
DD222 Unpaid Principal Balance After Modification The unpaid principal balance of a loan after the loan modification. The unpaid principal balance after modification excludes any applicable forbearance amount and can also be referred to as Net UPB Amount.

M
M


Currency(20,2) Data Range:

Min: 0.01
Max: 999999999999999999.99
LIR-82
DD225 Unpaid Principal Balance Before Modification The unpaid principal balance of a loan is the contractual UPB based on the existing mortgage loan terms immediately prior to the most recent Trial Period Plan Effective Date for the modification being reported. This UPB should not reflect any accounting based write-downs.

M
M


Currency(20,2) Data Range:
Min: 0.01
Max: 999999999999999999.99

LIR-70
LIR-417
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy