Data dictionary
Is this it?
|
|
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.
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
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
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 - 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 |
Related articles
| Related articles: |
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 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
| Related articles: |
TISS28 - CC only
See TISS Items SMW for a list of elements we collect as part of TISS.
Something went wrong with this query and it has no data - please tell Tina Tenbergen
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