S locations allowed collection table

From CCMDB Wiki

Table s_locations_allowed_collection table is contains info about what should be shown in the Service/Location field dropdown. Query s_serviceLocation_local filters this depending on the the Laptop identifier in Settings (CCMBD.mdb).

Data structure:

Most of its fields are driven by dropdowns based on s_dispo table.

Removing entries

Removing entries from this table while records still exist on a laptop causes sending problems. See Service/Location field#Retiring an available Service/Location field entry.

Related articles

Related articles: