Assignments and Releases

Dataset

Description

Assignments and Release provide a history of the mortgages secured by a property, when they started and when they ended.

Examples

Usage

Assignments provide a way to keep track of new mortgages taken out by a homeowner, adding to the financial commitment the owner has for this property.

Releases provide a way to track when mortgages have been discharged, reducing the financial commitment the owner has to this property.

Sourcing

TBD

Tables/Views

The following tables can be used to access Assignments and Releases information.

AssignmentRelease

A history of the assignments and releases associated with a property.

Rows: 25 million
Columns: 38
Family: Transaction

Note: This table contains records that are not matched to an ATTOM ID. In these situations, the ATTOM ID will be blank and address details provided. Where the property has been matched, the ATTOM ID is provided and the address information is blank. The latest address details can be sourced from the PropertyAddress view or the PropergtyFeature table.

Dimension Tables

The following dimension tables are relevant to Deed, providing lookups for various codes contained in the RETransaction table.

DimCounty - Description of each county and the geographic groupings to which it belongs - eg. State, CBSA, CSA.

DimDetailedDocumentType - Type of assignment/release document referenced by transaction - e.g. Assignment of Mortgage, Correction Assignment, Full Release wth a Legal Description

Understanding the Data

ATTOM ID

One of the biggest challenges working with property data is accurately identifying the property referenced. This is especially true when dealing with public record information provided from 3,000+ county recorder offices. ATTOM simplifies this process by assigning a permanent, unique identifier to each property transaction known as the ATTOM ID. All transactions recorded against the same property can be identified by using the ATTOM ID assigned to these transactions.

Transaction ID

ATTOM assigns a unique sequential number to each transaction making it easier to relocate the same document.

Original Loan Details

For releases, details about the loan (mortgage) being released. For an assignment that is transferring from an existing lender, details about the existing loan (mortgage) 

Product Articles (P-Articles)

All solution packs containing the Deed data element will include the following p-articles to help you understand and use the data: -

• Assignments and Releases 101