Data dictionary: Difference between revisions
No edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
== Registry == | == Registry == | ||
In the collection tool [[CCMDB. | 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]] === | === [[L_PHI table]] === | ||
| Line 31: | Line 31: | ||
== APACHE == | == APACHE == | ||
Apache has physiological components and diagnostic components. | 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=== | === [[L_Log table]] - physiological components=== | ||
| Line 52: | Line 55: | ||
This stores our version of [[ICD10]] (see [[ICD10 Diagnosis List]]), collected following the [[ICD10 collection]] instructions. | This stores our version of [[ICD10]] (see [[ICD10 Diagnosis List]]), collected following the [[ICD10 collection]] instructions. | ||
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_ICD10 table]] }} | {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_ICD10 table]] }} | ||
=== Charlson Comorbidities === | |||
* [[Charlson_Comorbidities_in_ICD10_codes]] | |||
=== Old dx schema === | === Old dx schema === | ||
| Line 83: | Line 89: | ||
=== DSM Data === | === DSM Data === | ||
See [[L_Labs_DSM table]] | |||
==== Elements collected via DSM ==== | ==== Elements collected via DSM ==== | ||
See [[DSM data#DSM results we store]] | |||
== Pharmacy == | == Pharmacy == | ||
| Line 102: | Line 104: | ||
== TISS28 - CC only== | == TISS28 - CC only== | ||
See [[TISS | See [[TISS Item List]] for a list of elements we collect as part of TISS. | ||
=== [[L_TISS_Form table]] === | === [[L_TISS_Form table]] === | ||
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }} | {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Form table]] }} | ||
| Line 108: | Line 110: | ||
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }} | {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L TISS Item table]] }} | ||
== Created | == Created Variables == | ||
We have some data elements we generate rather than calculate directly. | We have some data elements we generate rather than calculate directly. | ||
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[FieldCreatedRaw::Created]] }} | {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[FieldCreatedRaw::Created]] }} | ||
| Line 116: | Line 118: | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||