L Pharm Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (21 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
The '''L_Pharm_Flowsheet''' table contains the data we collect in the [[CCMDB. | {{DISPLAYTITLE:L_Pharm_Flowsheet table}}The '''L_Pharm_Flowsheet table''' table contains the data we collect in the [[CCMDB.accdb]] about the frequency at which certain [[Drugs Collected | 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]] | |||
{{#ask: [[Category:L_Pharm_Flowsheet table]] | |||
| ?FieldName | |||
| ?FieldDataType | |||
| ?DataElementSortIndex = order in table | |||
|sort=DataElementSortIndex | |||
|order=ascending | |||
|format=broadtable | |||
|default=No pages for labs that meet the semantic mediawiki criteria | |||
|headers=show | |||
|class=sortable wikitable smwtable | |||
}} | |||
== | === 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 profile, sum up all lines or see [[Query L_Pharm_total]]. | |||
===Spares=== | === 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. | 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 == | == 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 | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: Pharmacy]] | [[Category: Pharmacy]] | ||
[[Category: L Table]] | |||
Latest revision as of 15:10, 2023 May 17
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
| FieldName | FieldDataType | order in table | |
|---|---|---|---|
| D ID field | D_ID | string | 1 |
| Pat ID field | Pat_ID | number | 1 |
| PPI | PPI | number | 4 |
| H2-Blockers | H2-Blockers | number | 5 |
| Heparin SQ | Heparin SQ | number | 6 |
| LMWH | LMWH | number | 7 |
| Benzodiazepines cont inf | benzodiazepines cont inf | number | 8 |
| Opioids cont inf | opioids cont inf | number | 9 |
| Propofol cont inf | propofol cont inf | number | 10 |
| Insulin cont inf | insulin cont inf | number | 11 |
| Furosemide cont inf | furosemide cont inf | number | 12 |
| Azoles | azoles | number | 13 |
| Fungins | fungins | number | 14 |
| Antipseudomonals | antipseudomonals | number | 15 |
| Vancomycin | vancomycin | number | 16 |
| Fluoroquinolones | fluoroquinolones | number | 17 |
| Carbapenems | carbapenems | number | 18 |
| Vanco alternatives | vanco alternatives | number | 19 |
| 3rd generation cephalosporins | 3rd generation cephalosporins | number | 20 |
| Ceftazidime | ceftazidime | number | 21 |
| Tigecyline | tigecyline | number | 22 |
| Spare1 | spare1 | number | 23 |
| Spare2 | spare2 | number | 24 |
| Spare3 | spare3 | number | 25 |
| Spare4 | spare4 | number | 26 |
| Spare5 | spare5 | number | 27 |
| Spare6 | spare6 | number | 28 |
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 profile, sum up all lines or 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