| Field Name | Description | Data Type |
|---|---|---|
| Constellation_ID (CID) | CID (Constellation Unique Identifier) | varchar |
| Recording Date | The official date of the document recordation. YYYYMMDD | varchar |
| Recorder’s Book Number | Some counties only use Book & Page reference without the Document Number, others may use only the Document number. | varchar |
| Recorder’s Page Number | varchar | |
| Recorder’s Document Number | Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation. | varchar |
| Document Type Definition | Assignment of Sub Agreement of Sale (Hawaii) Assignment of Sub Lease (Hawaii) Assignment of Commercial Lease (Hawaii) Administrator’s Deed Affidavit Agreement of Sale Assessor Sales History Affidavit of Lost (or Missing) Assignment Assignment of Mortgage Assignment of Agreement of Sale (Hawaii) Assignment Deed (or Assignment of Condo Deed if Land Use = "CND") Affidavit of Trust or Trust Agreement (Los Angeles) Assignment of Sub Commercial Lease (Hawaii) Beneficiary Deed (Buyer ID = "BE") Bargain and Sale Deed Commissioners Assignment of Lease (Hawaii) Condominium Deed Cash Sale Deed Commercial Lease (Hawaii) Commissioner’s Deed - In North Carolina used in probate-related transfers. In Hawaii used in foreclosure-related transfers. Cancellation of Agreement of Sale (Hawaii) Conservator’s Deed Corporation Deed Correction Assignment Correction Deed Correction Release Contract of Sale Certificate of Transfer Deed of Distribution Declaration Transfer on Death Deed Deed Deed of Guardian Affidavit of Death Deed in Lieu of Foreclosure Distress Sale Affidavit of Death of Life Tenant Divorce/Dissolution of Marriage Transfer Exchange Executor’s Deed Foreclosure Fiduciary Deed Full Release with legal description Grant Deed Gift Deed Ground Lease Individual Deed Intrafamily Transfer - Transaction is between related parties for any reason & no consideration. Joint Tenancy Deed Legal Action/Court Order Leasehold Conv. With Agreement of Sale (Fee Purchase) (Hawaii) Land Contract Lease (Hawaii) Assignment of Lease (Leasehold Sale) (Hawaii) Lost Mortgage Satisfaction Leasehold Conv. with an Agreement of Sale (Hawaii) Land Court (Massachusetts) Limited Warranty Deed Miscellaneous Assignment Release of Multiple Loans Special Master Deed Master Assignment Release Original Deed of Trust Other Owelty Deed / Owelty Agreement Public Action - Common in Florida (Clerks Tax Deed or Tax Deeds). Also when property sold for taxes. Partnership Deed Partial Release with No legal description Private Party Personal Representatives Deed Partial Release with legal description Quit Claim Deed (arm's length) Quit Claim Deed (non-arm's length) Satisfaction of Land Contract (Wisconsin) or Release/Satisfaction of Agreement of Sale (Fee Property) (Hawaii) Receiver’s Deed Redemption Deed Referee’s Deed - used to transfer property pursuant to a foreclosure sale and is known to be used in New York counties (may also be used in other states, if encountered outside of NY, please forward LPS a sample for review). Release/Satisfaction of Agreement of Sale (Leasehold) (Hawaii) Full Release with No legal description Re-recorded Assignment Re-recorded Document Re-recorded Release REO Sale (REO Out) Sub Agreement of Sale (Hawaii) Substitution of Trustee and Full Reconveyance Sub Commercial Lease (Hawaii) Sheriff’s Deed - Common in New Jersey. The default code for transfers where borrower is in default, in other states document may be called something other than Sheriff’s Deed, i.e. "Masters in Equity Deed" in SC. Sub Lease (Hawaii) Subordination of Mortgage Affidavit Death of Trustee/Successor Trustee (Los Angeles) Survivorship Deed/Survivor Property Agreement Special Warranty Deed Substitution of Trustee and Assignment of Deed of Trust Trustee’s Deed (Certificate of Title) "Vendor’s Lien Warranty Deed with Vendor's Lien Special Warranty Deed with Vendor's Lien" Warranty Deed Transaction History Record | varchar |
| Multiple APN Code | Indicates the number of APNs (2-9) appearing on the conveying instrument. Left blank if only one parcel. | varchar |
| Partial Interest Transferred | Whenever LESS than 100% ownership interest is transferred by the recorded instrument. For example, a partner sells only his 50% interest. This also applies to transfers where the Grantors entire ownership interest is LESS than 100%. For example, the Grantor conveys all of his interest in the property, which is a 25% interest. When the percentage is a single digit (1-9), it is preceded with a zero: 5% = 05. When interest shown is a whole number plus a value after the decimal or fraction, it is rounded to nearest whole number only: 75.5% = 76; 33 1/3% = 33, etc. Note: If there are two or more parties each conveying a partial interest, where the total interest conveyed equals 100% - NOT a partial interest. | varchar |
| #1 - Seller First Name & Middle Name | The first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document). | varchar |
| #1 - Seller Last Name OR Corporation Name | If the last name is composed of two names, both are entered in the sequence they appear separated with a space, e.g. Mary B. Ashley Taylor, entered as: ASHLEY TAYLOR Last names such as Mc Neil, O'Brien, etc. are entered with no space, apostrophe or any other punctuation e.g. OBRIEN, MCNEIL. Names followed by 2nd, 3rd, or 4th are entered in the last name field after the name as roman numerals: 2nd = SMITH II, 3rd = SMITH III, 4th = SMITH IV. All other title designations are entered after the last name, such as: JR, SR, ESQ, PHD If Seller Name is blurred or missing from document, this field will show: NOT PROVIDED | varchar |
| #1 - Seller ID Code | Used to identify the nature of each grantor keyed from the recorded document. | varchar |
| #2 - Seller First Name & Middle Name | varchar | |
| #2 - Seller Last Name OR Corporation Name | varchar | |
| #2 - Seller ID Code | Used to identify the nature of each grantor keyed from the recorded document. | varchar |
| #1 - Buyer First Name & Middle Name | The first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document). | varchar |
| #1 - Buyer Last Name OR Corporation Name | If the last name is composed of two names, both are entered in the sequence they appear separated with a space, e.g. Mary B. Ashley Taylor, entered as: ASHLEY TAYLOR Last names such as Mc Neil, O'Brien, etc. are entered with no space, apostrophe or any other punctuation e.g. OBRIEN, MCNEIL. Names followed by 2nd, 3rd, or 4th are entered in the last name field after the name as roman numerals: 2nd = SMITH II, 3rd = SMITH III, 4th = SMITH IV. All other title designations are entered after the last name, such as: JR, SR, ESQ, PHD If Buyer Name is blurred or missing from document, this field will show: NOT PROVIDED | varchar |
| #1 - Buyer ID Code | Used to identify the nature of each grantee keyed from the recorded document. | varchar |
| #2 - Buyer First Name & Middle Name | See definition for buyer #1 | varchar |
| #2 - Buyer Last Name OR Corporation Name | See definition for buyer #1 | varchar |
| Buyer Vesting Code | The vesting code, when present, indicates how the buyers took title to the subject property. Note: The vesting codes EA and EU should not appear on records being keyed by IDM since we will be picking up all Buyer names involved in the transaction. However, these codes may still apply for transfer data purchased from a 3rd party vendor. | varchar |
| Buyer Mail: Care of Name | varchar | |
| Buyer Mail: Full Street Address | varchar | |
| Buyer Mail: Unit Type | Buyer Mailing Address Unit Designator. | varchar |
| Buyer Mail: Unit Number | varchar | |
| Buyer Mail: City | varchar | |
| Buyer Mail: State | Two-letter standard postal abbreviation. XX = Foreign Mail Address | varchar |
| Buyer Mail: Postal Code | Five-digit postal zip code | varchar |
| Buyer Mail: Postal +4 Code | Four-digit extension to postal zip code for the mailing address. Not always available. | varchar |
| Property/Buyer Mailing Address Code | Property_Unit_Type | |
| Sales Price | Total Sales Price relating to all properties conveyed by the corresponding instrument. If more than one parcel was included on the conveying instrument there is no way to allot the price to each parcel. Whenever the recorded document (deed) indicates the actual sales price, it will be entered here in whole dollars - see Sales Price Code = "D" | decimal |
| Sales Price Code | varchar | |
| City Transfer Tax | Applies in only designated cities where they levy a city tax on all purchase money real estate transfers within their jurisdiction. Input Format: 99999v99 (implied decimal) | varchar |
| County Transfer Tax | Generally appears in the form of a transfer tax stamp on the deed. The stamp amount represents a rate levied by the state per $1,000 of consideration paid in the transaction. Depending on the individual state, the stamp amount when converted to the actual transaction amount, using the corresponding rate, may represent the full sales price or only the amount of equity transferred. i.e. cash down plus any new financing. Input Format: 99999v99 (implied decimal) | varchar |
| Total Transfer Tax | Unique to certain regions where you add the city and county transfer tax amounts to compute the full sales price. Input Format: 999999v99 (implied decimal) | varchar |
| Title Company Name | Name of Title Company which issues the certificate of title insurance. Taken from the Deed and/or concurrent Trust Deed. Not coded or abbreviated. If more than one Title Company Name is reported on the document, this field will report "Multiple" versus an actual Title Company Name. | varchar |
| Standardized Land Use Code | For Address components, see Property Address Fields on Assessment Tab | varchar |
| Residential Indicator | Indicates Residential Use based on Assessor's Land Use | varchar |
| Intra-Family | Indicates the document is an intra-family transfer. | varchar |
| Cash Purchase | Indicates the current sale had no financing transaction associated with the sale | varchar |
| REO-Flag | Not REO REO-IN REO-Out Preforeclosure within 6 months REO-TRANSFER | varchar |
| DistressedSaleFlag | 1 indicates transaction deemed to be a Distressed; 0 = No | varchar |
| Seller Mail Address: Full Street | varchar | |
| Seller Mail Address: Unit Number | varchar | |
| Seller Mail Address: City Name | varchar | |
| Seller Mail Address: State Code | varchar | |
| Seller Mail Address: Zip Code | Five-digit postal zip code | varchar |
| Seller Mail Address: Zip +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| FIPS Code (State/County) | Numeric code which identifies every County/State in the United States. First 2 bytes = State; last 3 = County. | varchar |
| Assessor Parcel Number | Assessor's Parcel Number or Parcel Identification Number. When available on the document. | varchar |
| Property Full Street Address | For Address components, see Property Address fields on Assessment Tab in Public Records RLO. | varchar |
| Property City Name | For Address components, see Property Address fields on Assessment Tab in 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 |
| Property Unit Type | Property Address Unit Designator. | varchar |
| Property Unit Number | For Address components, see Property Address fields on Assessment Tab in Public Records RLO. | varchar |
| Property House Number | For Address components, see Property Address fields on Assessment Tab in Public Records RLO. | varchar |
| Property Street Direction Left | For Address components, see Property Address fields on Assessment Tab in Public Records RLO. | varchar |
| Property Street Name | For Address components, see Property Address fields on Assessment Tab in Public Records RLO. | varchar |
| Property Street Suffix | The recommended Official USPS Standardized Suffix Abbreviations | varchar |
| Property Street Direction Right | For Address components, see Property Address fields on Assessment Tab in Public Records RLO. | varchar |
| Property Address: Carrier Route | Format: C999 | varchar |
| Legal: Lot Code | Identifies properties which include more than one lot or partial lots. | varchar |
| 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 (-). | varchar |
| Legal: Block | The block of the subdivision or city in which the property is located. | varchar |
| Legal: Section | The section of the city in which the property is located. Not the same as the “Section” of a Township-Range. See Legal: Sec/Twn/Rng/Mer | varchar |
| Legal: District | The district in which the property is located. Usually a numeric code corresponding to the literal name in Legal: City, Municipality, Township | varchar |
| Legal: Land Lot | A large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located. | varchar |
| Legal: Unit | The subdivision unit number. Common for condominiums, townhomes, etc. | varchar |
| Legal: City, Township, Municipality | The jurisdiction in which the property is located. May be “Unincorporated”, if applicable. Often a description of the code provided in Legal: District | varchar |
| Legal: Subdivision Name | The name of the subdivision, plat, or tract in which the property is located. | varchar |
| Legal: Phase Number | Generally, the phase of a subdivision or tract development. | varchar |
| Legal: Tract Number | The number of the tract in which the property is located. Followed by "POR" (portion of) when applicable. | 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 |
| Complete Legal Description Code | A Legal taken from Assessment record M Multiple APN Transaction: The legal description is duplicated for every multiple APN record in the transaction. N One or more pieces of information were keyed from the legal description, but the complete legal description was unable to be keyed due to lack of field space. R Additional research of the legal description may be required to determine exact property conveyed (MN counties only) S The legal description was SKIPPED completely (exceptions are Legal: City, S-T-R or Lot Size). T Metes & Bounds Description with multiple (varying) S-T-R references. Keyer enters only the first S-T-R . X NO Legal Description was present on the Recorded Document. This includes legals where only legal information was keyed for Legal: City Y Able to capture complete legal description as reported on document. | varchar |
| Legal: Section/Township/ Range/Meridian | Format: SEC 99 TWN 99A RNG 99A Where "A" = Directional (N/S for TWN and E/W for RNG) | varchar |
| Recorder's Map Reference | Standardized to identify each portion. Multiples indicated with the ampersand (&), and ranges separated with a hyphen (-). Depending on the length of the Map Reference, spaces may be omitted. | varchar |
| Property Use Code | Property use as indicated on the trust deed (mortgage) and/or attached Rider. | varchar |
| Original Date of Contract | The date that the document was executed by the parties. Pre-dates the recording date. In some cases, may be the Notary Date. YYYYMMDD | varchar |
| Record Creation Date | The date this record was created | varchar |
| Hashvalue | Record hash value, updated hashvalue indicates if the record changed | varchar |
| ModificationTimestamp | When the record was updated | DateTimeOffset |
| TransactionId | Unique identifier for Deed record only | varchar |
