L Pharm Flowsheet table

From CCMDB Wiki
Jump to navigationJump to search

The L_Pharm_Flowsheet table table contains the data we collect in the CCMDB.accdb about the frequency at which certain drugs are used in the ICU setting.

Data for the drugs which are only collected as yes/no is stored in L_Log.

Data Structure

To see the data structure of this table, see most up-to-date ccmdb_data.mdb in Regional Server\data\Master\CCMDB data.mdb.

snapshot of structure

  • L_Pharm_Flowsheet table_ID - unique record ID
  • D_ID / Pat_ID - link to L_Log
  • Entry_dt - date line was entered, see #Meaning of lines
 FieldNameFieldDataTypeorder in table
Pat ID fieldPat_IDnumber1
D ID fieldD_IDstring1
PPIPPInumber4
H2-BlockersH2-Blockersnumber5
Heparin SQHeparin SQnumber6
LMWHLMWHnumber7
Benzodiazepines cont infbenzodiazepines cont infnumber8
Opioids cont infopioids cont infnumber9
Propofol cont infpropofol cont infnumber10
Insulin cont infinsulin cont infnumber11
Furosemide cont inffurosemide cont infnumber12
Azolesazolesnumber13
Funginsfunginsnumber14
Antipseudomonalsantipseudomonalsnumber15
Vancomycinvancomycinnumber16
Fluoroquinolonesfluoroquinolonesnumber17
Carbapenemscarbapenemsnumber18
Vanco alternativesvanco alternativesnumber19
3rd generation cephalosporins3rd generation cephalosporinsnumber20
Ceftazidimeceftazidimenumber21
Tigecylinetigecylinenumber22
Spare1spare1number23
Spare2spare2number24
Spare3spare3number25
Spare4spare4number26
Spare5spare5number27
Spare6spare6number28


Meaning of lines

Lines in this table give an incremental picture of how many labs were counted since last count for this patient. For a total count of labs for a patient see Query L_Pharm_total.

Spares

Added spare1 - spare6 to table before rolling out to collectors in anticipation of future changes. Easy to add to form and to send procedure, much more complicated to add to local data structure, hopefully this will minimize need of doing that.

Legacy

moving yes/no drugs out

yes/no drugs were initially stored in this table as well but were moved to table L_Log as of CCMDB.mdb_Change_Log_2012#ver_2012-10-19.

initiation

L_Pharm_Flowsheet table replaced the L_Pharm table as of January 1, 2012 for the new Pharmacy collection process which started January 1, 2012 for all Critical Care units in the Region