L Pharm Flowsheet table: Difference between revisions
Ttenbergen (talk | contribs) m →old: replaced with listing based on articles via SMW |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (8 intermediate revisions by 2 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 for the drugs which are only collected as '''yes/no''' is stored in [[L_Log]]. | ||
| Line 7: | Line 7: | ||
=== snapshot of structure === | === snapshot of structure === | ||
* | * L_Pharm_Flowsheet table_ID - unique record ID | ||
* D_ID / Pat_ID - link to [[L_Log]] | * D_ID / Pat_ID - link to [[L_Log]] | ||
* Entry_dt - date line was entered, see [[#Meaning of lines]] | * Entry_dt - date line was entered, see [[#Meaning of lines]] | ||
{{#ask: [[Category: | {{#ask: [[Category:L_Pharm_Flowsheet table]] | ||
| ?FieldName | | ?FieldName | ||
| ?FieldDataType | | ?FieldDataType | ||
| Line 25: | Line 25: | ||
=== Meaning of lines === | === 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 | 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 === | ||
| Line 34: | Line 34: | ||
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]]. | 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=== | === initiation=== | ||
L_Pharm_Flowsheet 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 | 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]] | |||