Mortgage
Provides mortgage, assignment, and release records linked to properties, covering loan amounts, lenders, borrowers, recording details, and related lien activity.
Mortgage Layout
| Field Name | Field Description | Data Type |
|---|---|---|
| Constellation1_ID (CID) | Unique Identifier in Constellation1 | 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’s Parcel Number (APN, PIN) | 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 | City Name where the property is located. May be different from Legal: City, Municipality, Township | 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 |
| Record Type | A Affidavit Death of Trustee/Successor Trustee - LOS ANGELES COUNTY ONLY B Hawaii Deed Concurrent Mortgage Fields populated from Matched Hawaii SAM record D Re-recorded Mortgage E For Declaration of Easement, Documents Conveying an Easement or Right of Way and Easement/Easement Deeds - LOS ANGELES COUNTY ONLY F Notice of Default/Notice of Trustee’s Sale M Mortgages: Non-concurrent, non-purchase money, and/or mortgages which were not matched to a deed. Keyed and maintained as separate records. N Re-Recorded Modification R Stand Alone Mortgage - Replacement S Stand Alone Mortgage T Mortgage Programmatically identified as Purchase Money (Assigned post-keying) U Hawaii - Conveyances V Hawaii - Stand Alone Mortgages W May be applied to deeds waiting for affidavit match file or mortgage records waiting for deed match file and the match file is delayed 6+ months. These are valid records. This flag is for internal controls to support data content issues that may arise w X Concurrent Mortgage - Replacement | 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 | County recorder’s document 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 |
| #1 - Borrower 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 - Borrower 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 Borrower Name is blurred or missing from document, this field will show: NOT PROVIDED | varchar |
| #1 - Borrower ID Code | Used to identify the nature of each grantee keyed from the recorded document. | varchar |
| #2 - Borrower First Name & Middle Name | varchar | |
| #2 - Borrower Last Name OR Corporation Name | varchar | |
| #2 - Borrower ID Code | varchar | |
| Borrower Vesting Code | The vesting code, when present, indicates how the borrowers 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 |
| 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 | 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 | varchar | |
| Legal: Unit | 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. Not necessarily the same as the Property City | 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 |
| 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 |
| Lender Name (Beneficiary) | Name of the beneficiary. When more that one Lender is reported, only the first Lender appearing on the document is entered. If a Trust, along with Trustees appear as Lender, then only the Trust Name is entered. Note: Whenever we encounter a mortgage/trust deed document that also references an Assignment of Mortgage, our practice is to capture the name of the Lender that ORIGINATED the loan, rather than the name of the Assignee Lender. | varchar |
| Lender Type | B Bank D Lender/Agent role undisclosed - used for encumbrance documents which fail to distinctly disclose the Lender/Beneficiary like “Trust Deed 7 Individual” in IL Counties, or in cases where the “Return to” party has been keyed as the Lender, because the body of the document omits the Lender/Beneficiary name and the “Return to” party not only appears to be an agent for the lender or is the actual lender, but also is not the Trustee or Borrower. E Et al (and others) F Finance Company G Government (FHA, VA, etc.) - used when the actual Lender servicing the loan on behalf of the government agency cannot be determined. If the Lending institution can be determined then the Lender Code will reflect the institution. I Insurance L Lending institution M Mortgage company N Not Known O Other (company or corporation) P Private Party (individual) Q MERS (Mortgage Electronic Registration System) R REO/Foreclosure Company (appears as Seller Name on REOs) S Seller U Credit Union W Internet Storefront X Subprime Lender Z Reverse Mortgage Lender | varchar |
| Loan Amount | Whole dollars only. Not calculated when loan made in installments distributed on a monthly or annual basis. Note: On Assumed Loans the loan amount being assumed is entered here, if available. | varchar |
| Loan Type | Indicates the type of loan, if able to determine from the recorded document. | varchar |
| Type Financing | When available will indicate the type of interest rate terms AND/OR see Loan Type. Left blank if unknown. 1. When document indicates the loan is initiated at an Adjustable Rate, Type Financing will be “ADJ” or “AJO”. 2. When document indicates the loan is initiated with a Fixed Rate, Type Financing will be “FIX” or “FXO”. | varchar |
| Interest Rate | When available, initial rate as given on the trust deed or rider. Format: 9(9)(.99999) | varchar |
| Due Date | When available, the date the trust deed will be paid in full. YYYYMMDD | varchar |
| Adjustable Rate Rider | (Y)es = an Adjustable Rate Rider recorded with the trust deed, else blank. | varchar |
| Adjustable Rate Index | Identifies the type of index the adjustable loan is tied to. | varchar |
| Change Index | Identifies the margin (expressed as a percentage) that is added by the Lender to the interest rate derived from the index. If that is not available, then the value represents the maximum change in the interest rate at any one time. Format: 9(9)(.99999) | varchar |
| Rate Change Frequency | Indicates the frequency the interest rates may change. | varchar |
| Interest Rate Not Greater Than | The maximum interest rate allowed on the first change date (date when loan switched from a fixed to an adjustable interest rate). Format: 9(9)(.99999) | varchar |
| Interest Rate Not Less Than | The minimum interest rate allowed on the first change date (date when loan switched from a fixed to an adjustable interest rate). Format: 9(9)(.99999) | varchar |
| Maximum Interest Rate | The maximum interest rate allowed for the loan. Format: 9(9)(.99999) | varchar |
| Interest Only Period | If available, the actual interest only period (expressed in years) OR (Y)es = the loan has an interest-only period. | varchar |
| Fixed/Step (Conversion) Rate Rider | Indicates initial state of the interest rate (fixed, variable, etc.) for the loan, if available. | varchar |
| First Change Date - Year (Conversion Rider) | The year that the loan converts from a FIXED to ADJUSTABLE interest rate. Format: YY (Two digit year; 2005 = “05”) | varchar |
| First Change Date - Month & Day (Conversion Rider) | The Month and Day that the loan converts from a FIXED to ADJUSTABLE interest rate. Format: M(M)DD | varchar |
| Prepayment Rider | (Y)es = a Prepayment Rate Rider recorded with the trust deed. Refer to Prepayment Term | varchar |
| Prepayment Term (Penalty Rider) | The number of months that the originated loan must remain active. If the loan is paid off early, the borrower will pay a prepayment penalty. Always expressed in months: 12, 18, 24, 36 are the most common. | varchar |
| Borrower Mail: Full Street Address | varchar | |
| Borrower Mail: Unit Number | varchar | |
| Borrower Mail: City Name | See Assessment Tab - Assessee Mail: City Name | varchar |
| Borrower Mail: State | Two-letter standard postal abbreviation. XX = Foreign Mail Address | varchar |
| Borrower Mail: Zip Code | Five-digit postal zip code. | varchar |
| Borrower Mail: Zip +4 Code | Four-digit extension to postal zip code for the mailing address. Not always available. | 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 |
| Title Company Name | varchar | |
| Lender DBA Name | Lender DBA/AKA Name. Not preceded with letters “DBA” or “AKA”. If present, Lender Care of Name is preceded by “C/O”. “DBA” takes priority over “C/O” if both are present on the same document. | varchar |
| Lender Mail: Full Street Address | Lender Address keyed for Private Party Lenders only For Street Address components, see Property Full Street Address on Assessment Tab. Note: Lender Zip keyed for all Lenders. | varchar |
| Lender Mail: Unit | varchar | |
| Lender Mail: City | varchar | |
| Lender Mail: State | varchar | |
| Lender Mail: Zip Code | Five-digit postal zip code. | varchar |
| Lender Mail: Zip +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| Loan Term - Months | Term of the Loan expressed in Months (i.e. 360 months). NOT calculated to populate field. | varchar |
| Loan Term - Years | Term of the Loan expressed in Year (i.e. 30 years). NOT calculated to populate field. | varchar |
| Assessor’s Land Use | Standardized Land Use derived from Assessment Record. See Separate Land-Use Table. | varchar |
| Residential Indicator | Indicates Residential Use based on Assessor’s Land Use | varchar |
| Construction Loan | Indicates the mortgage is a building/construction loan. | varchar |
| Cash Purchase | Indicates the mortgage is for cash. | varchar |
| Stand-Alone Refi | Indicates the mortgage is a stand-alone second. | varchar |
| Equity Credit Line | Indicates the mortgage is a home equity credit line. | varchar |
| Purchase Money Mortgage | “Y” = Purchase Money Mortgage | varchar |
| Unique_Link_ID | Unique document link identifier | 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 | DateTime(UTC) |
| TransactionId | Unique identifier for Mortgage record only | varchar |
Mortgage Assignment
| 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 |
| Document Type Code | “AM” (Assignment of Mortgage) “MS” (Master Assignment) When one lender is assigning dozens, hundreds or thousands of loans involving different FIPS, borrowers, etc. | varchar |
| MERS Indicator (ASSIGNEE) | Flag the document “Y” if the Assignee of the loan is in MERS. Enter “N” if there is NO mention of MERS. This field MUST be populated with either “Y” or “N”. | varchar |
| “M”AIN or “A”DDENDUM Record ID | “Default is BLANK (meaning there are NO addendum records for this recorded document) “M”ain (Master) “A”PN Addendum (tied to Assignment with multiple properties- same borrower) “D” DOT Addendum Record (tied to a “Master Assignment”) | varchar |
| Assignment Recording Date | The official date of document recordation. Location on document varies by county. YYYYMMDD | varchar |
| Assignment EFFECTIVE or CONTRACT Date | Due to the volume of assignments, we have found that the Recording Date may be several months (years) AFTER the date that the Assignment took effect. For that reason, when provided, we need to capture the EFFECTIVE DATE. If NONE use Dated Date. | varchar |
| Assignment Document Number (also known as: Reception No, Instrument No.) | This is a sequential number assigned to the document at the time of recording for identification and to establish the order of recordation. Not every county uses the Document Number system. | varchar |
| Assignment Book Number | Recorder Book Number - Format Per County Specs | varchar |
| Assignment Page Number | Enter the 1st Page Number for multi-page documents | varchar |
| Multiple Page Image Flag | “Y” if each page of a multiple page document is a separate image (“unstapled”). | varchar |
| Original Deed of Trust (“DOT”) Recording Date | Recording Date of the originating mortgage which is being assigned. YYYYMMDD | varchar |
| Original Deed of Trust (“DOT”) Contract Date | IF Recording Date is not available, then key the Original Contract Date. It is not necessary to key the Contract Date if Recording Date is provided. | varchar |
| Original Deed of Trust (“DOT”) Document Number | Document Number of the originating mortgage. | varchar |
| Original Deed of Trust (“DOT”) Book Number | Book Number of the originating mortgage. | varchar |
| Original Deed of Trust (“DOT”) Page Number | 1st Page Number of the originating mortgage | varchar |
| Original Beneficiary/Lender/Mortgagee/In Favor of/Made By | If multiple Lender/Entity Names are present, ALL the names that appear into this field including all characters, Trust Name(s), etc. as presented on document. For Lender/Entity names that are presented with “Mortgage Electronic Registration Systems Inc. As Nominee for ABC Lender”, all are keyed as presented including the MERS verbiage. If NO ORIGINAL BENEFICIARY/LENDER NAME IS PROVIDED on the Assignment and it is also NOT MERS, “NOT PROVIDED” is entered. | varchar |
| Original Loan Amount | Whole dollars only. | varchar |
| Assignor Name(s) | Lender/Entity Name(s) | varchar |
| Loan Number | May be preceded with “Account Number” or a portion of the Borrower’s Last Name. | varchar |
| Assignee(s) (Lender(s) receiving right, title & interest in the Deed of Trust or Mortgage) | ALL Lender/Entity Names | varchar |
| Assignee / Pool # | varchar | |
| Borrower Name(s)/Corporation(s) | Borrower Name and Borrower Vesting keyed exactly as presented on document. | varchar |
| Assessor’s Parcel Number (APN, PIN, PID) - Keyed | The APN May appear on same page/section as the Legal Description. Keyed using the APN formatting instructions for each county. | varchar |
| Multiple APN Code | Number of APN Addendum Records (2-9). ”+” if more than 9. Default is BLANK. | varchar |
| Tax Account ID | varchar | |
| Property: Full Street Address | For Address components, see Property Address fields on Assessment Tab . | varchar |
| Property: Unit | varchar | |
| Property: City Name | City Name where the property is located. May be different from Legal: City, Municipality, Township | 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 |
| Double System Recording Flag | Used to flag when a document is recorded in both Regular & Land systems (Hawaii); Torrens & Abstract (Minnesota). This is a coded field that identifies the dominant recording system the document is recorded in. L = Land R = Regular T = Torrens A = Abstract Default {blank} | varchar |
| Double System Document Number | When a document is recorded in both Regular and Land systems (Hawaii) or Torrens & Abstract (Minnesota), the document number for the non-dominant recording system is entered here. | varchar |
| Hawaii- Transfer Certificate of Title (TCT) MN- Previous Certificate of Title (Torrens Documents) | In Hawaii: A reference number recorded on documents filed in Land Court system only. Similar to a document number, the TCT number allows access information on transactions related to the subject property. In Minnesota: A reference number recorded on documents (labeled as “Cert#”) filed in Torrens System only. Similar definition as described above for Hawaii TCT. | varchar |
| Hawaii - Condo CPR/HPR | This is a 4-digit numeric value (Condominium Property Regime) that serves as the last segment of the parcel number for Condominiums. For non-condo property the CPR number is always “0000”. | varchar |
| Hawaii - Situs Unit Number | Created to accommodate a longer unit number value. In Hawaii, the unit number may indicate whether the property is “mountain” or “ocean” side. | varchar |
| Previous Double System Document Number | The Double System Document number corresponding to the Original Mortgage being assigned (applies to both HI & MN). | varchar |
| Hawaii - Previous Transfer Certificate of Title (TCT) MN- Previous Certificate of Title (Torrens Documents) | In Hawaii: The TCT of the original mortgage being Assigned. In Minnesota: The Existing Cert# of the original mortgage being assigned. | varchar |
| [Matched (M) or Orphan (O)] | (M)atched; (O)rphan | varchar |
| Purchase_Link_ID | Present If matched to the concurrent mortgage on a deed record | decimal |
| Mortgage_Link_ID | Present if matched to a standalone mortgage | decimal |
| 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 | DateTime(UTC) |
| TransactionId | Unique identifier for Mortgage Assignment record only | varchar |
Mortgage Release
| Field Name | Field Description | Data Type |
|---|---|---|
| Constellation_ID (CID) | CID (Constellation Unique Identifier) | 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 |
| Document Type Code | “RM” (FULL Release With NO Legal Description) “FL” Full Release with a Legal Description ”SB” (Substitution of Trustee and Full Reconveyance”) “ML” Release of Multiple Loans | varchar |
| Main or “A”ddendum Record ID | Default is BLANK (meaning there are NO addendum records for this recorded document) “M”ain (Master) “A”PN Addendum (tied to Releases with multiple properties- same borrower) “D” DOT Addendum Record (tied to a “Master Release”) | varchar |
| Release Recording Date | The official date the Release Document was recorded. Location on document varies by county. YYYYMMDD | varchar |
| Release Contract Date or Effective Date | The Recording Date may be several months (years) AFTER the date that the loan was paid off. For that reason, when provided, we need to capture the EFFECTIVE DATE. If NONE use Dated Date. YYYYMMDD | varchar |
| (Mortgage) Payoff Date (P.O. Date) | The date the mortgage was officially paid off (not the same as the recording or contract date) Other “pay-off” terms: Satisfied; Discharged; Reconveyed; Paid-off; “PIF” or “P.I.F.”. YYYYMMDD | varchar |
| Release Document Number (Instrument, Reception No) | sequential number assigned to the document at the time of recording for identification and to establish the order of recordation. Not every county may report a Document Number. | varchar |
| Release Book Number (Folio, Liber,Volume) | See explanation for Book Number | varchar |
| Release Page Number | Enter the 1st Page Number for multi-page documents | varchar |
| Multiple Page Image Flag | “Y” if each page of a multiple page document is a separate image | varchar |
| Original Deed of Trust (“DOT”) Recording Date | Recording Date of the mortgage which is being released. YYYYMMDD | varchar |
| Original Deed of Trust (“DOT”) Contract Date | Original Contract Date (dated date of the DOT) | varchar |
| Original Deed of Trust(“DOT”) Document Number | Document Number of the mortgage. NOTE: When the original DOT has been amended and those amendment dates are present; key the original DOT or EARLIEST date and Document Number provided. | varchar |
| Original Deed of Trust (“DOT”) Book Number | Book Number of the mortgage | varchar |
| Original Deed of Trust (“DOT”) Page Number | 1st Page Number of the originating mortgage | varchar |
| Original Beneficiary/Lender/Mortgagee | If multiple Lender/Entity Names are present, ALL the names that appear into this field including all characters, Trust Name(s), etc. as presented on document. For Lender/Entity names that are presented with “Mortgage Electronic Registration Systems Inc. As Nominee for ABC Lender”, all are keyed as presented including the MERS verbiage. If NO ORIGINAL BENEFICIARY/LENDER NAME IS PROVIDED on the Assignment and it is also NOT MERS, “NOT PROVIDED” is entered. | varchar |
| Original Loan Amount | Original Loan Amount in whole dollars | varchar |
| Current Beneficiary/Lender/Mortgagee | ALL Lender/Entity Names | varchar |
| Borrower Name(s)/Corporation(s) | Borrower Name and Borrower Vesting keyed exactly as presented on document | varchar |
| Borrower Mail: Full Street Address | Street Address components are: • House Number • House Alpha (i.e. 400 ½, 230A, etc) • Street Direction Left (i.e. N, S, E, W, NE, SE, etc) • Street Name • Suffix (Ave, Rd, St, etc) • Street Direction Right (i.e. N, S, E, W, NE, SE etc) Example incorporating all components: 400 ½ E Iris Ave NE | varchar |
| Borrower Mail: Unit | varchar | |
| Borrower Mail: City Name | City Name where Mail Full Street Address is located. | varchar |
| Borrower Mail: State | Two-letter standard postal abbreviation | varchar |
| Borrower Mail: Zip Code | Five-digit postal zip code. | varchar |
| Borrower Mail: Zip +4 Code | Four-digit extension to postal zip code. Not always available. | varchar |
| Assessor’s Parcel Number (APN, PID, PIN) Keyed | Entered using APN formatting rules per county | varchar |
| Multiple APN Code | Number of APN Addendum Records (2-9). ”+” if more than 9. Default is BLANK. | varchar |
| Tax Account ID | varchar | |
| Property: Full Street Address- (Look for phrases such as “Commonly known as”) | For Address components, see Property Address fields on Assessment Tab . | varchar |
| Property: Unit | varchar | |
| Property: City Name | For Address components, see Property Address fields on Assessment Tab . | varchar |
| Property: State | Two-letter standard postal abbreviation | varchar |
| Property: Zip Code | Five-digit postal zip code. | varchar |
| Double System Recording Flag | Used to flag when a document is recorded in both Regular & Land systems (Hawaii); Torrens & Abstract (Minnesota). This is a coded field that identifies the dominant recording system the document is recorded in. L = Land R = Regular T = Torrens A = Abstract Default {blank} | varchar |
| Double System Document Number | When a document is recorded in both Regular and Land systems (Hawaii) or Torrens & Abstract (Minnesota), the document number for the non-dominant recording system is entered here. | varchar |
| Hawaii- Transfer Certificate of Title (TCT) MN- Certificate of Title (Torrens Documents) | In Hawaii: A reference number recorded on documents filed in Land Court system only. Similar to a document number, the TCT number allows access information on transactions related to the subject property. In Minnesota: A reference number recorded on documents (labeled as “Cert#”) filed in Torrens System only. Similar definition as described above for Hawaii TCT. | varchar |
| Hawaii - Condo CPR/HPR | This is a 4-digit numeric value (Condominium Property Regime) that serves as the last segment of the parcel number for Condominiums. For non-condo property the CPR number is always “0000”. | varchar |
| Hawaii - Situs Unit Number | Created to accommodate a longer unit number value. In Hawaii, the unit number may indicate whether the property is “mountain” or “ocean” side. | varchar |
| Previous Double System Document Number | The Double System Document number corresponding to the Original Mortgage being assigned (applies to both HI & MN). | varchar |
| Hawaii - Previous Transfer Certificate of Title (TCT) MN- Previous Certificate of Title (Torrens Documents) | In Hawaii: The TCT of the original mortgage being Assigned. In Minnesota: The Existing Cert# of the original mortgage being assigned. | varchar |
| [Matched (M) or Orphan (O)] | (M)atched; (O)rphan | 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 | varchar |
| Hashvalue | Record hash value, updated hashvalue indicates if the record changed | varchar |
| ModificationTimestamp | When the record was updated | DateTime(UTC) |
| TransactionId | Unique identifier for Mortgage Release record only | varchar |
Full Detail information Confidential. Not for Distribution.