Uniform Collateral Data Portal (UCDP ) General User Guide

1 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 1 of 106 Uniform Collateral data Portal ( ucdp ) General user Guide July 2018 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 2 of 106 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 3 of 106 TABLE OF CONTENTS INTRODUCTION .. 7 WHAT IS THE Uniform Collateral data Portal ? .. 7 WHO SHOULD READ THIS MANUAL? .. 7 WHAT S IN THIS MANUAL? .. 7 1.

2 LOGGING INTO ucdp .. 9 FOR USERS CREATED IN 10 Figure Email Sent to Created Users .. 10 Figure Login Page .. 11 Figure Password Expired Page .. 11 Figure Password change successful .. 12 Figure Email sent notifying of the password change .. 12 Figure Terms and Conditions Page .. 13 Figure Challenge Response Questions Page .. 14 FOR USERS INVITED TO ucdp .. 15 Figure Email Sent to Invited Users .. 15 Figure Self Registration Page .. 16 Figure Self Registration Successful Page .. 17 Figure Email Address Validation Request .. 17 Figure Login Page .. 18 Figure Terms and Conditions Page .. 19 Figure Challenge Response Questions Page .. 19 NAVIGATING THE HOME PAGE .. 20 Figure Home Page .. 20 Table Home Page Features .. 21 2. SUBMITTING AN APPRAISAL .. 23 Figure Accessing the Submit Appraisal Page .. 23 STEPS TO SUBMIT AN APPRAISAL data FILE.

3 24 Figure Submit Appraisal .. 24 Table Required fields in the Submit Appraisal Page .. 24 Table Optional Fields in the Submit Appraisal Page .. 25 Figure Submit Appraisal .. 25 Figure Add Appraisal 2 and/or 3 to a Loan Submission .. 26 Figure Multiple Loan Submission Page .. 27 Figure Additional Icons, Links, and Buttons .. 28 Table Icons, Links and Buttons on Submit Appraisal Page .. 29 THE PROGRESS BAR FOR SUBMITTED APPRAISALS .. 29 Figure Progress Bar .. 29 Figure Upload Confirmation Report Page .. 30 Table Upload Status Possibilities .. 30 ADDITIONAL REPORT OPTIONS .. 31 Figure Upload Confirmation Report Page Additional Options .. 31 Table Icons in Upload Confirmation 31 VIEW/EDIT PAGES FOR APPRAISAL SUBMISSIONS .. 32 Figure View/Edit Page .. 33 Section 1: Submission Information .. 34 Figure Section 1 - Submission 34 Section 2: Appraisal Information.

4 34 Figure Section 2 - Appraisal Information .. 35 Section 3: Submission History .. 36 Figure Section 3 - History .. 36 3. SEARCHING FOR PREVIOUSLY SUBMITTED APPRAISALS .. 37 INITIATING A SEARCH .. 37 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 4 of 106 Figure Search Feature on the Home Page .. 37 Figure Appraisal Search Page .. 38 Table Search Parameters .. 39 VIEWING SEARCH RESULTS .. 40 Figure Search Results Page .. 40 Table Search Results Page Functions .. 41 Figure Search Page Legend .. 42 Figure Expanded Search Results Selection .. 43 Figure View Standard Form Report .. 44 USING ZIPPED FOLDERS .. 45 Figure Zipped Folder Download Options .. 45 Figure Zipped Folder Download .. 45 4.

5 VIEWING AND EDITING APPRAISAL INFORMATION .. 47 Figure Access View/Edit Page from the Upload Confirmation Report .. 47 Figure Access View/Edit Page from the Search Results Page .. 47 Figure View/Edit .. 49 SECTION 1 SUBMISSION INFORMATION .. 50 Figure View/Edit Page Submission Information (View Mode) .. 50 Figure View/Edit Page Submission Information (Edit Mode) .. 50 Table Submission Information Fields .. 51 Table Additional View/Edit Features .. 51 ADDING ANOTHER INVESTOR (GSE) .. 52 Figure View/Edit Page Add Another Investor .. 52 SECTION 2 - APPRAISAL INFORMATION .. 52 Figure View/Edit Page Appraisal Information .. 53 Table Appraisal Information Subsections .. 54 Appraisal Submission Information .. 54 Figure View/Edit Submission Information subsection .. 55 Appraisal File Operations .. 55 Figure File Operations subsection.

6 55 Appraisal Hard Stops .. 56 Figure Hard Stops subsection .. 57 Appraisal Findings (Appraisal 1, 2 and/or 3) .. 57 Figure Appraisal Findings Page .. 58 Table Findings Subsection .. 59 Working with Appraisal 2 and/or 3 .. 59 Figure File Operations Appraisal 2 and/or 3 .. 59 Figure Submission Information Appraisal 2 and/or 3 .. 60 SECTION 3 HISTORY INFORMATION FOR ALL APPRAISALS (APPRAISAL 1, 2 AND/OR 3) .. 61 Figure History subsection page .. 61 Table History subsection .. 61 5. GENERATING REPORTS .. 63 Figure Reports Tab .. 63 SUBMISSION REPORT DETAILS .. 64 Figure Submission Report Page .. 64 Table ucdp Standard Reports .. 64 Appraisal Failure Details Report .. 65 Figure Appraisal Failure Details Report Creation Page .. 65 Figure Scheduled Reports Email Notification .. 66 Figure Appraisal Failure Details Report Results Page.

7 67 Figure Report Navigation and Other Features .. 67 Figure Appraisal Failure Details Report Excel File Output .. 67 Figure Excel File Output Sample Legend tab .. 68 Appraisal Failure Summary Report .. 69 Figure Appraisal Failure Summary Report Creation Page .. 69 Figure Appraisal Failure Summary Report Results Page .. 70 Figure Report Navigation and Other Features .. 71 Figure Appraisal Failure Summary Report Results Page .. 71 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 5 of 106 Figure Excel File Output Sample Legend tab .. 71 Appraisal Submission Status Report .. 72 Figure Appraisal Submission Status Report Creation Page .. 72 Figure Appraisal Submission Status Report Results 73 Figure Report Navigation and Other Features.

8 74 Figure Appraisal Submission Status Report Excel File Output .. 74 Submission Summary Report .. 75 Figure Submission Summary Report Creation Page .. 75 Table Information contained in Submission Summary 76 Table Icons in Submission Summary Report .. 76 Figure Fannie Mae Submission Summary Report .. 77 Figure Freddie Mac Submission Summary Report .. 78 MY REPORTS .. 79 Table My Reports .. 79 Figure My Reports Page .. 80 Figure Edit Mode of the My Reports Page .. 80 6. ACCOUNT 81 Figure Account Administration .. 81 MANAGING YOUR user PROFILE .. 82 Figure user Profile Page .. 82 Figure Email Notice about a Scheduled Report .. 83 Figure Email Notice about a System Hard Stop Encountered .. 83 EDITING YOUR user ACCOUNT .. 84 Figure user Account Self Care Page .. 84 Figure user Account Challenge Response Questions Page .. 85 7. HELP CENTER.

9 87 Figure Help Center Access from Home Page .. 87 Figure Help Center user Guides Tab .. 88 Table Help Center Contents .. 89 APPENDIX A: FREQUENTLY USED TERMS .. 91 APPENDIX B: SUPPORTED APPRAISAL FORMS .. 93 Table Supported Appraisal Forms .. 93 APPENDIX C: SUPPORTED FILE FORMATS .. 95 APPENDIX D: LIST OF HARD STOPS .. 97 Table Hard Stop Description Table .. 97 Table 9001 Hard Stop Troubleshooting Guide .. 98 APPENDIX E: PASSWORD STRENGTH RULES AND RESET INSTRUCTIONS .. 99 Table Password Strength Rules .. 99 Figure Login Page Forgot Password Link .. 100 Figure Forgot Password Page .. 100 Figure Forgot Password Request Message .. 101 Figure Email Sent to Reset Password Request .. 101 Figure Password Reset Page Challenge Questions and Answers .. 102 Figure Password Reset Page New Password .. 102 Figure Password Reset Confirmation Page.

10 103 Figure Email Sent for ucdp Password Change .. 103 APPENDIX F: APPRAISER LICENSE VERIFICATION (GUIDANCE FOR LENDERS AND APPRAISERS) .. 105 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 6 of 106 This document relates to the Uniform Mortgage data Program , an effort undertaken jointly by Fannie Mae and Freddie Mac at the direction of their regulator, the Federal Housing Finance Agency. 7 of 106 Introduction What is the Uniform Collateral data Portal ? The Uniform Collateral data Portal ( ucdp ) is the Web-based Portal lenders and their designated agents use to electronically submit appraisal data files prior to loan delivery to Fannie Mae and/or Freddie Mac (Government Sponsored Enterprises or GSEs). Through the ucdp , you can submit up to 10 appraisal data files at a time, search for previously submitted appraisals, clear hard stops, view reports, and share appraisals with your business partners.