Template:CollectorDictionaryQuery

From CCMDB Wiki
Jump to navigation Jump to search

This template is used by the Data dictionary to help keep data uniformly structured and formatted.

--- This will say something went wrong and that there is no data because here in its definition there are no query criteria - there is nothing wrong with it saying that here.


Show   
 DescriptionStart dateEnd date
D ID fieldThe unique identifier/index of records in the Critical Care and Medicine Database.11 July 19881 January 2100
Pat ID fieldThe Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.11 July 19881 January 2100
Person ID fieldUnique random number id per patient that combines the D_IDs across admissions/encounters.11 July 19881 January 2100
L ICD10 IDUnique identifier of the L_ICD10 table11 July 19881 January 2100
ICD10 codeThe actual ICD10 code.11 July 19881 January 2100
Hospitalization IDNot currently used11 July 19881 January 2100
ClientGUID fieldThe unique person identifier from Cognos.29 August 20221 January 2100
ClientVisitGUID fieldUnique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data.29 August 20221 January 2100
LastName fieldLast Name of patient11 July 19881 January 2100
FirstName fieldLast Name of patient11 July 19881 January 2100
CCI 1 CodeThe unique identifier/index of CCI Procedure's first component in s_CCI_1 table.1 January 20191 January 2100
AgeThe number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).11 July 19881 January 2100
PHIN fieldThe patient's PHIN .11 July 19881 January 2100
Px DateThe date/time of a CCI procedure11 July 19881 January 2100
Dx DateThe date/time of an ICD10 diagnosis.11 July 19881 January 2100
CCI 2 CodeThe unique identifier/index of CCI Procedure's second component in s_CCI_2 table.1 January 20191 January 2100
CCI Picklist CodeThe CCI code for and entry in the L CCI Picklist subform, from s_CCI_Picklist table.1 January 20191 January 2100
Date of BirthDate of Birth (DOB) is the data a patient was born.11 July 19881 January 2100
Dx Date unknownTrue for Acquired Diagnosis / Complication when Dx Date legitimately missing.11 July 19881 January 2100
Px CountThe type of a CCI procedure (comorbid, admit or acquired)11 July 19881 January 2100
Chart numberThe number used by medical records to uniquely identify a patient's chart; it is different for the same patients at different hospitals.11 July 19881 January 2100
SentDtTm fieldTime the record was last sent.11 July 19881 January 2100
Dx TypeThe type of an ICD10 diagnosis (Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis / Complication)11 July 19881 January 2100
Start Date fieldDate the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 20111 January 2100
Dx PriorityThe priority of an ICD10 diagnosis, used to rank and group.11 July 19881 January 2100
ER DelayThe ER Delay is the difference between the pre-ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.11 July 19881 January 2100
Start Time fieldTime the record was created on the data collector's laptop; created automatically by CCMDB.accdb.25 February 20111 January 2100
s_dispo.loc_typeThe list provides a broader description of service and/ location of the patient's Previous Location,Pre-admit Inpatient Institution or Dispo field and found useful when providing reports.1 July 20161 January 2100
Dx PrimaryCheckbox that is set to true for a single Admit Diagnosis per ward stay that is the Primary Admit Diagnosis11 July 19881 January 2100
Notes fieldUsed by data collectors to keep notes during collection.11 July 19881 January 2100
Notes field (L PHI)Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.11 July 19881 January 2100
Px TypeThe type of a CCI Procedure as per CCI Collection, ie admit or acquired11 July 19881 January 2100
Mean BPMean Blood Pressure defined by round(((2x Diastolic) + Systolic)) ÷ 3)11 July 19881 January 2100
Azolesazoles contains manually collected doses of azoles that were given.11 July 19881 January 2100
Funginsfungins contains manually collected doses of fungins that were given.11 July 19881 January 2100
Antipseudomonalsantipseudomonals contains manually collected doses of antipseudomonals that were given.11 July 19881 January 2100
Province fieldProvince 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 19881 January 2100
Vancomycinvancomycin contains manually collected doses of vancomycin that were given.11 July 19881 January 2100
Sex fieldBiological sex of the patient at birth; options are "male" and "female".11 July 19881 January 2100
Fluoroquinolonesfluoroquinolones contains manually collected doses of fluoroquinolones that were given.11 July 19881 January 2100
Carbapenemscarbapenems contains manually collected doses of carbapenems that were given.11 July 19881 January 2100
Vanco alternativesvanco alternatives contains manually collected doses of vanco alternatives that were given.11 July 19881 January 2100
Postal Code fieldThe patient's postal code.1 January 20121 January 2100
AaDO2The patient's Alveolar-arterial oxygen tension difference level in .11 July 19881 January 2100
LastOpened DtTm fieldDate/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 20161 January 2100
Pre acute living situation fieldInfo about the living situation of the patient prior to the current hospitalization.1 July 20161 January 2100
Pre-admit Inpatient Institution fieldThe 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 20161 January 2100
Previous Location fieldThe most recent previous physical location (with #exceptions) of a patient before arriving at the collection location.1 July 20161 January 2100
Service/Location fieldLegacy field replaced by Boarding Loc and Service tmp entry1 July 20161 January 2100
Dispo fieldThe Dispo field contains information about what happens to the patient at the end of their admission.1 July 20161 January 2100
Visit Admit DtTm fieldThis field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.1 January 20031 January 2100
Dispo DtTm fieldDate and time when the patient changed status from what is documented in Service/Location field to Dispo field..1 July 20161 January 2100
ADL BathingNeed for help with bathing; component of ADL.1 October 20031 January 2100
ADL DressingNeed for help with dressing; component of ADL.1 October 20031 January 2100
ADL ToilettingNeed for help with toiletting; component of ADL1 October 20031 January 2100
ADL TransferingNeed for help with transferring; component of ADL1 October 20031 January 2100
ADL ContinenceControl of urination and bowel movements; component of ADL1 October 20031 January 2100
ADL FeedingNeed for help with feeding; component of ADL1 October 20031 January 2100
Admit Type for APACHE IIThe Admit Type for APACHE II is a way to classify patients' surgical status and one of the elements used to generate the APACHE score.11 July 19881 January 2100
TemperatureThe patient's Temperature level in °C.11 July 19881 January 2100
AP Sys BP FieldAp_SysBP is the systolic blood pressure.11 July 19881 January 2100
AP Dias BP FieldAp_DiasBP is the diastolic blood pressure.11 July 19881 January 2100
HRThe patient's Heart Rate level in beats/min.11 July 19881 January 2100
RRThe patient's respiratory rate level in breaths/min.11 July 19881 January 2100
AP Eye fieldThe eye component of the Glasgow_Coma_Scale.11 July 19881 January 2100
AP Motor fieldThe motor component of the Glasgow_Coma_Scale.11 July 19881 January 2100
AP Verbal fieldThe verbal component of the Glasgow_Coma_Scale.11 July 19881 January 2100
FiO2FIO2 is the fraction of inspired oxygen[1] in the gas mixture breathed by the patient.11 July 19881 January 2100
PO2PO2 is the partial pressure of oxygen in the patient's arterial blood.11 July 19881 January 2100
PCO2PCO2 (or PaCO2) is the partial pressure of carbon dioxide (CO2) in the patient's arterial blood in mmol/L.11 July 19881 January 2100
PHThe acidity or basicity of the patient's arterial blood.11 July 19881 January 2100
Serum CO2The patient's Serum CO2 level in mmol/L.11 July 19881 January 2100
NaThe patient's Sodium level in mmol/L.11 July 19881 January 2100
KThe patient's Potassium level in mmol/L.11 July 19881 January 2100
HCTThe patient's hematocrit level in percentage.11 July 19881 January 2100
WBCThe patient's White Blood Count level in x109/L.11 July 19881 January 2100
Creatinine (APACHE)The patient's level in .11 July 19881 January 2100
ARF (APACHE)The ARF checkbox is checked/true if patient is in Acute Renal Failure as per the APACHE definition.11 July 19881 January 2100
R Completetrue when patient registry data is complete1 January 200031 December 2100
ADL Completetrue when patient ADL data is complete1 January 200031 December 2100
RecordStatus fieldstatus of the data in the record. Possible values are complete, sent, questioned and vetted.24 April 20131 January 2100
Ap CompleteTrue when patient APACH II data is complete1 January 200031 December 2100
Labs CompleteTrue when patient Labs data is complete1 January 200031 December 2100
Tmp CompleteTrue when patient Tmp data is complete1 January 200031 December 2100
Como CompleteTrue when patient comorbid diagnosis data is complete1 January 200031 December 2100
Diag CompleteTrue when patient diagnosis data is complete1 January 200031 December 2100
Pharm CompleteTrue when patient pharmacy diagnosis data is complete1 January 200031 December 2100
RecordFree choice use by collectors to help collection, this field has no consistent meaning.1 January 190031 December 2100
LastChanged DtTm fieldLast time the record was closed with the "Close - with updates" button6 January 202131 December 2999
Pharm Vitamin K antagonists fieldTrue if drug in field name was given1 January 20121 January 2100
Pharm Heparin cont infTrue if a continuous infusion of Heparin was given1 January 20121 January 2100
Pharm Direct thrombin inhibitorsTrue if drug in field name was given1 January 20121 January 2100
Pharm HeparinoidsTrue if drug in field name was given1 January 20121 January 2100
Pharm Factor Xa inhibitorsTrue if drug in field name was given1 January 20121 January 2100
Pharm Dopamine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Dobutamine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Norepinephrine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Epinephrine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Phenylephrine cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Vasopressin cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Milrinone cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm Paralytics cont infTrue if drug in field name was given1 January 20121 January 2100
Pharm corticosteroidsTrue if drug in field name was given1 January 20121 January 2100
Pharm amphotericin BTrue if drug in field name was given1 January 20121 January 2100
Pharm influenza drugsTrue if influenza drugs were given1 January 20121 January 2100
Pharm bosentanTrue if drug in field name was given1 January 20121 January 2100
Pharm viagra-type vasodilatorsTrue if drug in field name was given1 January 20121 January 2100
Pharm special upper GI bleeding agentsTrue if drug in field name was given1 January 20121 January 2100
Pharm amiodaronesTrue if drug in field name was given1 January 20121 January 2100
Pharm anti-TB drugsTrue if drug in field name was given1 January 20121 January 2100
Pharm statinsTrue if drug in field name was given1 January 20121 January 2100
Pharm PPITrue if drug in field name was given1 January 20121 January 2100
Pharm H2 blockersTrue if drug in field name was given1 January 20121 January 2100
Pharm furosemideTrue if drug in field name was given1 January 20121 January 2100
Pharm heparin sqTrue if drug in field name was given1 January 20121 January 2100
Pharm LMWHTrue if drug in field name was given1 January 20121 January 2100
Pharm benzodiazepinesTrue if drug in field name was given1 January 20121 January 2100
Pharm opioidsTrue if drug in field name was given1 January 20121 January 2100
Pharm propofolTrue if drug in field name was given1 January 20121 January 2100
Pharm insulinTrue if drug in field name was given1 January 20121 January 2100