Location metadata storage: Difference between revisions
Ttenbergen (talk | contribs) m →Types of data to consider: moved data here from an email exchange with Julie |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (5 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]] [[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. | 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 | {{Todo | ||
| who =Tina | | who =Tina | ||
| question = | | question = _locationData | ||
* _Dev_CFE linking of s_LocationData table | * _Dev_CFE linking of s_LocationData table | ||
* _Dev_CCMDB - process to import data from wiki (similar to [[Converting ICD10 between wiki and ccmdb.accdb]]) | * _Dev_CCMDB - process to import data from wiki (similar to [[Converting ICD10 between wiki and ccmdb.accdb]]) | ||
| Line 9: | Line 9: | ||
* consider data import for locations so no manual pre-populating of pages | * 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 | * 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. | |||
* discussed at Task whether we should wait for Shared Health info, will make our own | * [[STB-L2HA]] is another page we will need to include when we deal with this. | ||
| todo_added = 2022-02-09 | | todo_added = 2022-02-09 | ||
| todo_action = 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 35: | Line 43: | ||
* Med numbers are not really tracked; there is an outdated list that was maintained by Trish in | * 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\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 46: | Line 55: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Location Information]] | [[Category:Location Information]] | ||