Data dictionary: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 1:

== ~~Is this it?~~ ==

== Instruction ==

~~{{Discuss | who=Tina | question=~~

* add a column for program (Critical care only or Medicine only or both).

** I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in [[Template:DataDictionaryQuery]] (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want.

*** how about adding the program as part of the sub header instead of table columns. --[[User:JMojica|JMojica]] 13:36, 2019 June 26 (CDT)

**** That I can do. Putting it on the list. Ttenbergen 13:48, 2019 July 3 (CDT)}}

On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.

Line 18:

Line 12:

== Registry ==

In the collection tool [[CCMDB.~~mdb~~]] 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.mdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.

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

Line 37:

Line 31:

== APACHE ==

Apache has physiological components and diagnostic components.

* [[APACHE Scoring table]]

* [[APACHE Acute Dxs in ICD10 codes]]

* [[APACHE Comorbidities in ICD10 codes]]

=== [[L_Log table]] - physiological components===

Line 58:

Line 55:

This stores our version of [[ICD10]] (see [[ICD10 Diagnosis List]]), collected following the [[ICD10 collection]] instructions.

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_ICD10 table]] }}

=== Charlson Comorbidities ===

* [[Charlson_Comorbidities_in_ICD10_codes]]

=== Old dx schema ===

Line 89:

=== DSM Data ===

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

See [[L_Labs_DSM table]]

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

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

== Pharmacy ==

Line 100:

Line 103:

== TISS28 ==

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

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

== Related articles ==

[[Category: Data structure]]

@@ Line 1: / Line 1: @@
-== Is this it? ==
+== Instruction ==
-{{Discuss | who=Tina | question=
-* add a column for program (Critical care only or Medicine only or both).
-** I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in [[Template:DataDictionaryQuery]] (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want.
-*** how about adding the program as part of the sub header instead  of table columns.  --[[User:JMojica|JMojica]] 13:36, 2019 June 26 (CDT)
-**** That I can do. Putting it on the list. Ttenbergen 13:48, 2019 July 3 (CDT)}}
 On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.
@@ Line 18: / Line 12: @@
 == Registry ==
-In the collection tool [[CCMDB.mdb]] 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.mdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.
 === [[L_PHI table]] ===
@@ Line 37: / Line 31: @@
 == APACHE ==
 Apache has physiological components and diagnostic components.
+* [[APACHE Scoring table]]
+* [[APACHE Acute Dxs in ICD10 codes]]
+* [[APACHE Comorbidities in ICD10 codes]]
 === [[L_Log table]] - physiological components===
@@ Line 58: / Line 55: @@
 This stores our version of [[ICD10]] (see [[ICD10 Diagnosis List]]), collected following the [[ICD10 collection]] instructions.
 {{DataDictionaryQuery | Criteria=  [[FieldName::>""]] [[InTable::L_ICD10 table]] }}
+=== Charlson Comorbidities ===
+* [[Charlson_Comorbidities_in_ICD10_codes]]
 === Old dx schema ===
@@ Line 89: / Line 89: @@
 === DSM Data ===
-{{:L Labs DSM table}}
+See [[L_Labs_DSM table]]
+==== Elements collected via DSM ====
+See [[DSM data#DSM results we store]]
 == Pharmacy ==
@@ Line 100: / Line 103: @@
 {{:L TmpV2 table}}
-== TISS28 ==
+== 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 107: / 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]] }}
+== Related articles ==
+{{Related Articles}}
 [[Category: Data structure]]