S locations allowed collection table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m sp |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (14 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Table [[ | {{DISPLAYTITLE:s_locations_allowed_collection table}} | ||
{{LegacyContent | |||
| explanation=Table [[s_locations_allowed_collection table]] was a table used to restrict which [[Service/Location]]s 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]] | |||
| content= | |||
structure: | 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: | |||
* ''' | * '''[[Service/Location | 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. | * '''sort''' - sort order on that laptop, lowest number will be first. | ||
Most of its fields are driven by dropdowns based on [[ | 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}} | |||
}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: 2016 Time and Place changes]] | [[Category: 2016 Time and Place changes]] | ||
Latest revision as of 11:47, 3 November 2023
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
Click Expand to show legacy content.