View table: Data_Element

Jump to navigation Jump to search

Table structure:

  1. field_name - String
  2. CCMDB_label - String
  3. CCMDB_tab - Wikitext string
  4. description - Wikitext
  5. tables - List of Page, delimiter: ,
  6. data_type - String
  7. datafield_length - String
  8. program_collecting - String
  9. created_raw - String
  10. start_date - Date
  11. end_date - Date
  12. sort - Integer

This table has 181 rows altogether.

Recreate data.

Page field name CCMDB label CCMDB tab description tables data type datafield length program collecting created raw start date end date sort
3rd generation cephalosporins (edit) 3rd generation cephalosporins _didn't find it

Pharm

3rd generation cephalosporins contains manually collected doses of 3rd generation cephalosporins that were given.

L Pharm Flowsheet table number integer CC Raw 2011-10-20 2013-03-11 20
AaDO2 (edit) AaDO2 <not in CCMDB>

Apache

The patient's Alveolar-arterial oxygen tension difference level in .

number N/A CC Created 1988-07-11 2300-01-01 34
Abdominal ultrasound (edit) US_Abd not stated

Lab

Contains the number of abdominal ultrasounds a client has had during an admission to our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 20
Accept DtTm field (edit) Accept DtTm Accept DtTm

not stated

First Service tmp entry DtTm for pts who came from the ER department only

L Log table date not stated Med and CC Raw 2016-07-01 2022-04-22 43
Accept DtTm missing field (edit) Accept_DtTm_missing Accept DtTm missing

not stated

checkbox is checked/true when no Accept DtTm is documented for a patient who came from from the ER.

L Log table boolean not stated Med and CC Raw 2016-07-01 2022-04-22 44
ADL Bathing (edit) ADL_Bathing Bathing

ADL

Need for help with bathing; component of ADL.

L Log table string 15 Med Raw 2003-10-01 2300-01-01 49
ADL Complete (edit) ADL Complete not stated

Top Row

true when patient ADL data is complete

L Log table boolean not stated CC Raw 2000-01-01 2100-12-31 79
ADL Continence (edit) ADL Continence Continence

ADL

Control of urination and bowel movements; component of ADL

L Log table string 15 Med Raw 2003-10-01 2300-01-01 53
ADL Dressing (edit) ADL_Dressing Dressing

ADL

Need for help with dressing; component of ADL.

L Log table string 15 Med Raw 2003-10-01 2300-01-01 50
ADL Feeding (edit) ADL_Feeding Feeding

ADL

Need for help with feeding; component of ADL

L Log table string 15 Med Raw 2003-10-01 2300-01-01 54
ADL Toiletting (edit) ADL_Toiletting Toiletting

ADL

Need for help with toiletting; component of ADL

L Log table string 15 Med Raw 2003-10-01 2300-01-01 51
ADL Transfering (edit) ADL_Transfering Transfering

ADL

Need for help with transferring; component of ADL

L Log table string 15 Med Raw 2003-10-01 2300-01-01 52
Admit Type for APACHE II (edit) Ap_AdmitType Admit Type

Apache

The Admit Type for APACHE II is a way to classify patients' surgical status and one of the elements used to generate the APACHE score.

L Log table string 10 Med and CC Raw 1988-07-11 2300-01-01 55
Age (edit) age not stated

not stated

The number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).

Created Variables Common 2021 table Created Variables CC 2021 table number Med and CC Created 1988-07-11 2300-01-01 3
Albumin 25pct (edit) Albumin_25pct not stated

Lab

Albumin_25pct contains number of doses of 25% Albumin that were given.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 9
Albumin 5pct (edit) Albumin_5pct not stated

Lab

Albumin_5pct contains the number of doses of 5% Albumin that were given.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 10
Angio coronary field (edit) Angio_coronary not stated

Lab

Angio coronary contained the manually counted number of coronary angiograms done during a stay in our unit, or on the way there.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2017-04-03 17
Angio others field (edit) Angio_others not stated

Lab

Angio_others contained the manually counted number of non-coronary angiograms done during a stay in our unit, or on the way there.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2017-04-03 18
Antipseudomonals (edit) antipseudomonals not stated

Pharm

antipseudomonals contains manually collected doses of antipseudomonals that were given.

L Pharm Flowsheet table number integer CC Raw 1988-07-11 2300-01-01 15
Ap Complete (edit) Ap Complete not stated

Top Row

True when patient APACH II data is complete

L Log table boolean not stated CC Raw 2000-01-01 2100-12-31 80
AP Dias BP Field (edit) Ap_APDiasBP APDiasBP

Apache

Ap_DiasBP is the diastolic blood pressure.

L Log table number single CC Raw 1988-07-11 2300-01-01 60
AP Eye field (edit) AP_Eye Eye

Apache

The eye component of the Glasgow_Coma_Scale.

L Log table string 13 Med and CC Raw 1988-07-11 2300-01-01 63
AP Motor field (edit) AP_Motor Motor

Apache

The motor component of the Glasgow_Coma_Scale.

L Log table string 19 Med and CC Raw 1988-07-11 2300-01-01 63
Ap SapsSysBP field (edit) Ap_SapsSysBP not stated

not stated

L Log table number long integer Med and CC Raw 1988-07-11 2014-05-13 48
AP Sys BP Field (edit) Ap_APSysBP APSysBP

Apache

Ap_SysBP is the systolic blood pressure.

L Log table number single CC Raw 1988-07-11 2300-01-01 59
AP Verbal field (edit) AP_Verbal Verbal

Apache

The verbal component of the Glasgow_Coma_Scale.

L Log table string 26 Med and CC Raw 1988-07-11 2300-01-01 63
ARF (APACHE) (edit) Ap_ARF ARF

Apache

The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.

L Log table number single CC Raw 1988-07-11 2300-01-01 77
Arrive DtTm field (edit) Arrive_DtTm Arrive DtTm

Dispo

First non-ER Boarding location date and time, or start of ( Service Location) for legacy records.

date not stated Med and CC Raw 2016-07-01 2022-04-22 45
Arterial blood gas (labs) (edit) ABG not stated

Lab

ABG contains manually collected arterial blood gas counts.

L Labs Flowsheet table integer long CC Raw 1988-07-11 2018-12-31 24
Azoles (edit) azoles not stated

Pharm

azoles contains manually collected doses of azoles that were given.

L Pharm Flowsheet table number integer CC Raw 1988-07-11 2300-01-01 13
Benzodiazepines cont inf (edit) benzodiazepines cont inf not stated

Pharm

benzodiazepines cont inf contains manually collected doses of benzodiazepines cont inf that were given.

L Pharm Flowsheet table number integer CC Raw 2011-11-29 2014-05-13 8
Blood culture (edit) Blood_CS

Lab

Contains the number of blood cultures a patient has had during an admission to our unit.

L Labs Flowsheet table not entered integer CC Raw 2017-03-17 22
Carbapenems (edit) carbapenems not stated

Pharm

carbapenems contains manually collected doses of carbapenems that were given.

L Pharm Flowsheet table number integer CC Raw 1988-07-11 2300-01-01 18
CBC (edit) CBC not stated

Lab

CBC contains the number of CBCs done during a patient's stay in our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 4
CCI 1 Code (edit) not stated not stated

CCI

The unique identifier/index of CCI Procedure's first component in s_CCI_1 table.

number long integer Med and CC Raw 2019-01-01 2300-01-01 3
CCI 2 Code (edit) not stated not stated

CCI

The unique identifier/index of CCI Procedure's second component in s_CCI_2 table.

number long integer Med and CC Raw 2019-01-01 2300-01-01 4
CCI Picklist Code (edit) not stated not stated

CCI

The CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.

L CCI Picklist table string 20 Med and CC Raw 2019-01-01 2300-01-01 4
Ceftazidime (edit) ceftazidime not stated

Pharm

ceftazidime contains manually collected doses of ceftazidime that were given.

L Pharm Flowsheet table number integer CC Raw 2012-01-02 2013-03-08 21
Chart number (edit) Chart Chart

Top Row

The number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.

L Log table L PHI table string 8 Med and CC Raw 1988-07-11 2300-01-01 6
Chronic Health APACHE (edit) Ap_Chronic Chronic

Apache

Specific chronic pre-existing conditions used for APACHE score.

L Log table string 30 CC Raw 2022-02-17 56
ClientGUID field (edit) ClientGUID not stated

not stated

The unique person identifier from Cognos.

L Log table string 16 Med and CC Raw 2022-08-29 2300-01-01 2
ClientVisitGUID field (edit) ClientVisitGUID N/A

not stated

Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.

L Log table string 16 Med and CC Raw 2022-08-29 2300-01-01 2
Como Complete (edit) Como_Complete not stated

Top Row

True when patient comorbid diagnosis data is complete

L Log table boolean not stated CC Raw 2000-01-01 2100-12-31 84
Creatinine (APACHE) (edit) Ap_Creat Creatinine

Apache

The patient's level in .

L Log table number single CC Raw 1988-07-11 2300-01-01 76
Creatinine (labs) (edit) Creatinine not stated

Lab

Creatinine contains the number of creatinines done during a patient's stay in our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2017-03-17 11
CT Scan (labs) (edit) CT_Scan not stated

Lab

CT_Scan contains the manually counted number of CT scans done during a patient's stay in our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 16
CXR (edit) CXR not stated

Lab

Chest Xrays (CXR) contains the manually counted number of chest xrays (CXR) done during a patient's stay in our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 15
D ID field (edit) D_ID not stated

not stated

The unique identifier/index of records in the Critical Care and Medicine Database.

L CCI Picklist table L CCI Component table L Como table L Dxs table L ICD10 table L Labs DSM table L Labs Flowsheet table L Log table L PCH table L PHI table L Pharm Flowsheet table L TISS Form table L TISS Item table L TmpV2 table L TISS76 table string 18 Med and CC Raw 1988-07-11 2300-01-01 1
Date of Birth (edit) Birth DOB

Top Row

Date of Birth (DOB) is the data a patient was born.

L Log table L PHI table date not stated Med and CC Raw 1988-07-11 2300-01-01 5
DC Treatment (edit) R_dc_treat not stated

not stated

"DC" for critical care patients if life-support treatment is terminated, blank for all others.

L Log table string 50 CC Raw 1988-07-11 2022-05-10 12
Diag Complete (edit) Diag_Complete not stated

Top Row

True when patient diagnosis data is complete

L Log table boolean not stated CC Raw 2000-01-01 2100-12-31 85
Dispo DtTm field (edit) Dispo_DtTm Dispo DtTm

Dispo

Date and time when the patient changed status from what is documented in Service/Location field to Dispo field..

L Log table date not stated Med and CC Raw 2016-07-01 2300-01-01 46
Dispo field (edit) dispo Dispo

Dispo

The Dispo field contains information about what happens to the patient at the end of their admission.

L Log table number long Med and CC Raw 2016-07-01 2300-01-01 41
Dx Date (edit) Dx_Date Date/unknown

ICD10

The date/time of an ICD10 diagnosis.

L ICD10 table date not stated Med and CC Raw 1988-07-11 2300-01-01 4
Dx Date unknown (edit) Dx_Date_unknown Date/unknown

ICD10

True for Acquired Diagnosis / Complication when Dx Date legitimately missing.

L ICD10 table boolean not stated Med and CC Raw 1988-07-11 2300-01-01 5
Dx Primary (edit) Dx primary not stated

ICD10

Checkbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis

L ICD10 table boolean not stated Med and CC Raw 1988-07-11 2300-01-01 8
Dx Priority (edit) Dx Priority not stated

ICD10

The priority of an ICD10 diagnosis, used to rank and group.

L ICD10 table number single Med and CC Raw 1988-07-11 2300-01-01 7
Dx Type (edit) Dx Type not stated

ICD10

The type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)

L ICD10 table string 8 Med and CC Raw 1988-07-11 2300-01-01 6
Echocardiogram (edit) US_Echo US Echo

Lab

Contains the number of heart ultrasounds (echocardiograms) a client has had during an admission to our unit.

L Labs Flowsheet table number integer CC Raw 1988-07-11 2018-12-31 19
ER Delay (edit) ER Delay not stated

not stated

The ER Delay is the difference between the pre-ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.

Created Variables Common 2021 table date n/a Med and CC Created 1988-07-11 2300-01-01 8
FFP (edit) FFP not stated

Lab

Fresh Frozen Plasma / FFP contains manually collected doses of FFP that were given.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 7
FiO2 (edit) Ap_FIO2 FIO2

Apache

FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.

L Log table number single CC Raw 1988-07-11 2300-01-01 67
FirstName field (edit) FirstName First Name

Top Row

Last Name of patient

L Log table L PHI table string 40 Med and CC Raw 1988-07-11 2300-01-01 3
Fluoroquinolones (edit) fluoroquinolones not stated

Pharm

fluoroquinolones contains manually collected doses of fluoroquinolones that were given.

L Pharm Flowsheet table number integer CC Raw 1988-07-11 2300-01-01 17
Fungins (edit) fungins not stated

Pharm

fungins contains manually collected doses of fungins that were given.

L Pharm Flowsheet table number integer CC Raw 1988-07-11 2300-01-01 14
Furosemide cont inf (edit) furosemide cont inf not stated

Pharm

furosemide cont inf contains manually collected doses of furosemide cont inf that were given.

L Pharm Flowsheet table number integer CC Raw 2011-12-21 2014-05-09 12
GCS sedated field (edit) GCS_sedated Sedated

Apache

Field does not contain any relevant data.

L Log table boolean not stated CC Raw 2016-09-22 2021-06-15 67
H2-Blockers (edit) H2-Blockers not stated

Pharm

H2-Blockers contains manually collected doses of H2-Blockers that were given.

L Pharm Flowsheet table number integer CC Raw 2009-12-24 2014-05-12 5
HCT (edit) Ap_Hemat HCT

Apache

The patient's hematocrit level in percentage.

L Log table number single CC Raw 1988-07-11 2300-01-01 74
Heparin SQ (edit) Heparin SQ not stated

Pharm

Heparin SQ contains manually collected doses of Heparin SQ that were given.

L Pharm Flowsheet table number integer CC Raw 2011-11-28 2014-05-13 6
Hospitalization ID (edit) Person_ID N/A

not stated

Not currently used

L Log table L Person table number long integer Med and CC Created 1988-07-11 2300-01-01 1
HR (edit) Ap_HeartRate Heart Rate

Apache

The patient's Heart Rate level in beats/min.

L Log table number single CC Raw 1988-07-11 2300-01-01 61
ICD10 code (edit) ICD10 code ICD10 code

ICD10

The actual ICD10 code.

S ICD10 table L ICD10 table string 10 Med and CC Raw 1988-07-11 2300-01-01 1
Insulin cont inf (edit) insulin cont inf not stated

Pharm

insulin cont inf contains manually collected doses of insulin cont inf that were given.

L Pharm Flowsheet table number integer CC Raw 2011-12-06 2014-05-13 11
K (edit) Ap_K not stated

Apache

The patient's Potassium level in mmol/L.

L Log table number single CC Raw 1988-07-11 2300-01-01 73
L ICD10 ID (edit) L ICD10 ID not stated

ICD10

Unique identifier of the L_ICD10 table

L ICD10 table number long Med and CC Raw 1988-07-11 2300-01-01 1
Labs Complete (edit) Labs_Complete not stated

Top Row

True when patient Labs data is complete

L Log table boolean not stated CC Raw 2000-01-01 2100-12-31 82
LastChanged DtTm field (edit) LastChanged_DtTm not stated

Top Row

Last time the record was closed with the "Close - with updates" button

L Log table date not stated Med and CC Raw 2021-01-06 2999-12-31 91
LastName field (edit) LastName Last Name

Top Row

Last Name of patient

L Log table L PHI table string 40 Med and CC Raw 1988-07-11 2300-01-01 2
LastOpened DtTm field (edit) LastOpened DtTm not stated

not stated

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.

L Log table date not stated Med and CC Raw 2016-04-14 2100-01-01 34
LMWH (edit) LMWH not stated

Pharm

LMWH contains manually collected doses of LMWH that were given.

L Pharm Flowsheet table number integer CC Raw 2011-12-06 2011-12-31 7
Magnesium (labs) (edit) Magnesium not stated

Lab

Magnesium contains the number of magnesiums done during a patient's stay in our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 12
Mean BP (edit) MBP <not in CCMDB>

Apache

Mean Blood Pressure defined by round(((2x Diastolic) + Systolic)) รท 3)

Created Variables CC 2021 table number single CC Created 1988-07-11 2300-01-01 13
MRI (labs) (edit) MRI not stated

Lab

MRI contains the manually counted number of MRIs done during a patient's stay in our unit.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 27
Na (edit) Ap_Na not stated

Apache

The patient's Sodium level in mmol/L.

L Log table number single CC Raw 1988-07-11 2300-01-01 72
Notes field (edit) Notes Notes

Top Row

Used by data collectors to keep notes during collection.

L Log table memo not stated Med and CC Raw 1988-07-11 2300-01-01 9
Notes field (L PHI) (edit) Notes not stated

not stated

Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.

L PHI table string not stated Med and CC Raw 1988-07-11 2300-01-01 9
Off ward field (edit) off_ward Off Ward

Dispo

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.

L Log table number long integer Med and CC Raw 2016-07-01 2020-01-29 39
Opioids cont inf (edit) opioids cont inf not stated

Pharm

opioids cont inf contains manually collected doses of opioids cont inf that were given.

L Pharm Flowsheet table number integer CC Raw 2011-12-06 2014-05-13 9
Packed cells (edit) Packed cells not stated

Lab

Packed cells contains doses of packed cells that were given.

L Labs Flowsheet table integer integer CC Raw 1988-07-11 2018-12-31 6
Pat ID field (edit) Pat_ID Serial

Top Row

The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.

L CCI Picklist table L CCI Component table L Como table L Dxs table L ICD10 table L Labs Flowsheet table L Log table L PCH table L PHI table L Pharm Flowsheet table L TISS Form table L TISS Item table L TmpV2 table number Long Integer Med and CC Raw 1988-07-11 2300-01-01 1
PCO2 (edit) Ap_CO2 CO2

Apache

PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.

L Log table number single CC Raw 1988-07-11 2300-01-01 69
Pentaspan (edit) Pentaspan not stated

Lab

Pentaspan contains the number of doses or Pentaspan that were given while in the unit.

L Labs Flowsheet table integer integer CC Raw 2014-06-12 26
Person ID field (edit) Person_ID N/A

not stated

Unique random number id per patient that combines the D_IDs across admissions/encounters.

L Log table L Person table number long integer Med and CC Created 1988-07-11 2300-01-01 1
PH (edit) Ap_pH ph

Apache

The acidity or basicity of the patient's arterial blood.

L Log table number single CC Raw 1988-07-11 2300-01-01 70
Pharm 1st or 2nd generation cephalosporins (edit) pharm_1st or 2nd generation cephalosporins <not in CCMDB>

Pharm

True if drug in field name was given

L Log table boolean not stated CC Raw 2012-01-01 2013-08-07 108
Pharm 4th generation cephalosporins (edit) pharm_4th generation cephalosporins <not in CCMDB>

Pharm

True if drug in field name was given

L Log table boolean not stated CC Raw 2012-01-01 2013-02-28 109
Pharm aminoglycosides (edit) pharm_aminoglycosides <not in CCMDB>

Pharm

True if drug in field name was given

L Log table boolean not stated CC Raw 2012-01-01 2013-03-05 111
Pharm amiodarones (edit) pharm_amiodarones (F2)amiodarones

Pharm

True if drug in field name was given

L Log table boolean not stated CC Raw 2012-01-01 2300-01-01 116
Pharm amphotericin B (edit) pharm_amphotericin B (E3)amphotericin B

Pharm

True if drug in field name was given

L Log table boolean not stated CC Raw 2012-01-01 2300-01-01 106

More...