MCR
MCR
Report type: mcr_v2
About this export
- Assists with Mortgage Call Report (MCR) regulatory reporting.
- Contains information about:
- Quarterly actions
- Application amount changes
- The export has rows for each application, and for each quarter the application was in progress. A loan application that is in progress during two quarters will have two rows, one for each quarter.
caution
- Your organization is responsible for ensuring that your regulatory report submissions are complete and accurate.
- This report is provided as a convenience to assist with your Mortgage Call Report (MCR) process,
- Your organization should review the report and make any necessary adjustments before submitting to the appropriate regulatory agency.
| Position | Field Name | Datatype | Mode | Date Added | Definition | Categorical Values | Format Notes | Misc. Notes |
|---|---|---|---|---|---|---|---|---|
| 1 | report_quarter | STRING | NON-NULLABLE | 2023-03-25 | Q# YYYY | |||
| 2 | report_quarter_start_datetime | DATETIME | NON-NULLABLE | 2023-03-25 | Start datetime of reporting quarter (inclusive) | |||
| 3 | report_quarter_end_datetime | DATETIME | NON-NULLABLE | 2023-03-25 | Start datetime of reporting quarter (exclusive) | |||
| 4 | application_uuid_value | STRING | NON-NULLABLE | 2022-08-01 | ||||
| 5 | application_short_id | STRING | NON-NULLABLE | 2022-08-01 | ||||
| 6 | application_start_date | DATE | NON-NULLABLE | 2022-08-01 | ||||
| 7 | expiration_date | DATE | NON-NULLABLE | 2022-08-01 | Application expiration date if left incomplete | |||
| 8 | rescission_start_date | DATE | NULLABLE | 2022-08-01 | ||||
| 9 | rescission_exit_date | DATE | NULLABLE | 2022-08-01 | ||||
| 10 | funding_date | DATE | NULLABLE | 2022-08-01 | ||||
| 11 | approved_not_accepted_date | DATETIME | NULLABLE | 2022-08-01 | ||||
| 12 | withdrawn_date | DATETIME | NULLABLE | 2022-08-01 | ||||
| 13 | denied_date | DATETIME | NULLABLE | 2022-08-01 | ||||
| 14 | transfer_date | DATE | NULLABLE | 2022-08-01 | Date of loan ownership transfer | |||
| 15 | amount | FLOAT | NON-NULLABLE | 2022-08-01 | Application amount | |||
| 16 | profile_state | STRING | NON-NULLABLE | 2022-08-01 | Residential U.S. state of primary applicant. NOT subject property state. | |||
| 17 | nmls_mlo_id | STRING | NULLABLE | 2022-08-01 | NMLS MLO ID used on Application Summary document | |||
| 18 | mlo_full_name | STRING | NULLABLE | 2022-08-01 | MLO full name used on Application Summary document | |||
| 19 | mlo_employee_id | STRING | NULLABLE | 2022-08-01 | MLO employee ID | |||
| 20 | referring_mlo_name | STRING | NULLABLE | 2022-08-01 | Referring MLO name | |||
| 21 | referring_mlo_nmls_no | STRING | NULLABLE | 2022-08-01 | Referring MLO NMLS number | |||
| 22 | fico_score | STRING | NON-NULLABLE | 2022-08-01 | Primary applicant FICO score | codes beyond the 300-850 range are error codes | ||
| 23 | post_loan_cltv | FLOAT | NULLABLE | 2022-08-01 | Cash loan to value ratio post loan | |||
| 24 | organization | STRING | NULLABLE | 2022-08-01 | Originating organization | |||
| 25 | AC010 | STRING | NULLABLE | 2022-08-01 | Application in process at beginning of quarter flag | x | ||
| 26 | AC020 | STRING | NULLABLE | 2022-08-01 | Application received during quarter flag | x | ||
| 27 | AC030 | STRING | NULLABLE | 2022-08-01 | Application approved but not accepted during quarter flag | x | ||
| 28 | AC040 | STRING | NULLABLE | 2022-08-01 | Application denied during quarter flag | x | ||
| 29 | AC050 | STRING | NULLABLE | 2022-08-01 | Application withdrawn during quarter flag | x | ||
| 30 | AC062 | STRING | NULLABLE | 2022-08-01 | Pre-approval request denied during quarter flag | x | ||
| 31 | AC064 | STRING | NULLABLE | 2022-08-01 | Pre-approval request approved but not accepted during quarter | x | ||
| 32 | AC065 | INTEGER | NULLABLE | 2022-08-01 | Net change in application amount | Net change in application amount during the report quarter | ||
| 33 | AC070 | STRING | NULLABLE | 2022-08-01 | Closed and funded during report quarter flag | x | ||
| 34 | AC080 | STRING | NULLABLE | 2022-08-01 | Application in process at end of period | x | ||
| 35 | AC100 | STRING | NULLABLE | 2022-08-01 | Conventional loan flag, Any loan other than FHA, VA, FSA or RHS loans | x | ||
| 36 | AC200 | STRING | NULLABLE | 2022-08-01 | One to four family dwelling flag | x | ||
| 37 | AC310 | STRING | NULLABLE | 2022-08-01 | Home improvement flag -- Any dwelling-secured loan to be used, at least in part, for repairing, rehabilitating, remodeling, or improving a dwelling (or the real property on which the dwelling is located) OR any loan not secured by a lien on a dwelling to be used, at least in part, for one or more of those purposes that is classified as a home improvement loan by the institution | x | ||
| 38 | AC500 | STRING | NULLABLE | 2022-08-01 | First lien flag -- secured by first lien | x | ||
| 39 | AC510 | STRING | NULLABLE | 2022-08-01 | Subordinate lien flag | x | ||
| 40 | AC610 | INTEGER | NULLABLE | 2022-08-01 | Lender Fees Collected-Forward Mortgages. The gross total amount of lender fees, examples include but are not limited to application fee, doc prep fee, administrative fee, you collected on forward mortgages during the period. Do not include pass through fees. | |||
| 41 | AC910 | STRING | NULLABLE | 2022-08-01 | Flag - total loans funded | x | ||
| 42 | AC940 | STRING | NULLABLE | 2022-08-01 | Not Subject to QM flag | x | ||
| 43 | AC1000 | STRING | NULLABLE | 2022-08-01 | Flag - Loans Made and Assigned but Required to Repurchase in Period | x | ||
| 44 | AC1100 | INTEGER | NULLABLE | 2022-08-01 | Gross Revenue from Operations | |||
| 45 | AC1200 | INTEGER | NULLABLE | 2022-08-01 | Flag - Closed Loan with Servicing Retained During the Quarter | |||
| 46 | AC1210 | STRING | NULLABLE | 2022-08-01 | Flag - Closed Loans with Servicing Released During the Quarter | x | ||
| 47 | I120_count | STRING | NULLABLE | 2022-08-01 | Closed and funded during quarter flag | x | ||
| 48 | I120_amount | INTEGER | NULLABLE | 2022-08-01 | Closed and funded amount |