L Log table

From CCMDB Wiki
Jump to navigationJump 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 Integer1 January 19001 January 2100Med and CC
Person ID fieldPerson_IDnumberlong integer1 January 19001 January 2100Med and CC
D ID fieldD_IDstring181 January 19001 January 2100Med and CC
LastName fieldLastNamestring401 January 19001 January 2100Med and CC
FirstName fieldFirstNamestring401 January 19001 January 2100Med and CC
PHIN fieldPHINnumberLong Integer1 January 19001 January 2100Med and CC
Date of BirthBirthdatenot entered1 January 19001 January 2100Med and CC
Chart numberChartstring81 January 19001 January 2100Med and CC
SentDtTm fieldSentDtTmdatenot entered1 January 19001 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 entered1 January 19001 January 2100Med and CC
FinalCheck fieldFinalCheckbooleannot entered1 January 190024 May 2013Med and CC
DC TreatmentR_dc_treatstring501 January 19001 January 2100CC
Province fieldR_Provincestring21 January 19001 January 2100Med and CC
Sex fieldR_Sexstring71 January 19001 January 2100Med and CC
R Filter FieldR_Filterstring101 January 19001 January 2100Med and CC
Postal Code fieldPostalCodestring61 January 20121 January 2100Med and CC
LastOpened DtTm fieldLastOpened DtTmdatenot entered1 January 201631 December 2100CC
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 20161 January 2100Med and CC
Off ward fieldoff_wardnumberlong integer1 July 20161 January 2100Med 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 20161 January 2100Med and CC
Accept DtTm missing fieldAccept_DtTm_missingbooleannot entered1 July 20161 January 2100Med and CC
Arrive DtTm fieldArrive_DtTmdatenot entered1 July 20161 January 2100Med and CC
Dispo DtTm fieldDispo_DtTmdatenot entered1 July 20161 January 2100Med and CC
Transfer Ready DtTm fieldTransfer_Ready_DtTmdatenot entered1 July 20161 January 2100Med and CC
TR info status fieldTR_info_statusstring195 May 20161 January 2100Med and CC
ADL BathingADL_Bathingstring151 January 19001 January 2100Med
ADL DressingADL_Dressingstring151 January 19001 January 2100Med
ADL ToilettingADL_Toilettingstring151 January 19001 January 2100Med
ADL TransferingADL_Transferingstring151 January 19001 January 2100Med
ADL ContinenceADL Continencestring151 January 19001 January 2100Med
ADL FeedingADL_Feedingstring151 January 19001 January 2100Med
Admit Type for APACHE IIAp_AdmitTypestring101 January 19001 January 2100Med and CC
Chronic Health APACHEAp_Chronicstring301 January 19001 January 2100CC
TemperatureAp_Tempnumbersingle1 January 19001 January 2100CC
AP Sys BP FieldAp_APSysBPnumbersingle1 January 19001 January 2100CC
AP Dias BP FieldAp_APDiasBPnumbersingle1 January 19001 January 2100CC
HRAp_HeartRatenumbersingle1 January 19001 January 2100CC
RRAp_RespRatenumbersingle1 January 19001 January 2100CC
AP Motor fieldAP_Motorstring191 January 19001 January 2100Med and CC
AP Eye fieldAP_Eyestring131 January 19001 January 2100Med and CC
AP Verbal fieldAP_Verbalstring261 January 19001 January 2100Med and CC
GCS sedated fieldGCS_sedatedbooleannot entered22 September 20161 January 2100CC
FiO2Ap_FIO2numbersingle1 January 19001 January 2100CC
PO2Ap_PO2numbersingle1 January 19001 January 2100CC
PCO2Ap_CO2numbersingle1 January 19001 January 2100CC
PHAp_pHnumbersingle1 January 19001 January 2100CC
Serum CO2Ap_SerCO2numbersingle1 January 19001 January 2100CC
NaAp_Nanumbersingle1 January 19001 January 2100CC
KAp_Knumbersingle1 January 19001 January 2100CC
HCTAp_Hematnumbersingle1 January 19001 January 2100CC
WBCAp_WBCnumbersingle1 January 19001 January 2100Med and CC
Creatinine (APACHE)Ap_Creatnumbersingle1 January 19001 January 2100CC
ARF (APACHE)Ap_ARFnumbersingle1 January 19001 January 2100CC
R CompleteR Completebooleannot entered1 January 200031 December 2100CC
ADL CompleteADL Completebooleannot entered1 January 200031 December 2100CC
Ap CompleteAp Completebooleannot entered1 January 200031 December 2100CC
RecordStatus fieldRecordStatusstring2024 April 20131 January 2100Med and CC
ApLab CompleteApLab Completebooleannot entered1 January 200031 December 2016CC
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
Pharm Flow CompletePharm_Flow_Completebooleannot entered1 January 200031 December 2100CC
RecordRecordstring81 January 190031 December 2100CC
Room nrRoom_nrstring151 January 190031 December 2100CC
LastChanged DtTm fieldLastChanged_DtTmdatenot entered1 January 201631 December 2100CC
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 20121 January 2100CC
Pharm 1st or 2nd generation cephalosporinspharm_1st or 2nd generation cephalosporinsbooleannot entered1 January 20121 January 2100CC
Pharm 4th generation cephalosporinspharm_4th generation cephalosporinsbooleannot entered1 January 20121 January 2100CC
Pharm antistaph penicillinspharm_antistaph penicillinsbooleannot entered1 January 20121 January 2100CC
Pharm aminoglycosidespharm_aminoglycosidesbooleannot entered1 January 20121 January 2100CC
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