S locations allowed collection table

From CCMDB Wiki
Revision as of 12:30, 2017 November 8 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

Table s_locations_allowed_collection table drives what is shown in the laptops location / Service/Location field dropdown.

structure:

  • Service/Location from s_dispo
  • allowed_laptop_ward
  • allowed_laptop_hosp
  • sort - sort order on that laptop, lowest number will be first.

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