S LocationData table: Difference between revisions

(4 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 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 28:

Line 30:

| todo_action = 2022-02-10

}}

~~{{DJ |~~

* I added some sample data to this table. I will eventually add the pulling into CFE of this table to automation CFE, but if you want to test how this data would work in your queries for now, you can link it in manually and work with the sample data in there. Processes to get data in there and all that still to come. [[User:Ttenbergen|Ttenbergen]] 13:45, 2022 February 10 (CST)

}}

== Related articles ==

[[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 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 28: / Line 30: @@
 | todo_action = 2022-02-10
   }}
-{{DJ |
-* I added some sample data to this table. I will eventually add the pulling into CFE of this table to automation CFE, but if you want to test how this data would work in your queries for now, you can link it in manually and work with the sample data in there. Processes to get data in there and all that still to come. [[User:Ttenbergen|Ttenbergen]] 13:45, 2022 February 10 (CST)
-}}
 == Related articles ==
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: S dispo table | *]]
+[[Category:S dispo table | *]]
-[[Category: Location Information | *]]
+[[Category:Location Information | *]]