S LocationData table: Difference between revisions

(6 intermediate revisions by the same user not shown)

Line 1:

The '''s_LocationData''' table in [[CCMDB.accdb]] contains the possible values for the metadata for locations. See [[Location metadata storage]].

{{DISPLAYTITLE:s_LocationData table}}The '''s_LocationData''' table in [[CCMDB.accdb]] contains the possible values for the metadata for locations. See [[Location metadata storage]].

== Data Structure ==

Line 10:

|| '''location_name''' || text || unique ID, name of the location in [[s_dispo table]] and [[Boarding Loc]] and on this wiki

|-

|| '''~~attribute~~''' || text || name of the attribute, e.g. "bed count"

|| '''attribute_name''' || text || name of the attribute, e.g. "bed count"; there should be a wiki page for each of these to explain how they are used and how they tie into queries and reports

|-

|| '''~~value~~''' || text || value of the attribute, e.g. "15" in case of bed number

|| '''attribute_value''' || text || value of the attribute, e.g. "15" in case of bed number

|-

|| '''Start_DtTm''' || date || when this location-attribute-value combination becomes active

Line 23:

| who = Tina

| question = locationData

* No longer applicable, we discussed today that we will need multiple start and end dates and that it maybe should be stored on wiki.

---

* _dev_CCMDB - the process to import from wiki should run a consistency check on the start and end dates to ensure there is no overlap of same attribute

* _dev_CFE - include this in the import of s_ tables at startup; there was a second s_ table to pull into CFE, emailed Julie for which one

Line 32:

Line 34:

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: S dispo table | *]]

[[Category:S dispo table | *]]

[[Category: Location Information | *]]

[[Category:Location Information | *]]

@@ Line 1: / Line 1: @@
-The '''s_LocationData''' table in [[CCMDB.accdb]] contains the possible values for the metadata for locations. See [[Location metadata storage]].
+{{DISPLAYTITLE:s_LocationData table}}The '''s_LocationData''' table in [[CCMDB.accdb]] contains the possible values for the metadata for locations. See [[Location metadata storage]].
 == Data Structure ==
@@ Line 10: / Line 10: @@
 || '''location_name''' || text || unique ID, name of the location in [[s_dispo table]] and [[Boarding Loc]] and on this wiki
 |-
-|| '''attribute''' || text || name of the attribute, e.g. "bed count"
+|| '''attribute_name''' || text || name of the attribute, e.g. "bed count"; there should be a wiki page for each of these to explain how they are used and how they tie into queries and reports
 |-
-|| '''value''' || text || value of the attribute, e.g. "15" in case of bed number
+|| '''attribute_value''' || text || value of the attribute, e.g. "15" in case of bed number
 |-
 || '''Start_DtTm''' || date || when this location-attribute-value combination becomes active
@@ Line 23: / Line 23: @@
   | who = Tina
   | question = locationData
+* No longer applicable, we discussed today that we will need multiple start and end dates and that it maybe should be stored on wiki.
+---
 * _dev_CCMDB - the process to import from wiki should run a consistency check on the start and end dates to ensure there is no overlap of same attribute
 * _dev_CFE - include this in the import of s_ tables at startup; there was a second s_ table to pull into CFE, emailed Julie for which one
@@ Line 32: / Line 34: @@
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: S dispo table | *]]
+[[Category:S dispo table | *]]
-[[Category: Location Information | *]]
+[[Category:Location Information | *]]