- Print
- DarkLight
- PDF
Defining Popular Fields
- Print
- DarkLight
- PDF
Field Definitions - Data Dictionary
The below data dictionary table contains the definitions of the top fields that get asked about in LightBox Vision.
Field Name | Definition |
---|---|
ASSESSED LAND VALUE | The Assessed Land Value (before exemptions, if any) as provided by the county or local taxing/assessment authority. |
ASSESSED IMPROVEMENT VALUE | The Assessed Improvement Values (before exemptions, if any) as provided by the county or local taxing/assessment authority |
BUYER NAME | Buyer name(s) of the last market sale |
DOCUMENT NO | The document number used to record the last market sale transaction. |
FIPS CODE | Federal Information Processing Code for the State + Federal Information Processing Code for the County. First two digits are state code, last three digits are county code. |
IMPROVEMENT PERCENT | Percent of the Total Assessed Value from improvements. The improvement value divided by the total assessed value is the Percentage. |
LANDUSE CATEGORY | The category of the standardized land use code. |
LANDUSE DESCRIPTION | Description of the local/municipal use code for the property in 'code.' |
LAST MARKET SALE | Also referred to as “Date Transfer”. This is the date of the last market sale of a property. |
LAST TRANSFER | Also referred to as “Value Transfer”. This is the price of the last market sale. |
LIGHTBOX ADDRESS ID | A proprietary LightBox identifier for an address that is unique and persistent. |
LIGHTBOX ASSESSMENT ID | A proprietary LightBox identifier for an assessment record that is unique and persistent. |
LIGHTBOX BUILDING ID | A proprietary LightBox identifier for a building that is unique and persistent. |
LIGHTBOX PARCEL ID | A proprietary LightBox identifier for a parcel boundary that is unique and persistent. |
LOT AREA (ASSESSOR) | The lot area size of a property as provided by the assessor. |
MAILING ADDRESS | The current owner mailing address that is comprised of street name, direction, prefix, number suffix, and unit. Ex: 123 Main St S Unit 5" |
OWNER NAME 1 | Current first owner full name (first & last name) |
SELLER NAME | Prior sale’s seller name |
SITE ADDRESS | Address where the physical property is located. |
TOTAL ASSESSED VALUE | The Total Assessed Value of both Land & Improvement values (before exemptions, if any) for the property as provided by the county or local taxing/assessment authority. |
ZONING | Actual City Zoning, unique to each incorporated area as reported to the County. Please note that it is not always current, nor reported. |
APN Definitions (Assessor Parcel Numbers)
LightBox Vision has multiple references to APN’s based upon their formatting and provider specifications in our system. The table below gives the definitions to these.
Field Name | Definition |
---|---|
APN | Assessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels. While format and composition vary widely, it is usually composed of MAP, PAGE, PARCEL, and SUB PARCEL numbers. Some counties use SEC‑TWP‑RNG as part of the APN or a MAP-BOOK, PAGE, and PARCEL reference; others use SUBDIVISION, BLOCK, and LOT to identify a parcel. Leading zeros or spaces used to maintain the integrity of the format. Re-formatted if necessary to match the county display format. |
ALTERNATE APN | Deprecated or historical parcel number as inventoried by the tax assessor. |
ALTERNATE TAXAPN | Deprecated or historical parcel number as inventories by the tax assessor. |
APN UNF | Also referred to as “Unformatted APN”. Property APN/ID as inventoried by the tax assessor and is modified to remove special characters. |
PARCEL APN | Unique parcel APN derived from the parcel geometry. |
MASTER PARCEL APN | Also referred to as “Map APN”. This is the master/main APN number associated with the primary parcel in a location where multiple parcels with identical geometry exist. This can occur where there are multiple taxable properties in a location (condos, timeshares, mobile home parks). |
MULTI APN FLAG | Indicates multiple or split property sales. |
TAXAPN | Property APN/ID as inventoried by the tax assessor. |
TAXAPN UNF | Property APN/ID as inventoried by the tax assessor and is modified to remove special characters. |
UNIQUE PARCEL APN | Unique parcel APN derived from the parcel geometry. |
UNIQUE TAXAPN | Property APN/ID as inventories by the tax assessor (APN) + duplicate APN sequence number if populated. |
Codes for Deed Transaction Types
Field Name | Code | Code Description |
---|---|---|
Deed Transaction Type | 1 | Non-Arms Length transactions with a valid Title Company Name (no accommodations) |
Deed Transaction Type | 2 | Arms Length Residential transactions (Purchase/Resales) |
Deed Transaction Type | 3 | New Construction residential transactions |
Deed Transaction Type | 6 | REO & Trustee Deeds |
Deed Transaction Type | 9 | Insured Non-Residential Grant Deeds |
Codes for Document Types
Field Name | Code | Code Description |
---|---|---|
Document Type Code | AA | Assignment of Sub Agreement of Sale (Hawaii) |
Document Type Code | AB | Assignment of Sub Lease (Hawaii) |
Document Type Code | AC | Assignment of Commercial Lease (Hawaii) |
Document Type Code | AD | Administrator’s Deed |
Document Type Code | AF | Affidavit |
Document Type Code | AG | Agreement of Sale |
Document Type Code | AH | Assessor Sales History |
Document Type Code | AR | Assignment of Agreement of Sale (Hawaii) |
Document Type Code | AS | Assignment Deed (or Assignment of Condo Deed if Land Use = "CND") |
Document Type Code | AT | Affidavit of Trust or Trust Agreement (Los Angeles) |
Document Type Code | AU | Assignment of Sub Commercial Lease (Hawaii) |
Document Type Code | BD | Beneficiary Deed (Buyer ID = "BE") |
Document Type Code | BS | Bargain and Sale Deed |
Document Type Code | CA | Commissioners Assignment of Lease (Hawaii) |
Document Type Code | CD | Condominium Deed |
Document Type Code | CH | Cash Sale Deed |
Document Type Code | CL | Commercial Lease (Hawaii) |
Document Type Code | CM | Commissioner’s Deed - In North Carolina used in probate-related transfers. In Hawaii used in foreclosure-related transfers |
Document Type Code | CN | Cancellation of Agreement of Sale (Hawaii) |
Document Type Code | CO | Conservator’s Deed |
Document Type Code | CP | Corporation Deed |
Document Type Code | CR | Correction Deed |
Document Type Code | CS | Contract of Sale |
Document Type Code | CT | Certificate of Transfer |
Document Type Code | DB | Deed of Distribution |
Document Type Code | DC | Declaration |
Document Type Code | DD | Transfer on Death Deed |
Document Type Code | DE | Deed |
Document Type Code | DG | Deed of Guardian |
Document Type Code | DJ | Affidavit of Death |
Document Type Code | DL | Deed in Lieu of Foreclosure |
Document Type Code | DS | Distress Sale |
Document Type Code | DT | Affidavit of Death of Life Tenant |
Document Type Code | DV | Divorce/Dissolution of Marriage Transfer |
Document Type Code | EC | Exchange |
Document Type Code | EX | Executor’s Deed |
Document Type Code | FC | Foreclosure |
Document Type Code | FD | Fiduciary Deed |
Document Type Code | GD | Grant Deed |
Document Type Code | GF | Gift Deed |
Document Type Code | GR | Ground Lease |
Document Type Code | ID | Individual Deed |
Document Type Code | IT | Intrafamily Transfer - Transaction is between related parties for any reason & no consideration. |
Document Type Code | JT | Joint Tenancy Deed |
Document Type Code | LA | Legal Action/Court Order |
Document Type Code | LC | Leasehold Conv. With Agreement of Sale (Fee Purchase) (Hawaii) |
Document Type Code | LD | Land Contract |
Document Type Code | LE | Lease (Hawaii) |
Document Type Code | LH | Assignment of Lease (Leasehold Sale) (Hawaii) |
Document Type Code | LS | Leasehold Conv. with an Agreement of Sale (Hawaii) |
Document Type Code | LT | Land Court (Massachusetts) |
Document Type Code | LW | Limited Warranty Deed |
Document Type Code | MD | Special Master Deed |
Document Type Code | OT | Other |
Document Type Code | OW | Owelty Deed / Owelty Agreement |
Document Type Code | PA | Public Action - Common in Florida (Clerks Tax Deed or Tax Deeds). Also when property sold for taxes |
Document Type Code | PD | Partnership Deed |
Document Type Code | PR | Personal Representatives Deed |
Document Type Code | QA | Quit Claim Deed (arm's length) |
Document Type Code | QC | Quit Claim Deed (non-arm's length) |
Document Type Code | RA | Satisfaction of Land Contract (Wisconsin) or Release/Satisfaction of Agreement of Sale (Fee Property) (Hawaii) |
Document Type Code | RC | Receiver’s Deed |
Document Type Code | RD | Redemption Deed |
Document Type Code | RF | Referee’s Deed - Used to transfer property pursuant to a foreclosure sale and is known to be used in New York counties (may also be used in other states) |
Document Type Code | RL | Release/Satisfaction of Agreement of Sale (Leasehold) (Hawaii) |
Document Type Code | RR | Re-recorded Document |
Document Type Code | RS | REO Sale (REO Out) |
Document Type Code | SA | Sub Agreement of Sale (Hawaii) |
Document Type Code | SC | Sub Commercial Lease (Hawaii) |
Document Type Code | SD | Sheriff’s Deed - Common in New Jersey. The default code for transfers where borrower is in default, in other states document may be called something other than Sheriff’s Deed, i.e. "Masters in Equity Deed" in SC. |
Document Type Code | SL | Sub Lease (Hawaii) |
Document Type Code | ST | Affidavit Death of Trustee/Successor Trustee (Los Angeles) |
Document Type Code | SV | Survivorship Deed/Survivor Property Agreement |
Document Type Code | SW | Special Warranty Deed |
Document Type Code | TD | Trustee’s Deed (Certificate of Title) |
Document Type Code | VL | Vendor’s Lien |
Document Type Code | WD | Warranty Deed |
Document Type Code | XX | Transaction History Record |