| 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:
|
| 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.