SmartFabric EFS Schema Notes

ASSESSMENT_LID

LAND_LOT

BUILDING_CONDITION

FIPS_CODE

DISTRICT

BUILDING_CONDITION_DESC

UNIQUE_PARCEL_APN

LEGAL_UNIT

WATER

PARCEL_APN

PHASE_NBR

WATER_CODE_DESC

COUNTY

ASSR_MAP_REF

SEWER

TAXAPN

CITY_SECTION

SEWER_DESC

ALTERNATE_TAXAPN

LEGAL_FULL

BUILDING_AREA_INDICATOR

ALTERNATE_TAXAPN_INDICATOR

LEGAL_SEC_TWP_RNG

BUILDING_AREA_INDICATOR_DESC

ALTERNATE_TAXAPN_INDICATOR_DESC

ZONING

MULTI_TAXAPN_FLAG

SITE_ADDR

TOWNSHIP

LAST_MARKET_SALE_DOC_TYPE_DESC

SITE_CITY

RANGE

LAST_MARKET_SALE_DOC_TYPE

SITE_STATE

SECTION

LAST_MARKET_SALE_TRAN_TYPE

SITE_ZIP

TAX_RATE_CODE_AREA

LAST_MARKET_SALE_TRAN_TYPE_DESC

SITE_PLUS_4

TAX_ACCT_NBR

LAST_MARKET_SALE_VAL_TRANSFER

CENSUS_TRACT

TAX_YEAR

LAST_MARKET_SALE_SALE_CODE

CENSUS_BLOCK_GROUP

TAX_AMOUNT

LAST_MARKET_SALE_SALE_CODE_DESC

CENSUS_BLOCK

TAX_EXEMPT_CODES

LAST_MARKET_SALE_FULL_PART_CODE

CBSA_CODE

TAX_EXEMPT_CODES_DESC

LAST_MARKET_SALE_DOC_NUMBER

MUNICIPALITY

YR_BLT

LAST_MARKET_SALE_SOURCE_CODE

MSA_CODE

YR_BLT_EFFECT

LAST_MARKET_SALE_DATE_TRANSFER

MSA_CODE_DESC

BLDG_NUMBER

LAST_MARKET_SALE_BOOK

OWNER_OCCUPIED

BUILDING_SQFT

LAST_MARKET_SALE_PAGE

OWNER_NAME

BSMT_1_CODE

LAST_MARKET_SALE_SELLER_NAME

OWNER_NAME_1

BASEMENT_FINISH_DESC

LAST_MARKET_SALE_SELLER_1_FIRST_MID

OWNER_NAME_2

ELECT_AVAIL_CODE

LAST_MARKET_SALE_SELLER_1_LAST

OWNERSHIP_STATUS_CODE

ELECT_AVAIL_CODE_DESC

LAST_MARKET_SALE_SELLER_1_CODE

OWNERSHIP_STATUS_DESC

BEDROOMS

LAST_MARKET_SALE_SELLER_1_CODE_DESC

COMPANY_FLAG

TOTAL_ROOMS

LAST_MARKET_SALE_SELLER_2_FIRST_MID

MAIL_CITY

TOTAL_BATHS_CALCULATED

LAST_MARKET_SALE_SELLER_2_LAST

MAIL_STATE

TOTAL_BATHS

LAST_MARKET_SALE_BUYER_NAME

MAIL_ZIP

PARTIAL_BATHS

LAST_MARKET_SALE_BUYER_1_FIRST_MID

MAIL_PLUS_4

AIR_CONDITIONING

LAST_MARKET_SALE_BUYER_1_LAST

MAIL_ADDR

AIR_CONDITIONING_TYPE_DESC

LAST_MARKET_SALE_BUYER_1_CODE

USE_CODE_MUNI

CONSTRUCTION_CODE

LAST_MARKET_SALE_BUYER_1_CODE_DESC

USE_CODE_MUNI_DESC

CONSTRUCTION_CODE_DESC

LAST_MARKET_SALE_BUYER_2_FIRST_MID

USE_CODE_STD_LPS

EXTERIOR_WALL_TYPE

LAST_MARKET_SALE_BUYER_2_LAST

USE_CODE_STD_DESC_LPS

EXTERIOR_WALL_DESC

LAST_MARKET_SALE_BUYER_2_CODE

USE_CODE_STD_CTGR_DESC_LPS

FIREPLACE_TYPE

LAST_MARKET_SALE_BUYER_2_CODE_DESC

USE_CODE_STD_CTGR_LPS

FOUNDATION_TYPE

LAST_MARKET_SALE_RCDRS_MAP_REF

STATE_LAND_USE_CODE

FOUNDATION_TYPE_DESC

LAST_MARKET_SALE_LOAN_DUE_DATE

STATE_LAND_USE_CODE_DESC

GARAGE_CARPORT_TYPE

LAST_MARKET_SALE_BUYER_VESTING_CODE

LOT_WIDTH

GARAGE_CODE_DESC

LAST_MARKET_SALE_BUYER_VESTING_CODE_DESC

LOT_DEPTH

HEATING_TYPE

LAST_MARKET_SALE_ORIGINAL_SALE_DATE

ACREAGE

HEATING_DESC

GEOMETRY_SOURCE

LAND_SQFT

PARKING_SPACES

GEOMETRY

ASSR_ACREAGE

POOL_INDICATOR

BLDG_AREA_1_DESC

ASSR_SQFT

POOL_INDICATOR_DESC

BLDG_AREA_1

CAL_ACREAGE

ROOF_COVER_TYPE

BLDG_AREA_1_INDICATOR

CAL_SQFT

ROOF_COVER_DESC

BLDG_AREA_2_DESC

LOT_SIZE_AREA

STORIES_NUMBER

BLDG_AREA_2

LOT_SIZE_AREA_UNIT

STORIES_NUMBER_DESC

BLDG_AREA_2_INDICATOR

LOT_SIZE_AREA_ORGN

STYLE_TYPE

BLDG_AREA_3_DESC

TOPOGRAPHY

STYLE_DESC

BLDG_AREA_3

TOPOGRAPHY_DESC

UNITS_NUMBER

BLDG_AREA_3_INDICATOR

AVM_VALUE

BLDG_CLASS

BLDG_AREA_4_DESC

VAL_ASSD

BLDG_CLASS_DESC

BLDG_AREA_4

VAL_ASSD_LAND

BUILDING_QUALITY

BLDG_AREA_4_INDICATOR

VAL_ASSD_IMPRV

FLOOR_COVER

BLDG_AREA_5_DESC

VAL_MARKET

FLOOR_COVER_DESC

BLDG_AREA_5

DATE_CERT

PLUMBING_FIXTURES

BLDG_AREA_5_INDICATOR

VAL_MRKT_LAND

HEATING_FUEL_TYPE

BLDG_AREA_6_DESC

VAL_MRKT_IMPRV

HEATING_FUEL_TYPE_DESC

BLDG_AREA_6

YR_MRKT_VAL

AIR_CONDITIONING_TYPE

BLDG_AREA_6_INDICATOR

DATE_ASSR_TAPE_CUT

AIR_CONDITIONING_DESC

BLDG_AREA_7_DESC

BLOCK_NUMBER

INTERIOR_WALLS

BLDG_AREA_7

LOT_NUMBER

INTERIOR_WALLS_DESC

BLDG_AREA_7_INDICATOR

SUBDIVISION

SITE_INFLUENCE

TRACT_NUMBER

SITE_INFLUENCE_DESCRIPTION

LEGAL_1

ROOF_TYPE

LOT_CODE

ROOF_TYPE_DESC