L Log table

From CCMDB Wiki
Revision as of 16:19, 2019 July 30 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

L_Log is the main table where the basic patient information is stored. In the relational structure of our data, L_Log is the parent table to the other L-tables.

Difference between Centralized_data.mdb and CCMDB_data.mdb

In CCMBD.mdb, the L_Log table contains all the patient related data. In CFE, the information that could identify the patient is stored in PHI.mdb.L_PHI table instead, but the other information is still stored in Centralized_data.mdb.L_Log.

Data Structure

 FieldNameFieldDataTypeFieldLengthDataElementStartDateDataElementEndDateDataElementProgram
Pat ID fieldPat_IDnumberLong Integer11 July 19881 January 2100Med and CC
D ID fieldD_IDstring1811 July 19881 January 2100Med and CC
Person ID fieldPerson_IDnumberlong integer11 July 19881 January 2100Med and CC
Hospitalization IDPerson_IDnumberlong integer11 July 19881 January 2100Med and CC
ClientGUID fieldClientGUIDstring1629 August 20221 January 2100Med and CC
ClientVisitGUID fieldClientVisitGUIDstring1629 August 20221 January 2100Med and CC
LastName fieldLastNamestring4011 July 19881 January 2100Med and CC
FirstName fieldFirstNamestring4011 July 19881 January 2100Med and CC
PHIN fieldPHINnumberLong Integer11 July 19881 January 2100Med and CC
Date of BirthBirthdatenot entered11 July 19881 January 2100Med and CC
Chart numberChartstring811 July 19881 January 2100Med and CC
SentDtTm fieldSentDtTmdatenot entered11 July 19881 January 2100Med and CC
Start Date fieldstart_Datedatenot entered25 February 20111 January 2100Med and CC
Start Time fieldstart_Timedatenot entered25 February 20111 January 2100Med and CC
Notes fieldNotesmemonot entered11 July 19881 January 2100Med and CC
DC TreatmentR_dc_treatstring5011 July 198810 May 2022CC
Province fieldR_Provincestring211 July 19881 January 2100Med and CC
Sex fieldR_Sexstring711 July 19881 January 2100Med and CC
R Filter FieldR_Filterstring1011 July 19881 January 2019Med and CC
Postal Code fieldPostalCodestring61 January 20121 January 2100Med and CC
LastOpened DtTm fieldLastOpened DtTmdatenot entered14 April 20161 January 2100Med and CC
Pre acute living situation fieldPre_Acute_Living_Situationnumberlong integer1 July 20161 January 2100Med and CC
Pre-admit Inpatient Institution fieldPre_admit_Inpatient_Institutionnumberlong integer1 July 20161 January 2100Med and CC
Previous Location fieldPrevious_Locationnumberlong integer1 July 20161 January 2100Med and CC
Previous Service fieldPrevious_Servicenumberlong integer1 July 20167 September 2022Med and CC
Off ward fieldoff_wardnumberlong integer1 July 201629 January 2020Med and CC
Service/Location fieldService_Locationnumberlong integer1 July 20161 January 2100Med and CC
Dispo fielddisponumberlong1 July 20161 January 2100Med and CC
Visit Admit DtTm fieldVisit_Admit_DtTmdatenot entered1 January 20031 January 2100Med and CC
Accept DtTm fieldAccept DtTmdatenot entered1 July 201622 April 2022Med and CC
Accept DtTm missing fieldAccept_DtTm_missingbooleannot entered1 July 201622 April 2022Med and CC
Dispo DtTm fieldDispo_DtTmdatenot entered1 July 20161 January 2100Med and CC
Transfer Ready DtTm fieldTransfer_Ready_DtTmdatenot entered1 June 199915 October 2020Med and CC
TR info status fieldTR_info_statusstring195 May 201615 October 2020Med and CC
Ap SapsSysBP fieldAp_SapsSysBPnumberlong integer11 July 198813 May 2014Med and CC
ADL BathingADL_Bathingstring151 October 20031 January 2100Med
ADL DressingADL_Dressingstring151 October 20031 January 2100Med
ADL ToilettingADL_Toilettingstring151 October 20031 January 2100Med
ADL TransferingADL_Transferingstring151 October 20031 January 2100Med
ADL ContinenceADL Continencestring151 October 20031 January 2100Med
ADL FeedingADL_Feedingstring151 October 20031 January 2100Med
Admit Type for APACHE IIAp_AdmitTypestring1011 July 19881 January 2100Med and CC
Chronic Health APACHEAp_Chronicstring3017 February 2022CC
TemperatureAp_Tempnumbersingle11 July 19881 January 2100CC
AP Sys BP FieldAp_APSysBPnumbersingle11 July 19881 January 2100CC
AP Dias BP FieldAp_APDiasBPnumbersingle11 July 19881 January 2100CC
HRAp_HeartRatenumbersingle11 July 19881 January 2100CC
RRAp_RespRatenumbersingle11 July 19881 January 2100CC
AP Eye fieldAP_Eyestring1311 July 19881 January 2100Med and CC
AP Motor fieldAP_Motorstring1911 July 19881 January 2100Med and CC
AP Verbal fieldAP_Verbalstring2611 July 19881 January 2100Med and CC
GCS sedated fieldGCS_sedatedbooleannot entered22 September 201615 June 2021CC
FiO2Ap_FIO2numbersingle11 July 19881 January 2100CC
PO2Ap_PO2numbersingle11 July 19881 January 2100CC
PCO2Ap_CO2numbersingle11 July 19881 January 2100CC
PHAp_pHnumbersingle11 July 19881 January 2100CC
Serum CO2Ap_SerCO2numbersingle11 July 19881 January 2100CC
NaAp_Nanumbersingle11 July 19881 January 2100CC
KAp_Knumbersingle11 July 19881 January 2100CC
HCTAp_Hematnumbersingle11 July 19881 January 2100CC
WBCAp_WBCnumbersingle11 July 19881 January 2100Med and CC
Creatinine (APACHE)Ap_Creatnumbersingle11 July 19881 January 2100CC
ARF (APACHE)Ap_ARFnumbersingle11 July 19881 January 2100CC
R CompleteR Completebooleannot entered1 January 200031 December 2100CC
ADL CompleteADL Completebooleannot entered1 January 200031 December 2100CC
RecordStatus fieldRecordStatusstring2024 April 20131 January 2100Med and CC
Ap CompleteAp Completebooleannot entered1 January 200031 December 2100CC
Labs CompleteLabs_Completebooleannot entered1 January 200031 December 2100CC
Tmp CompleteAp Completebooleannot entered1 January 200031 December 2100CC
Como CompleteComo_Completebooleannot entered1 January 200031 December 2100CC
Diag CompleteDiag_Completebooleannot entered1 January 200031 December 2100CC
Pharm CompleteComo_Completebooleannot entered1 January 200031 December 2100CC
RecordRecordstring81 January 190031 December 2100CC
LastChanged DtTm fieldLastChanged_DtTmdatenot entered6 January 202131 December 2999Med and CC
Pharm Vitamin K antagonists fieldPharm_Vitamin_K_antagonistsbooleannot entered1 January 20121 January 2100CC
Pharm Heparin cont infpharm_Heparin cont infbooleannot entered1 January 20121 January 2100CC
Pharm Direct thrombin inhibitorspharm_Direct thrombin inhibitorsbooleannot entered1 January 20121 January 2100CC
Pharm Heparinoidspharm_Heparinoidsbooleannot entered1 January 20121 January 2100CC
Pharm Factor Xa inhibitorspharm_Factor Xa inhibitorsbooleannot entered1 January 20121 January 2100CC
Pharm Dopamine cont infpharm_Dopamine cont infbooleannot entered1 January 20121 January 2100CC
Pharm Dobutamine cont infpharm_Dobutamine cont infbooleannot entered1 January 20121 January 2100CC
Pharm Norepinephrine cont infpharm_Norepinephrine cont infbooleannot entered1 January 20121 January 2100CC
Pharm Epinephrine cont infpharm_Epinephrine cont infbooleannot entered1 January 20121 January 2100CC
Pharm Phenylephrine cont infpharm_Phenylephrine cont infbooleannot entered1 January 20121 January 2100CC
Pharm Vasopressin cont infpharm_Vasopressin cont infbooleannot entered1 January 20121 January 2100CC
Pharm Milrinone cont infpharm_Milrinone cont infbooleannot entered1 January 20121 January 2100CC
Pharm Paralytics cont infpharm_Paralytics cont infbooleannot entered1 January 20121 January 2100CC
Pharm corticosteroidspharm_corticosteroidsbooleannot entered1 January 20121 January 2100CC
Pharm amphotericin Bpharm_amphotericin Bbooleannot entered1 January 20121 January 2100CC
Pharm macrolidespharm_macrolidesbooleannot entered1 January 201217 March 2013CC
Pharm 1st or 2nd generation cephalosporinspharm_1st or 2nd generation cephalosporinsbooleannot entered1 January 20127 August 2013CC
Pharm 4th generation cephalosporinspharm_4th generation cephalosporinsbooleannot entered1 January 201228 February 2013CC
Pharm antistaph penicillinspharm_antistaph penicillinsbooleannot entered1 January 201219 February 2013CC
Pharm aminoglycosidespharm_aminoglycosidesbooleannot entered1 January 20125 March 2013CC
Pharm influenza drugspharm_influenza drugsbooleannot entered1 January 20121 January 2100CC
Pharm bosentanpharm_bosentanbooleannot entered1 January 20121 January 2100CC
Pharm viagra-type vasodilatorspharm_viagra-type vasodilatorsbooleannot entered1 January 20121 January 2100CC
Pharm special upper GI bleeding agentspharm_special upper GI bleeding agentsbooleannot entered1 January 20121 January 2100CC
Pharm amiodaronespharm_amiodaronesbooleannot entered1 January 20121 January 2100CC
Pharm anti-TB drugspharm_anti-TB drugsbooleannot entered1 January 20121 January 2100CC
Pharm statinspharm_statinsbooleannot entered1 January 20121 January 2100CC
Pharm PPIpharm_PPIbooleannot entered1 January 20121 January 2100CC
Pharm H2 blockerspharm_H2_blockersbooleannot entered1 January 20121 January 2100CC
Pharm furosemidepharm_furosemidebooleannot entered1 January 20121 January 2100CC
Pharm heparin sqpharm_heparin_sqbooleannot entered1 January 20121 January 2100CC
Pharm LMWHpharm_LMWHbooleannot entered1 January 20121 January 2100CC
Pharm benzodiazepinespharm_benzodiazepinesbooleannot entered1 January 20121 January 2100CC
Pharm opioidspharm_opioidsbooleannot entered1 January 20121 January 2100CC
Pharm propofolpharm_propofolbooleannot entered1 January 20121 January 2100CC
Pharm insulinpharm_insulinbooleannot entered1 January 20121 January 2100CC