Commercial Tenant — data dictionary
Commercial tenant occupancy records. · 23 fields · source FA Commercial Tenant Data Dictionary Layout v24 20250601 (v24 · 2025-06-01).
| Field | Type | Display | Code table | Description |
|---|---|---|---|---|
| PROPERTY IDENTIFICATION INFORMATION | ||||
| FIPS | varchar(5) | Public Display | FIPS | FIPS: Federal Information Processing Standard. Five digit code. First two digits represent the STATE, while the last three digits represent the COUNTY or county equivalents. |
| PropertyID | bigint(11) | No Display | The First American Derived ID that uniquely identifies a property in the First American Database. | |
| APN | varchar(45) | No Display | 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. | |
| TENANT INFORMATION | ||||
| COMPANY NAME | varchar(60) | No Display | The name of the company. | |
| ALIAS COMPANY NAME | varchar(60) | No Display | Name of the business operating under a different legal name. | |
| ADDRESS | varchar(53) | No Display | Street Address: 123 S MAIN ST | |
| SUITE/UNIT | varchar(15) | No Display | The unit or suite number of the property address: 123 S Main St # 4 | |
| CITY | varchar(30) | No Display | The city for the property address. | |
| STATE | varchar(2) | No Display | Two letter state abbreviation for the property. | |
| ZIP-5 | varchar(5) | No Display | Five digit code assigned by the USPS: 90001-1000 | |
| ZIP+4 | varchar(4) | No Display | Four digit code assigned by the USPS: 90001-1000 | |
| CONTACT NAME | varchar(45) | No Display | Contact name of the company. | |
| CONTACT TITLE | varchar(40) | No Display | Contact title of the company. | |
| PHONE | varchar(10) | No Display | Phone number of the contact. | |
| NON-PROFIT FLAG | varchar(1) | No Display | N = NonProfit Tenant. | |
| BUSINESS START DATE | varchar(8) | No Display | Date the business was established. | |
| MOVED-IN DATE | varchar(8) | No Display | Date the business moved-in to location. | |
| TYPE OF BUSINESS | varchar(51) | No Display | Description of the type os business at this loacation. | |
| FIPS/APN MATCH TO PROP | varchar(50) | No Display | This field is blank at this time. | |
| FIPS/APN MATCH TYPE | varchar(1) | No Display | C=matched to commercial property; V=matched to residential property & verified that business is still there; R=business address matches to residential property, but active business existence there is not a certainty. | |
| LIQUOR LICENSE FLAG | varchar(1) | No Display | This field is blank at this time. | |
| UNDERGROUND FUEL TANK FLAG | varchar(1) | No Display | This field is blank at this time. | |
| NAICS | varchar(11) | No Display | Retrieved from national database based on business type, company name and source business description | |