Location metadata storage: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
We track locations in many fields; they are drawn from either [[s_tmp table]] [[Boarding Loc]] entries or from [[s_dispo table]]. We are interested in some information about some of these locations, like their [[Level of care hierarchy]] / [[s_level_of_care table]] or how many beds they have. | |||
{{Todo | |||
| who =Tina | |||
| question = _locationData | |||
* _Dev_CFE linking of s_LocationData table | |||
* _Dev_CCMDB - process to import data from wiki (similar to [[Converting ICD10 between wiki and ccmdb.accdb]]) | |||
* set up wiki template for locations | |||
* consider data import for locations so no manual pre-populating of pages | |||
* S_level_of_care needs to be integrated with whatever metadata we set up | |||
* discussed at Task whether we should wait for Shared Health info, will make our own; Shared Health's data is no better than ours, so won't do that. | |||
* [[STB-L2HA]] is another page we will need to include when we deal with this. | |||
| todo_added = 2022-02-09 | |||
| todo_action = 2022-02-09 | |||
}} | |||
{{Todo | |||
| who = Tina | |||
| todo_added = 2022-06-22 | |||
| todo_action = 2022-06-22 | |||
| question = _locationData | |||
* Discussed at JALT; we need to store this on a per page on wiki level, with multiple start and end dates being possible. Tina needs to create the structure for this and pre-populate. Probably discuss with Julie at the planning stage. [[User:Ttenbergen|Ttenbergen]] 12:04, 2022 June 22 (CDT) | |||
** It needs to be possible to access this as data. [[User:Ttenbergen|Ttenbergen]] 09:58, 2022 June 28 (CDT) | |||
}} | |||
== Flexibility for values changing over time == | == Flexibility for values changing over time == | ||
| Line 10: | Line 29: | ||
== Flexibility for what needs to be collected == | == Flexibility for what needs to be collected == | ||
There also might be information we have not even considered yet that we might need to track. So, we would want a flexible infrastructure. One way to do this would be something similar to the [https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model Entity–attribute–value model] we use for the [[s_tmp table]]. See [[s_LocationData table]] for more info. | There also might be information we have not even considered yet that we might need to track. So, we would want a flexible infrastructure. One way to do this would be something similar to the [https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model Entity–attribute–value model] we use for the [[s_tmp table]]. See [[s_LocationData table]] for more info. | ||
== How and where to keep the master data == | == How and where to keep the master data == | ||
| Line 27: | Line 38: | ||
== Types of data to consider == | == Types of data to consider == | ||
* | * CC bed numbers are in | ||
** S:\WRHA\WRHA_CCMED\CCMDB_SAS_by_Julie\SASCFE\CC_data\CCBedMonth.xlsx | |||
** S:\MED\MED_CCMED\CCMDB_ADMIN_DATABASE\Bed_CountAndDates\CCBedMonth.xlsx | |||
* Med numbers are not really tracked; there is an outdated list that was maintained by Trish in | |||
** S:\MED\MED_CCMED\CCMDB_ADMIN_DATABASE\Bed_CountAndDates\BedBaseMonthly_Medicine.xlsx | |||
** S:\MED\MED_CCMED\CCMDB_ADMIN_DATABASE\!BedBase_count_CC_Med | |||
* possibly other things: [[Collection location documentation]] / [[Site and Location table]] | * possibly other things: [[Collection location documentation]] / [[Site and Location table]] | ||
* [[STB-L2HA]] is an overflow location... do we want to designate those somehow? | * [[STB-L2HA]] is an overflow location... do we want to designate those somehow? | ||
| Line 39: | Line 55: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Location Information]] | [[Category:Location Information]] | ||