Auto Data Dictionary
From CCMDB Wiki
Jump to navigationJump to searchThis page generates an automatically updated list of data fields in the Critical Care and Medicine Database based on contents of this wiki.
What if a field is missing
This only includes fields that have their own article and that properly use the Template:Data element. If field is missing, check that article exists and template is used correctly.
data fields
We collect a total of 180 fields, but since much of our data is realtional this doesn't really give an indication of how many things we collect.
Currently collected
This is a list of fields in the Critical Care and Medicine Database
Table | Tab | Data type | length | Description | Start date | Created vs raw | |
---|---|---|---|---|---|---|---|
3rd generation cephalosporins | L Pharm Flowsheet table | Pharm | number | integer | 3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given. | 1 January 1900 | Raw |
ADL Bathing | L Log table | ADL | string | 15 | Need for help with bathing; component of ADL. | 1 January 1900 | Raw |
ADL Continence | L Log table | ADL | string | 15 | Control of urination and bowel movements; component of ADL | 1 January 1900 | Raw |
ADL Dressing | L Log table | ADL | string | 15 | Need for help with dressing; component of ADL. | 1 January 1900 | Raw |
ADL Feeding | L Log table | ADL | string | 15 | Need for help with feeding; component of ADL | 1 January 1900 | Raw |
ADL Toiletting | L Log table | ADL | string | 15 | Need for help with toiletting; component of ADL | 1 January 1900 | Raw |
ADL Transfering | L Log table | ADL | string | 15 | Need for help with transferring; component of ADL | 1 January 1900 | Raw |
AP Dias BP Field | L Log table | Apache | number | single | Ap_DiasBP is the diastolic blood pressure. | 1 January 1900 | Raw |
AP Eye field | L Log table | Apache | string | 13 | The eye component of the Glasgow_Coma_Scale. | 1 January 1900 | Raw |
AP Motor field | L Log table | Apache | string | 19 | The motor component of the Glasgow_Coma_Scale. | 1 January 1900 | Raw |
AP Sys BP Field | L Log table | Apache | number | single | Ap_SysBP is the systolic blood pressure. | 1 January 1900 | Raw |
AP Verbal field | L Log table | Apache | string | 26 | The verbal component of the Glasgow_Coma_Scale. | 1 January 1900 | Raw |
ARF (APACHE) | L Log table | Apache | number | single | The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition. | 1 January 1900 | Raw |
AaDO2 | N/A | Apache | number | N/A | The patient's Alveolar-arterial oxygen tension difference level in . | 1 January 1900 | Created |
Accept DtTm field | L Log table | not stated | date | not entered | The date and time when the patient is accepted from the ER department ONLY. | 1 July 2016 | Raw |
Accept DtTm missing field | L Log table | not stated | boolean | not entered | checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER. | 1 July 2016 | Raw |
Admit Type for APACHE II | L Log table | Apache | string | 10 | Admit type for APACHE | 1 January 1900 | Raw |
Age | Created variables common Created variables CC table | not stated | number | The number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise). | 1 January 1900 | Created | |
Antipseudomonals | L Pharm Flowsheet table | Pharm | number | integer | antipseudomonals contains manually collected doses of antipseudomonals that were given. | 1 January 1900 | Raw |
Arrive DtTm field | L Log table | Dispo | date | not entered | Date and time when the patient physically arrived on unit ( Service Location) OR in a Boarding location. | 1 July 2016 | Raw |
Azoles | L Pharm Flowsheet table | Pharm | number | integer | azoles contains manually collected doses of azoles that were given. | 1 January 1900 | Raw |
Benzodiazepines cont inf | L Pharm Flowsheet table | Pharm | number | integer | benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given. | 1 January 1900 | Raw |
Carbapenems | L Pharm Flowsheet table | Pharm | number | integer | carbapenems contains manually collected doses of carbapenems that were given. | 1 January 1900 | Raw |
Chart number | L Log table L PHI table | Top Row | string | 8 | The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals. | 1 January 1900 | Raw |
Chronic Health APACHE | L Log table | Apache | string | 30 | Specific chronic pre-existing conditions used for APACHE score. | 1 January 1900 | Raw |
Creatinine (APACHE) | L Log table | Apache | number | single | The patient's level in . | 1 January 1900 | Raw |
D ID field | L Log table L Labs Flowsheet table L Pharm Flowsheet table L PHI table L TISS Form table L TISS Item table L TISS76 table L Labs DSM table L ICD10 table L PCH table L CCI Component table L CCI Picklist table L Como table L Dxs table L TmpV2 table | not stated | string | 18 | The unique identifier/index of records in the Critical Care and Medicine Database. | 1 January 1900 | Raw |
DC Treatment | L Log table | not stated | string | 50 | "DC" for critical care patients if life-support treatment is terminated, blank for all others. | 1 January 1900 | Raw |
Date of Birth | L Log table L PHI table | Top Row | date | not entered | Date of Birth (DOB) is the data a patient was born. | 1 January 1900 | Raw |
Dispo DtTm field | L Log table | Dispo | date | not entered | Date and time when the patient changed status from what is documented in Service/Location field to Dispo field.. | 1 July 2016 | Raw |
Dispo field | L Log table | Dispo | number | long | The Dispo field contains information about what happens to the patient at the end of their admission. | 1 July 2016 | Raw |
Dx Date | L ICD10 table | ICD10 | date | not entered | The date/time of an ICD10 diagnosis. | 1 January 1900 | Raw |
Dx Date unknown | L ICD10 table | ICD10 | boolean | not entered | True for Acquired Diagnosis / Complication when Dx Date legitimately missing. | 1 January 1900 | Raw |
Dx Primary | L ICD10 table | ICD10 | boolean | not entered | Checkbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis | 1 January 1900 | Raw |
Dx Priority | L ICD10 table | ICD10 | number | single | The priority of an ICD10 diagnosis, used to rank and group. | 1 January 1900 | Raw |
Dx Type | L ICD10 table | ICD10 | string | 8 | The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) | 1 January 1900 | Raw |
ER Delay | Created variables common | not stated | date | n/a | The ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER. | 1 January 1900 | Created |
FiO2 | L Log table | Apache | number | single | FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient. | 1 January 1900 | Raw |
FirstName field | L Log table L PHI table | Top Row | string | 40 | Last Name of patient | 1 January 1900 | Raw |
Fluoroquinolones | L Pharm Flowsheet table | Pharm | number | integer | fluoroquinolones contains manually collected doses of fluoroquinolones that were given. | 1 January 1900 | Raw |
Fungins | L Pharm Flowsheet table | Pharm | number | integer | fungins contains manually collected doses of fungins that were given. | 1 January 1900 | Raw |
Furosemide cont inf | L Pharm Flowsheet table | Pharm | number | integer | furosemide cont inf contains manually collected doses of furosemide cont inf that were given. | 1 January 1900 | Raw |
GCS sedated field | L Log table | Apache | boolean | not entered | The GCS sedated field is a checkbox used together with the Glasgow Coma Scale; if the patient is sedated when the GCS is assessed, this box is checked. | 22 September 2016 | Raw |
H2-Blockers | L Pharm Flowsheet table | Pharm | number | integer | H2-Blockers contains manually collected doses of H2-Blockers that were given. | 1 January 1900 | Raw |
HCT | L Log table | Apache | number | single | The patient's hematocrit level in percentage. | 1 January 1900 | Raw |
HR | L Log table | Apache | number | single | The patient's Heart Rate level in beats/min. | 1 January 1900 | Raw |
Heparin SQ | L Pharm Flowsheet table | Pharm | number | integer | Heparin SQ contains manually collected doses of Heparin SQ that were given. | 1 January 1900 | Raw |
ICD10 code | L ICD10 table S ICD10 table | ICD10 | string | 10 | The actual ICD10 code. | 1 January 1900 | Raw |
Insulin cont inf | L Pharm Flowsheet table | Pharm | number | integer | insulin cont inf contains manually collected doses of insulin cont inf that were given. | 1 January 1900 | Raw |
K | L Log table | Apache | number | single | The patient's Potassium level in mmol/L. | 1 January 1900 | Raw |
L ICD10 ID | L ICD10 table | ICD10 | number | long | Unique identifier of the L_ICD10 table | 1 January 1900 | Raw |
LastName field | L Log table L PHI table | Top Row | string | 40 | Last Name of patient | 1 January 1900 | Raw |
Mean BP | Created variables CC table | Apache | number | single | Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3) | 1 January 1900 | Created |
Na | L Log table | Apache | number | single | The patient's Sodium level in mmol/L. | 1 January 1900 | Raw |
Notes field | L Log table | Top Row | memo | not entered | Used by data collectors to keep notes during collection. | 1 January 1900 | Raw |
Notes field (L PHI) | L PHI table | not stated | string | not entered | Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed. | 1 January 1900 | Raw |
Opioids cont inf | L Pharm Flowsheet table | Pharm | number | integer | opioids cont inf contains manually collected doses of opioids cont inf that were given. | 1 January 1900 | Raw |
PCO2 | L Log table | Apache | number | single | PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L. | 1 January 1900 | Raw |
PH | L Log table | Apache | number | single | The acidity or basicity of the patient's arterial blood. | 1 January 1900 | Raw |
PHIN field | L Log table L PHI table | Top Row | number | Long Integer | The patient's PHIN . | 1 January 1900 | Raw |
PO2 | L Log table | Apache | number | single | PO2 is the partial pressure of oxygen in the patient's arterial blood. | 1 January 1900 | Raw |
Pat ID field | L Log table L Labs Flowsheet table L Pharm Flowsheet table L PHI table L TISS Form table L TISS Item table L ICD10 table L PCH table L CCI Component table L CCI Picklist table L Como table L Dxs table L TmpV2 table | Top Row | number | Long Integer | The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number. | 1 January 1900 | Raw |
Person ID field | L Log table L Person table | not stated | number | long integer | Unique random number id per patient that combines the D_IDs across admissions/encounters. | 1 January 1900 | Created |
Pharm 1st or 2nd generation cephalosporins | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm 4th generation cephalosporins | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Direct thrombin inhibitors | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Dobutamine cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Dopamine cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Epinephrine cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Factor Xa inhibitors | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm H2 blockers | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Heparin cont inf | L Log table | Pharm | boolean | not entered | True if a continuous infusion of Heparin was given | 1 January 2012 | Raw |
Pharm Heparinoids | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm LMWH | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Milrinone cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Norepinephrine cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm PPI | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Paralytics cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Phenylephrine cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Vasopressin cont inf | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm Vitamin K antagonists field | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm aminoglycosides | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm amiodarones | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm amphotericin B | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm anti-TB drugs | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm antistaph penicillins | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm benzodiazepines | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm bosentan | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm corticosteroids | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm furosemide | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm heparin sq | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm influenza drugs | L Log table | Pharm | boolean | not entered | True if influenza drugs were given | 1 January 2012 | Raw |
Pharm insulin | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm macrolides | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm opioids | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm propofol | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm special upper GI bleeding agents | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm statins | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Pharm viagra-type vasodilators | L Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | Raw |
Postal Code field | L Log table | Dispo | string | 6 | The patient's postal code. | 1 January 2012 | Raw |
Pre acute living situation field | L Log table | Dispo | number | long integer | Info about the living situation of the patient prior to the current hospitalization. | 1 July 2016 | Raw |
Pre-admit Inpatient Institution field | L Log table | Dispo | number | long integer | The most recent previous inpatient location of patients who were already inpatients elsewhere and who have been under medical care continuously before coming to our unit. | 1 July 2016 | Raw |
Previous Location field | L Log table | Dispo | number | long integer | The most recent previous physical location (except #Bed Borrows) of a patient before arriving at the collection location. | 1 July 2016 | Raw |
Previous Service field | L Log table | Dispo | number | long integer | The most recent "originating service" which sends the patients to their current service location. | 1 July 2016 | Raw |
Propofol cont inf | L Pharm Flowsheet table | Pharm | number | integer | propofol cont inf contains manually collected doses of propofol cont inf that were given. | 1 January 1900 | Raw |
Province field | L Log table | Dispo | string | 2 | Province in which the patient is registered with health care. If the patient is not eligible for health care, it records the province that they reside in. | 1 January 1900 | Raw |
Px Count | L CCI Component table L CCI Picklist table | CCI | date | not entered | The type of a CCI procedure (comorbid, admit or acquired) | 1 January 1900 | Raw |
Px Date | L CCI Component table L CCI Picklist table | CCI | date | not entered | The date/time of a CCI procedure | 1 January 1900 | Raw |
Px Type | L CCI Component table L CCI Picklist table | CCI | string | not entered | The type of a CCI Procedure as per CCI Collection, ie admit or acquired | 1 January 1900 | Raw |
RR | L Log table | Apache | number | single | The patient's respiratory rate level in breaths/min. | 1 January 1900 | Raw |
RecordStatus field | L Log table | Top Row | string | 20 | status of the data in the record. Possible values are complete, sent, questioned and vetted. | 24 April 2013 | Raw |
S dispo.loc type | S dispo table | string | 20 | 1 July 2016 | Raw | ||
S dispo.service type | S dispo table | string | 10 | 1 July 2016 | Raw | ||
SentDtTm field | L Log table | not stated | date | not entered | Time the record was last sent. | 1 January 1900 | Raw |
Serum CO2 | L Log table | Apache | number | single | The patient's Serum CO2 level in mmol/L. | 1 January 1900 | Raw |
Service/Location field | L Log table | Dispo | number | long integer | Legacy field replaced by Boarding Loc and Service tmp entry | 1 July 2016 | Raw |
Sex field | L Log table | Dispo | string | 7 | Biological sex of the patient at birth; options are "male" and "female". | 1 January 1900 | Raw |
Spare1 | L Pharm Flowsheet table | Pharm | number | integer | spare1 contains manually collected doses of spare1 that were given. | 1 January 1900 | Raw |
Spare2 | L Pharm Flowsheet table | Pharm | number | integer | spare2 contains manually collected doses of spare2 that were given. | 1 January 1900 | Raw |
Spare3 | L Pharm Flowsheet table | Pharm | number | integer | spare3 contains manually collected doses of spare3 that were given. | 1 January 1900 | Raw |
Spare4 | L Pharm Flowsheet table | Pharm | number | integer | spare4 contains manually collected doses of spare4 that were given. | 1 January 1900 | Raw |
Spare5 | L Pharm Flowsheet table | Pharm | number | integer | spare5 contains manually collected doses of spare5 that were given. | 1 January 1900 | Raw |
Spare6 | L Pharm Flowsheet table | Pharm | number | integer | spare6 contains manually collected doses of spare6 that were given. | 1 January 1900 | Raw |
Start Date field | L Log table | not stated | date | not entered | Date the record was created on the data collector's laptop; created automatically by CCMDB.accdb. | 25 February 2011 | Raw |
Start Time field | L Log table | not stated | date | not entered | Time the record was created on the data collector's laptop; created automatically by CCMDB.accdb. | 25 February 2011 | Raw |
Temperature | L Log table | Apache | number | single | The patient's Temperature level in °C. | 1 January 1900 | Raw |
Transfer Delay | Created variables common | not stated | number | single | Transfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days. | 15 January 1999 | Created |
Vanco alternatives | L Pharm Flowsheet table | Pharm | number | integer | vanco alternatives contains manually collected doses of vanco alternatives that were given. | 1 January 1900 | Raw |
Vancomycin | L Pharm Flowsheet table | Pharm | number | integer | vancomycin contains manually collected doses of vancomycin that were given. | 1 January 1900 | Raw |
Visit Admit DtTm field | L Log table | Dispo | date | not entered | The Visit Admit DtTm field is the start of the current inpatient admission. | 1 January 2003 | Raw |
WBC | L Log table | Apache | number | single | The patient's White Blood Count level in x109/L. | 1 January 1900 | Raw |
Legacy data
Click to see legacy data only |
Full list
Click to see full list | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This is a list of fields in the Critical Care and Medicine Database
|
Background
This page uses the Template:Data element and Semantic Mediawiki / Cargo to draw information from the more detailed description pages.
Related articles
Related articles: |
|