Mortgage Layout Mortgage Assignment Mortgage Release

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.