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. |
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 |
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 |
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 |
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 |
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 |
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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |