Data dictionary: Difference between revisions

(50 intermediate revisions by 2 users not shown)

Line 1:

~~{{DT | Attempt at~~ a ~~easier to follow~~ data ~~dictionary }}~~

== Instruction ==

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

For an alphabetic listing, see [[Auto Data Dictionary]].

== Scope ==

See [[Site and Location table]] for a list of where we collect data.

See [[Total admissions ICU/Med]] for a recent count of records.

See [[Data Request Status ICU/Med]] for how many requests we have had.

== 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.accdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.

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

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

=== [[L_Log table]] - Registry ===

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[FieldCCMDBTab::~~Top Row~~]] }}

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::Med and CC]] OR [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::not entered]]}}

==== CC only ====

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::CC]]}}

== ADT - via [[EPR]] ==

Admission, discharge and transfer data

=== [[L_Log table]] ===

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Dispo]] }}

== APACHE ==

Apache has physiological components and diagnostic components. ~~See {{DT | need to link to~~ APACHE ~~dx/como info when it's ready}}~~

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

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] }}

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::Med and CC]] OR [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::not entered]] }}

==== CC only ====

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::CC]] }}

=== Diagnostic components ===

* [[APACHE Comorbidities in ICD10 codes]]

* [[APACHE Acute Dxs in ICD10 codes]]

== ADLs - Activities of Daily Living ==

Collected according to [[ADL General Collection Information]].

=== Med only ===

{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[FieldCCMDBTab::ADL]] [[DataElementProgram::Med]]}}

== Diagnoses ==

=== ICD10 - [[L_ICD10 table]] ===

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

In this schema procedures were coded together with diagnoses.

==== Diagnoses - [[L_Dxs table]] ====

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

Line 26:

Line 68:

== Procedures ==

This stores our version of [[CCI]], collected following the [[CCI Collection]] instructions.

=== [[L_CCI_Picklist table]] ===

See [[CCI Picklist]] for possible values.

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

=== [[L_CCI_Component table]] ===

See [[CCI component 1 codes - what organ was something done to]], [[CCI component 2 codes - what was done]] for possible values.

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

=== Old dx coding schema ===

In the old dx coding schema procedures were coded together with diagnoses, see [[#L_Dxs table]].

== Labs ==

=== CCI ===

~~{{DT | need~~ to ~~figure out filter~~ for labs ~~only }}~~

See [[Converting Lab Counts to CCI]] for how the labs described in [[#Pre-CCI manual collection]] are now collected in CCI.

=== Pre-CCI manual collection ===

=== Pre-CCI manual collection - CC only ===

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

=== DSM Data ===

~~{{DataDictionaryQuery | Criteria=~~ [[~~FieldName::>""~~]] [[~~InTable::L Labs~~ DSM ~~table table~~]] }}

See [[L_Labs_DSM table]]

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

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

== Pharmacy ==

=== CC only ===

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

== Temporary project data ==

See [[Projects]] for a list of current and past projects.

=== [[L_TmpV2 table]] ===

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

== TISS28 - CC only==

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

=== [[L_TISS_Item table]] ===

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

== Created Variables ==

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

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

== Related articles ==

[[Category: Data structure]]

[[Category:Data structure]]

@@ Line 1: / Line 1: @@
-{{DT | Attempt at a easier to follow data dictionary }}
+== Instruction ==
+On any of the tables below, click on the links in the left columns to find out our definitions and instructions for those fields.
+For an alphabetic listing, see [[Auto Data Dictionary]].
+== Scope ==
+See [[Site and Location table]] for a list of where we collect data.
+See [[Total admissions ICU/Med]] for a recent count of records.
+See [[Data Request Status ICU/Med]] for how many requests we have had.
 == 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.accdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.
 === [[L_PHI table]] ===
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_PHI table]]}}
 === [[L_Log table]] - Registry ===
-{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[FieldCCMDBTab::Top Row]] }}
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::Med and CC]] OR [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::not entered]]}}
+==== CC only ====
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] [[DataElementProgram::CC]]}}
+== ADT - via [[EPR]] ==
+Admission, discharge and transfer data
+=== [[L_Log table]] ===
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Dispo]] }}
 == APACHE ==
-Apache has physiological components and diagnostic components. See {{DT | need to link to APACHE dx/como info when it's ready}}
+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===
-{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] }}
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::Med and CC]] OR [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::not entered]] }}
+==== CC only ====
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Apache]] [[DataElementProgram::CC]] }}
+=== Diagnostic components ===
+* [[APACHE Comorbidities in ICD10 codes]]
+* [[APACHE Acute Dxs in ICD10 codes]]
+== ADLs - Activities of Daily Living ==
+Collected according to [[ADL General Collection Information]].
+=== Med only ===
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[FieldCCMDBTab::ADL]] [[DataElementProgram::Med]]}}
 == Diagnoses ==
 === ICD10 - [[L_ICD10 table]] ===
+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 ===
+In this schema procedures were coded together with diagnoses.
 ==== Diagnoses - [[L_Dxs table]] ====
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Dxs table]] }}
@@ Line 26: / Line 68: @@
 == Procedures ==
+This stores our version of [[CCI]], collected following the [[CCI Collection]] instructions.
 === [[L_CCI_Picklist table]] ===
+See [[CCI Picklist]]  for possible values.
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_CCI_Picklist table]] }}
 === [[L_CCI_Component table]] ===
+See [[CCI component 1 codes - what organ was something done to]], [[CCI component 2 codes - what was done]] for possible values.
 {{DataDictionaryQuery | Criteria=  [[FieldName::>""]] [[InTable::L_CCI_Component table]] }}
+=== Old dx coding schema ===
+In the old dx coding schema procedures were coded together with diagnoses, see [[#L_Dxs table]].
 == Labs ==
 === CCI ===
-{{DT | need to figure out filter for labs only }}
+See [[Converting Lab Counts to CCI]] for how the labs described in [[#Pre-CCI manual collection]] are now collected in CCI.
-=== Pre-CCI manual collection ===
+=== Pre-CCI manual collection - CC only ===
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Labs_Flowsheet table]] }}
 === DSM Data ===
-{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L Labs DSM table table]] }}
+See [[L_Labs_DSM table]]
+==== Elements collected via DSM ====
+See [[DSM data#DSM results we store]]
 == Pharmacy ==
+=== CC only ===
 {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Pharm_Flowsheet table]] }}
 == Temporary project data ==
+See [[Projects]] for a list of current and past projects.
 === [[L_TmpV2 table]] ===
-{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Pharm_Flowsheet table]] }}
+{{:L TmpV2 table}}
+== TISS28 - CC only==
+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]] }}
+=== [[L_TISS_Item table]] ===
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }}
+== 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]]
+[[Category:Data structure]]