Defining Popular Fields
    • Dark
      Light
    • PDF

    Defining Popular Fields

    • Dark
      Light
    • PDF

    Article summary

    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.
    (Ex: if APN is 07-08-34.001 then the unformatted version would be 070834001)

    PARCEL APN

    Unique parcel APN derived from the parcel geometry.
    Note: may differ from unique APN derived from the tax assessor

    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.  
    Ex: When a sale occurs that includes multiple parcels.

    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.
    Note: may differ from unique APN derived from the tax assessor

    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
    Warranty Deed with Vendor’s Lien
    Special Warranty Deed with Vendor’s Lien

    Document Type Code

    WD

    Warranty Deed

    Document Type Code

    XX

    Transaction History Record


    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.