Data dictionary: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 9: | Line 9: | ||
=== [[L_Log table]] - Registry === | === [[L_Log table]] - Registry === | ||
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[ | {{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Log table]] [[Category:Registry Data]] }} | ||
== ADT == | == ADT == | ||
Revision as of 01:50, 3 January 2019
|
Attempt at a easier to follow data dictionary. Is this what you had in mind? |
For an alphabetic listing, see Auto Data Dictionary.
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.
Something went wrong with this query and it has no data - please tell Tina Tenbergen
L_Log table - Registry
Something went wrong with this query and it has no data - please tell Tina Tenbergen
ADT
Admission, discharge and transfer data
L_Log table - physiological components
Something went wrong with this query and it has no data - please tell Tina Tenbergen
APACHE
Apache has physiological components and diagnostic components.
L_Log table - physiological components
Something went wrong with this query and it has no data - please tell Tina Tenbergen
Diagnostic components
ADLs - Activities of Daily Living
Collected according to ADL General Collection Information. Something went wrong with this query and it has no data - please tell Tina Tenbergen
Diagnoses
ICD10 - L_ICD10 table
This stores our version of ICD10 (see ICD10 Diagnosis List), collected following the ICD10 collection instructions. Something went wrong with this query and it has no data - please tell Tina Tenbergen
Old dx schema
In this schema procedures were coded together with diagnoses.
Diagnoses - L_Dxs table
Something went wrong with this query and it has no data - please tell Tina Tenbergen
Comorbids - L_Como table
Something went wrong with this query and it has no data - please tell Tina Tenbergen
Procedures
This stores our version of CCI, collected following the CCI Collection instructions.
See CCI Picklist for possible values. Something went wrong with this query and it has no data - please tell Tina Tenbergen
See CCI component 1 codes - what organ was something done to, CCI component 2 codes - what was done for possible values. Something went wrong with this query and it has no data - please tell Tina Tenbergen
Old dx coding schema
In the old dx coding schema procedures were coded together with diagnoses, see #L_Dxs table.
Labs
CCI
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
Something went wrong with this query and it has no data - please tell Tina Tenbergen
DSM Data
Something went wrong with this query and it has no data - please tell Tina Tenbergen
Pharmacy
Something went wrong with this query and it has no data - please tell Tina Tenbergen
Temporary project data
Something went wrong with this query and it has no data - please tell Tina Tenbergen