Property Attributes Assessment Data Schema

Field Name	Long Name	Data Type (Length)	Description
PAID	Product ID	VARCHAR (50)	Unique ID for each record in the product
LINKID	Link ID	VARCHAR (50)	ID to link Precisely Property Attributes products
PBKEY	PreciselyID	VARCHAR (50)	Unique ID for an addressable location. Not always available.
PARENT	Parent	VARCHAR (50)	For secondary (child) address records (e.g. units, apartments, or suites), the Precisely ID of the parent address. Only present when applicable.
PID	Precisely Parcel Boundary Link ID	VARCHAR (50)	Link to parcel boundary dataset. Composed of state/county FIPS code and parcel APN.
OWNER (ASSESSEE) INFORMATION
FNAME	Owner First Name	VARCHAR (166)	Property owner's first name
MNAME	Owner Middle Name	VARCHAR (166)	Property owner's middle name
LNAME	Owner Last Name	VARCHAR (166)	Property owner's last name. May contain suffix (Jr., Sr., I, II, etc.)
FNAME2	Owner2 First Name	VARCHAR (166)	First name of the second owner of the property
MNAME2	Owner2 Middle Name	VARCHAR (166)	Middle name of the second owner of the property
LNAME2	Owner2 Last Name	VARCHAR (166)	Last name of the second owner of the property. May contain suffix (Jr., Sr., I, II, etc.)
OWNTYPE	Owner Type	VARCHAR (1)	Indicates whether the property is owned by an individual or individuals, a business or corporation, or a government entity. Possible values: I - Individual B - Business/corporation Note: This field does not indicate the type of property (residential, vacant, etc.)
BUSNAME	Business Name	VARCHAR (255)	Name of business if property is owned commercially
OWNVEST_CD	Owner Vesting Code	VARCHAR (5)	Code indicating ownership terms. Identifies how the assessee took title (vesting) or describing the type of entity (by ID) based on conversion. Refer to the Field Value Key tab of Property Attributes Assessment Product Data Schema.xlsx for more information. Present when available.
TAX BILL (OWNER MAILING) ADDRESS INFORMATION
TAX_ADDR	Tax Bill First Line Address	VARCHAR (80)	Formatted first line of the address to which the tax bill is sent
TAX_ADD_NUMBER	Tax Bill House Number	VARCHAR (13)	House number
TAX_PREDIR	Tax Bill Street Pre-directional	VARCHAR (2)	Street directional prefix (N, S, E, W, etc.)
TAX_STREETNAME	Tax Bill Street Name	VARCHAR (60)	Street name. May also be a post office (PO) box number, rural route (RR) number, or highway contract (HC) box number.
TAX_STRTYPE	Tax Bill Street Type	VARCHAR (40)	Street suffix (ST, AVE, PL, BLVD, etc.)
TAX_POSTDIR	Tax Bill Street Post-directional	VARCHAR (2)	Street directional extension (N, S, E, W, etc.)
TAX_UNIT_DES	Tax Bill Unit Type	VARCHAR (4)	Unit designator (apt, unit, etc.)
TAX_UNIT_NUM	Tax Bill Unit Number	VARCHAR (15)	Unit number
TAX_CITY	Tax Bill City	VARCHAR (30)	City name
TAX_STATE	Tax Bill State	VARCHAR (2)	State abbreviation
TAX_ZIPCODE	Tax Bill Zip	VARCHAR (7)	ZIP Code
TAX_PLUS4	Tax Bill Plus4 Zip	VARCHAR (4)	ZIP+4 extension
PROPERTY (SITUS) ADDRESS INFORMATION
ADDRESS	Property First Line Address	VARCHAR (80)	Formatted first line of the property's physical address
ADD_NUMBER	Property House Number	VARCHAR (13)	House number
PREDIR	Property Street Pre-directional	VARCHAR (2)	Street directional prefix (N, S, E, W, etc.)
STREETNAME	Property Street Name	VARCHAR (60)	Street name
STRTYPE	Property Street Type	VARCHAR (15)	Street suffix (ST, AVE, PL, BLVD, etc.)
POSTDIR	Property Street Post-directional	VARCHAR (2)	Street directional extension (N, S, E, W, etc.)
UNIT_DES	Property Unit Type	VARCHAR (4)	Unit designator (apt, unit, etc.)
UNIT_NUM	Property Unit Number	VARCHAR (15)	Unit number
CITY	Property City	VARCHAR (30)	City name
STATE	Property State	VARCHAR (2)	State abbreviation
ZIPCODE	Property Zip	VARCHAR (5)	ZIP Code
PLUS4	Property Plus4 Zip	VARCHAR (4)	ZIP+4 extension
VACANT	Property USPS Vacancy	VARCHAR (1)	Indicates whether the physical address has been determined to be vacant by the USPS: Y -Vacant N - Not vacant U - Unknown
PROP_CAT	Property Category	VARCHAR (1)	Property type classification derived from standardized land use code: R – Residential C – Commercial V - Vacant X – Other
PROP_ABS_OWN_CD	Absentee Owner Code	VARCHAR (1)	Absentee owner indicator code: A - Absentee B - Probable owner-occupied property O - Owner-occupied
PHYSICAL PROPERTY INFORMATION
PROP_APN	Property APN	VARCHAR (45)	Formatted assessor's parcel number (APN) or parcel identification number - an identifier assigned by the assessing agency to simplify the identification of parcels. APN formatting and composition vary by agency, but the APN is usually composed of map-book, page, and parcel numbers. Some jurisdictions use section-township-range values as part of the APN.
OLD_APN	Old APN	VARCHAR (31)	APN used previously to identify the property, or an alternate APN, if available. Since this field provides a way to tie parcel information back to old APNs, the old APN will supersede an alternate APN. This field is populated for a period of no more than five years from the time an assessing agency changes its parcel numbering system.
ALT_OLD_APN_IND	Alt/Old APN Indicator	VARCHAR (20)	Indicates whether the value in OLD_APN is an old or alternate APN. 1 - Alternate APN 2 - Old APN 3 - Parent 4 - Subdivision-Split When an APN described one parcel in the previous year and that parcel has since been split into multiple parcels, the parcels in the current edition of the product with the single parcel number from the previous year and this field will be populated with a value of Subdivision-Split.
PROP_APNSEQNBR	Property APN Sequence Number	VARCHAR (3)	Sequence number assigned to ensure the uniqueness of each APN. Parcels with the same APN can have different owners, addresses, or land use. A sequence number (e.g., 10132021A seq 001) is added to differentiate parcels having the same APN.
FIPSCD	FIPS Code	VARCHAR (5)	Combination of state FIPS code (first two digits) and county FIPS code (last 3 digits)
PROP_CENSUSTRACT	Census Tract	VARCHAR (16)	Combination of Census Tract, Census Block, and Census Block Suffix codes
PROP_ZONING	Zoning Code	VARCHAR (25)	County or local zoning code
PROP_ST_LANDUSE	Standardized Land Use Code	VARCHAR (4)	Standardized land use code. Refer to Field Value Key tab of Property Attributes Assessment Data Schema worksheet for more information. Note: A code of 1999 is based on the following criteria: Land use in the source file is generally indicated as residential. Some jurisdictions may classify residential lots as residential properties. Improvement value is greater than zero. The property is owner-occupied or contains a homeowner exemption. If there is no land use designation, BEDROOM and BATH fields are populated.
PROP_LU_DESC	County Land-Use Description	VARCHAR (45)	Land use description taken directly from the source file, edited to include user-friendly terminology without the loss of any regional or local references.
PROP_LU_CODE	County Land-Use Code	VARCHAR (8)	This field contains the land use code used by the county for land use classification. These codes are usually numeric, but sometimes they are alphanumeric.
LAT	Latitude	FLOAT	Parcel Latitude (DECIMAL value)
LON	Longitude	FLOAT	Parcel Longitude (DECIMAL value)
LOC_CODE	Location Code	VARCHAR (4)	Location match code from Precisely Spectrum Geocoding.
PROPERTY LEGAL DESCRIPTION
LEGAL_MAPREF	Legal: Assessor's Map Ref	VARCHAR (15)	Map number assigned by assessing agency. May or may not match APN or legal map references.
LEGAL_ASSDESC	Legal: Assessor Description	VARCHAR (125)	Narrative property description exactly as it appears in source file
LEGAL_BRIEFDESC	Legal: Full Brief Description	VARCHAR (400)	Compilation of all legal description components
LEGAL_LOT	Legal: Lot Code	VARCHAR (2)	Identifies properties that include more than one lot or partial lots: M - More than one lot MP - Multiple lots with a portion of one or more lots P - Portion of a lot
LEGAL_LOTNUM	Legal: Lot Number	VARCHAR (7)	Lot numbers of the individual lot(s) comprising the property or the actual lot number(s) of a tract or subdivision. If the property is made up of multiple lots, field will contain as many numbers as allowed by field length, separated by either commas ( , ) or ampersands ( & ). Refer to LEGAL_LOT field above.
LEGAL_LNDLOT	Legal: Land Lot	VARCHAR (10)	Tract or portion of land in which the property is located. May encompass multiple individual lots or blocks.
LEGAL_TCTNUM	Legal: Tract Number	VARCHAR (10)	The number of the tract in which the property is located
LEGAL_BLK	Legal: Block	VARCHAR (7)	The block of the subdivision or city in which the property is located
LEGAL_SEC	Legal: Section	VARCHAR (7)	Section of the city in which the property is located. Note: Not the same as Section in Section-Township-Range (see LEGAL_SECTWPRANMER field).
LEGAL_DIS	Legal: District	VARCHAR (12)	District in which the property is located. Usually a numeric code corresponding to the literal name in LEGAL_TWPMUNI field.
LEGAL_UNIT	Legal: Unit	VARCHAR (6)	Subdivision unit number, common for condominiums, townhomes, etc. Not necessarily the same as UNIT_NUM.
LEGAL_PHASE	Legal: Phase Number	VARCHAR (7)	Phase number of a subdivision or tract development
LEGAL_SUB	Legal: Subdivision Name	VARCHAR (40)	The name of the subdivision, plat, or tract in which the property is located
LEGAL_TWPMUNI	Legal: City, Township, Municipality	VARCHAR (30)	Jurisdiction in which the property is located. Value may be Unincorporated if applicable. Provides a description of the code found in the LEGAL_DIS field. Not necessarily the same as CITY value.
LEGAL_SECTWPRANMER	Legal: Section/Township/ Range/Meridian	VARCHAR (30)	Value format: SEC ## TWN ##D RNGD, where D is a directional (N/S for TWN and E/W for RNG)
PROPERTY CHARACTERISTIC ATTRIBUTES
PROP_ACRES	Property Acres	FLOAT	Total land area in acres
PROP_SQFT	Property Square Footage	FLOAT	Total land area in square feet
PROP_FRONTFT	Property Frontage Footage	FLOAT	Frontage - length of the street-facing portion of the property, in feet. Populated when provided by the jurisdiction.
PROP_DEPTHFT	Property Depth Footage	FLOAT	Length between the front and back of the property, in feet. Populated when provided by the jurisdiction.
BLDG_VIEW	Building View	VARCHAR (3)	Code indicating view from building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PROP_INFL	Site Influence	VARCHAR (3)	Code(s) identifying features or location characteristics that might influence the value or desirability of a parcel (e.g. waterfront location, traffic patterns, etc.). This field can contain up to two values. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_YRBLD	Year Built	VARCHAR (4)	Year the primary structure on the property was built
BLDG_EFFYRBLD	Effective Year Built	VARCHAR (4)	The first year in which the building was assessed with its current components. If, for example, a building was constructed in 1960 and added to in 1974, BLDG_YRBLD would be 1960 and BLDG_EFFYRBLD would be 1974.
BLDG_NAME	Condo Project or Building Name	VARCHAR (20)	Building or complex name
BLDG_COUNT	Building Count	INT	Total number of buildings or structures on a single parcel, as reported in assessment roll. Note: When a multi-record condition exists, this field will reflect the number of improvement records in the source file.
BLDG_SQFT	Main Building Square Footage	INT	Area of the primary structure on the property. When multiple building areas for a structure are provided, the preferred value of this field is living area for residential structures and total area for all other structures.
BLDG_SQFT_CODE	Main Building Square Footage Code	VARCHAR (2)	Code indicating the source used to populate the BLDG_SQFT field. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_STYLE	Building Style	VARCHAR (3)	Type of building style (e.g., Colonial, Cape Code, Bungalow). Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_STORIES	Building Stories Count	VARCHAR(10)	Actual number of stories in structure or code indicating number of stories (refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.). Note: A number followed by a plus sign ( + ) indicates either a fractional story less than 1/2 (i.e., 2+) or an attic/basement combination (2+AB).
BLDG_UNITNBR	Building Unit Number	VARCHAR (10)	Number of units reported in the assessment roll. Primarily used for apartment buildings.
BLDG_QLTY	Building Quality	VARCHAR (2)	Building quality code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_TYPE	Building Type	VARCHAR (3)	Primary building type code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook..
BLDG_IMPCD	Building Improvement Type	VARCHAR (3)	Primary improvement type code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_MOBHOME	Mobile Home	VARCHAR (1)	Indicates whether the property is a mobile home: Y - Yes N - No
BLDG_COND	Building Condition	VARCHAR (3)	Code indicating the physical condition of the building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_CNSTR	Building Construction	VARCHAR (3)	Code indicating primary construction method. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_EXTNW	Exterior Walls	VARCHAR (3)	Code indicating type or finish of exterior walls. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOF_FRAME	Roofing Frame Type	VARCHAR (3)	Code indicating type of roof framing used in structure. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOF_COVER	Roof Cover	VARCHAR (3)	Code indicating type of roof covering used on the primary improvement on the property. Note: This information is not always available in the source file. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOF_SHAPE	Roof Shape	VARCHAR (2)	Code indicating architectural style of roof. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
LIVINGSQFT	Living Area	INT	Area of a building that is used for general habitation. This is typically the area of a building that is heated or air conditioned and does not include garage, porch or basement square footage.
GROSSSQFT	Gross Area	INT	Square footage for the entire building
ADJGROSSSQFT	Gross Adjusted Area	INT	Square footage used by the local assessing authority to determine improvement value. This figure is typically 100 percent of the living area, plus lower percentage of non-living area.
BLDG_AREA1	Building Area 1	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND1	Building Area 1 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA2	Building Area 2	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND2	Building Area 2 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA3	Building Area 3	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND3	Building Area 3 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA4	Building Area 4	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND4	Building Area 4 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA5	Building Area 5	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND5	Building Area 5 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA6	Building Area 6	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND6	Building Area 6 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA7	Building Area 7	INT	Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND7	Building Area 7 Indicator	VARCHAR (2)	Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BSMT_TYPE	Basement Type	VARCHAR (3)	Code indicating type of basement. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BSMTSQFT	Basement Square Footage	INT	Total square footage of basement, including finished and unfinished areas
BLDG_FND	Foundation Type	VARCHAR (3)	Code indicating type of foundation. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_CLASS	Building Class	VARCHAR (1)	Fire insurance building classification code used for commercial/industrial buildings. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
INT_WALL	Interior Walls	VARCHAR (1)	Code indicating composition of Interior walls. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
FLOOR_TYPE	Flooring Type	VARCHAR (3)	Code indicating type of floor construction. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOM_CT	Total Room Count	INT	Total number of rooms in the primary building
BEDRM_CT	Bedroom Count	INT	Total number of bedrooms (with closets) in the primary building
ROOM_OTHER	Other Rooms	VARCHAR (5)	Code(s) describing rooms in the house or main building, if provided by assessing jurisdiction. Up to 5 codes may be present per parcel. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BATH_CT	Number of Baths	FLOAT	Number of bathrooms, including partial baths
BATHPAR_CT	Number of Partial Baths	INT	If the assessing agency provides separate fields for full and partial baths, the number of full baths will be listed in the BATH_CT field and the number of partial baths in this field.
BATHFIX_CT	Count of Bath Fixtures	INT	Total number of bathroom fixtures - sinks, toilets, bathtubs, and shower heads
PLUMBFIX_CT	Count of Plumbing Fixtures	VARCHAR (3)	Number of plumbing features in the primary building or improvement as reported by the assessing agency
COOL_TYPE	Cooling Type	VARCHAR (3)	Code indicating the type of air conditioning used in the building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PROP_FRPL	Fireplace	VARCHAR (1)	Actual number of fireplaces. Value of Y indicates only that a fireplace or fireplaces is/are present.
PROP_FRPLTYPE	Fireplace Type	VARCHAR (3)	Code indicating the type of fireplace(s) in the building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PROP_GAR	Garage Type	VARCHAR (3)	Code indicating type of garage or carport. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PRKG_SQFT	Parking Square Footage	INT	Total square footage of primary garage or parking area, including both finished and unfinished areas.
PRKG_SPACES	Parking Capacity	INT	Total number of parking spaces or car capacity of the garage or parking area
POOL	Pool	VARCHAR (1)	Indicates if pool is present
POOL_TYPE	Pool Type	VARCHAR (3)	Code indicating type of pool construction and amenities. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
HEAT_TYPE	Heating Type	VARCHAR (3)	Code indicating type of heating system. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ENERGY_TYPE	Energy Type	VARCHAR (3)	Code indicating type of electrical service in building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
FUEL_TYPE	Fuel Type	VARCHAR (3)	Code indicating type of heating fuel used. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
SEWER_TYPE	Sewer Type	VARCHAR (20)	Type of waste disposal/sewage system: 1 - None 2 - Public 3 - Cesspool 4 - Septic 5 - Private 6 - Storm 7 - Commercial 8 - Yes
WATER_TYPE	Water Type	VARCHAR (20)	Water system type: None Cistern Commercial Private Public Public Well Spring-Creek Well Yes
ELEVATOR	Elevator	VARCHAR (1)	Indicates presence or number of elevators
AMENITIES	Amenities	VARCHAR (5)	Identifies the extra selling features that add to the value of property, such as a tennis court or golf course. This data is provided by the jurisdiction, but typically does not indicate the size of the amenity. This field can contain up to five codes. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_OTHER1	Other Improvement Building Indicator 1	VARCHAR (2)	Code describing buildings not attached to the main building or house, and other improvements. Refer to Field Value Key 'Other Impr Building Indicator 1-5' for codes. When provided by the jurisdiction, size or area of buildings/improvements is listed in BLDG_OTHER1_AREA#
BLDG_OTHER1_AREA	Other Improvement Building Area 1	VARCHAR (9)	Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER2	Other Improvement Building Indicator 2	VARCHAR (2)	See description for Other Improvement Building Indicator 1
BLDG_OTHER2_AREA	Other Improvement Building Area 2	VARCHAR (9)	Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER3	Other Improvement Building Indicator 3	VARCHAR (2)	See description for Other Improvement Building Indicator 1
BLDG_OTHER3_AREA	Other Improvement Building Area 3	VARCHAR (9)	Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER4	Other Improvement Building Indicator 4	VARCHAR (2)	See description for Other Improvement Building Indicator 1
BLDG_OTHER4_AREA	Other Improvement Building Area 4	VARCHAR (9)	Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER5	Other Improvement Building Indicator 5	VARCHAR (2)	See description for Other Improvement Building Indicator 1
BLDG_OTHER5_AREA	Other Improvement Building Area 5	VARCHAR (9)	Area or measurement of buildings/improvements described in BLDG_OTHER#
EXT_FEAT1	Extra Features 1 Indicator	VARCHAR (2)	Code identifying an exterior feature that potentially adds value to the property but is not a building or attribute described in the BLDG_OTHER# fields. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook. Note: It is possible for this field to be populated without the associated EXT_FEAT#_AREA having a value.
EXT_FEAT1_AREA	Extra Features 1 Area	VARCHAR (9)	Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
EXT_FEAT2	Extra Features 2 Indicator	VARCHAR (2)	See description for Extra Features 1-4 Indicator
EXT_FEAT2_AREA	Extra Features 2 Area	VARCHAR (9)	Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
EXT_FEAT3	Extra Features 3 Indicator	VARCHAR (2)	See description for Extra Features 1-4 Indicator
EXT_FEAT3_AREA	Extra Features 3 Area	VARCHAR (9)	Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
EXT_FEAT4	Extra Features 4 Indicator	VARCHAR (2)	See description for Extra Features 1-4 Indicator
EXT_FEAT4_AREA	Extra Features 4 Area	VARCHAR (9)	Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
PROP_LASTUPDATE	Record Last Update	VARCHAR (8)	Date on which property information was last updated
PROPERTY TAX ASSESSMENT INFORMATION
TAX_ACCT_NUM	Tax Account Number	VARCHAR (30)	Arbitrary parcel identifier, assigned by the assessing agency for tax purposes. Present when provided in assessment file.
TAPE_CUT_DATE	Assessment Source File Date ("Tape Cut")	VARCHAR (10)	Date (YYYYMMDD format) on which the assessment file was generated or on which it was received by the vendor
REC_DATE	Recording Date from Assessment	VARCHAR (8)	Date (YYYYMMDD format) of the most recent sale as listed in assessment records, if available, otherwise the date on which the property was sold to the current owner
DOC_TYPE	Document Type from Assessment	VARCHAR (25)	Code describing the type of document listed in tax/assessment records as being used to transfer the property during the most recent sale (if available). Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
SALE_AMT	Sales Price from Assessment	BIGINT	Most recent sale price of the parcel (if available), expressed in whole dollars. Availability varies by jurisdiction.
SALE_CD	Sales Price Code from Assessment	VARCHAR (2)	Sales price code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
REC_BK_NUM	Recorder's Book Number from Assessment	VARCHAR (10)	If available, the book or folio number assigned to the most recent sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
REC_PG_NUM	Recorder's Page Number from Assessment	VARCHAR (10)	If available, the page number assigned to the most recent sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
REC_DOC_NUM	Recorder's Document Number from Assessment	VARCHAR (20)	Sequential number assigned to property transfer documents at the time of sale.
PRIOR_SALE_REC_DATE	Prior Sale Date	VARCHAR (8)	If available, date of sale (YYYYMMDD format) to previous owner, as recorded in assessment records
PRIOR_SALE_DOC_TYPE	Prior Sale - Document Type Code	VARCHAR (2)	Sale price code for previous transfer. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PRIOR_SALE_AMT	Prior Sales Price	BIGINT	If available, sale price of previous transfer as listed in assessment records
PRIOR_SALE_CD	Prior Sales Price Code	VARCHAR (2)	Price code for previous sale price. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PRIOR_SALE_BK_NUM	Prior Sale - Book Number	VARCHAR (10)	If available, the book or folio number assigned to the previous sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
PRIOR_SALE_PG_NUM	Prior Sale - Page Number	VARCHAR (10)	If available, the page number assigned to the previous sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
PRIOR_SALE_DOC_NUM	Prior Sale - Document Number	VARCHAR (20)	Sequential number assigned to property transfer documents at the time of previous transfer.
TAX_AMT	Tax Amount	DECIMAL(11,2)	The amount of property tax for which the taxpayer was billed for the tax year, expressed in dollars and cents. Note: In some states, tax amounts are not available at the time that tax rolls are certified. Decisions to wait for tax amounts are made on a county-by-county basis. In cases where gross and net tax amounts are provided, net tax takes precedence over gross tax.
TAX_YR	Tax Year	VARCHAR (4)	Year in which the amount in TAX_AMT field was levied.
TAX_DEL_YR	Tax Delinquent Year	VARCHAR (4)	Year in which any unpaid property taxes became delinquent
ASSESS_YR	Assessment Year	VARCHAR (4)	Year for which values in Assessed Value fields (below) are calculated. If a fiscal year (e.g. 2020-2021), only the starting year of the range is listed.
ASSED_VAL	Total Assessed Value	BIGINT	The total assessed value of the property's land and improvement values as provided by the county or local tax/assessment authority.
ASSED_LANDVAL	Land Assessed Value	BIGINT	The assessed land values as provided by the county or local tax/assessment authority.
ASSED_IMPVAL	Improve Assessed Value	BIGINT	The assessed improvement values as provided by the county or local tax/assessment authority.
MRKETVAL_YR	Market Value Year	VARCHAR (4)	The year the Market Values fields were established. Normally, this is a constant year for all records with a market value > zero, although there are cases where the county file contains the year each parcel was physically appraised and in such cases we move the Market Value year specific to each parcel resulting in several different values per county.
MRKTVAL_TOTAL	Total Market Value	BIGINT	Total market value of the property's land and improvement values as provided by the county or local tax/assessment authority.
MRKTVAL_LAND	Land Market Value	BIGINT	Market land values as provided by the county or local tax/assessment authority.
MRKTVAL_IMP	Improve Market Value	BIGINT	Market improvement values as provided by the county or local tax/assessment authority.
APPRAISED_VAL	Total Appraised Value	BIGINT	Total appraised value of land and improvements, as provided by the county or local tax/assessment authority.
APPRAISED_VAL_LAND	Land Appraised Value	BIGINT	The appraised land values as provided by the county or local tax/assessment authority.
APPRAISED_VAL_IMP	Improve Appraised Value	BIGINT	The appraised improvement values as provided by the county or local tax/assessment authority.
REPLACE_CALC	Replacement Cost	BIGINT	Replacement cost as calculated for insurance purposes.
TAX_EXEMPT_CODE	Tax Exemption Codes	VARCHAR (4)	Property tax exemption code(s) (maximum 4). Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
CA_EXEMPT	California Homeowner's Exemption	VARCHAR (1)	Indicates if a California homeowner's exemption applies to the property. Note: This is not the same as a homestead tax exemption.
TAXRATE_CODE	Tax Rate Code Area	VARCHAR (18)	Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll.
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.

Property Attributes Assessment Data Schema - 23.1

spectrum-inline