Location metadata storage: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{ | We track locations in many fields; they are drawn from either [[s_tmp]] [[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]] 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 | |||
| todo_added = 2022-02-09 | |||
| todo_action = 2022-02-09 | |||
}} | |||
== Flexibility for values changing over time == | == Flexibility for values changing over time == | ||
| Line 10: | Line 18: | ||
== 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 == | ||