Data dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,581 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(43 intermediate revisions by 2 users not shown)
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 ==
== 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]] ===
=== [[L_PHI table]] ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_PHI table]]}}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_PHI table]]}}


=== [[L_Log table]] - Registry ===
=== [[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 ==
== ADT - via [[EPR]] ==
Admission, discharge and transfer data
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 ==
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===
{{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 ===
=== Diagnostic components ===
Line 27: Line 47:
== ADLs - Activities of Daily Living ==
== ADLs - Activities of Daily Living ==
Collected according to [[ADL General Collection Information]].
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 ==
== Diagnoses ==
Line 33: 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 60: Line 85:
See [[Converting Lab Counts to CCI]] for how the labs described in [[#Pre-CCI manual collection]] are now collected in 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 ===
=== Pre-CCI manual collection - CC only ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Labs_Flowsheet table]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Labs_Flowsheet table]] }}


=== DSM Data ===
=== 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 ==
== Pharmacy ==
=== CC only ===
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Pharm_Flowsheet table]] }}
{{DataDictionaryQuery | Criteria= [[FieldName::>""]] [[InTable::L_Pharm_Flowsheet table]] }}


== Temporary project data ==
== Temporary project data ==
See [[Projects]] for a list of current and past projects.
=== [[L_TmpV2 table]] ===
=== [[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]]

Latest revision as of 11:32, 30 July 2025

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

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

CC only

Something went wrong with this query and it has no data - please tell Tina Tenbergen

ADT - via EPR

Admission, discharge and transfer data

L_Log table

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

CC only

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.

Med only

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

Charlson Comorbidities

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.

L_CCI_Picklist table

See CCI Picklist for possible values. Something went wrong with this query and it has no data - please tell Tina Tenbergen

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. 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 - CC only

Something went wrong with this query and it has no data - please tell Tina Tenbergen

DSM Data

See L_Labs_DSM table

Elements collected via DSM

See DSM data#DSM results we store

Pharmacy

CC only

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Temporary project data

See Projects for a list of current and past projects.

L_TmpV2 table

L_TmpV2 table in CCMDB.accdb and Centralized_data.accdb contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at Projects.

Entity–attribute–value model

See Entity–attribute–value model of the L Tmp V2 table

Linking

This table is linked to L_Log table by D_ID. See CCMDB Data Structure for more info.

Data Structure

To see the most up-to-date data structure of this table, see most up-to-date CCMDB data.mdb in Regional Server\data\Master. The fields are used differently depending on project, see Projects for a list and the individual project pages for field usage.

Field Name position type description
Tmp_ID 1 AutoNumber (Long integer) unique identifier of tmp entry
Pat_ID/D_ID 2
Project 3 text () name of the Project, corresponds to s_tmp.Study
Item 4 text () value in project, or dropdown, corresponds to s_tmp.value
obsdate 5 Date/Time automatically entered date of collection, see Separation of date and time fields
obstime 6 Date/Time automatically entered time of collection, see Separation of date and time fields
date_var 7 Date/Time date, if collected, specified in s_tmp.date_var_label, see Separation of date and time fields
time_var 8 Date/Time time, if collected, specified in s_tmp.time_var_label, see Separation of date and time fields
int_var 9 number (long integer) integer variable, if collected, specified in s_tmp.int_var_label
float_var 9 number (double) float/real variable, if collected, specified in s_tmp.float_var_label
bool_var 10 Yes/No boolean variable, if collected, specified in s_tmp.bool_var_label
comment_var 11 Text comment variable, if collected, not specified in s_tmp since generally permitted as free text comment

why separate?

See separation of date and time fields

Related articles:


TISS28 - CC only

See TISS Item List for a list of elements we collect as part of TISS.

L_TISS_Form table

Something went wrong with this query and it has no data - please tell Tina Tenbergen

L_TISS_Item table

Something went wrong with this query and it has no data - please tell Tina Tenbergen

Created Variables

We have some data elements we generate rather than calculate directly. Something went wrong with this query and it has no data - please tell Tina Tenbergen

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_dictionary&oldid=166056"