s_locations_allowed_collection table

Legacy Content

This page contains Legacy Content.

• Explanation: Table s_locations_allowed_collection table was a table used to restrict which Service/Locations should be available on a laptop based on work allocation. It became irrelevant when we stopped allocating by unit, and was finally removed 2023-11-03 as part of Change to having each collector collect both programs on the same laptop.
• Successor: Query s_serviceLocation_local

Expand

Click Expand to show legacy content.

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:

• ServiceLocation - linked to s_dispo
• Laptop_identifier - to declare on which laptop this will shwo
• sort - sort order on that laptop, lowest number will be first.

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