The FourOh-LLC Address Book is undergoing its second revision. The address is now separated to the following fields for the basis:
This is the Campus, Building, Floor, Suite designation. The USPS is not necessary going to deliver to the floor, one building owner might have the authority to rename the Campus, the Suite, one geo-address might hold several floors.
This is the exact name of the current tenant
The FourOh-LLC address book is now separated by the Service type - Office Furniture suppliers are separated from industrial-grade Garage Door manufacturers. The field for this is called FBST-A (Filter by Service Type, Revision A)
The values for these field are harvested from various sources:
This is not a precise process. For example, the “Overhead Door Corporation”, a “Sanwa Holdings Company”, is a manufacturer in the “garage door industry”, invented the “upward-lifting garage door”, and the “electric garage door opener”. Part of the Vocabulary used by this manufacturer is as follows:
Their top-categories for Commercial Garage Doors appear to be:
Their sub-categories for Commercial Garage Doors appear to be:
Their Commercial Door Operators appear to be:
Beyond these categories the rest of their data is Model Names, Series Names and other related grouping. In any case it seems reasonable to record but separate these categories by the manufacturer / supplier.
The Model Name maybe added to a separate field from these.
The resulting data:
|1||1||Commercial Garage Door||Sectional - Thermacore Doors|
|2||1||Commercial Garage Door||Sectional - Sectional Steel Doors|
|3||1||Commercial Garage Door||Rolling Doors - Counter Doors|
|4||1||Commercial Garage Door||High-Speed - High Speed Metal Doors|
Looking at all the categories above, a rational approach would be to merge some or all of these, so a Service Call to the Manufacturer or to their Service Provider is processed faster, with more accuracy. The questions asked are these and a few more of the same: