Data dictionary: Difference between revisions

(6 intermediate revisions by the same user not shown)

Line 12:

== Registry ==

In the collection tool [[CCMDB.accdb]] the registry data is all in the [[L_Log table]]. In the data processing tool [[CFE]] and the central repository [[~~Centralized data~~.~~mdb~~]] this data is split out from the other in L_Log for [[PHIA]] reasons.

In the collection tool [[CCMDB.accdb]] the registry data is all in the [[L_Log table]]. In the data processing tool [[CFE]] and the central repository [[Centralized_data.accdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.

=== [[L_PHI table]] ===

Line 89:

=== DSM Data ===

~~{{:L Labs DSM~~ table}}

See [[L_Labs_DSM table]]

==== Elements collected via DSM ====

~~{{#ask:~~ [[~~AcquiredFrom::~~DSM]]

See [[DSM data#DSM results we store]]

~~|default=none found~~

~~|format=UL~~

~~|limit=20~~

}}

== Pharmacy ==

Line 108:

Line 104:

== TISS28 - CC only==

See [[TISS ~~Items SMW~~]] for a list of elements we collect as part of TISS.

See [[TISS Item List]] for a list of elements we collect as part of TISS.

=== [[L_TISS_Form table]] ===

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }}

Line 114:

Line 110:

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }}

== Created ~~variables~~ ==

== Created Variables ==

We have some data elements we generate rather than calculate directly.

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[FieldCreatedRaw::Created]] }}

Line 122:

Line 118:

[[Category: Data structure]]

[[Category:Data structure]]

@@ Line 12: / Line 12: @@
 == Registry ==
-In the collection tool [[CCMDB.accdb]] the registry data is all in the [[L_Log table]]. In the data processing tool [[CFE]] and the central repository [[Centralized data.mdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.
+In the collection tool [[CCMDB.accdb]] the registry data is all in the [[L_Log table]]. In the data processing tool [[CFE]] and the central repository [[Centralized_data.accdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.
 === [[L_PHI table]] ===
@@ Line 89: / Line 89: @@
 === DSM Data ===
-{{:L Labs DSM table}}
+See [[L_Labs_DSM table]]
 ==== Elements collected via DSM ====
-{{#ask: [[AcquiredFrom::DSM]]
+See [[DSM data#DSM results we store]]
-|default=none found
-|format=UL
-|limit=20
-}}
 == Pharmacy ==
@@ Line 108: / Line 104: @@
 == TISS28 - CC only==
-See [[TISS Items SMW]] for a list of elements we collect as part of TISS.
+See [[TISS Item List]] for a list of elements we collect as part of TISS.
 === [[L_TISS_Form table]] ===
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }}
@@ Line 114: / Line 110: @@
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }}
-== Created variables ==
+== Created Variables ==
 We have some data elements we generate rather than calculate directly.
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[FieldCreatedRaw::Created]] }}
@@ Line 122: / Line 118: @@
-[[Category: Data structure]]
+[[Category:Data structure]]