Property Historical Sales Data Schema - 23.1

spectrum-inline

Product type
Software
Portfolio
Enrich
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Quality > Context Graph
Spectrum > Discovery
Spectrum > Web Services
Spectrum > Spatial > Spectrum Spatial
Spectrum > Quality > Addressing
Spectrum > Dataflow Designer
Spectrum > Geocoding > Enterprise Tax
Spectrum > Data Integration
Spectrum > Quality > Spectrum Quality
Spectrum > Spectrum Platform
Spectrum > GeoEnrichment
Version
23.1
Language
English
Product name
Precisely Spectrum
Title
spectrum-inline
First publish date
2007

Field Name Short Name Data Type (Length) Description
ProductID PAID VARCHAR (50) Unique ID for each record in the product.
LinkID LINKID VARCHAR (50) ID to link Precisely Property Attributes products.
PreciselyID PBKEY VARCHAR (50) Unique ID for an addressable location. Not always available.
Parent PARENT VARCHAR (50) The parent ID for the PreciselyID which represents the address for a building with units, apartments, and suites. Only present when applicable.
PID PID VARCHAR (50) Link to Parcel Boundary dataset.
Seller/Buyer Information
Seller #1 - First Name & Middle Name SELLER1_FIRST_MIDDLE VARCHAR (40) Seller's first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document).
Seller #1 - Last Name OR Corporation Name SELLER1_LAST_CORPNAME VARCHAR (40) If the last name is composed of two names, both are entered in the sequence they appear separated with a space, e.g. Amy B. Jefferson Wright, entered as: JEFFERSON WRIGHT 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
Seller #1 - ID Code SELLER1_ID_CODE VARCHAR (2) Used to identify the nature of each grantor keyed from the recorded document. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Seller #2 - First Name & Middle Name SELLER2_FIRST_MIDDLE VARCHAR (40) See definition for Seller #1 - First Name & Middle Name field.
Seller #2 - Last Name OR Corporation Name SELLER2_LAST_CORPNAME VARCHAR (40) See definition for Seller #1 - Last Name OR Corporation Name field.
Seller #2 - ID Code SELLER2_ID_CODE VARCHAR (2) Identifies the nature of each grantor keyed from the recorded document. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Seller Mail Address: Formatted Address SELLER_MAIL_FORMATADDR VARCHAR (80) Full formatted address for the seller.
Seller Mail Address: City Name SELLER_MAIL_CITY VARCHAR (30) Parsed city name for seller mailing address
Seller Mail Address: State Abbreviation SELLER_MAIL_STATE VARCHAR (2) Parsed state abbreviation for seller mailing address
Seller Mail Address: Zip Code SELLER_MAIL_POSTCODE VARCHAR (7) ZIP Code for seller mailing address.
Seller Mail Address: Zip + 4 SELLER_MAIL_PLUS4 VARCHAR (4) ZIP+4 for seller mailing address. This field does not have 100% fill rate.
Buyer #1 - First Name & Middle Name BUYER1_FIRST_MIDDLE VARCHAR (40) Buyer's name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document).
Buyer #1 - Last Name OR Corporation Name BUYER1_LAST_CORPNAME VARCHAR (40) If the last name is composed of two names, both are entered in the sequence they appear separated with a space, e.g. Amy B. Jefferson Wright, entered as: JEFFERSON WRIGHT 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
Buyer #1 - ID Code BUYER1_ID_CODE VARCHAR (2) Identifies the nature of each grantee keyed from the recorded document. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Buyer #2 - First Name & Middle Name BUYER2_FIRST_MIDDLE VARCHAR (40) See definition for Buyer #1 - First Name & Middle Name field.
Buyer #2 - Last Name OR Corporation Name BUYER2_LAST_CORPNAME VARCHAR (40) See definition for Buyer #2 - Last Name or Corporation Name field.
Buyer #2 - ID Code BUYER2_ID_CODE VARCHAR (2) Identifies the nature of each grantee keyed from the recorded document. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Buyer Vesting Code BUYER_VEST_CODE VARCHAR (2) The vesting code, when present, indicates how the buyers took title to the subject property. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
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 third party vendor.
Buyer Mail Address: Formatted Address BUYER_MAIL_FORMATADDR VARCHAR (80) Full formatted address for the buyer.
Buyer Mail Address: City Name BUYER_MAIL_CITY VARCHAR (30) Parsed city name for buyer mailing address
Buyer Mail Address: State Abbreviation BUYER_MAIL_STATE VARCHAR (2) Parsed state abbreviation for buyer mailing address
Buyer Mail Address: Zip Code BUYER_MAIL_POSTCODE VARCHAR (7) ZIP Code for buyer mailing address.
Buyer Mail Address: Zip + 4 BUYER_MAIL_PLUS4 VARCHAR (4) ZIP+4 for buyer mailing address. This field does not have 100% fill rate.
Property Information
Property Formatted Address PROP_ADDR VARCHAR (80) Property full formatted address
Property House Number PROP_ADDR_NUM VARCHAR (13) Parsed property house number
Property Street Pre-directional PROP_PREDIR VARCHAR (2) Parsed property pre-directional
Property Street Name PROP_STNAME VARCHAR (60) Parsed street name
Property Street Type PROP_STTYPE VARCHAR (15) Parsed street name type (i.e. RD). Please see USPS Publication 28 - Postal Addressing Standards.
Property Street Post-Directional PROP_POSTDIR VARCHAR (2) Parsed property post directional
Property Unit Designator PROP_UNIT_DES VARCHAR (4) Parsed unit designator for secondary address per Please see USPS Publication 28 - Postal Addressing Standards.
Property Unit Number PROP_UNIT_NUM VARCHAR (15) May be different from legal unit number
Property City Name PROP_CITY VARCHAR (30) Parsed city name. Not necessarily the same as legal city, municipality, or township.
Property State PROP_STATE VARCHAR (2) Parsed state abbreviation
Property Zip Code PROP_POSTCODE VARCHAR (5) Parsed 5-digit ZIP Code
Property Zip + 4 PROP_PLUS4 VARCHAR (4) Parsed ZIP+4 extension
Assessor’s Parcel Number (APN, PIN) APN_PIN VARCHAR (45) Assessor's Parcel Number or Parcel Identification Number. when available on the document.
Multi-APN Flag MULTI_APN VARCHAR (2) Indicates the number of APNs (2-9) appearing on the conveying instrument. Left blank if only one parcel. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
FIPS Code STCTY_FIPS VARCHAR (5) 2-digit state and 3-digit county Federal Information Processing Standard codes.
Property Use Code PROP_USE_CODE VARCHAR (3) Property use as indicated on the trust deed (mortgage) and/or attached Rider. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Recorder and Deed Information
Deed Document Type Code DEED_DOC_TYPE VARCHAR (2) Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Inter-Family INTER_FAMILY VARCHAR (1) Indicates the document is an inter-family transfer.
Recording Date RECORDING_DATE VARCHAR (8) Official date on which document was recorded, in YYYYMMDD format.
Recorder’s Book Number RECORDER_BKNUM VARCHAR (10) Populated when counties use book and page reference without the document number, instead of the document number.
Recorder’s Page Number RECORDER_PGNUM VARCHAR (10) Populated when counties use book and page reference without the document number, instead of the document number.
Recorder’s Document Number RECORDER_DOCNUM VARCHAR (20) Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation.
Partial Interest Transferred PAR_INT_TRANSFERRED VARCHAR (2) Indicates that 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's 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. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Note: If there are two or more parties each conveying a partial interest, where the total interest conveyed equals 100%, this is not considered partial interest.
Legal: Lot Code LEGAL_LOT VARCHAR (2) Identifies properties which include more than one lot or partial lots. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Legal: Lot Number(s) LEGAL_LOTNUMS VARCHAR (10) 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 (-). Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Legal: Block LEGAL_BLOCK VARCHAR (7) The block of the subdivision or city in which the property is located.
Legal: Section LEGAL_SECTION VARCHAR (7) The section of the city in which the property is located. Not the same as the “Section” of a Township-Range. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Legal: District LEGAL_DISTRICT VARCHAR (7) The district in which the property is located. Usually a numeric code corresponding to the literal name in Legal: City, Municipality, Township field.
Legal: Land Lot LEGAL_LANDLOT VARCHAR (7) A large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located.
Legal: Unit LEGAL_UNIT VARCHAR (6) The subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the Property Unit Number field.
Legal: City, Township, Municipality LEGAL_CITY_TWP_MUNI VARCHAR (30) The jurisdiction in which the property is located. May be “Unincorporated”, if applicable. Often a description of the code provided in Legal: District field. Not necessarily the same as the Property City field.
Legal: Subdivision Name LEGAL_SUBNAME VARCHAR (50) The name of the subdivision, plat, or tract in which the property is located.
Legal: Phase Number LEGAL_PHASENUM VARCHAR (7) Generally, the phase of a subdivision or tract development.
Legal: Tract Number LEGAL_TRACTNUM VARCHAR (10) The number of the tract in which the property is located. Followed by POR (portion of) when applicable.
Legal: Short Description LEGAL_SHORTDESC VARCHAR (200) 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. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Legal: Section/Township/ Range/Meridian LEGAL_SEC_TWP_RGE_MER VARCHAR (30) Format: SEC 99 TWN 99A RNG 99A Where A - Directional (N/S for TWN and E/W for RNG)
Legal Description Code LEGAL_DESC_CODE VARCHAR (2) Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Recorder's Map Reference RECORDER_MAPREF VARCHAR (20) Standardized to identify each portion. Multiples indicated with the ampersand (&), and ranges separated with a hyphen (-). Spaces may be omitted depending on the length of the map reference.
Deed Transaction Type DEED_TRANS_TYPE VARCHAR (2)

Valid deed codes:

1 - Non-arm's length transfer

2 - Residential resale

3 - Residential new construction sale

6 - Foreclosure or distress sale

9 - Insured non-residential grant deeds. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.

Sale and Mortgage Information
Mortgage: Document Number or Book/Page CONTD_DOCNUM VARCHAR (19) Mortgage info recorded at the time of deed recording. The sequential document number or the book/page number assigned to the concurrent mortgage at the time of recording for identification and to establish the order of recordation.
Note:
  • The document number takes priority if both document number and book and page are recorded on the document.
  • If book and page values are keyed, separate the values with a slash ( / ) example: "4778/456" = book 4778, page 456
Original Date of Contract CONTRACT_DATE VARCHAR (8) The date that the document was executed by the parties. Pre-dates the recording date. In some cases, may be the date notarized. YYYYMMDD
Sales Price SALES_PRICE INT Total sales price of 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. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Sales Price Code SALESPRICE_CODE VARCHAR (2) Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
City Transfer Tax CITY_TRANSFER_TAX FLOAT Applies only to designated cities where a municipal tax is levied on real estate transfers within their jurisdiction. Input format: 99999v99 (implied decimal)
County Transfer Tax CTY_TRANSFER_TAX FLOAT 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)
Total Transfer Tax TOTAL_TRANSFER_TAX FLOAT Unique to certain regions where the sum of city and county transfer taxes is used to compute the full sale price. Input format: 999999v99 (implied decimal)
Mortgage: Lender Name (Beneficiary) CONTD_LENDER_NAME VARCHAR (40) Mortgage info recorded at the time of deed recording. Name of the beneficiary to the first trust deed (mortgage). When more than 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 a mortgage/trust deed also references an assignment of mortgage, Precisely's practice is to capture the name of the lender that originated the loan rather than the name of the assignee lender.
Mortgage: Lender Type CONTD_LENDER_TYPE VARCHAR (1) Mortgage info recorded at the time of deed recording. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Mortgage: Loan Amount CONTD_LOAN_AMT INT Mortgage info recorded at the time of deed recording. Mortgage (purchase money) recorded concurrently with the conveying instrument. Reported in dollars only, without commas. Not calculated when loan made in installments distributed on a monthly or annual basis.
Note: On assumed loans (Mortgage: Loan Type = A), the loan amount being assumed is entered here, if available.
Mortgage: Loan Type CONTD_LOAN_TYPE VARCHAR (2) Indicates the type of loan, if able to determine from the recorded document. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Mortgage: Type Financing CONTD_TYPE_FINANCING VARCHAR (4) When available will indicate the type of interest rate terms for the mortgage. Left blank if unknown. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Note: Field value will be ADJ for an adjustable rate loan or FIX for a fixed rate loan.
Mortgage: Interest Rate CONTD_INT_RATE FLOAT When available, initial interest rate as listed in the trust deed or rider. Input Format: 99v99 (implied decimal)
Mortgage: Due Date CONTD_DUE_DATE VARCHAR (8) When available, the date of concurrent trust deed will be paid in full. Format: YYYYMMDD
2nd Mortgage: Loan Amount CONTD2_LOAN_AMT INT Loan amount of second trust deed concurrent (subject to) to the original (first) loan.
Adjustable Rate Rider ADJ_RATE_RIDER VARCHAR (1) Value of Y indicates that an adjustable rate rider was recorded with the trust deed, otherwise this field is blank. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Adjustable Rate Index ADJ_RATE_INDEX VARCHAR (15) Index type for adjustable rate loan. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Change Index CHANGE_INDEX FLOAT 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. Input format: 99v99 (implied decimal)
Rate Change Frequency RATE_CHANGE_FREQ VARCHAR (1) Indicates the frequency the interest rates may change. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Interest Rate Not Greater Than INT_RATE_NOGREATTHAN FLOAT The maximum interest rate allowed on the first change date (date when loan switched from a fixed to an adjustable interest rate). Format: 99v99 (implied decimal)
Interest Rate Not Less Than INT_RATE_NOLESSTHAN FLOAT The minimum interest rate allowed on the first change date (date when loan switched from a fixed to an adjustable interest rate). Format: 99v99 (implied decimal)
Maximum Interest Rate MAX_INT_RATE FLOAT The maximum interest rate allowed for the loan. Format: 99v99 (implied decimal)
Interest Only Period INT_ONLY_PERIOD VARCHAR (2) If available, the actual interest only period (expressed in years) OR Yes = the loan has an interest-only period.
Fixed/Step (Conversion) Rate Rider FIXED_CONV_RATE_RIDER VARCHAR (1) Indicates initial state of the interest rate (fixed, variable, etc.) for the concurrent loan, if available. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
First Change Date - Year (Conversion Rider) FIRST_CHANGE_DATE_YR_CONV VARCHAR (2) The year that the loan converts from a fixed to adjustable interest rate. Format: two-digit year
First Change Date - Month & Day (Conversion Rider) FIRST_CHANGE_DATE_MTH_DAY_CONV VARCHAR (4) The month and day that the loan converts from a fixed to adjustable interest rate. Format: MMDD
Prepayment Rider PREPAYMENT_RIDER VARCHAR (1) Y indicates that a prepayment rate rider was recorded with the trust deed. Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.
Prepayment Term (Penalty Rider) PREPAYMENT_TERM_PENALTY VARCHAR (2) 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. 12, 18, 24, 36 are the most common values.
Title Company Name TITLE_COMP_NAME VARCHAR (28) 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.
REO-Flag REO_FLAG VARCHAR (1)

0 - NOT REO

1 - REO-IN

2 - REO-OUT

3 - Pre foreclosure within 6 months

4 - REO-TRANSFER

DistressedSaleFlag DISTRESSED_SALE_FLAG VARCHAR (1)

0 - Indicates that transaction was not deemed a distressed sale

1 - Indicates that transaction was a distressed sale

LoanOrganizationNMLS_ID LOAN_ORG_NMLS_ID VARCHAR (12) Loan originator company/organization ID number. Sometimes Referenced as NMLSR ID or Originator Company ID.
LoanOrganizationName LOAN_ORG_NAME VARCHAR (100) Name of loan originator organization/company as referenced on signature page of mortgage document - Also referenced as Creditor.
MortgageBrokerNMLS_ID MORT_BROKER_NMLS_ID VARCHAR (12) NMLS ID recorded on the document for the originating broker
MortgageBroker MORT_BROKER VARCHAR (100) NMLS broker name recorded on the document.
LoanOfficerNMLS_ID LOAN_OFFICER_NMLD_ID VARCHAR (12) Loan originator ID number assigned to individual originating loan. Sometimes referenced as NMLSR ID or Originator ID
LoanOfficerName LOAN_OFFICER_NAME VARCHAR (150) Full name of individual loan originator/agent as referenced on signature page of mortgage document
Loan Transaction Type LOAN_TRANS_TYPE VARCHAR (2) Valid codes are:

4 - HELOCS (Purchase and Non-Purchase)

5 - REFI and 2nd Trust Deed (Purchase and Non-Purchase)

7 - Residential Resale Purchase Money Loan

8 - Construction Loan (Purchase Money and Non-Purchase)

10 - New Construction Purchase Money Loan

11 - Non-Residential Mortgages (Purchase and Non-Purchase). Refer to the Field Value Key tab in the Property Historical Sales Data Schema workbook.

Change_Type CHANGE_TYPE CHAR (1) Change type:

A – Added

D – Deleted

U – Updated

Note: The Change_Type field is only available in Change Log files.