Foreclosure
Provides pre-foreclosure and foreclosure-related public records, including notice details, auction information, and distressed property status used to identify risk and opportunity.
Foreclosure Layout
| Field Name | Field Description | Data Type |
|---|---|---|
| Constellation1_ID (CID) | Unique Identifier in Constellation1 | varchar |
| FIPS Code (State/County) | Numeric code to identify every County/State in the US. 1st 2 positions = State, last 3 positions = County | varchar |
| Assessor’s Parcel Number (APN, PIN) | Present if matched | varchar |
| County Name | Actual County Name. Not abbreviated. May also be Independent City Name. | varchar |
| Postal State | Two-letter standard postal abbreviation | varchar |
| Document Type Code | Unique 2 position document type field that identifies the foreclosure record type. | number |
| Recording Date | The official date of recordation for the foreclosure document. Format provides four positions for the year: YYYYMMDD | date |
| Recorder’s Document Number | Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation. Not every county will have document numbers. | number |
| Recorder’s Book Number | Some counties only use Book & Page reference without the Document Number, others may use only the Document number. | number |
| Recorder’s Page Number | See explanation for Book Number | number |
| Trustee Sale Number | Number assigned by the Trustee for the purpose of tracking the foreclosure for the given property. May also be referred to as File # or TS#. Format varies. | number |
| Case Number | This field is populated in judicial states only and is assigned by the court where the foreclosure suit was filed. Format varies. (Previously Title Company Name field thru Feb 2007 production.) | number |
| Original Date of Contract | The date that the document was executed by the parties. Equals or pre-dates the recording date. In some cases, may be the Notary Date. Format: YYYYMMDD | date |
| Unpaid Balance | Whole dollars. Unpaid principal amount of the loan as stated on the foreclosure document. | varchar |
| Past Due Amount | Amount that is past due on the loan. Format in whole dollars. NOTE: There may be documents that do not report a past due amount and therefore field may be blank. | varchar |
| Past Due As of Date | The Date entered into this field corresponds to the amount keyed into the Past Due Amount field. If the Total Delinquency Amount was keyed, then this field will be populated with the As of Date for the Total Delinquency amount or if not provided, then the Contract Date. If the Installment Amount was keyed, then the Installment Due Date for the first missed payment should be entered. NOTE: This field is only populated when the Past Due Amount field is populated - See “Payment Due Date” field as alternate field when no amount is keyed. Format: YYYYMMDD | date |
| Contact First Name & Middle Name | Contact Name for information regarding sale of property (or to cure the default). For historical records, if no contact name given, then Trustee name was duplicated to this field. For current recordings, contact names are entered if different than the Trustee. | varchar |
| Contact Last Name OR Corporation Name | varchar | |
| Contact Mail: Care of Name | Or Attention To (or Mail to Name if Contact Name is not provided) UNLESS IT IS THE SAME AS THE TRUSTEE NAME/MAIL ADDRESS | varchar |
| Contact Mail: Full Street Address | Keyers have the option to key full street Address as reported on the document -OR- keyers may abbreviate street address directionals & street suffix endings - if abbreviating, the USPS abbreviation guidelines must be followed. . Full Street Address components are: • House Number • House Alpha (i.e. 400 ½, 230A, etc.) • Street Direction Left (valid direction codes: N, S, E, W, NE, NW, SE, SW) • Street Name • Suffix (Ave, Rd, St, etc. • Street Direction Right (valid direction codes: N, S, E, W, NE, NW, SE, SW) Example incorporating all components: 400 ½ E Iris Ave NE Note: Rural Routes are considered to be Property Addresses. | varchar |
| Contract Mail: Unit | varchar | |
| Contact Mail: City Name | varchar | |
| Contact Mail: State Code | varchar | |
| Contact Mail: Zip Code | Five-digit postal zip code. | varchar |
| Contact Mail: Zip +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| Contact Telephone Number | varchar | |
| Due Date | The date that the installment payment was originally due. Format: YYYYMMDD | varchar |
| Trustee First Name & Middle Name | Note: In Colorado, the Trustee fields will be blank since Colorado uses a Public Trustee | varchar |
| Trustee Last Name OR Corporation Name | varchar | |
| Trustee Mail: Care of Name | If a C/O Name (%, C/O, Attn, etc.) is present, may not want to consider the address in Fields #32-37 as the actual Trustee Mail Address | varchar |
| Trustee Mail: Full Street Address | varchar | |
| Trustee Mail: Unit Number | varchar | |
| Trustee Mail: City Name | See definition for buyer #1 | varchar |
| Trustee Mail: State Code | See definition for buyer #1 | varchar |
| Trustee Mail: Zip Code | Five-digit postal zip code. | varchar |
| Trustee Mail: Zip Code +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| Trustee Telephone Number | varchar | |
| #1 - Trustor/Borrower First Name & Middle Name | Party(ies) in default. See Borrower Name on Mortgage Tab (Fields #23-28). | varchar |
| #1 - Trustor/Borrower Last Name OR Corporation Name | The Name of the Truesee/Borrower | varchar |
| #1 - Trustor/Borrower ID Code | varchar | |
| #2 - Trustor/Borrower First Name & Middle Name | The Name of the Truesee/Borrower | varchar |
| #2 - Trustor/Borrower Last Name OR Corporation Name | The Name of the Truesee/Borrower | varchar |
| #2 - Trustor/Borrower ID Code | varchar | |
| Original Beneficiary (Lender) Name | Name of the original beneficiary | varchar |
| Original Beneficiary (Lender) Type | varchar | |
| Current Beneficiary (Lender) Name | Populated if mortgage assigned to new lender | varchar |
| Current Beneficiary (Lender) Type | varchar | |
| MERS Indicator | (Y)es = loan registered with MERS (Mortgage Electronic Registration System) for electronic registry and tracking | varchar |
| Loan Recording Date | The official date of recordation for the original loan. Format provides four positions for the year: YYYYMMDD | Data Type |
| Loan Document Number | number | |
| Loan Book Number | number | |
| Loan Page Number | number | |
| Original Loan Amount | Loan amount of the original loan in default. Whole dollars only. | number |
| Legal: Lot Number(s) | The individual lot(s) which comprise the property. The actual lot number(s) such as in a tract or subdivision. If more than one, as many multiple lot numbers as allowed by the field length are entered, separated with a comma (,) or ampersand (&). A hyphen is used to indicate a range (-). | number |
| Legal: Block | The block of the subdivision or city in which the property is located | number |
| Legal: Subdivision Name | The name of the subdivision, plat, or tract in which the property is located | varchar |
| Legal: Brief Description | Lists exceptions, when only a portion of Block, Lot, Tract or Subdivision is entered in the specific field. Or, when legal description components are not fielded, this field will be populated. | varchar |
| Auction Date | The scheduled Auction Date as reported on the Notice of Sale. Format: YYYYMMDD | Data Type |
| Auction Time | The scheduled Auction Time as reported on the Notice of Sale. Format: HHMMX (X = A or P for time of day) - colon implied | varchar |
| Auction Location | The Street Address where the auction is scheduled to take place, usually reported on the Notice of Sale | varchar |
| Auction: Minimum Bid Amount | Whole dollars only. The minimum bid amount as reported on the Notice of Sale or reflects the total amount due on the loan. | varchar |
| Property Address Code | varchar | |
| Auction City | The City where the auction is scheduled to take place as reported on the Notice of Sale | varchar |
| Original NOD Recording Date | For re-recorded documents, the official date of the recordation of the original document. Format provides four positions for the year: YYYYMMDD | date |
| Original NOD Document Number | number | |
| Original NOD Book Number | number | |
| Original NOD Page Number | number | |
| NOD APN | Assessor’s Parcel Number or Parcel Identification Number as reported on the document | varchar |
| Property Full Street Address | For Address components, see Property Address Fields on Assessment Tab of Public Records RLO. | varchar |
| Property Unit Type | varchar | |
| Property Unit Number | For Address components, see Property Address Fields on Assessment Tab of Public Records RLO. | varchar |
| Property City Name | For Address components, see Property Address Fields on Assessment Tab of Public Records RLO. | varchar |
| Property State | Two-letter standard postal abbreviation | varchar |
| Property Zip Code | Five-digit postal zip code. | varchar |
| Property Zip +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| Purchase_Link_ID | Present If matched to the concurrent mortgage on a deed record | varchar |
| Mortgage_Link_ID | Present if matched to a standalone mortgage | varchar |
| Record Creation Date | The date this record was created | date |
| Hashvalue | Record hash value, updated hashvalue indicates if the record changed | varchar |
| ModificationTimestamp | When the record was updated | date |
| TransactionId | Unique identifier for Preforeclosure record only | varchar |
| Version | varchar |
Full Detail information Confidential. Not for Distribution.