Data dictionary

Is this it?

add a column for program (Critical care only or Medicine only or both). I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in Template:DataDictionaryQuery (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want. how about adding the program as part of the sub header instead of table columns. --JMojica 13:36, 2019 June 26 (CDT) That I can do. Putting it on the list. Ttenbergen 13:48, 2019 July 3 (CDT)

• SMW

• Cargo

• Categories

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.

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

• 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

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.

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

L_Labs_DSM table is a table in DSM Labs Consistency check.accdb that holds the DSM data aggregated from the DSM Lab Extract.

See L_Labs_Flowsheet table for the table that holds the old manually collected data.

Data Structure

column	field	type	description
1	D_ID	text(18)	D ID field
2	Import_DtTm	DtTm	Date and time imported
3	Lab_DtTm	DtTm	Date and time of the test
4	Lab	text(20)	Our name for the lab
5	TestResult	text(10)	result of the test
6	DSM_RequestNo	text(14)	Unique ID per lab request
7	DSM_GrpCode	text(10)	link to S group table
8	DSM_TestCode	Long integer	link to S mapping lab table

Pharmacy

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

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

TISS28

See TISS Items SMW 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