Post date: May 14, 2015 9:49:27 PM
Error reports are received from LMWS in response to our twice daily (three times on the first Tuesday of each month), when data conditions exist on loans that prevent the import process from importing them. These responses are received via email to adr.support@quandis.com , and come from lmwmgr@he2unxpv228.fhlmc.com. The subject of the email is "Error Report for Foreclosure/Bankruptcy Loan Level Attorney Data" The following two sections describe the data conditions, and the process on how to correct them and/or notify the appropriate party(ies) of the concern.
Invalid Key/Loan Combination Procedure
Key IDs are sent with each case, and are unique identifiers to LMWS, which allow the ADR system to send updates on existing cases. The "Invalid Key/Loan Com" error means the Key ID we are attempting to submit was used to identify a previous case associated with a different Freddie Mac loan number. An example of this is: F001351000 1281 991208293 723147115 Invalid Key/Loan Com. The Key ID associated with the new loan/case will need to be reset in the ADR system.
You will be using the "LMWSKeyIDFix.xlsx" spreadsheet for this, which is attached to this Blog Post.
Open the "inval_loans_lenstar.doc" attachment found in the LMWS Error Report email and copy all rows with a reason of "Invalid Key/Loan Com"
Paste these into the LMWSKeyIDFix spreadsheet, starting with row 2 (header row must remain as-is)
In some cases, multiple Invalid Key/Loan Com items will not be grouped together, the easiest way to deal with this is to copy all of the contents of the Word Doc, paste them into the spreadsheet and delete the inapplicable rows, being sure to remove any empty rows entirely
Once all items have been pasted into the spreadsheet, they will need to be separated into individual columns
Select the A column for all rows you have pasted in (starting with A2, do not select A1, which is the header row; example: you have 3 Invalid Key/Loan Com items, you should have A2, A3 and A4 selected)
Select the "Data" tab in the toolbar ribbon, then select "Text to Columns", a 3-step wizard will pop up
In the first step, select the radio button for "Fixed width", then click "Next"
The second step is where you are able to specify what data should be in each column. This can be left the way Excel assumes it should be, click "Next"
Step 3 allows you to define the data formats. Highlight all rows and select the "Text" radio button. This will preserve any leading 0s in the columns
Click "Finish"
Your data is now placed in the appropriate columns
Any data that was placed in columns E, F, G and further to the right can be deleted
Sort the spreadsheet by the first column and remove any duplicates
Save this spreadsheet to your file system (i.e. Desktop)
Login to www.freddiemacadr.com and navigate to "Dashboard" >> "Import Data"
Select "KeyID Cleanup" from the "Import Dashboard" list
Drag and drop the LMWSKeyIDFix spreadsheet that you saved to your file system into the light blue bar above the panel that rendered on the right side of the page
The panel to the right will refresh and the import will be queued
Select "Refresh" from the "Options" dropdown in that panel and review the status. If the status of your import does not update to "Complete" within 10 minutes, contact the lead developer for the ADR system to assist with troubleshooting
Upon successful import, ensure the loans do not appear in the following transmission. If found there, contact the lead developer for the ADR system to assist with troubleshooting
Invalid Loan Number Procedure
LMWS rejects any cases that are associated with "Invalid Loans" There are two definitions of "Invalid Loans", for the purpose of this procedure:
The Loan exists in the LMWS database, but is not in a valid status. An example of a valid status is "Foreclosure", and an example of an invalid status is "Active"
The Loan does not exist in the LMWS database
Follow the steps below for each Foreclosure case that is identified as "Invalid Loan Number" in the "inval_loans_lenstar.doc" attachment. Foreclosure cases are identified with the letter "F" at the beginning of the row within the attachment. Example: F003007910 4111 790944103 NULL Invalid Loan Number. All items with other leading letters can be skipped.
Login to www.freddiemacadr.com and navigate to "Dashboard" >> "Loans" (default landing page)
Search for the Loan Number identified as invalid
Click on the loan number to access the Loan Summary page
Scroll to the Process tabs (Foreclosure, Bankruptcy and Deficiency)
Select the tab for the appropriate Process Type
Foreclosures are identified by the letter "F" at the beginning of the keyid field in the attachment
Bankruptcies are identified by the letters "P" (POC) and "B" (MFR) at the beginning of the keyid field in the attachment
Click on the Attorney Case ID link to access the case's Summary page. If there are more than one cases of that type, additional research will be required to locate the appropriate case
If the attorneys are different between the cases, navigate to each attorney's Organization Summary page and locate the four digit code in the "Tags" panel. Match this code with the four digit code in the id_atty column of the attachment
If the attorneys are the same for all cases, the history records of each case, and their Tasks will need to be researched to identify which was updated most recently
Once the proper case is found, review its history, and the history records of the Tasks, Holds, Messages and Attachments and obtain the username of the user that performed the most recent update
Navigate to the Attorney Organization and obtain the primary contact for the firm
Send an email with the following information to these two contacts:
Subject: ADR – Invalid Loan Number
Body:
Hello,
Freddie Mac has identified the following loan(s) as being in a non-delinquent status: [LoanNumber]
A foreclosure or bankruptcy case was added or updated recently, which triggered the alert from Freddie
Mac. Please review your case and contact Freddie Mac directly with any questions on loan level
information.
Thank you.