Location metadata storage: Difference between revisions

(10 intermediate revisions by the same user not shown)

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.

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~~

| 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 ==

Line 27:

Line 38:

== Types of data to consider ==

* ~~Bed~~ numbers as in S:\WRHA\WRHA_CCMED\CCMDB_SAS_by_Julie\SASCFE\CC_data\CCBedMonth.xlsx or S:\MED\MED_CCMED\CCMDB_ADMIN_DATABASE\Bed_CountAndDates\CCBedMonth.xlsx

* 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]]

* [[STB-L2HA]] is an overflow location... do we want to designate those somehow?

Line 39:

Line 55:

[[Category: Location Information]]

[[Category:Location Information]]

@@ 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.
+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
+  | 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 ==
@@ Line 27: / Line 38: @@
 == Types of data to consider ==
-* Bed numbers as in S:\WRHA\WRHA_CCMED\CCMDB_SAS_by_Julie\SASCFE\CC_data\CCBedMonth.xlsx  or S:\MED\MED_CCMED\CCMDB_ADMIN_DATABASE\Bed_CountAndDates\CCBedMonth.xlsx
+* 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]]
 * [[STB-L2HA]] is an overflow location... do we want to designate those somehow?
@@ Line 39: / Line 55: @@
 {{Related Articles}}
-[[Category: Location Information]]
+[[Category:Location Information]]