ADR Attorney Integration Guide

ADR Attorney Integration Guide


Version 1.30

2023.01.13

Notice

Copyright © 2013 by Quandis. All rights reserved. This document contains confidential and privileged material for the sole use of the intended reader. Any review or distribution not expressly authorized herein is strictly prohibited. The XML structure and definition of this document represents material that is protected by international and federal copyright and trademark laws and Quandis is the sole owner of all intellectual property contained in this document. Any use or reuse of this XML structure or format is strictly prohibited and constitutes a violation of Quandis’ Copyright and other intellectual property protection. The information contained within this document represents confidential information as governed and defined in the Quandis Non-Disclosure Agreement to which the user has agreed by virtue of such user’s use of the information contained herein. If you are not the intended reader of this document please contact Quandis and destroy all copes and even if you are not he intended recipient, you are still subject to the all rights reserved by Quandis and the protections set forth herein or any other rights enjoyed by Quandis for any reason whatsoever. No part of this document may be reproduced, stored, archived, or transmitted in any form without the express written consent of Quandis.

Quandis has used its best effort in preparing this document. Quandis makes no representations, or warranties with respect to the accuracy or completeness of this document and specifically disclaims any implied warranties or merchantability or fitness for a particular purpose. Quandis shall have no liability to any party wherever located because of any use or attempted use of this document.


Table of Contents

Revision History

Overview

Objective

Definitions

System Connectivity

Security Model

ADR Environments

Submission URLs

Data Submission

Submission Checklist

HTTP Response Status

Interpreting Import Result XML

Supported Operations

Data Binding

SubscriberID Patterns

Data Binding Scenarios

Scenario 1 – Updating a Process Record Using a SubscriberID

Scenario 2 – Updating Child Records During Process Update Using a SubscriberID

Scenario 3 – Updating Child Records Using Stand-Alone Format Using a SubscriberID

Scenario 4 – Updating a Process Record Using Autobind

Scenario 5 – Updating Child Records During Process Update Using Autobind

Scenario 6 – Updating Child Records Using Stand-Alone Format Using Autobind

Operations

Data Definition Legend

Foreclosure – New Referral

Foreclosure Update

POC – New Referral

POC Update

MFR – New Referral

MFR – Update

Message

Document

ImportForm

Embedded Object Structures

Total Debt Ledger

Pre Post Petition Ledger

Decision Delay

Import Form

Messages

Documents

Appendix A: Workflow Steps

Appendix B: Decision Delay Templates

Appendix C: Court List

Appendix D: Ledger Templates

Appendix E: FAQ & Troubleshooting

Appendix F: ADR Certification Checklist

Appendix G: Required Foreclosure Documents

Appendix H: Import Dashboard

Appendix I: Attachment Templates


DateVersionDescription
2013-05-201.0Initial Release
2013-05-201.1Fixed Typo in checklist in Security Model. Adjusted ImportResult data definition table.
2013-05-211.2Adjusted definitions, Security Model and FAQ.
2013-05-241.3Updated URLs and Appendix A. Added ADR Certification Checklist.
2013-05-281.4Updated Bankruptcy templates in Appendix A.
2013-05-311.5Updated field requirements.
2013-07-251.6Updated workflow steps for: Alabama and Michigan. Added workflow for Texas Home Equity, Nebraska (Non Judicial). See Appendix A. Court names updated. See Appendix D. Added Appendix H for Required Documents. Removed DateClosed and ClosedReason from Foreclosure, MFR and POC referral schemas. DateClosed and ClosedReason can be passed in the Update method. Added Appendix I for Import Dashboard.
2013-12-061.7Removed step ‘Notice of Default’ for Alabama Non-Judicial. Added ‘Litigation Detail’ as type of delay. Added Opening Bid Amount as required value for ‘Foreclosure Sale Held’ step.
2014-01-271.8Added Judicial Wofkflows for Alaska, Alabama, Arkansas,  Arizona, Minnesota, Missouri, Montana and Nevada. Added Non Judicial workflow for Hawaii.Foreclosure Sale Held task – UPB is required when completing the task and value must be greater than $0. If the property is identified as being sold to a 3rd party or undisclosed, the Sale Amount must be greater than $100.Made Bar Date non mandatory while creating new MFR or POC referrals.
2014-02-241.9Add Michigan Judicial workflow. Added max length for text fields.
2014-03-191.10Removed “Redemption Period Expires” step from PA process. Additional data requirements for the “Foreclosure Sale Held” step.
2014-04-231.11Made Court Case number mandatory while completing “Complaint Filed” step.Change in sequence for Rhode Island template.
2014-05-081.12Changed step name for Rhode Island workflow.
2014-06-261.13Added NY Co-op workflow
2014-07-151.14Changed steps for CO Non-Judicial workflow
2014-08-151.15Updated Attachment Template setting to “Many Per Parent” for “FC Document” and “Affidavit of Service”.
2014-09-181.16Updated list of Workflows.  Added list of Attachment Templates.
2015-02-231.17Updated list of Workflows. Templates for CO Non Judicial, CT Judicial, LA Judicial (Executory), MN Non Judicial, NJ Judicial, NV Non Judicial, NY Co-op, PR Judicial, RI Non Judicial, WA Judicial, and WV Non Judicial have been added/updated. See Appendix A for details.Updated ImportForm Data Definition and Sample XML.
2015-06-021.18Added OR Non-Judicial workflowAdded CA Judicial workflowUpdated NY Co-Op workflowUpdated MI Non-Judicial workflow
2017-02-101.19Updated DecisionDelayTemplate listAdded ImportForm Message requirementAdded Bankruptcy Case Closure requirementsRemoved Workflow Steps Table and added reference to Attorney User Guide; to be maintained thereRemoved DCS Milestone Appendix (B)Added Foreclosure and Bankruptcy Closed Reason Enumerations
2017-08-171.20Added Foreclosure and Bankruptcy Case Closure ImportForm data elements
2017-09-171.21Synced Foreclosure and ForeclosureUpdate operations; general cleanup
2018-08-151.22Added new elements required for ordering Title
2018-11-161.23Added ProcessType in Foreclosure Operation sample XML
2019-10-181.24Added Autobind documentation; updated all Operations and their schemas to account for conditional requirements based on Autobind addition
2020-01-141.25Removed Autobind from standalone Operations; not currently supported
2020-02-221.26Added Total Debt Ledger Posted Date to ImportForm operation
2022-06-211.27Added single line item to Troubleshooting section
2022-06-291.28Added “HAF” to list of Hold Templates in Appendix B; general clean-up for that table
2022-09-061.29Added Converted Date, Discharged Date and Dismissed Date elements
2023-01-131.30Removed all references to the “Restart” Operation. Restart feature is no longer available
2025-01-281.31Added errors related to Bid information to Troubleshooting Errors section in Appendix E; Changed required fields to conditional where appropriate

Overview

Objective

This document is a technical guide integrating attorney system with Freddie ADR system. It describes transmission protocols utilized, xml messaging and schema requirements. It will also outline general usage and common error types.

It is written for both prospective and new system integrators, consultants and other technical professionals interested in integrating with ADR.

Definitions

The following terms are referred to in this document.

TermDefinition
ADRAttorney Data Reporting System
EndpointWeb service or HTTP receiver that is exposed by an organization to receive inbound data
QBOAcronym for Quandis Business Objects. Generally refers to any module or component that has been created by Quandis.
ImportFormQBO term used to represent a tracking step in ADR. Formerly known as Milestone in DCS. Synonymous with task or step in other systems.
RESTAcronym for Representational State Transfer
HTTPSAcronym for Hypertext Transfer Protocol Secure. See http://en.wikipedia.org/wiki/HTTP_Secure
BASIC AuthenticationHTTP authentication method. Seehttp://tools.ietf.org/html/rfc2617http://en.wikipedia.org/wiki/Basic_access_authentication
Process Object / Process RecordRefers to a process record in ADR. Process records are database records which represent a Foreclosure, MFR and POC.
ImportFormObject structure used in ADR for step tracking within an ADR process. Formerly known as Milestone in DCS.
DecisionDelayObject structure used in ADR to track delays within a process.
MessageObject structure used in ADR to store note or memo data.
LedgerObject structure used to ADR to store accounting information.
ADR CertificationCertification process in which integrators must successfully complete before they are allowed submit data to the ADR production environment.

System Connectivity

ADR receives data via the public internet using HTTPS (2048 bit) protocol as the standard protocol. VPN connectivity is supported under special circumstances. ADR supports REST service API.

Security Model

ADR uses BASIC Authentication as the primary authentication method. Authentication is obtained by specifying the security credentials provided by Quandis

In order to successfully authenticate with the ADR API, the following HTTP headers must be observed:

HTTP HeaderAdditional Notes
AuthorizationQuandis will procure credentials for each ADR environment. These credentials must be supplied with each call. The credentials are used to construct the BASIC authentication header.
User-Agent OR SOAPAction Ensure HTTP header “User-Agent” is nonexistent in the call or the HTTP header “SOAPAction” exists with a value. By satisfying either, ADR infers the call is an automated request and issues a Basic Authentication challenge instead of redirecting for forms authentication.

ADR Environments

ADR exposes the following environments

EnvironmentPurposeHostname
DEVDevelopment environment used for initial connectivity and integration testsdevadr.quandis.net
UATQA environment used for system integration testingintegrationadr.quandis.net (to be deprecated as of 08/22/2018)uatadr.quandis.net
PRODProduction environmentintegration.freddiemacadr.com (to be deprecated as of 10/04/2018)www.freddiemacadr.com

Submission URLs

ADR exposes separate URLs for each resource. The URLs follow the pattern:

http://{baseUrn}/Import/Import.ashx/{OperationName}

  • baseUrn is the ADR environment name
  • OperationName is the import operation.

The following are examples of URLs to distinct ADR resources:

URLDescription
https://devadr.quandis.net/Import/Import.ashx/ForeclosureResource used to call Foreclosure operation in ADR development environment
https://uatadr.quandis.net/Import/Import.ashx/ImportFormResource used to call ImportForm operation in ADR UAT environment
https://www.freddiemacadr.com/Import/Import.ashx/MFRResource used to call MFR operation in ADR production environment

Unless otherwise specified all ADR operations must be performed as HTTP POST. Please refer to the full list of operations in the Supported Operations section of the integration guide.


Data Submission

Submission Checklist

To submit data to ADR, the following criteria must be met:

ItemDetails
HTTP Headers correctly setRefer to “Security Model”
URL Resource must be specifiedRefer to “Submission URLs”.
HTTP MethodMust be set to “POST”
Xml Content must be in correct formatRefer To “Operations”. The format of the Xml must match the schema format associated with the operation

The following diagram depicts the processing flow of an ADR Import submission.


HTTP Response Status

Upon submission, the ADR resource will return HTTP status. Any status other than 200 indicates a problem with the submission. The following table outlines the possible statuses:

HTTP StatusDescription
200Success. Refer to Import Result XML
401Login failure. Check credentials and ensure credentials match environment
500Failure(s) occurred. Refer to Import Result Xml for additional detail

Interpreting Import Result XML

Import Result is the XML output returned by the ADR Import resource. It is important to observe the XML is returned in both successful and non-successful scenarios. The Xml format contains summary information and detail information. Depending on the operation invoked, the detail information can contain one or many items.

The following table outlines the various attributes of an Import Result:

NodeRequiredTypeLengthDescription / Enumerations
ImportResultsYNContains summary information for import operation
IDYIImportFileID. Searchable in ADR
SuccessCountYISuccessful objects inserted or updated.
WarningCountYIWarning Count
ErrorCountYIError Count
StatusYEComplete, Error, Validation Error
ImportStartYDImport Start Time
ImportCompleteYDImport Complete Time
ReferenceNTReference Value provided by client. Searchable in ADR
ResultNNIndividual Operation Result
IDYIImportLogID. Searchable in ADR
ReferenceNO, TReference provided by client for individual operation. Searchable in ADR
ObjectYTObject affected by Import
ObjectIDNIObjectID of Object
OperationYTOperation performed on object.
StatusYTOutcome of operation. Success, Error
MessageOTOnly produced when Operation results in Error.  Reason for Operation error
PropertiesONCollection of object properties. Will be omitted if Reference attribute is provided at Operation level

Supported Operations

Data Binding

Data binding is the ability to locate an existing record on a subsequent submission during automation. Data binding locates the process object using one of the following methods:

  • SubscriberID pattern
  • Autobind

Process objects are the primary referral types which consist of:

  • Foreclosure
  • MFR
  • POC

There are two scenarios when data binding is utilized:

  • Updating an existing process object (eg. Foreclosure, MFR or POC)
  • Saving child objects which are related to a process object (eg. Completing an ImportForm or adding a DecisionDelay)

SubscriberID Patterns

When XML data is submitted to ADR, a SubscriberID can be included in each XML message, which enables the message to be uniquely identified. ADR schemas will utilize SubscriberID patterns in two different formats:

  • Process SubscriberID – This format is when a process structure is passed and contains a SubscriberID nested in the XML. By nesting a SubscriberID in the process XML, any data contained in the XML is bound to the process
  • Object / ObjectSubscriberID – This format is utilized when an object is submitted stand-alone and not nested in a process object. By providing a combination of Object and ObjectSubscriberID the process record can be located and the object can be bound correctly. Note the value contain in ObjectSubscriberID is the same exact value as Process SubscriberID.

The format of SubscriberIDs follows a general pattern. In addition, there are several key aspects of the SubscriberID pattern that must be adhered to at all times. Consider:

  • SubscriberIDs are globally unique
    • For example, if a Foreclosure is submitted with a SubscriberID value of: http://www.attorney.com-Foreclosure-181 any updates to this Forclosure must be sent with the same SubscriberID value or they will be interpreted as a targeting a different Foreclosure record.
  • SubscriberIDs follow the pattern <url of source>-<tablename of object in source system>-<identity of object in source organization>
    • URL of source- contains the URL of the source organization. In the case of a ADR data, this is the URL of the attorney website or attorney Case Management System (CMS). Eg.  www.attorney.com
    • Table name of object – generally contains the table name the object was exported from. Eg. In the ADR system, Foreclosures are exported out of the Foreclosure table. Hence, the value would be ‘Foreclosure’.
    • Identity of object – This is the primary key identity of the object in the source system. Eg. The Foreclosure row in the vendor system has a primary key value of 181
    • A full example would be www.attorney.com-Foreclosure-181

Autobind

When a SubscriberID is not provided, ADR will utilize the Freddie Mac Loan Number and Attorney Case ID to uniquely identify the case. Updates to Processes and their child objects can be performed using this method.  If multiple records with the same Attorney Case ID are present, Autobind will bind to the active case first, and if no active case is present, it will bind to the most recent case, based on the DateOpened value.

Two assumptions are made in regards to the Attorney Case ID when using the Autobind method for data binding:

  • The Attorney Case ID must be unique across all cases within the firm’s Case Management System (CMS)
  • The Attorney Case IDs for each case must match between the attorney’s CMS and the ADR system
    • Should the Case ID change in the CMS, the Case’s ID in the ADR system will need to be manually updated by a user from the UI.  See the ADR Attorney User Guide for instructions on how to perform this function.

Data Binding Scenarios

Scenario 1 – Updating a Process Record using a SubscriberID

Updating a process record is the ability to submit an update that will locate a given process and update the record. Common scenarios include:

  • Closing a Process (eg. Closing a process, sale information)
  • Changing attributes of a Process (eg. Updating debtor contact, borrowers)

In both of these scenarios, the Xml submitted contains a process object structure that contains a SubscriberID which uniquely identifies the process record. An example of a process update is:

<ImportCollection>

<MFRItem>

<SubscriberID>http://www.attorney.com-MFR-1000000</SubscriberID>

<DateClosed>2013-01-01</DateClosed>

<ClosedReason>Reinstated</ClosedReason>

</MFRItem>

</ImportCollection>

Scenario 2 – Updating Child Records During Process Update using a SubscriberID

Most objects tied to a process can be updated by nesting them in a process update. The following example shows how to update an ImportForm as part of a process update:

<ImportCollection>

<MFRItem>

<SubscriberID>http://www.attorney.com-MFR-1000000</SubscriberID>

<Forms>

<ImportFormItem>

<Template>Bankruptcy File Received</Template>

<ActualCompletion>2013-01-01</ActualCompletion>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</Forms>

</MFRItem>

</ImportCollection>

By nesting the ImportForm in the process update, the ImportForm record is automatically bound the process record.

Scenario 3 – Updating Child Records Using Stand-Alone Format using a SubscriberID

An alternate way to update ImportForms is to submit them stand-alone or outside of the process update. Updating an ImportForm using a non process object format or stand-alone format requires the object to be submitted with a format that contains a reference to the process object using the Object/ObjectSubscriberID format. An example of a stand-alone update is:

<ImportCollection>

<ImportFormItem>

<Object>Bankruptcy</Object>

<ObjectSubscriberID>http://www.attorney.com-MFR-1000000</ObjectSubscriberID>

<Template>Bankruptcy File Received</Template>

<ActualCompletion>2013-01-01</ActualCompletion>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</ImportCollection>

Scenario 4 – Updating a Process Record using Autobind

Updating a process record is the ability to submit an update that will locate a given process and update the record. Common scenarios include:

  • Closing a Process (eg. Closing a process, sale information)
  • Changing attributes of a Process (eg. Updating debtor contact, borrowers)

In both of these scenarios, the Xml submitted contains a process object structure that contains the Attorney Case ID which uniquely identifies the process record. An example of a process update is:

<ImportCollection>

<MFRItem>

<MFR>010.X9899.19</MFR>

<DateClosed>2019-10-01</DateClosed>

<ClosedReason>Motion Granted</ClosedReason>

</MFRItem>

</ImportCollection>

Scenario 5 – Updating Child Records During Process Update using Autobind

Most objects tied to a process can be updated by nesting them in a process update. The following example shows how to update an ImportForm as part of a process update:

<ImportCollection>

<ForeclosureItem>

<Foreclosure>19-FC12345</Foreclosure>

<Loan>

<Agency>Freddie Mac</Agency>

<Loan>000135114</Loan>

</Loan>

<Forms>

<ImportFormItem>

<Template>Foreclosure File Received</Template>

<ActualCompletion>2019-10-01</ActualCompletion>

<Messages_0_Messsage>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</Forms>

</ForeclosureItem>

</ImportCollection>

By nesting the ImportForm in the process update, the ImportForm record is automatically bound the process record.


Operations

The following is the list of operations supported by ADR Attorney Integration API.

OperationDescriptionStand-AloneSchema File
ForeclosureCreates new Foreclosure referralNoForeclosure.xsd
ForeclosureUpdateUpdates existing Foreclosure, including updating status, sale information, financial information, delays and forms.NoForeclosure.Update.xsd
POCCreates new POC referralNoPOC.xsd
POCUpdateUsed to update an existing POC, including updating status, sale information, financial information delays and forms.NoPOC.Update.xsd
MFRCreates new new MFR referralNoMFR.xsd
MFRUpdateCan be used to update an existing MFR, including updating status, sale information, financial information, delays and forms.NoMFR.Update.xsd
MessageAdds message on an existing Foreclosure, POC or MFR referralYesMessage.xsd
DocumentAdds document on an existing Foreclosure, POC or MFR referralYesDocument.xsd
ImportFormUpdates ImportForm (aka Steps/Milestones/Tasks) on an existing Foreclosure, POC or MFR referralYesImportForm.xsd
ResultReturns import result Xml from an individual submission. This call must be performed as a HTTP GET.N/AN/A

Data Definition Legend

The following table provides a definition on the Required and Type columns for field definition.

CategoryEnumerationDescription
RequiredYYES. Item is required
RequiredNNo. Items is not required
RequiredOOptional. Optionally required and pertains to parent nodes
RequiredCConditional. Required under certain conditions (see Description)
TypeNNode. Represents parent-most node of embedded object structure
TypeEEnumerated. See Description or schema for details
TypeAXml Attribute
TypeTText
TypeDDate.  Acceptable formats are:
YYYY-MM-DD
YYYY-MM-DDTHH:MM:SS
YYYY-MM-DDTHH:MM:SS+HH:MM
YYYY-MM-DDTHH:MM:SS-HH:MM
YYYY-MM-DDTHH:MM:SSZ
TypeMMoney
TypeIInteger


Foreclosure – New Referral

This operation can be used to create a new Foreclosure referral.
****The structure of the XML submitted must follow the order found in the table below****

Data Definition

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionN
ReferenceNAJob number of submission
ForeclosureItemYN
ReferenceNA50Unique value representing Foreclosure record in attorney CMS
SubscriberIDNT255Unique Foreclosure identified in following pattern:
http://www.<AttorneyName>.com-Foreclosure-<Loan>
LoanYN
AgencyYEWill always be “Freddie Mac”
LoanYT9Valid FreddieMac Loan Number
Property_AddressNT100Property Address
Property_CityNT50Property City
Property_PostalCodeNT10Property Postal Code; 5-digit or 5+4 digit
ServicerLoanIDYT100Servicer’s Loan Number
LoanTypeNEConventional, FHA, VA, USDA
OriginalBalanceYMOriginal Loan Amount
UPBAmountYMCurrent Unpaid Principal Balance
LienPriorityTypeNIIndicates Lien Position; Enumerations: 1, 2
PublicRecordsNN
PublicRecordItemCNRequired when providing PublicRecords element
PublicRecordCERequired when providing PublicRecords element
Will always be “Mortgage Deed of Trust”
FilingDateND Deed of Trust Dated Date
RecordingDateND Deed of Trust Recording Date
BorrowersN
BorrowerItemYNAt least one BorrowerItem required
LastNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
FirstNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
BorrowerTypeYEPrimary, Secondary
USSSNNT11
AddressNT50Mailing Street Address for Borrower(s)
CityNT50Mailing City for Borrower(s)
StateNT2Mailing State for Borrower(s)
PostalCodeNT10Mailing Postal Code for Borrower(s)
SequenceYIIndicates borrower sequence. Sequence value must be the same on subsequent submissions
ForeclosureYT50Attorney reference number/Case ID
DateOpenedYD
StatusYE“Open”, “On Hold”, “Closed”
ProcessTypeOE“Judicial”, “Non Judicial”, “Home Equity”, “Co-op”
DateClosedND
SaleAmountNM
SoldToNameNE“Back to Beneficiary”, “Third Party”, “Reverted to Senior”, “Undisclosed”
ScheduledSaleDateND
RedemptionDateND
DeficiencyStatusOE“Waived”, “Preserved”
RedemptionAmountNM
TotalDebtLedgerNNRefer to Total Debt Ledger
DelaysONRefer To Decision Delay
FormsONRefer To Import Forms
MessagesONRefer To Messages
AttachmentsONRefer To Documents
OpeningBidAmountOM

Sample XML

<ImportCollection>

<ForeclosureItem>

<SubscriberID>http://www.attorney.com-Foreclosure-10000053</SubscriberID>

<Loan>

<Agency>Freddie Mac</Agency>

<Loan>408693568</Loan>

<Property_Address>601 E Hampton St</Property_Address>

<Property_City>Riverside</Property_City>

<Property_PostalCode>91406</Property_PostalCode>

<ServicerLoanID>00001255568</ServicerLoanID>

<LoanType>Conventional</LoanType>

<OriginalBalance>155765.33</OriginalBalance>

<UPBAmount>135400.44</UPBAmount>

<LienPriorityType>1</LienPriorityType>

<PublicRecords>

<PublicRecordItem>

<PublicRecord>Mortgage Deed of Trust</PublicRecord>

<FilingDate>2015-07-21</FilingDate>

<RecordingDate>2015-07-25</RecordingDate>

</PublicRecordItem>

</PublicRecords>

<Borrowers>

<BorrowerItem>

<LastName>Doe</LastName>

<FirstName>Jane</FirstName>

<BorrowerType>Primary</BorrowerType>

<USSSN>555124444</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

<Sequence>1</Sequence>

</BorrowerItem>

<BorrowerItem>

<LastName>Doe</LastName>

<FirstName>John</FirstName>

<BorrowerType>Primary</BorrowerType>

<USSSN>555124445</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

<Sequence>2</Sequence>

</BorrowerItem>

</Borrowers>

</Loan>

<Foreclosure>10000053</Foreclosure>

<DateOpened>2013-03-22</DateOpened>

<ProcessType>Non Judicial</ProcessType>

<TotalDebtLedger>

<Template>Total Debt</Template>

<Items>

<AccruedLateCharges>15.00</AccruedLateCharges>

<PendingAdvances>25</PendingAdvances>

<FCFeesCosts>

<Items>

<ForeclosureFee>15</ForeclosureFee>

</Items>

</FCFeesCosts>

</Items>

</TotalDebtLedger>

<Forms>

<ImportFormItem>

<Template>Foreclosure File Received</Template>

<ProjectedCompletion>2013-04-25</ProjectedCompletion>

<ActualCompletion>2013-05-02</ActualCompletion>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</Forms>

<Messages>

<MessageItem>

<Template>Attorney Message</Template>

<Message>This is the subject</Message>

<BodyText>Message Content Goes here</BodyText>

</MessageItem>

</Messages>

<Attachments>

<AttachmentItem>

<FileName>Deficiency.pdf</FileName>

<Template>Deficiency Judgment</Template>

<Description>Description goes here</Description>

<Content><![CDATA[Base64]]></Content>

</AttachmentItem>

</Attachments>

</ForeclosureItem>

</ImportCollection>


Foreclosure Update

Foreclosure updates can consist of a variety of data points. The following table indicates the parent node requirements for a Foreclosure update. Please refer to the schema for specific field level requirements.
****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionN
ForeclosureItemYN
SubscriberIDCT255Unique Foreclosure identified in following pattern:
http://www.<AttorneyName>.com-Foreclosure-<Loan>
Must match SubscriberID for existing case
Required if Foreclsoure node/value is not supplied
LoanNN
AgencyCEIf Loan Node/Collection is supplied, Agency is required
Will always be “Freddie Mac”
LoanCT9If Loan Node/Collection is supplied, Loan is required
Valid FreddieMac Loan Number
ServicerLoanIDNT100Servicer’s Loan Number
LoanTypeNEConventional, FHA, VA, USDA
OriginalBalanceNMOriginal Loan Amount
UPBAmountNMCurrent Unpaid Principal Balance
LienPriorityTypeNIIndicates Lien Position; Enumerations: 1, 2
PublicRecordsNN
PublicRecordItemCNRequired when providing PublicRecords element
PublicRecordCERequired when providing PublicRecords element
Will always be “Mortgage Deed of Trust”
FilingDateND Deed of Trust Dated Date
RecordingDateND Deed of Trust Recording Date
BorrowersNNIf Loan Node/Collection is supplied, Borrowers is required
BorrowerItemCNIf Borrowers Node/Collection is supplied, at least one BorrowerItem required
LastNameCT50If Borrowers Node/Collection is supplied, LastName is required
Combined length of LastName + FirstName cannot exceed 50 Characters
FirstNameCT50If Borrowers Node/Collection is supplied, FirstName is required
Combined length of LastName + FirstName cannot exceed 50 Characters
BorrowerTypeCEIf Borrowers Node/Collection is supplied, BorrowerType is required
Primary, Secondary
USSSNYT11
AddressNT50Mailing Street Address for Borrower(s)
CityNT50Mailing City for Borrower(s)
StateNT2Mailing State for Borrower(s)
PostalCodeNT10Mailing Postal Code for Borrower(s)
SequenceCIIf Loan Node/Collection is supplied, Sequence is required
Indicates borrower sequence. Sequence value must be the same on subsequent submissions
ForeclosureCEAttorney reference number/Case ID
Required when SubscriberID is not supplied.  Must match the Foreclosure value when the target Case was created
StatusYE“Open”, “On Hold”, “Closed”
DateClosedCDRequired when Status is set to “Closed”
ClosedReasonCERequired when Status is set to “Closed”
“Bankruptcy Filed”, “Case Completed”, “Charge Off Completed”, “Consent Judgment”, “Investor Loan Sold”, “Investor Request”, “Loss Mitigation Completed”, “Low Balance Loan”, “Opened In Error”, “Paid Off / Reinstated”, “Repurchased”, “Servicer Request”, “Third Party Sale Completed”
SaleAmountNM
SoldToNameNE“Back to Beneficiary”, “Third Party”, “Reverted to Senior”, “Undisclosed”
ScheduledSaleDateND
RedemptionDateND
DeficiencyStatusCERequired when Status is set to “Closed” and Closed Reason is “Case Completed” OR “Third Party Sale Completed”
“Waived”, “Preserved”
RedemptionAmountNM
TotalDebtLedgerNNRefer to Total Debt Ledger
DelaysONRefer To Decision Delay
FormsONRefer To Import Forms
MessagesONRefer To Messages
AttachmentsONRefer To Documents
OpeningBidAmountOM

Sample XML (With SubscriberID Binding)

<ImportCollection>

<ForeclosureItem>

<SubscriberID>http://www.attorney.com-Foreclosure-10000048</SubscriberID>

<Forms>

<ImportFormItem>

<Template>Foreclosure File Received</Template>

<ProjectedCompletion>2013-04-25</ProjectedCompletion>

<ActualCompletion>2013-05-03</ActualCompletion>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</Forms>

</ForeclosureItem>

</ImportCollection>

Sample XML (Using Autobind)

<ImportCollection>

<ForeclosureItem>

<Foreclosure>19-FC12345</Foreclosure>

<Loan>

<Agency>Freddie Mac</Agency>

<Loan>000135114</Loan>

</Loan>

<Forms>

<ImportFormItem>

<Template>Foreclosure File Received</Template>

<ActualCompletion>2019-10-01</ActualCompletion>

<Messages_0_Messsage>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</Forms>

</ForeclosureItem>

</ImportCollection>


POC – New Referral

This operation can be used to create a new POC referral.
****The structure of the XML submitted must follow the order found in the table below****

Data Definition

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
POCItemYN
SubscriberIDNT255Unique Bankruptcy record identified in following pattern:
http://www.<AttorneyName>.com-POC-<Loan>
LoanYN
AgencyYEWill always be “Freddie Mac”
LoanYT9Valid FreddieMac Loan Number
POCYT50Unique POC case identifier for attorney
BKCaseNoYT50Bankruptcy case number
ChapterYEBankruptcy chapter
FilingDateYDCase filing date
BarDateND
StateOfFilingYT2Filing state
DateOpenedYD
StatusYE“AP Order Entered”, “APO-Stip. Automatic Default Remedy”, “APO-Stip. No Automatic Default Remedy”, “Case Dismissed”, “Hold”, “Open”, “Stay Relief Denied”, “Stay Relief Granted”
CourtYERefer to Appendix D
DebtorContactYN
LastNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
FirstNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
USSSNNT11
AddressNT50Mailing Street Address for Debtor(s)
CityNT50Mailing City for Debtor(s)
StateNT2Mailing State for Debtor(s)
PostalCodeNT10Mailing Postal Code for Debtor(s)
CoDebtorContactNO, N
DebtorAttorneyContactNO, N
LastNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
FirstNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
AddressYT50
CityNT50
StateNT2
PostalCodeNT10
PrePostPetitionLedgerNNRefer to Pre Post Petition Ledger
DelaysONRefer To Decision Delay
FormsONRefer To Import Forms
MessagesONRefer To Messages
AttachmentsONRefer To Documents

Sample XML

<ImportCollection Reference=”abc”>

<POCItem>

<SubscriberID>http://www.attorney.com-POC-40000012</SubscriberID>

<Loan>

<Agency>Freddie Mac</Agency>

<Loan>0943079608</Loan>

</Loan>

<POC>40000012</POC>

<BKCaseNo>1234546</BKCaseNo>

<Chapter>9</Chapter>

<FilingDate>2013-01-13</FilingDate>

<StateOfFiling>FL</StateOfFiling>

<DateOpened>2013-03-29</DateOpened>

<Status>Open</Status>

<Court>Florida Southern Bankruptcy Court</Court>

<DebtorContact>

<LastName>Bankrupt</LastName>

<FirstName>Bobby</FirstName>

<USSSN>555124444</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

</DebtorContact>

<CoDebtorContact>

<LastName>Doe</LastName>

<FirstName>John</FirstName>

<USSSN>555114444</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

</CoDebtorContact>

<DebtorAttorneyContact>

<LastName>Attorney</LastName>

<FirstName>Contact</FirstName>

<Address>123 Attorney Street</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

</DebtorAttorneyContact>

<PrePostPetitionLedger>

<Template>Pre and Post Petition Arrearages</Template>

<Items>

<AccruedLateCharges>15.00</AccruedLateCharges>

</Items>

</PrePostPetitionLedger>

</POCItem>

</ImportCollection>


POC Update

POC updates can consist of a variety of data points. The following table indicates the parent node requirements for a POC update. Please refer to the schema for specific field level requirements.
****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
POCItemYN
SubscriberIDCT255Unique Bankruptcy record identified in following pattern:
http://www.<AttorneyName>.com-POC-<Loan>
Must match SubscriberID for existing case
Required if POC node/value is not supplied
POCCT255Unique POC case identifier for attorney
Required for Autobinding if SubscriberID node/value is not supplied
LoanCNRequired for Autobinding if SubscriberID node/value is not supplied
AgencyCEWill always be “Freddie Mac”
Required when Loan Collection is included
LoanCT9Valid FreddieMac Loan Number
Required when Loan Collection is included
StatusYE“AP Order Entered”, “APO-Stip. Automatic Default Remedy”, “APO-Stip. No Automatic Default Remedy”, “Case Dismissed”, “Closed”, “Hold”, “Open”, “Stay Relief Denied”, “Stay Relief Granted”Status=”Closed” must be accompanied by DateClosed and ClosedReason
DateClosedCDRequired when Status is set to “Closed”
ClosedReasonCE“Investor Request”, “Opened In Error”, “Repurchased”, “Servicer Request”, “Case Converted”, “Discharged”, “Dismissed”, “MFR   Granted”, “Paid Off / Reinstated”, “Investor Loan Sold”, “Loss Mitigation Completed”, “POC Filed”, “STIP / APO Entered”Required when Status is set to “Closed”
ConvertedDateCDRequired when changing the Case Chapter OR when setting the Closed Reason to “Case Converted”
DischargedDateCDRequired when setting the Closed Reason to “Dicharged”
DismissedDateCDRequired when setting the Closed Reason to “Dismissed”
DebtorContactNN
CoDebtorContactNN
DebtorAttorneyContactNN
PrePostPetitionLedgerNNRefer to Pre Post Petition Ledger
DelaysNNRefer To Decision Delay
FormsNNRefer To Import Forms
MessagesNNRefer To Messages
AttachmentsNNRefer To Documents

Sample XML

<ImportCollection>

<POCItem>

<SubscriberID>http://www.attorney.com-POC-10000000</SubscriberID>

<DateClosed>2013-04-15</DateClosed>

<ClosedReason>Case Completed</ClosedReason>

<CoDebtorContact>

<LastName>Doe</LastName>

<FirstName>John</FirstName>

<USSSN>555114444</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

</CoDebtorContact>

<PrePostPetitionLedger>

<Template>Pre and Post Petition Arrearages</Template>

<Items>

<AccruedLateCharges>15.00</AccruedLateCharges>

</Items>

</PrePostPetitionLedger>

</POCItem>

</ImportCollection>


MFR – New Referral

This operation can be used to create a new MFR referral.
****The structure of the XML submitted must follow the order found in the table below****

Data Definition

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
MFRItemYN
SubscriberIDNT255Unique Bankruptcy record identified in following pattern:
http://www.<AttorneyName>.com-MFR-<Loan>
LoanYN
AgencyYEWill always be “Freddie Mac”
LoanYT9Valid FreddieMac Loan Number
MFRYT50Attorney reference number
BKCaseNoYT50Bankruptcy case number
ChapterYEBankruptcy chapter
FilingDateYDCase filing date
BarDateND
StateOfFilingYE2Filing state
DateOpenedYD
StatusYE“AP Order Entered”, “APO-Stip. Automatic Default Remedy”, “APO-Stip. No Automatic Default Remedy”, “Case Dismissed”, “Hold”, “Open”, “Stay Relief Denied”, “Stay Relief Granted”
CourtYERefer to Appendix D
DebtorContactYN
LastNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
FirstNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
USSSNNT11
AddressNT50Mailing Street Address for Debtor(s)
CityNT50Mailing City for Debtor(s)
StateNT2Mailing State for Debtor(s)
PostalCodeNT10Mailing Postal Code for Debtor(s)
CoDebtorContactNO, N
DebtorAttorneyContactNO, N
LastNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
FirstNameYT50Combined length of LastName + FirstName cannot exceed 50 Characters
AddressNT50
CityNT50
StateNT2
PostalCodeNT10
PrePostPetitionLedgerNNRefer to Pre Post Petition Ledger
DelaysONRefer To Decision Delay
FormsONRefer To Import Forms
MessagesONRefer To Messages
AttachmentsONRefer To Documents

Sample XML

<ImportCollection Reference=”abc”>

<MFRItem>

<SubscriberID>http://www.attorney.com-MFR-40000030</SubscriberID>

<Loan>

<Agency>Freddie Mac</Agency>

<Loan>0996242716</Loan>

</Loan>

<MFR>40000030</MFR>

<BKCaseNo>1234546</BKCaseNo>

<Chapter>9</Chapter>

<FilingDate>2013-01-13</FilingDate>

<StateOfFiling>FL</StateOfFiling>

<DateOpened>2013-03-29</DateOpened>

<Status>Open</Status>

<Court>Florida Southern Bankruptcy Court</Court>

<DebtorContact>

<LastName>Bankrupt</LastName>

<FirstName>Bobby</FirstName>

<USSSN>555124444</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

</DebtorContact>

<CoDebtorContact>

<LastName>Doe</LastName>

<FirstName>John</FirstName>

<USSSN>555114444</USSSN>

<Address>123 Maple</Address>

<City>Miami</City>

<State>FL</State>

<PostalCode>33135</PostalCode>

</CoDebtorContact>

<DebtorAttorneyContact>

<LastName>Attorney</LastName>

<FirstName>Contact</FirstName>

<Address>123 Attorney Street</Address>

<City>Ocala</City>

<State>FL</State>

<PostalCode>33139</PostalCode>

</DebtorAttorneyContact>

<PrePostPetitionLedger>

<Template>Pre and Post Petition Arrearages</Template>

<Items>

<AccruedLateCharges>10.00</AccruedLateCharges>

</Items>

</PrePostPetitionLedger>

<Forms>

<ImportFormItem>

<Template>Bankruptcy File Received</Template>

<ProjectedCompletion>2013-04-25</ProjectedCompletion>

<ActualCompletion>2013-04-26</ActualCompletion>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</Forms>

</MFRItem>

</ImportCollection>


MFR – Update

MFR updates can consist of a variety of data points. The following table indicates the parent node requirements for a MFR update. Please refer to the schema for specific field level requirements.
****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
MFRItemYN
SubscriberIDCT255Unique Bankruptcy record identified in following pattern:
http://www.<AttorneyName>.com-MFR-<Loan>
Must match SubscriberID for existing case
Required if MFR node/value is not supplied
MFRCT255Unique MFR case identifier for attorney
Required for Autobinding if SubscriberID node/value is not supplied
LoanCNRequired for Autobinding if SubscriberID node/value is not supplied
AgencyCEWill always be “Freddie Mac”
Required when Loan Collection is included
LoanCT9Valid FreddieMac Loan Number
Required when Loan Collection is included
StatusYE“AP Order Entered”, “APO-Stip. Automatic Default Remedy”, “APO-Stip. No Automatic Default Remedy”, “Case Dismissed”, “Closed”, “Hold”, “Open”, “Stay Relief Denied”, “Stay Relief Granted”Status=”Closed” must be accompanied by DateClosed and ClosedReason
DateClosedCDRequired when Status is set to “Closed”
ClosedReasonCE“Investor Request”, “Opened In Error”, “Repurchased”, “Servicer Request”, “Case Converted”, “Discharged”, “Dismissed”, “MFR   Granted”, “Paid Off / Reinstated”, “Investor Loan Sold”, “Loss Mitigation Completed”, “POC Filed”, “STIP / APO Entered”Required when Status is set to “Closed”
ConvertedDateCDRequired when changing the Case Chapter OR when setting the Closed Reason to “Case Converted”
DischargedDateCDRequired when setting the Closed Reason to “Dicharged”
DismissedDateCDRequired when setting the Closed Reason to “Dismissed”
DebtorContactNN
CoDebtorContactNN
DebtorAttorneyContactNN
PrePostPetitionLedgerNNRefer to Pre Post Petition Ledger
DelaysNNRefer To Decision Delay
FormsNNRefer To Import Forms
MessagesNNRefer To Messages
AttachmentsNNRefer To Documents

Sample XML

<ImportCollection>

<MFRItem>

<SubscriberID>http://www.attorney.com-MFR-40000030</SubscriberID>

<DateClosed>2013-04-15</DateClosed>

<ClosedReason>Case Completed</ClosedReason>

</MFRItem>

</ImportCollection>


Message

This stand-alone operation can be used to post a message to an existing Foreclosure, POC or an MFR referral.

****The structure of the XML submitted must follow the order found in the table below****

Data Definition

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
ReferenceNA50reference number
MessageItemYN
ObjectYEForeclosure, Bankruptcy
Required if Parent Process ID (Foreclosure, MFR or POC) is not supplied
ObjectSubscriberIDYT255SubscriberID of Foreclosure, POC or MFR
Must match SubscriberID for existing case
Required if Parent Process ID (Foreclosure, MFR or POC) is not supplied
ForeclosureCT50Unique attorney Case ID for Foreclosure Case
Must match a Case ID for an existing Foreclosure Case assigned to the firm
Required if Parent Process is a Foreclosure and Object/ObjectSubscriberID are not supplied
POCCT50Unique attorney Case ID for POC Case
Must match a Case ID for an existing POC Case assigned to the firm
Required if Parent Process is a Bankruptcy POC and Object/ObjectSubscriberID are not supplied
MFRCT50Unique attorney Case ID for MFR Case
Must match a Case ID for an existing MFR Case assigned to the firm
Required if Parent Process is a Bankruptcy MFR and Object/ObjectSubscriberID are not supplied
TemplateYEValid message template – “Attorney Message”
MessageYT50Message Subject
BodyTextNTN/AMessage Text

Sample XML

<ImportCollection Reference=”abc”>

<MessageItem>

<Object>Bankruptcy</Object>

<ObjectSubscriberID>http://www.attorney.com-MFR-40000030</ObjectSubscriberID>

<Template>Attorney Message</Template>

<Message>This is the subject</Message>

<BodyText>Message Content Goes here</BodyText>

</MessageItem>

</ImportCollection>


Document

This stand-alone operation can be used to upload a document to an existing Foreclosure, POC or an MFR referral.

****The structure of the XML submitted must follow the order found in the table below****

Data Definition

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
AttachmentItemYN
ObjectYEForeclosure, Bankruptcy
Required if Parent Process ID (Foreclosure, MFR or POC) is not supplied
ObjectSubscriberIDYT255SubscriberID of Foreclosure, POC or MFR
Must match SubscriberID for existing case
Required if Parent Process ID (Foreclosure, MFR or POC) is not supplied
ForeclosureCT50Unique attorney Case ID for Foreclosure Case
Must match a Case ID for an existing Foreclosure Case assigned to the firm
Required if Parent Process is a Foreclosure and Object/ObjectSubscriberID are not supplied
POCCT50Unique attorney Case ID for POC Case
Must match a Case ID for an existing POC Case assigned to the firm
Required if Parent Process is a Bankruptcy POC and Object/ObjectSubscriberID are not supplied
MFRCT50Unique attorney Case ID for MFR Case
Must match a Case ID for an existing MFR Case assigned to the firm
Required if Parent Process is a Bankruptcy MFR and Object/ObjectSubscriberID are not supplied
FileNameYT50File Name
TemplateYEValid document template name
DescriptionNTN/ADocument description
ContentYTN/ABase64 encoded document content

Sample XML

<ImportCollection>

<AttachmentItem>

<Object>Bankruptcy</Object>

<ObjectSubscriberID>http://www.attorney.com-MFR-40000030</ObjectSubscriberID>

<FileName>DocketList.pdf</FileName>

<Template>BK Document</Template>

<Description>Description goes here</Description>

<Content><![CDATA[Base64 Content]]></Content>

</AttachmentItem>

</ImportCollection>


ImportForm

This stand-alone operation can be used to update an ImportForm for an existing Foreclosure, POC or MFR referral. This operation is primarily used to project and complete step dates.

****The structure of the XML submitted must follow the order found in the table below****

Data Definition

NodeRequiredTypeLengthDescription / Enumerations
ImportCollectionYN
ImportFormItemYN
ObjectYE50Foreclosure, Bankruptcy
Required if Parent Process ID (Foreclosure, MFR or POC) is not supplied
ObjectSubscriberIDYT255SubscriberID of Foreclosure, POC or MFR
Must match SubscriberID for existing case
Required if Parent Process ID (Foreclosure, MFR or POC) is not supplied
ForeclosureCT50Unique attorney Case ID for Foreclosure Case
Must match a Case ID for an existing Foreclosure Case assigned to the firm
Required if Parent Process is a Foreclosure and Object/ObjectSubscriberID are not supplied
POCCT50Unique attorney Case ID for POC Case
Must match a Case ID for an existing POC Case assigned to the firm
Required if Parent Process is a Bankruptcy POC and Object/ObjectSubscriberID are not supplied
MFRCT50Unique attorney Case ID for MFR Case
Must match a Case ID for an existing MFR Case assigned to the firm
Required if Parent Process is a Bankruptcy MFR and Object/ObjectSubscriberID are not supplied
TemplateYEValid Import Form or Milestone template name
ProjectedCompletionCO, DAt least one of the dates required
ActualCompletionCO, DAt least one of the dates required
Messages_0_MessageYTN/A“Task Changed”
Messages_0_BodyTextYTN/AMessage text
Foreclosure_Loan_UPBAmountCARequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_BidAtSale_BidOpeningCARequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_BidAtSale_BidMaxCARequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_BidAtSale_BidDueCDRequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_SoldToNameCERequired while completing ‘Foreclosure Sale Held’ step. Values (Undisclosed, Third Party, Reverted to Senior, Back to Beneficiary)
Foreclosure_SaleAmountCARequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_TotalDebtLedger_AmountMoneyCARequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_TotalDebtLedger_PostedDateCDTotal Debt Amount as-of date; Required while completing ‘Foreclosure Sale Held’ steps
Foreclosure_TotalDebtLedger_LedgerCTRequired while completing ‘Foreclosure Sale Held’ step
Foreclosure_DeficiencyStatusCERequired while completing ‘Foreclosure Sale Held’ and ‘Foreclosure Case Closure’ step.  Values (Preserved, Waived)
Foreclosure_ThirdPartyContact_ContactCTRequired while completing ‘Foreclosure Sale Held’ step and SoldToName = ‘Third Party.
Foreclosure_ThirdPartyContact_AddressCTRequired while completing ‘Foreclosure Sale Held’ step and SoldToName = ‘Third Party.
Foreclosure_ThirdPartyContact_CityCTRequired while completing ‘Foreclosure Sale Held’ step and SoldToName = ‘Third Party.
Foreclosure_ThirdPartyContact_StateCTRequired while completing ‘Foreclosure Sale Held’ step and SoldToName = ‘Third Party.
Foreclosure_ThirdPartyContact_PostalCodeCTRequired while completing ‘Foreclosure Sale Held’ step and SoldToName = ‘Third Party.
Foreclosure_ThirdPartyContact_PhoneCTRequired while completing ‘Foreclosure Sale Held’ step and SoldToName = ‘Third Party.
Foreclosure_FCCaseNumberCTRequired while completing ‘Complaint Filed’ step.
Foreclosure_StatusCERequired while completing ‘Foreclosure Case Closure’ step.  Values (Closed)
Foreclosure_ClosedReasonCERequired while completing ‘Foreclosure Case Closure’ step.  Values (Bankruptcy Filed, Case Completed, Charge Off Completed, Consent Judgment, Investor Loan Sold, Investor Request, Loss Mitigation Completed, Low Balance Loan, Opened In Error, Paid Off / Reinstated, Repurchased, Servicer Request, Third Party Sale Completed)
Foreclosure_DateClosedCDRequired while completing ‘Foreclosure Case Closure’ step.
Bankruptcy_StatusCERequired while completing ‘Bankruptcy Case Closure’ step.  Values (Closed)
Bankruptcy_ClosedReasonCERequired while completing ‘Bankruptcy Case Closure’ step.  Values (Investor Request, Opened In Error, Repurchased, Servicer Request, Case Converted, Discharged, Dismissed, MFR  Granted, Paid Off / Reinstated, Investor Loan Sold, Loss Mitigation Completed, POC Filed, STIP / APO Entered)
Bankruptcy_DateClosedCDRequired while completing ‘Bankruptcy Case Closure’ step.

Sample XML

<ImportCollection>

<ImportFormItem>

<Object>Foreclosure</Object>

<ObjectSubscriberID>http://www.attorney.com-Foreclosure-10000047</ObjectSubscriberID>

<Template>Foreclosure File Received</Template>

<ProjectedCompletion>2013-04-25</ProjectedCompletion>

<ActualCompletion>2013-04-26</ActualCompletion>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</ImportCollection>

Sample XML (For ‘Foreclosure Sale Held’ step)

<ImportCollection Reference=”13686″>

<ImportFormItem>

<Object>Foreclosure</Object>

<ObjectSubscriberID>www. attorney.com-Foreclosure-0477796788</ObjectSubscriberID>

<Template>Foreclosure Sale Held</Template>

<ActualCompletion>2014-03-10</ActualCompletion>

<Foreclosure_Loan_UPBAmount>210000</Foreclosure_Loan_UPBAmount>

<Foreclosure_BidAtSale_BidOpening>20000</Foreclosure_BidAtSale_BidOpening>

<Foreclosure_BidAtSale_BidMax>255000</Foreclosure_BidAtSale_BidMax>

<Foreclosure_BidAtSale_BidDue>2014-03-10</Foreclosure_BidAtSale_BidDue>

<Foreclosure_SoldToName>Undisclosed</Foreclosure_SoldToName>

<Foreclosure_SaleAmount>250000</Foreclosure_SaleAmount>

<Foreclosure_TotalDebtLedger_AmountMoney>100000</Foreclosure_TotalDebtLedger_AmountMoney>

<Foreclosure_TotalDebtLedger_PostedDate>2014-02-04</Foreclosure_TotalDebtLedger_PostedDate>

<Foreclosure_TotalDebtLedger_Ledger>Total Debt</Foreclosure_TotalDebtLedger_Ledger>

<Foreclosure_DeficiencyStatus>Waived</Foreclosure_DeficiencyStatus>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</ImportCollection>

Sample XML (For ‘Foreclosure Sale Held’ step)

<ImportCollection Reference=”13686″>

<ImportFormItem>

<Object>Foreclosure</Object>

<ObjectSubscriberID>www. attorney.com-Foreclosure-0477796788</ObjectSubscriberID>

<Template>Foreclosure Sale Held</Template>

<ActualCompletion>2014-03-10</ActualCompletion>

<Foreclosure_Loan_UPBAmount>210000</Foreclosure_Loan_UPBAmount>

<Foreclosure_BidAtSale_BidOpening>20000</Foreclosure_BidAtSale_BidOpening>

<Foreclosure_BidAtSale_BidMax>255000</Foreclosure_BidAtSale_BidMax>

<Foreclosure_BidAtSale_BidDue>2014-03-10</Foreclosure_BidAtSale_BidDue>

<Foreclosure_SoldToName>Third Party</Foreclosure_SoldToName>

<Foreclosure_SaleAmount>250000</Foreclosure_SaleAmount>

<Foreclosure_TotalDebtLedger_AmountMoney>100000</Foreclosure_TotalDebtLedger_AmountMoney>

<Foreclosure_TotalDebtLedger_PostedDate>2014-02-04</Foreclosure_TotalDebtLedger_PostedDate>

<Foreclosure_TotalDebtLedger_Ledger>Total Debt</Foreclosure_TotalDebtLedger_Ledger>

<Foreclosure_ThirdPartyContact_Contact>Quandis</Foreclosure_ThirdPartyContact_Contact>

<Foreclosure_ThirdPartyContact_Address>123 Portola Pkwy</Foreclosure_ThirdPartyContact_Address>

<Foreclosure_ThirdPartyContact_City>Foothll Ranch</Foreclosure_ThirdPartyContact_City>

<Foreclosure_ThirdPartyContact_State>CA</Foreclosure_ThirdPartyContact_State>

<Foreclosure_ThirdPartyContact_PostalCode>925604</Foreclosure_ThirdPartyContact_PostalCode>

<Foreclosure_ThirdPartyContact_Phone>949-525-1111</Foreclosure_ThirdPartyContact_Phone>

<Foreclosure_DeficiencyStatus>Preserved</Foreclosure_DeficiencyStatus>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</ImportCollection>

Sample XML (For ‘Foreclosure Case Closure’ step)

<ImportCollection Reference=”13686″>

<ImportFormItem>

<Object>Foreclosure</Object>

<ObjectSubscriberID>www. attorney.com-Foreclosure-0477796788</ObjectSubscriberID>

<Template>Foreclosure Case Closure</Template>

<ActualCompletion>2017-08-10</ActualCompletion>

<Foreclosure_Status>Closed</Foreclosure_Status>

<Foreclosure_ClosedReason>Case Completed</Foreclosure_ClosedReason>

<Foreclosure_DateClosed>2017-08-11</Foreclosure_DateClosed>

<Foreclosure_DeficiencyStatus>Preserved</Foreclosure_DeficiencyStatus>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</ImportCollection>

Sample XML (For ‘Bankruptcy Case Closure’ step)

<ImportCollection Reference=”13686″>

<ImportFormItem>

<Object>Bankruptcy</Object>

<ObjectSubscriberID>www. attorney.com-Bankruptcy-01777967A</ObjectSubscriberID>

<Template>Bankruptcy Case Closure</Template>

<ActualCompletion>2017-08-10</ActualCompletion>

<Bankruptcy_Status>Closed</Bankruptcy_Status>

<Bankruptcy_ClosedReason>Discharged</Bankruptcy_ClosedReason>

<Bankruptcy_DateClosed>2017-08-11</Bankruptcy_DateClosed>

<Messages_0_Message>Task Changed</Messages_0_Message>

<Messages_0_BodyText>Task changed because of this reason</Messages_0_BodyText>

</ImportFormItem>

</ImportCollection>


Embedded Object Structures

The following objects structures are reused with Foreclosure, MFR, POC referral and update formats.

Total Debt Ledger

****The structure of the XML submitted must follow the order found in the table below****

The Total Debt Ledger is used by Foreclosure referrals:

NodeRequiredTypeLengthDescription / Enumerations
TotalDebtLedgerYN
TemplateYETotal Debt
ItemsN
AccruedLateChargesNM
BKFeesCostsNM
CorporateAdvanceBalanceNM
CorporateAdvancesNM
EscrowBalanceNM
FundsinSuspenseNM
OtherCostsNM
PendingAdvancesNM
PerDiemNM
PrincipalBalanceNM
RentsCollectedNM
TotalDueBeneficiaryasofSaleDateNM
FCFeesCostsON
ItemsYN
ForeclosureFeeNM

Pre Post Petition Ledger

The Pre Post Petition Ledger is used by both MFR and POC referrals:

****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
PrePostPetitionLedgerYN
TemplateYEPre and Post Petition Arrearages
ItemsYN
AccruedLateChargesNM
BKFeesCostsNM
CorporateAdvanceBalanceNM
CorporateAdvancesNM
EscrowBalanceNM
FCFeesCostsNM
FundsinSuspenseNM
InterestfromNM
OtherCostsNM
PaymentsNM
PendingAdvancesNM
PerDiemNM
PrincipalBalanceNM
RentsCollectedNM
TotalDueBeneficiaryasofSaleDateNM

Decision Delay

Decision Delays are used by all referral types to indicate when a file is set to delay.

****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
DelaysYNUsed to post Decision Delays
DecisionDelayItemYN
DecisionDelayTemplateYERefer to Appendix B
ActualStartYD
ProjectedCompletionYD
ActualCompletionCD
Message_0_MessageNE“Delay Changed”
Messages_0_BodyTextNTNAMessage indicating delay reason
PartyStatusCodeYEApplicable only to ‘Litigation Detail’
LitigationStatusCodeYEApplicable only to ‘Litigation Detail’
LitigationDateYDApplicable only to ‘Litigation Detail’
LitigationClaimCodeYEApplicable only to ‘Litigation Detail’

Sample XML for ‘Litigation Detail’

<ImportCollection>

<ForeclosureItem>

<SubscriberID>http://www.attorney.com-Foreclosure-10000019</SubscriberID>

<Delays>

<DecisionDelayItem>

<DecisionDelayTemplate>Litigation Detail</DecisionDelayTemplate>

<ActualStart>2013-12-01</ActualStart>

<ProjectedCompletion>2014-10-20</ProjectedCompletion>

<Messages_0_Message>Delay Changed</Messages_0_Message>

<Messages_0_BodyText>Body Text</Messages_0_BodyText>

<PartyStatusCode>FM Party Plaintiff</PartyStatusCode>

<LitigationStatusCode>Trial Date</LitigationStatusCode>

<LitigationDate>2013-11-15</LitigationDate>

<LitigationClaimCode>HAMP claim</LitigationClaimCode>

</DecisionDelayItem>

</Delays>

</ForeclosureItem>

</ImportCollection>


Import Form

Import Forms are used to update an ImportForm for an existing Foreclosure, POC or MFR referral.

****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
FormsONUsed to update milestones on a Foreclosure
ImportFormItemYN
TemplateYERefer to Appendix A “Templates”
ProjectedCompletionCDOne of the two dates must be included
ActualCompletionCDOne of the two dates must be included
Messages_0_MessageYE“Task Changed”
Messages_0_BodyTextYTN/AMessage text

Messages

Messages are used to add messages for a given file.

****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
MessagesYN
MessageItemYN
TemplateYEValid message template
MessageYT50Message Subject
BodyTextNTN/AMessage Text

Documents

Documents are used to add a document under a file.

****The structure of the XML submitted must follow the order found in the table below****

NodeRequiredTypeLengthDescription / Enumerations
AttachmentsONUsed to post a document on a file
AttachmentItemYN
FileNameYT50Document name which includes file extension
TemplateYEValid document template
DescriptionNTN/ADocument description
ContentYTN/ABase64 encoded document content

Appendix A: Workflow Steps

Workflow Steps can be found in the Attorney User Guide


Appendix B: Decision Delay Templates

The following is a list of hold templates in ADR.

  • Applies To indicates the file type
  • Previous Template Name indicates a Template name change, with change date in parentheses
TemplateApplies ToPrevious Template Name
Bankruptcy Ch 7Foreclosure
Bankruptcy Ch 11Foreclosure
Bankruptcy Ch 12Foreclosure
Bankruptcy Ch 13Foreclosure
ContestedForeclosureNEW (3/10/17)
DILForeclosureNEW (3/10/17)
Document DelayForeclosureNEW (3/10/17)
Forebearance AgreementForeclosure
FRE MoratoriumForeclosureNEW (3/10/17)
HAFForeclosureNEW (6/29/22)
HAMPForeclosure
JR. Lien BankruptcyForeclosureNEW (3/10/17)
Litigation DetailForeclosure
Loss MitigationForeclosureNEW (3/10/17)
Low Balance LoanForeclosure
MediationForeclosure
ModificationForeclosureNEW (3/10/17)
OCCForeclosure
ProbateForeclosureNEW (3/10/17)
Property Issues / SeizureForeclosureProperty Issue (3/10/17)
Repay PlanForeclosure
SCRAForeclosureNEW (3/10/17)
Servicer IssuedForeclosureServicer Issued Hold/Delay (3/10/17)
Short SaleForeclosureNEW (3/10/17)
Statutory/Jurisdictional DelayForeclosure
Title IssueForeclosureNEW (3/10/17)
ForeclosureAccount Current (Removed 3/10/17)
ForeclosureAdequate Protection Order(Removed 3/10/17)
ForeclosureBK Motion Withdrawn (Removed 3/10/17)
ForeclosureCease and Desist (Removed 3/10/17)
ForeclosureConsent Order (Removed 3/10/17)
ForeclosureCramdown (Removed 3/10/17)
ForeclosureCredit Counseling (Removed 3/10/17)
ForeclosureDeceased Borrower (Removed 3/10/17)
ForeclosureDelegated Postponement (Removed 3/10/17)
ForeclosureDIL Approved (Removed 3/10/17)
ForeclosureEnvironmental (Removed 3/10/17)
ForeclosureExecutive Communication (Removed 3/10/17)
ForeclosureFC Freddie Mac Designated Counsel (Removed 3/10/17)
ForeclosureForbearance (Removed 3/10/17)
ForeclosureFRE Moratorium (Hurricane Sandy) (Removed 3/10/17)
BK DILBankruptcyNEW (3/10/17)
BK Document DelayBankruptcyNEW (3/10/17)
BK Forebearance AgreementBankruptcyNEW (3/10/17)
BK FRE MoratoriumBankruptcyNEW (3/10/17)
BK HAMPBankruptcyNEW (3/10/17)
BK LitigationBankruptcyNEW (3/10/17)
BK Loss MitigationBankruptcyNEW (3/10/17)
BK ModificationBankruptcyNEW (3/10/17)
BK ProbateBankruptcyNEW (3/10/17)
BK Property Issues / SeizureBankruptcyNEW (3/10/17)
BK Repay PlanBankruptcyNEW (3/10/17)
BK SCRABankruptcyNEW (3/10/17)
BK Servicer IssuedBankruptcyNEW (3/10/17)
BK Short SaleBankruptcyNEW (3/10/17)
BK Title IssueBankruptcyNEW (3/10/17)
BankruptcyBK Freddie Mac Designated Counsel (Removed 3/10/17)
BankruptcyBK Hold (Removed 3/10/17)
Bankruptcy Stip/APO (Removed 3/10/17)

The following are the valid enumerations for Litigation Detail elements:

ElementValid Values
Party Status CodeFM Party Plaintiff
FM Party Defendant
FM not named
Litigation Status CodeComplaint Filed
Dispositive Motion Filed
Discovery Period
Trial Date
Notice of appeal Filed
Appellate Briefing Schedule
Post Trial Proceedings
Litigation Claim CodeConservatorship issue or challenge
Federal Instrumentality status
Charter interpretation or challenge
Freddie Mac as Federal Agency or Government Actor claim
Constitutional claim, including due process
Class Action claim
MERS claim
Environmental claim
Order to Show Cause, Sanction Motion or Hearings
HAMP claim
Predatory Lending claim
Ability to Re-pay claim
Discrimination claim
Uniform Mortgage Instrument claim
Other

Appendix C: Court List

CourtState
Alaska Bankruptcy CourtAK
Alabama Middle Bankruptcy CourtAL
Alabama Northern Bankruptcy CourtAL
Alabama Southern Bankruptcy CourtAL
Arkansas Eastern Bankruptcy CourtAR
Arkansas Western Bankruptcy CourtAR
Arizona Bankruptcy CourtAZ
California Central Bankruptcy – L.A.CA
California Central Bankruptcy – N.D.CA
California Central Bankruptcy – R.S.CA
California Central Bankruptcy – S.A.CA
California Central Bankruptcy – S.V.CA
California Eastern Bankruptcy CourtCA
California Northern Bankruptcy CourtCA
California Southern Bankruptcy CourtCA
Central District Of CaliforniaCA
Colorado Bankruptcy CourtCO
Connecticut Bankruptcy CourtCT
District Of Columbia Bankruptcy CourtDC
Delaware Bankruptcy CourtDE
Florida Middle Bankruptcy CourtFL
Florida Northern Bankruptcy CourtFL
Florida Southern Bankruptcy CourtFL
Georgia Northern Bankruptcy CourtGA
Georgia Southern Bankruptcy CourtGA
Middle District of GeorgiaGA
Guam Bankruptcy CourtGU
Hawaii Bankruptcy CourtHI
Iowa Northern Bankruptcy CourtIA
Iowa Southern Bankruptcy CourtIA
Idaho Bankruptcy CourtID
Illinois Central Bankruptcy CourtIL
Illinois Northern Bankruptcy – Chicago  – ECFIllinois Northern BankruptcyIL
Illinois Southern Bankruptcy CourtIL
Indiana Northern Bankruptcy CourtIN
Indiana Southern Bankruptcy  – ECFIndiana Southern BankruptcyIN
Kansas Bankruptcy CourtKS
Kentucky Eastern Bankruptcy CourtKY
Kentucky Western Bankruptcy CourtKY
Louisiana Eastern Bankruptcy CourtLA
Louisiana Middle Bankruptcy CourtLA
Louisiana Western Bankruptcy CourtLA
Massachusetts Bankruptcy CourtMA
Maryland Bankruptcy CourtMD
Maine Bankruptcy CourtME
Michigan Eastern Bankruptcy CourtMI
Michigan Western Bankruptcy CourtMI
Minnesota Bankruptcy CourtMN
Missouri Eastern Bankruptcy CourtMO
Missouri Western Bankruptcy CourtMO
Mississippi Northern Bankruptcy CourtMS
Mississippi Southern Bankruptcy CourtMS
Montana Bankruptcy CourtMT
North Carolina Eastern Bankruptcy  – ECFNorth Carolina Eastern BankruptcyNC
North Carolina Middle Bankruptcy CourtNC
North Carolina Western Bankruptcy CourtNC
North Dakota Bankruptcy CourtND
Nebraska Bankruptcy CourtNE
New Hampshire Bankruptcy CourtNH
New Jersey Bankruptcy CourtNJ
New Mexico Bankruptcy CourtNM
Nevada Bankruptcy CourtNV
New York Eastern Bankruptcy CourtNY
New York Northern Bankruptcy CourtNY
New York Southern Bankruptcy CourtNY
New York Western Bankruptcy CourtNY
Ohio Northern Bankruptcy CourtOH
Ohio Southern Bankruptcy CourtOH
Oklahoma Eastern Bankruptcy CourtOK
Oklahoma Northern Bankruptcy CourtOK
Oklahoma Western Bankruptcy CourtOK
Oregon Bankruptcy CourtOR
Pennsylvania Eastern Bankruptcy CourtPA
Pennsylvania Middle Bankruptcy CourtPA
Pennsylvania Western Bankruptcy CourtPA
Puerto Rico Bankruptcy CourtPR
Rhode Island Bankruptcy CourtRI
South Carolina Bankruptcy CourtSC
South Dakota Bankruptcy CourtSD
Tennessee Eastern Bankruptcy CourtTN
Tennessee Middle Bankruptcy CourtTN
Tennessee Western Bankruptcy CourtTN
Texas Eastern Bankruptcy CourtTX
Texas Northern Bankruptcy CourtTX
Texas Southern Bankruptcy CourtTX
Texas Western Bankruptcy CourtTX
Utah Bankruptcy CourtUT
Virginia Eastern Bankruptcy  – ECFVirginia Eastern BankruptcyVA
Virginia Western Bankruptcy CourtVA
Vermont Bankruptcy CourtVT
Washington Eastern Bankruptcy CourtWA
Washington Western Bankruptcy CourtWA
Wisconsin Eastern Bankruptcy CourtWI
Wisconsin Eastern Bankruptcy CourtWI
Wisconsin Western Bankruptcy CourtWI
West Virginia Northern Bankruptcy CourtWV
West Virginia Southern Bankruptcy CourtWV
Wyoming Bankruptcy CourtWY

Appendix D: Ledger Templates

The following is a list of ledger templates in ADR.

  • Applies To indicate the file type
  • DCS Template Name maps the previous DCS Ledger Template
TemplateApplies ToLedger ItemDCS Template Name
Total DebtForeclosureAccrued Late ChargesOutstanding Late Charges
Escrow BalanceEscrow Balance
Funds in SuspenseSuspense Balance
Interest fromInterest From L.I.
Per Diem
Principal BalanceUnpaid Principal Balance
Rents Collected
Total Due Beneficiary as of Sale Date
Corporate Advance BalanceNon-Escrow Advances
Other CostsOther Fees
Pending Advances
BK Fees / Costs
FC Fees / Costs
Corporate Advances
Payments
Pre and Post Petition ArrearagesBankruptcyAccrued Late Charges
Escrow Balance
Funds in Suspense
Interest from
Per Diem
Principal Balance
Rents Collected
Total Due Beneficiary as of Sale Date
Corporate Advance Balance
Other Costs
Pending Advances
BK Fees / Costs
FC Fees / Costs
Corporate Advances
Payments

Appendix E: FAQ & Troubleshooting

The following are commonly asked questions related to ADR integration.

Q: Are Property and Loan information required in the XML when submitting ADR?

Answer:  No. Only the Freddie Mac loan number is required when submitting the referral. The ADR system already contains property and loan data which is boarded by FHLMC on a daily basis. It is important the correct loan number is provided at time of referral as the referral is bound based on loan number at time of submission.

Q: In DCS referrals required an AttorneySubscriberID value that bound the attorney to the referral. Is this required in ADR?

Answer:  No. ADR will set the attorney organization to the process record by using the credential submitted in the referral request.

Q: Can updates be submitted on the same referrals that were in DCS?

Answer:  Updates can be submitted on open referrals that were in DCS. ADR will contain converted processes that were open in DCS. Additionally the process based SubscriberIDs will be converted as well so any updated will require the same SubscriberID patterns to locate an existing process.

Q: Will ADR accept submission of Eviction and Closing referrals?

Answer:  No. Freddie Mac has elected to not track Eviction and Closings in ADR, so ADR does not expose interfaces to submit these referral types.

Q: How are steps updated in ADR?

Answer:  ImportForm. ADR has replaced “Milestones” with ImportForms.

Troubleshooting Errors

Error: You don’t have permissions to the ‘LoanInsert’ function.

Explanation: This error occurs when attempting to pass in a Freddie Mac Loan Number (<Loan> Node) that does not exist in the system.  You may only add cases on Loans that are already present in ADR.

Rule Exception: Foreclosure cannot be inserted without Assigned Organization

Explanation: This error will occur under one of three conditions:

  1. Your integration account is not associated with any Organizations
  2. You are attempting to create a case for a Loan where the Property’s State is not covered by your firm’s Jurisdiction(s)
    1. If your integration account is associated with multiple Organizations, and one of the Organization’s Jurisdiction covers the Property’s State, the system may have attempted to bind the wrong Organization to the case.  A subsequent attempt to submit the case should bind the proper Organization to the case
  3. You are attempting to update a case using a SubscriberID that does not yet exist, however the Foreclosure case is already present in the system
    1. This condition typically occurs when using any operation other than the Foreclosure operation, and often times is a result of a firm adding new states to their list of jurisdictions.  Please contact adr.support@quandis.com to determine if this is the condition you are facing, and perform a backfill of SubscriberIDs for all applicable jurisdictions, if necessary.

Rule Exception: There is currently an active Foreclosure for this Loan and your account is not configured to add one

Explanation: The ADR system only allows one active Foreclosure case per Loan.  Your firm or another firm already has an active case on this Loan, and it will need to be closed out prior to adding your new case.  If the case is assigned to your firm, there may be an issue with your SubscriberID mismatching the SubscriberID associated with the existing case.  Please make sure this value did not change between submissions.

Rule Exception: A (foreclosure/bankruptcy) process cannot be opened on a loan that is archived, closed or in REO.

Explanation: Loans that are no longer in Freddie Mac’s portfolio (Archived or Closed) and those that have been sold and are now in REO do not allow Foreclosure and Bankruptcy Cases to be added.  Existing Cases can be updated using the ForeclosureUpdate, MFRUpdate, POCUpdate, ImportForm, Message and Document Operations.  If you feel this exception was thrown in error, please contact Freddie Mac.

Rule Exception: Start Date must be specified when creating a case

Explanation: You must supply a Start Date (DateOpened) when inserting new cases.  This should get caught at the schema level when using the Foreclosure operation, however, the ForeclosureUpdate operation does not require it at the schema level, and if the case does not already exist, the system will attempt to insert a new case.  Switch to the Foreclosure operation, and include the DateOpened field.

Rule Exception: Task Completion dates cannot be changed once already set

Explanation: This error is informing the sender that the Task (ImportForm) they are attempting to complete was previously completed, using a different date than the current submission.  The system does not allow Task Completion dates to be altered.

Rule Exception: Tasks cannot be completed using a date prior to the previous task’s completion date

Explanation: Milestones (Tasks) must be completed in order.  Once a Task is completed, if you attempt to complete the following Task with an earlier completion date, the system will throw this error.

Rule Exception: Case status cannot be updated once the case is already closed

Explanation: The SubscriberID being passed in is associated with a case that is closed.  A new SubscriberID will need to be generated for the new case.
*If a new SubscriberID cannot be generated, the existing case’s SubscriberID will need to be modified.  Please contact adr.support@quandis.com for assistance.

Rule Exception: In order to close a case, the Status must be ‘Closed’ AND a Removal Date must be entered

Explanation: This error is informing the sender that they are attempting to close a Bankruptcy (MFR/POC) case and one of these conditions is present:

  • A Status node was supplied, with a value of “Closed”, and a DateClosed (AKA “Removal Date”) node and value were not supplied
  • A DateClosed (AKA “Removal Date”) and value were provided, but the Status node was omitted, OR a Status other than “Closed” was supplied within the Status node

Rule Exception: Opening Bid Amount must be set when completing task

Explanation: A value is required in the Foreclosure_BidAtSale_BidOpening field when completing the Foreclosure Sale Held Task.
Rule Exception: Credit Bid Amount must be set when completing task

Explanation: A value is required in the Foreclosure_BidAtSale_BidMax field when completing the Foreclosure Sale Held Task.
Rule Exception: Credit Bid Due must be set when completing task

Explanation: A value is required in the Foreclosure_BidAtSale_BidDue field when completing the Foreclosure Sale Held Task.
 


Appendix F: ADR Certification Checklist

ADR certification process in which integrators must successfully complete before they are allowed submit data to the ADR production environment. Certification is obtained by demonstrating the ability to invoke various ADR operations that simulate realistic submission scenarios. The following checklist can be used to prepare for certification testing.

File TypeOperationLoan NumberPass / Fail
ForeclosureNew Referral
Update Foreclosure
Complete Import Form
Post a Message
Upload a Document
ForeclosureComplete all Import Forms for State
Add a Decision Delay
Complete Delay
Update Ledger
 Close File
POCNew Referral
Update POC
Post a Message
Upload a Document
Complete an Import Form
Add a Decision Delay
Complete Delay
Complete Remaining Import Forms
Update Ledger
Close File
MFRNew Referral
Update MFR
Upload a Document
Complete an Import Form
Add a Decision Delay
Complete Delay
Post a Message
Complete Remaining Import Forms
Update Ledger
Close File

Appendix G: Required Foreclosure Documents

Foreclosure Document Requirements change from time-to-time.  For the most current list required in your state, please reference the Required Documents tab of the ADR Support Page (login required).  For the most current list pending deployment to PROD, please reference the Required Documents tab of the UAT ADR Support Page (login also required)


Appendix H: Import Dashboard

The ADR Import Dashboard is a tool available on the ADR website which allows integrators to monitor updates posted using the API. This is very useful tool for viewing or reconciling import data. The dashboard can be accessed by clicking the “Dashboards” main menu item, and then choosing “Import Data”.

The Import Dashboard on the left shows all templates the user has access to. Users can click on the Template on the left and the result pane will refresh on the right with imports based on the selected template.

The result pane columns can be sorted ascending or descending by clicking on the column header. The options drop down to the right allows for quick filtering:

  • Filters
    • Active – Imports submitted in the last 7 days
    • Success – Imports with no errors. If chosen, ensure Error is unchecked.
    • Error – Imports that contain at least one error. If chosen, ensure Success is unchecked.
    • Complete – Imports that are complete. Used for asynchronous imports.

Smart Search

The upper right hand contains a text box with the label “Search”. This is the smart search box. This is the fastest way to conduct a search for an import.  Possible submission values:

  • ImportFileID – Value returned in the “ID” attribute in the ImportResults tag. This is also referred to as ImportFileID.
  • External Reference – value of “Reference” attribute of the ImportCollection tag when import is submitted

Search Dashboard

By clicking on the down arrow on the right hand side of the Smart Search text box, you will expose a modal labeled “Search Imports”.

This modal allows additional search filtering. The search filters include:

  • Template – Import File Template submitted
  • ID – Value returned in the “ID” attribute in the ImportResults tag. This is also referred to as ImportFileID.
  • External Reference – value of “Reference” attribute of the ImportCollection tag when import is submitted
  • Uploaded By – available list of accounts who submitted imports
  • Date Range
    • From Date
    • To Date – Ensure this value includes the To Date plus one additional day
  • Filters
    • Success – Imports with no errors. If chosen, ensure Error is unchecked.
    • Error – Imports that contain at least one error. If chosen, ensure Success is unchecked.
    • Complete – Imports that are complete. Used for asynchronous imports.
    • Queued – Imports that are queued to process. Used for asynchronous imports.

Viewing Import Records

From the results pane a user can click on the following links per item:

  • Import File – This will direct them to view the Import File Summary
  • Download – This will allow the user to view the Xml that was submitted
  • Status – This will expose summary statistics and render a link to download and Xml version of the Import Results. This Xml format is the same format that was returned by the interface upon submission

Import File Summary

This is the summary view that allows individual viewing of an import. This view will provide the same information as the search result pane along with additional information.

The Import File Summary is broken up into 3 sections:

  • Summary – Display summary information on the import and allows download of request and result data along with statistics
  • Transactions – Currently not applicable for ADR
  • Import Activity – Contains individual result information about records that were part of the import. This includes:
    • Status – Success or Error
    • TableName – ADR table name
    • Identify – Primary Key Identifier of record affected
    • Reference – Attorney supplied reference number
      • Note this contains a link to raw Xml or stack trace information

Appendix I: Attachment Templates

The following is a list of the available attachment templates, along with the parent object, name and repeatability.

  • Parent: This is the object the template applies to
  • Name: The name of the attachment template
  • Repeatability: This defines the behavior of the template in relation to its parent.
    • One per parent: Only one attachment allowed per parent, regardless of status
    • Many per parent: Many attachments allowed per parent, regardless of status
    • One open per parent: Only one open attachment allowed per parent.
ParentAttachment NameRepeatability
ForeclosureAct LettersOne per parent
ForeclosureAffidavitOne per parent
ForeclosureApplicationOne per parent
ForeclosureAppraisalOne per parent
ForeclosureARM RiderOne per parent
ForeclosureAssignmentOne per parent
ForeclosureAssignment (unrecorded)One per parent
ForeclosureBankruptcy PlanOne per parent
ForeclosureBid FormMany per parent
ForeclosureBPOOne per parent
ForeclosureBreach LetterOne per parent
ForeclosureCertificate of AttachmentOne per parent
ForeclosureCertificate of Title (mh)One per parent
ForeclosureCertificate of Sale (mh)One per parent
ForeclosureCharge Off FormOne per parent
ForeclosureCondo RiderOne per parent
ForeclosureConsent OrdersOne per parent
ForeclosureContract for DeedOne per parent
ForeclosureCopy of Assignment of LeaseOne per parent
ForeclosureCopy of Proprietary LeaseOne per parent
ForeclosureCopy of Stock CertificateOne per parent
ForeclosureCopy of Stock PowerOne per parent
ForeclosureCopy of UCC-1One per parent
ForeclosureCredit BureauOne per parent
ForeclosureCredit Life InsuranceOne per parent
ForeclosureCredit ReportOne per parent
ForeclosureCurrent Title CommitmentOne per parent
ForeclosureCustomer CorrespondenceOne per parent
ForeclosureDeed of TrustOne per parent
ForeclosureDemand LetterOne per parent
ForeclosureDefault PayoffsOne per parent
ForeclosureDerogatory Credit ExplanationOne per parent
ForeclosureDisclosure of Loan TermsOne per parent
ForeclosureDIL AuthorizationOne per parent
ForeclosureEnvironmental HazardsOne per parent
ForeclosureEPA CorrespondenceOne per parent
ForeclosureExtension AgreementOne per parent
ForeclosureFC Final DeedOne per parent
ForeclosureFHA Eviction PackageOne per parent
ForeclosureFHA Post Sale PackageOne per parent
ForeclosureFHA Title PackageOne per parent
ForeclosureFlood Insurance CertificationOne per parent
ForeclosureForbearance AgreementOne per parent
ForeclosureForeclosure complaintsOne per parent
ForeclosureForeclosure JudgmentsOne per parent
ForeclosureForeclosure/Sheriff’s DeedOne per parent
ForeclosureGood Faith EstimateOne per parent
ForeclosureHardship LetterOne per parent
ForeclosureHAMP LetterOne per parent
ForeclosureHome Equity OrderOne per parent
ForeclosureHUDOne per parent
ForeclosureHUD-1One per parent
ForeclosureLoan ApplicationOne per parent
ForeclosureLoan ApprovalOne per parent
ForeclosureLost Assignment AffidavitOne per parent
ForeclosureLost Note AffidavitOne per parent
ForeclosureMechanic’s Lien AffidavitOne per parent
ForeclosureMisc RiderOne per parent
ForeclosureMobile-Home TitleOne per parent
ForeclosureModificationOne per parent
ForeclosureMortgageOne per parent
ForeclosureMortgage Insuring CertificateOne per parent
ForeclosureMortgage RiderOne per parent
ForeclosureMotion for Relief OrderOne per parent
ForeclosureName AffidavitOne per parent
ForeclosureNon Sufficient FundOne per parent
ForeclosureNoteOne per parent
ForeclosureNote RiderOne per parent
ForeclosureNotice of BK FilingOne per parent
ForeclosureNotice of Default ComplaintOne per parent
ForeclosureNotice of SaleOne per parent
ForeclosureOtherOne per parent
ForeclosurePayment HistoryOne per parent
ForeclosurePayoff StatementsOne per parent
ForeclosurePower of AttorneyOne per parent
ForeclosureProperty InspectionOne per parent
ForeclosureProperty Insurance PolicyOne per parent
ForeclosurePUD RiderOne per parent
ForeclosurePurchase Sales ContractOne per parent
ForeclosureReaffirmationOne per parent
ForeclosureRecorded Security InstrumentOne per parent
ForeclosureRehabilitation Loan RiderOne per parent
ForeclosureRelease of LienOne per parent
ForeclosureRelease/Dismissal of Tax SuitOne per parent
ForeclosureReturned POCsOne per parent
ForeclosureRight to CancelOne per parent
ForeclosureSecurity DeedOne per parent
ForeclosureSheriff’s Sale NoticeOne per parent
ForeclosureSheriff’s DeedOne per parent
ForeclosureStipulated PlanOne per parent
ForeclosureSubstitute Trustee’s DeedOne per parent
ForeclosureSubstitution of TrusteeOne per parent
ForeclosureSummary SheetOne per parent
ForeclosureSummon & Complaint DocsOne per parent
ForeclosureSurveyOne per parent
ForeclosureTitle CommitmentOne per parent
ForeclosureTitle IndemnityOne per parent
ForeclosureTitle PolicyOne per parent
ForeclosureTitle SearchOne per parent
ForeclosureTransfer of Service DisclosureOne per parent
ForeclosureTruth in LendingOne per parent
ForeclosureUnderwriter Approval LetterOne per parent
ForeclosureUnrecorded MortgageOne per parent
ForeclosureWarranty DeedOne per parent
ForeclosureReinstatement QuoteMany per parent
ForeclosurePayoff QuoteMany per parent
ReportCrystal Report1One per parent
ReportExcel Report1One per parent
ImportFileBulk ImportMany per parent
ReportTimeline SummaryMany per parent
ReportHoldMany per parent
ReportTimeline CompletionMany per parent
ReportTimeline ExceptionMany per parent
ReportLitigation DetailMany per parent
OrganizationLMWS Attorney Firm FileMany per parent
OrganizationLMWS ForeclosureMany per parent
OrganizationLMWS Bankruptcy MFRMany per parent
OrganizationLMWS Backruptcy POCMany per parent
ForeclosureMultipleTestMany per parent
ForeclosureDeficiency JudgmentOne open per parent
BankruptcyBK DocumentMany per parent
ForeclosureFC DocumentMany per parent
AttachmentLDI Response FileOne per parent
ForeclosureFC Bidding InstructionsOne per parent
ForeclosureCertificate of PurchaseOne per parent
ForeclosureNotice of Intent Seek DefOne per parent
ForeclosureAffidavit of IndebtednessOne per parent
ForeclosureOrder Approving FC SaleOne per parent
ForeclosureAffidavit of ServiceMany per parent
ForeclosureAssignment of JudgementOne per parent
ContactSpec Test – hli54ks5Many per parent
ReportSettlementMany per parent
ReportForeclosure Document DeficiencyMany per parent
ReportSFDML LitigationMany per parent
ReportInventoryMany per parent
ReportSummary LevelMany per parent
MessageTemplateBlast Email AttachmentsMany per parent
ReportPostponementMany per parent
ForeclosureUpload TestMany per parent
ReportAttorney Data ManagementMany per parent
ReportLitigation Hold ReconciliationMany per parent