Data dictionary: Difference between revisions

(42 intermediate revisions by 2 users not shown)

Line 1:

~~{{Discuss | who~~=~~Julie | question~~=~~Attempt at a easier~~ to ~~follow data dictionary~~. ~~Is this what you had in mind? }}~~

== Instruction ==

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

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

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

Line 9:

Line 18:

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

== ADT ==

==== 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]] ~~- physiological components~~===

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

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

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

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

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

Line 29:

Line 47:

== ADLs - Activities of Daily Living ==

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

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

=== Med only ===

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

== Diagnoses ==

Line 35:

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 62:

Line 85:

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

[[Category: Data structure]]

[[Category:Data structure]]

@@ Line 1: / Line 1: @@
-{{Discuss | who=Julie | question=Attempt at a easier to follow data dictionary. Is this what you had in mind? }}
+== Instruction ==
-For an alphabetic listing, see [[Auto Data Dictionary]].
+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.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.accdb]] this data is split out from the other in L_Log for [[PHIA]] reasons.
 === [[L_PHI table]] ===
@@ Line 9: / Line 18: @@
 === [[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]]}}
-== ADT ==
+==== 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]] - physiological components===
+=== [[L_Log table]] ===
-{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::dispo]] }}
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::Dispo]] }}
 == 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===
-{{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 ===
@@ Line 29: / Line 47: @@
 == ADLs - Activities of Daily Living ==
 Collected according to [[ADL General Collection Information]].
-{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]][[FieldCCMDBTab::ADL]] }}
+=== Med only ===
+{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[FieldCCMDBTab::ADL]] [[DataElementProgram::Med]]}}
 == Diagnoses ==
@@ Line 35: / 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 62: / Line 85: @@
 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_TmpV2 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]]