SmartFabric EFS Schema Notes

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

The Assessment layer does not contain every variable found in the standard data model.

Certain variables have been removed from the schema to ensure optimal performance when querying and streaming large volumes of Assessment data. This spreadsheet lists all variables found in SmartFabric EFS as of March 2023.

Future versions of SmartFabric EFS may include some amount of these variables.

Note:
This is the variable list; variable descriptions can be found in the SmartFabric schema documents.

March 2023 Release

Downloadable PDF Table

	Field Names
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

Was this article helpful?

What's Next

LightBox API Documentation