Auto Data Dictionary: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→data fields) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
This page generates an automatically updated list of data fields in the [[Critical Care and Medicine Database]] based on contents of this wiki. | |||
This | |||
== What if a field is missing == | == What if a field is missing == | ||
Line 8: | Line 7: | ||
<!-- As generated by [[Semantic Mediawiki]] --> | <!-- As generated by [[Semantic Mediawiki]] --> | ||
We collect a total of '''{{#ask: [[Category:Data structure]] [[FieldName::>""]] | We collect a total of '''{{#ask: [[Category:Data structure]] [[FieldName::>""]] | ||
| limit= | | limit=1000 | ||
| format=count | | format=count | ||
}}''' fields, but since much of our data is realtional this doesn't really give an indication of how many things we collect. | }}''' fields, but since much of our data is realtional this doesn't really give an indication of how many things we collect. | ||
Line 21: | Line 20: | ||
| ?DataElementEndDate=End date | | ?DataElementEndDate=End date | ||
| ?FieldCreatedRaw=Created vs raw | | ?FieldCreatedRaw=Created vs raw | ||
| limit= | | limit=1000 | ||
| intro=This is a list of fields in the Critical Care and Medicine Database | | intro=This is a list of fields in the Critical Care and Medicine Database | ||
| format=table | | format=table | ||
}} | }} | ||
== 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}} | |||
[[Category: Data structure]] | [[Category: Data structure]] |
Revision as of 11:14, 2020 February 5
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 180 fields, but since much of our data is realtional this doesn't really give an indication of how many things we collect.
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. | 20 October 2011 | 11 March 2013 | 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 | L_Log table | 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 | 22 April 2022 | 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 | 22 April 2022 | Raw |
Admit Type for APACHE II | L_Log table | Apache | string | 10 | 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. | 11 July 1988 | 1 January 2100 | Raw |
Age | Created Variables Common 2021 table Created Variables CC 2021 table | not stated | number | The number of years between Date of Birth and the last birthday prior to or on (Admit 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 |
Ap SapsSysBP field | L_Log table | not stated | number | long integer | 11 July 1988 | 13 May 2014 | Raw | |
Arrive DtTm field | N/A | Dispo | date | not entered | First non-ER Boarding location date and time, or start of ( Service Location) for legacy records. | 1 July 2016 | 22 April 2022 | 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. | 29 November 2011 | 13 May 2014 | 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. | 2 January 2012 | 8 March 2013 | 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. | 17 February 2022 | Raw | |
ClientGUID field | L_Log table | not stated | string | 16 | The unique person identifier from Cognos. | 29 August 2022 | 1 January 2100 | Raw |
ClientVisitGUID field | L_Log table | not stated | string | 16 | Unique identifier of a hospital admission for a patient for use with multiple encounters and Cognos data. | 29 August 2022 | 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 | 10 May 2022 | 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 |
ER Delay | Created Variables Common 2021 table | not stated | date | n/a | The 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 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[1] in the gas mixture breathed by the patient. | 11 July 1988 | 1 January 2100 | 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. | 21 December 2011 | 9 May 2014 | 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. | 24 December 2009 | 12 May 2014 | 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. | 28 November 2011 | 13 May 2014 | 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. | 6 December 2011 | 13 May 2014 | 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. | 6 December 2011 | 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 | 1 January 2100 | 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 2021 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. | 6 December 2011 | 13 May 2014 | 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. | 12 September 2011 | 12 May 2014 | 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 | 7 August 2013 | Raw |
Pharm 4th generation cephalosporins | L_Log table | Pharm | boolean | not entered | True if drug in field name was given | 1 January 2012 | 28 February 2013 | 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 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 | 5 March 2013 | 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 | 19 February 2013 | 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 | 17 March 2013 | 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 | 7 September 2022 | 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. | 6 December 2011 | 13 May 2014 | 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 |
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. | 8 December 2012 | 8 December 2012 | Raw |
Spare2 | L_Pharm_Flowsheet table | Pharm | number | integer | spare2 contains manually collected doses of spare2 that were given. | 8 December 2012 | 8 December 2012 | Raw |
Spare3 | L_Pharm_Flowsheet table | Pharm | number | integer | spare3 contains manually collected doses of spare3 that were given. | 8 December 2012 | 8 December 2012 | Raw |
Spare4 | L_Pharm_Flowsheet table | Pharm | number | integer | spare4 contains manually collected doses of spare4 that were given. | 8 December 2012 | 8 December 2012 | Raw |
Spare5 | L_Pharm_Flowsheet table | Pharm | number | integer | spare5 contains manually collected doses of spare5 that were given. | 8 December 2012 | 8 December 2012 | Raw |
Spare6 | L_Pharm_Flowsheet table | Pharm | number | integer | spare6 contains manually collected doses of spare6 that were given. | 8 December 2012 | 8 December 2012 | 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. | 21 July 2012 | 26 August 2012 | 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 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 June 1999 | 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 | This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date. | 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 |
s_dispo.loc_type | s_dispo table | string | 20 | The 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 2016 | 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.