Auto Data Dictionary

This 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 186 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.	11 July 1988	Raw
ADL Bathing	L Log table	ADL	string	15	Need for help with bathing; component of ADL.	1 October 2003	Raw
ADL Continence	L Log table	ADL	string	15	Control of urination and bowel movements; component of ADL	1 October 2003	Raw
ADL Dressing	N/A	ADL	string	15	Need for help with dressing; component of ADL.	1 October 2003	Raw
ADL Feeding	L Log table	ADL	string	15	Need for help with feeding; component of ADL	1 October 2003	Raw
ADL Toiletting	L Log table	ADL	string	15	Need for help with toiletting; component of ADL	1 October 2003	Raw
ADL Transfering	L Log table	ADL	string	15	Need for help with transferring; component of ADL	1 October 2003	Raw
AP Dias BP Field	L Log table	Apache	number	single	Ap_DiasBP is the diastolic blood pressure.	11 July 1988	Raw
AP Eye field	L Log table	Apache	string	13	The eye component of the Glasgow_Coma_Scale.	11 July 1988	Raw
AP Motor field	L Log table	Apache	string	19	The motor component of the Glasgow_Coma_Scale.	11 July 1988	Raw
AP Sys BP Field	L Log table	Apache	number	single	Ap_SysBP is the systolic blood pressure.	11 July 1988	Raw
AP Verbal field	L Log table	Apache	string	26	The verbal component of the Glasgow_Coma_Scale.	11 July 1988	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.	11 July 1988	Raw
AaDO2	N/A	Apache	number	N/A	The patient's Alveolar-arterial oxygen tension difference level in .	11 July 1988	Created
Accept DtTm field	L Log table	not stated	date	not entered	First Service tmp entry DtTm for pts who came 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	11 July 1988	Raw
Age	Created Variables CC table Created Variables Common 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).	11 July 1988	Created
Antipseudomonals	L Pharm Flowsheet table	Pharm	number	integer	antipseudomonals contains manually collected doses of antipseudomonals that were given.	11 July 1988	Raw
Arrive DtTm field	L Log table	Dispo	date	not entered	First non-ER Boarding location date and time, or start of ( Service Location) for legacy records.	1 July 2016	Raw
Azoles	L Pharm Flowsheet table	Pharm	number	integer	azoles contains manually collected doses of azoles that were given.	11 July 1988	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.	11 July 1988	Raw
CCI 1 Code	N/A	CCI	number	long integer	The unique identifier/index of CCI Procedure's first component in s_CCI_1 table.	1 January 2019	Raw
CCI 2 Code	N/A	CCI	number	long integer	The unique identifier/index of CCI Procedure's second component in s_CCI_2 table.	1 January 2019	Raw
CCI Picklist Code	L CCI Picklist table	CCI	string	20	The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.	1 January 2019	Raw
Carbapenems	L Pharm Flowsheet table	Pharm	number	integer	carbapenems contains manually collected doses of carbapenems that were given.	11 July 1988	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.	11 July 1988	Raw
Chronic Health APACHE	L Log table	Apache	string	30	Specific chronic pre-existing conditions used for APACHE score.	11 July 1988	Raw
ClientVisitGUID	L Log table L Person table	not stated	string	16	Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.	17 June 2021	Raw
Creatinine (APACHE)	L Log table	Apache	number	single	The patient's level in .	11 July 1988	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.	11 July 1988	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.	11 July 1988	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.	11 July 1988	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.	11 July 1988	Raw
Dx Date unknown	L ICD10 table	ICD10	boolean	not entered	True for Acquired Diagnosis / Complication when Dx Date legitimately missing.	11 July 1988	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	11 July 1988	Raw
Dx Priority	L ICD10 table	ICD10	number	single	The priority of an ICD10 diagnosis, used to rank and group.	11 July 1988	Raw
Dx Type	L ICD10 table	ICD10	string	8	The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)	11 July 1988	Raw
ER Delay	Created Variables Common table	not stated	date	n/a	The ER Delay is the difference between the Accept DtTm and Arrive_DtTm, or ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.	11 July 1988	Created
FiO2	L Log table	Apache	number	single	FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.	11 July 1988	Raw
FirstName field	L Log table L PHI table	Top Row	string	40	Last Name of patient	11 July 1988	Raw
Fluoroquinolones	L Pharm Flowsheet table	Pharm	number	integer	fluoroquinolones contains manually collected doses of fluoroquinolones that were given.	11 July 1988	Raw
Fungins	L Pharm Flowsheet table	Pharm	number	integer	fungins contains manually collected doses of fungins that were given.	11 July 1988	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.	11 July 1988	Raw
H2-Blockers	L Pharm Flowsheet table	Pharm	number	integer	H2-Blockers contains manually collected doses of H2-Blockers that were given.	11 July 1988	Raw
HCT	L Log table	Apache	number	single	The patient's hematocrit level in percentage.	11 July 1988	Raw
HR	L Log table	Apache	number	single	The patient's Heart Rate level in beats/min.	11 July 1988	Raw
Heparin SQ	L Pharm Flowsheet table	Pharm	number	integer	Heparin SQ contains manually collected doses of Heparin SQ that were given.	11 July 1988	Raw
Hospitalization ID	L Log table L Person table	not stated	number	long integer	Not currently used	11 July 1988	Created
ICD10 code	L ICD10 table S ICD10 table	ICD10	string	10	The actual ICD10 code.	11 July 1988	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.	11 July 1988	Raw
K	L Log table	Apache	number	single	The patient's Potassium level in mmol/L.	11 July 1988	Raw
L ICD10 ID	L ICD10 table	ICD10	number	long	Unique identifier of the L_ICD10 table	11 July 1988	Raw
LastName field	L Log table L PHI table	Top Row	string	40	Last Name of patient	11 July 1988	Raw
Mean BP	Created Variables CC table	Apache	number	single	Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)	11 July 1988	Created
Na	L Log table	Apache	number	single	The patient's Sodium level in mmol/L.	11 July 1988	Raw
Notes field	L Log table	Top Row	memo	not entered	Used by data collectors to keep notes during collection.	11 July 1988	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.	11 July 1988	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.	11 July 1988	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.	11 July 1988	Raw
PH	L Log table	Apache	number	single	The acidity or basicity of the patient's arterial blood.	11 July 1988	Raw
PHIN field	L Log table L PHI table	Top Row	number	Long Integer	The patient's PHIN .	11 July 1988	Raw
PO2	L Log table	Apache	number	single	PO2 is the partial pressure of oxygen in the patient's arterial blood.	11 July 1988	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.	11 July 1988	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.	11 July 1988	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 (with #exceptions) 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.	11 July 1988	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.	11 July 1988	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)	11 July 1988	Raw
Px Date	L CCI Component table L CCI Picklist table	CCI	date	not entered	The date/time of a CCI procedure	11 July 1988	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	11 July 1988	Raw
RR	L Log table	Apache	number	single	The patient's respiratory rate level in breaths/min.	11 July 1988	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.	11 July 1988	Raw
Serum CO2	L Log table	Apache	number	single	The patient's Serum CO2 level in mmol/L.	11 July 1988	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".	11 July 1988	Raw
Spare1	L Pharm Flowsheet table	Pharm	number	integer	spare1 contains manually collected doses of spare1 that were given.	11 July 1988	Raw
Spare2	L Pharm Flowsheet table	Pharm	number	integer	spare2 contains manually collected doses of spare2 that were given.	11 July 1988	Raw
Spare3	L Pharm Flowsheet table	Pharm	number	integer	spare3 contains manually collected doses of spare3 that were given.	11 July 1988	Raw
Spare4	L Pharm Flowsheet table	Pharm	number	integer	spare4 contains manually collected doses of spare4 that were given.	11 July 1988	Raw
Spare5	L Pharm Flowsheet table	Pharm	number	integer	spare5 contains manually collected doses of spare5 that were given.	11 July 1988	Raw
Spare6	L Pharm Flowsheet table	Pharm	number	integer	spare6 contains manually collected doses of spare6 that were given.	11 July 1988	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.	11 July 1988	Raw
Transfer Delay (Critical Care)	Created Variables Common table	not stated	number	single	Transfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days. Other terms use to call it are Beds Occupied by transferable patients, Wasted Beds, Avoidable Days.	15 January 1999	Created
Transfer Delay (Medicine)	Created Variables Common table	not stated	number	single	Transfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days. Other terms use to call it are Beds Occupied by transferable patients, Wasted Beds, Avoidable Days.	1 October 2003	Created
Vanco alternatives	L Pharm Flowsheet table	Pharm	number	integer	vanco alternatives contains manually collected doses of vanco alternatives that were given.	11 July 1988	Raw
Vancomycin	L Pharm Flowsheet table	Pharm	number	integer	vancomycin contains manually collected doses of vancomycin that were given.	11 July 1988	Raw
Visit Admit DtTm field	L Log table	Dispo	date	not entered	The Visit Admit DtTm field is the start of the hospital registration for the current admission. If from ER, this is also the Triage DtTm.	1 January 2003	Raw
WBC	L Log table	Apache	number	single	The patient's White Blood Count level in x109/L.	11 July 1988	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   Table Tab Data type length Description Start date End 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. 11 July 1988 1 January 2100 Raw ADL Bathing L Log table ADL string 15 Need for help with bathing; component of ADL. 1 October 2003 1 January 2100 Raw ADL Complete L Log table Top Row boolean not entered true when patient ADL data is complete 1 January 2000 31 December 2100 Raw ADL Continence L Log table ADL string 15 Control of urination and bowel movements; component of ADL 1 October 2003 1 January 2100 Raw ADL Dressing N/A ADL string 15 Need for help with dressing; component of ADL. 1 October 2003 1 January 2100 Raw ADL Feeding L Log table ADL string 15 Need for help with feeding; component of ADL 1 October 2003 1 January 2100 Raw ADL Toiletting L Log table ADL string 15 Need for help with toiletting; component of ADL 1 October 2003 1 January 2100 Raw ADL Transfering L Log table ADL string 15 Need for help with transferring; component of ADL 1 October 2003 1 January 2100 Raw AP Dias BP Field L Log table Apache number single Ap_DiasBP is the diastolic blood pressure. 11 July 1988 1 January 2100 Raw AP Eye field L Log table Apache string 13 The eye component of the Glasgow_Coma_Scale. 11 July 1988 1 January 2100 Raw AP Motor field L Log table Apache string 19 The motor component of the Glasgow_Coma_Scale. 11 July 1988 1 January 2100 Raw AP Sys BP Field L Log table Apache number single Ap_SysBP is the systolic blood pressure. 11 July 1988 1 January 2100 Raw AP Verbal field L Log table Apache string 26 The verbal component of the Glasgow_Coma_Scale. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw AaDO2 N/A Apache number N/A The patient's Alveolar-arterial oxygen tension difference level in . 11 July 1988 1 January 2100 Created Abdominal ultrasound L Labs Flowsheet table Lab integer integer Contains the number of abdominal ultrasounds a client has had during an admission to our unit. 11 July 1988 31 December 2018 Raw Accept DtTm field L Log table not stated date not entered First Service tmp entry DtTm for pts who came from the ER department only 1 July 2016 1 January 2100 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 1 January 2100 Raw Admit Type for APACHE II L Log table Apache string 10 Admit type for APACHE 11 July 1988 1 January 2100 Raw Age Created Variables CC table Created Variables Common 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). 11 July 1988 1 January 2100 Created Albumin 25pct L Labs Flowsheet table Lab integer integer Albumin_25pct contains number of doses of 25% Albumin that were given. 11 July 1988 31 December 2018 Raw Albumin 5pct L Labs Flowsheet table Lab integer integer Albumin_5pct contains the number of doses of 5% Albumin that were given. 11 July 1988 31 December 2018 Raw Angio coronary field L Labs Flowsheet table Lab integer integer Angio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there. 11 July 1988 3 April 2017 Raw Angio others field L Labs Flowsheet table Lab integer integer Angio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there. 11 July 1988 3 April 2017 Raw Antipseudomonals L Pharm Flowsheet table Pharm number integer antipseudomonals contains manually collected doses of antipseudomonals that were given. 11 July 1988 1 January 2100 Raw Ap Complete L Log table Top Row boolean not entered True when patient APACH II data is complete 1 January 2000 31 December 2100 Raw ApLab Complete L Log table Top Row boolean not entered True when patient APACHE II lab data is complete 1 January 2000 31 December 2016 Raw Arrive DtTm field L Log table Dispo date not entered First non-ER Boarding location date and time, or start of ( Service Location) for legacy records. 1 July 2016 1 January 2100 Raw Arterial blood gas (labs) L Labs Flowsheet table Lab integer long ABG contains manually collected arterial blood gas counts. 11 July 1988 31 December 2018 Raw Azoles L Pharm Flowsheet table Pharm number integer azoles contains manually collected doses of azoles that were given. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw Blood culture L Labs Flowsheet table Lab not entered integer Contains the number of blood cultures a patient has had during an admission to our unit. 17 March 2017 Raw CBC L Labs Flowsheet table Lab integer integer CBC contains the number of CBCs done during a patient's stay in our unit. 11 July 1988 31 December 2018 Raw CCI 1 Code N/A CCI number long integer The unique identifier/index of CCI Procedure's first component in s_CCI_1 table. 1 January 2019 1 January 2100 Raw CCI 2 Code N/A CCI number long integer The unique identifier/index of CCI Procedure's second component in s_CCI_2 table. 1 January 2019 1 January 2100 Raw CCI Picklist Code L CCI Picklist table CCI string 20 The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table. 1 January 2019 1 January 2100 Raw CT Scan (labs) L Labs Flowsheet table Lab integer integer CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit. 11 July 1988 31 December 2018 Raw CXR L Labs Flowsheet table Lab integer integer Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit. 11 July 1988 31 December 2018 Raw Carbapenems L Pharm Flowsheet table Pharm number integer carbapenems contains manually collected doses of carbapenems that were given. 11 July 1988 1 January 2100 Raw Ceftazidime L Pharm Flowsheet table Pharm number integer ceftazidime contains manually collected doses of ceftazidime that were given. 11 July 1988 31 December 2011 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. 11 July 1988 1 January 2100 Raw Chronic Health APACHE L Log table Apache string 30 Specific chronic pre-existing conditions used for APACHE score. 11 July 1988 1 January 2100 Raw ClientVisitGUID L Log table L Person table not stated string 16 Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. 17 June 2021 1 January 2100 Raw Como Complete L Log table Top Row boolean not entered True when patient comorbid diagnosis data is complete 1 January 2000 31 December 2100 Raw Creatinine (APACHE) L Log table Apache number single The patient's level in . 11 July 1988 1 January 2100 Raw Creatinine (labs) L Labs Flowsheet table Lab integer integer Creatinine contains the number of creatinines done during a patient's stay in our unit. 11 July 1988 17 March 2017 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. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw Diag Complete L Log table Top Row boolean not entered True when patient diagnosis data is complete 1 January 2000 31 December 2100 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 1 January 2100 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 1 January 2100 Raw Dx Date L ICD10 table ICD10 date not entered The date/time of an ICD10 diagnosis. 11 July 1988 1 January 2100 Raw Dx Date unknown L ICD10 table ICD10 boolean not entered True for Acquired Diagnosis / Complication when Dx Date legitimately missing. 11 July 1988 1 January 2100 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 11 July 1988 1 January 2100 Raw Dx Priority L ICD10 table ICD10 number single The priority of an ICD10 diagnosis, used to rank and group. 11 July 1988 1 January 2100 Raw Dx Type L ICD10 table ICD10 string 8 The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication) 11 July 1988 1 January 2100 Raw EPR Admit DtTm field L Log table not stated date not entered arrival time on the unit as per Cognos/ EPR data 27 October 2019 1 November 2020 Raw ER Delay Created Variables Common table not stated date n/a The ER Delay is the difference between the Accept DtTm and Arrive_DtTm, or ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER. 11 July 1988 1 January 2100 Created Echocardiogram L Labs Flowsheet table Lab number integer Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit. 11 July 1988 31 December 2018 Raw FFP L Labs Flowsheet table Lab integer integer Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given. 11 July 1988 31 December 2018 Raw FiO2 L Log table Apache number single FIO2 is the fraction of inspired oxygen[2] in the gas mixture breathed by the patient. 11 July 1988 1 January 2100 Raw FinalCheck field L Log table Top Row boolean not entered Legacy; used to be checked when all data is complete, now see RecordStatus field. 11 July 1988 24 May 2013 Raw FirstName field L Log table L PHI table Top Row string 40 Last Name of patient 11 July 1988 1 January 2100 Raw Fluoroquinolones L Pharm Flowsheet table Pharm number integer fluoroquinolones contains manually collected doses of fluoroquinolones that were given. 11 July 1988 1 January 2100 Raw Fungins L Pharm Flowsheet table Pharm number integer fungins contains manually collected doses of fungins that were given. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw GCS sedated field L Log table Apache boolean not entered Field does not contain any relevant data. 22 September 2016 15 June 2021 Raw H2-Blockers L Pharm Flowsheet table Pharm number integer H2-Blockers contains manually collected doses of H2-Blockers that were given. 11 July 1988 1 January 2100 Raw HCT L Log table Apache number single The patient's hematocrit level in percentage. 11 July 1988 1 January 2100 Raw HR L Log table Apache number single The patient's Heart Rate level in beats/min. 11 July 1988 1 January 2100 Raw Heparin SQ L Pharm Flowsheet table Pharm number integer Heparin SQ contains manually collected doses of Heparin SQ that were given. 11 July 1988 1 January 2100 Raw Hospitalization ID L Log table L Person table not stated number long integer Not currently used 11 July 1988 1 January 2100 Created ICD10 code L ICD10 table S ICD10 table ICD10 string 10 The actual ICD10 code. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw K L Log table Apache number single The patient's Potassium level in mmol/L. 11 July 1988 1 January 2100 Raw L ICD10 ID L ICD10 table ICD10 number long Unique identifier of the L_ICD10 table 11 July 1988 1 January 2100 Raw LMWH L Pharm Flowsheet table Pharm number integer LMWH contains manually collected doses of LMWH that were given. 11 July 1988 31 December 2011 Raw Labs Complete L Log table Top Row boolean not entered True when patient Labs data is complete 1 January 2000 31 December 2100 Raw LastChanged DtTm field L Log table Top Row date not entered Last time the record was closed with the "Close - with updates" button 6 January 2021 31 December 2999 Raw LastName field L Log table L PHI table Top Row string 40 Last Name of patient 11 July 1988 1 January 2100 Raw LastOpened DtTm field L Log table not stated date not entered Date/Time the record was last closed with the "Close - with updates" button. This will usually be the last time the collector updated the record. 14 April 2016 31 December 2999 Raw MRI (labs) L Labs Flowsheet table Lab integer integer MRI contains the manually counted number of MRIs done during a patient's stay in our unit. 11 July 1988 31 December 2018 Raw Magnesium (labs) L Labs Flowsheet table Lab integer integer Magnesium contains the number of magnesiums done during a patient's stay in our unit. 11 July 1988 31 December 2018 Raw Mean BP Created Variables CC table Apache number single Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3) 11 July 1988 1 January 2100 Created Na L Log table Apache number single The patient's Sodium level in mmol/L. 11 July 1988 1 January 2100 Raw Notes field L Log table Top Row memo not entered Used by data collectors to keep notes during collection. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw Off ward field L Log table Dispo number long integer Checked/true if the patient who meets the Definition of a Medicine Laptop Admission or Definition of a Critical Care Laptop Admission spent any time in a bed that is not at their actual collection location between Arrive DtTm and Dispo DtTm. The patient must be covered by the attending of the service of the home unit that is credited with the "off ward" designation. 1 July 2016 29 January 2020 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. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 Raw PH L Log table Apache number single The acidity or basicity of the patient's arterial blood. 11 July 1988 1 January 2100 Raw PHIN field L Log table L PHI table Top Row number Long Integer The patient's PHIN . 11 July 1988 1 January 2100 Raw PO2 L Log table Apache number single PO2 is the partial pressure of oxygen in the patient's arterial blood. 11 July 1988 1 January 2100 Raw PPI L Pharm Flowsheet table Pharm number integer PPI contains manually collected doses of PPI that were given. 11 July 1988 31 December 2011 Raw PT PTT L Labs Flowsheet table Lab integer integer PT_PTT contains the number of PTs and PTTs done during a patient's stay in our unit. 11 July 1988 17 March 2017 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. 11 July 1988 1 January 2100 Raw Pentaspan L Labs Flowsheet table Lab integer integer Pentaspan contains the number of doses or Pentaspan that were given while in the unit. 12 June 2014 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. 11 July 1988 1 January 2100 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 1 January 2100 Raw Pharm 4th generation cephalosporins L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Complete L Log table Top Row boolean not entered True when patient pharmacy diagnosis data is complete 1 January 2000 31 December 2100 Raw Pharm Direct thrombin inhibitors L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Dobutamine cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Dopamine cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Epinephrine cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Factor Xa inhibitors L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Flow Complete L Log table Top Row boolean not entered Unused field 1 January 2000 31 December 2100 Raw Pharm H2 blockers L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Heparin cont inf L Log table Pharm boolean not entered True if a continuous infusion of Heparin was given 1 January 2012 1 January 2100 Raw Pharm Heparinoids L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm LMWH L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Milrinone cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Norepinephrine cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm PPI L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Paralytics cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Phenylephrine cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Vasopressin cont inf L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm Vitamin K antagonists field L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm aminoglycosides L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm amiodarones L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm amphotericin B L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm anti-TB drugs L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm antistaph penicillins L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm benzodiazepines L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm bosentan L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm corticosteroids L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm furosemide L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm heparin sq L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm influenza drugs L Log table Pharm boolean not entered True if influenza drugs were given 1 January 2012 1 January 2100 Raw Pharm insulin L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm macrolides L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm opioids L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm propofol L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 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 1 January 2100 Raw Pharm statins L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Pharm viagra-type vasodilators L Log table Pharm boolean not entered True if drug in field name was given 1 January 2012 1 January 2100 Raw Platelets L Labs Flowsheet table Lab integer integer Platelets contains number of doses of platelets that were given. 11 July 1988 31 December 2018 Raw Postal Code field L Log table Dispo string 6 The patient's postal code. 1 January 2012 1 January 2100 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 1 January 2100 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 1 January 2100 Raw Previous Location field L Log table Dispo number long integer The most recent previous physical location (with #exceptions) of a patient before arriving at the collection location. 1 July 2016 1 January 2100 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 1 January 2100 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. 11 July 1988 1 January 2100 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. 11 July 1988 1 January 2100 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) 11 July 1988 1 January 2100 Raw Px Date L CCI Component table L CCI Picklist table CCI date not entered The date/time of a CCI procedure 11 July 1988 1 January 2100 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 11 July 1988 1 January 2100 Raw R Complete L Log table Top Row boolean not entered true when patient registry data is complete 1 January 2000 31 December 2100 Raw R Filter Field L Log table Dispo string 10 Critical care patients on a long term ventilator (LTV). 11 July 1988 1 January 2019 Raw RR L Log table Apache number single The patient's respiratory rate level in breaths/min. 11 July 1988 1 January 2100 Raw Record L Log table Top Row string 8 Free choice use by collectors to help collection, this field has no consistent meaning. 1 January 1900 31 December 2100 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 1 January 2100 Raw Registry Patient Type N/A Dispo string 10 Service of the attending physician for medicine data, and the type of admit diagnosis for critical care patients. 1 April 1997 9 May 2018 Raw Room nr L Log table not stated string 15 Legacy element that was never used consistently. 1 January 1900 31 December 2100 Raw S dispo.loc type S dispo table string 20   1 July 2016 1 January 2100 Raw S dispo.service type S dispo table string 10   1 July 2016 1 January 2100 Raw SGPT ALT (labs) L Labs Flowsheet table Lab integer integer SGPT_ALT contains the number of SGPTs and ALTs done during a patient's stay in our unit. 11 July 1988 17 March 2017 Raw SentDtTm field L Log table not stated date not entered Time the record was last sent. 11 July 1988 1 January 2100 Raw Serum CO2 L Log table Apache number single The patient's Serum CO2 level in mmol/L. 11 July 1988 1 January 2100 Raw Service/Location field L Log table Dispo number long integer Legacy field replaced by Boarding Loc and Service tmp entry 1 July 2016 1 January 2100 Raw Sex field L Log table Dispo string 7 Biological sex of the patient at birth; options are "male" and "female". 11 July 1988 1 January 2100 Raw Spare1 L Pharm Flowsheet table Pharm number integer spare1 contains manually collected doses of spare1 that were given. 11 July 1988 1 January 2100 Raw Spare2 L Pharm Flowsheet table Pharm number integer spare2 contains manually collected doses of spare2 that were given. 11 July 1988 1 January 2100 Raw Spare3 L Pharm Flowsheet table Pharm number integer spare3 contains manually collected doses of spare3 that were given. 11 July 1988 1 January 2100 Raw Spare4 L Pharm Flowsheet table Pharm number integer spare4 contains manually collected doses of spare4 that were given. 11 July 1988 1 January 2100 Raw Spare5 L Pharm Flowsheet table Pharm number integer spare5 contains manually collected doses of spare5 that were given. 11 July 1988 1 January 2100 Raw Spare6 L Pharm Flowsheet table Pharm number integer spare6 contains manually collected doses of spare6 that were given. 11 July 1988 1 January 2100 Raw Sputum C+S L Labs Flowsheet table Lab integer integer Contains the number of any sputum specimens (including endotracheal secretions) sent for "culture and sensitivity" for bacteria or fungus. 11 July 1988 17 March 2017 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 1 January 2100 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 1 January 2100 Raw TR info status field L Log table Dispo string 19 Cross-check field that will contain data if Transfer_Ready_DtTm field is empty 5 May 2016 15 October 2020 Raw Temperature L Log table Apache number single The patient's Temperature level in °C. 11 July 1988 1 January 2100 Raw Tigecyline L Pharm Flowsheet table Pharm number integer tigecyline contains manually collected doses of tigecyline that were given. 11 July 1988 31 December 2011 Raw Tmp Complete L Log table Top Row boolean not entered True when patient Tmp data is complete 1 January 2000 31 December 2100 Raw Transfer Delay (Critical Care) Created Variables Common table not stated number single Transfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days. Other terms use to call it are Beds Occupied by transferable patients, Wasted Beds, Avoidable Days. 15 January 1999 1 January 2100 Created Transfer Delay (Medicine) Created Variables Common table not stated number single Transfer Delay is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days. Other terms use to call it are Beds Occupied by transferable patients, Wasted Beds, Avoidable Days. 1 October 2003 1 January 2100 Created Transfer Ready DtTm field L Log table Dispo date not entered Date and time the intent to discharge a patient to a lower level in the Level of care hierarchy was documented. 1 July 2016 15 October 2020 Raw Troponin L Labs Flowsheet table Lab integer integer Troponincontains the number of troponins done during a patient's stay in our unit. 11 July 1988 17 March 2017 Raw Urine CS L Labs Flowsheet table Lab integer integer Urine_CS contains the number of any urine specimens sent for "culture and sensitivity" for bacteria or fungus. 11 July 1988 17 March 2017 Raw Vanco alternatives L Pharm Flowsheet table Pharm number integer vanco alternatives contains manually collected doses of vanco alternatives that were given. 11 July 1988 1 January 2100 Raw Vancomycin L Pharm Flowsheet table Pharm number integer vancomycin contains manually collected doses of vancomycin that were given. 11 July 1988 1 January 2100 Raw Venous blood gas (labs) L Labs Flowsheet table Lab integer long VBG contains manually collected venous blood gas counts. 11 July 1988 31 December 2018 Raw Visit Admit DtTm field L Log table Dispo date not entered The Visit Admit DtTm field is the start of the hospital registration for the current admission. If from ER, this is also the Triage DtTm. 1 January 2003 1 January 2100 Raw Voluven L Labs Flowsheet table Lab integer integer Voluven contains the number of doses or Voluven that were given while in the unit. 11 July 1988 12 June 2014 Raw WBC L Log table Apache number single The patient's White Blood Count level in x109/L. 11 July 1988 1 January 2100 Raw

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:

CCMDB ‎ (← links) MCHP Export data dictionary ‎ (← links) Data dictionary ‎ (← links)