L Pharm Flowsheet table: Difference between revisions
m Text replacement - "L Pharm Flowsheet" to "L_Pharm_Flowsheet table" |
m Text replacement - "L_Pharm_Flowsheet" to "L_Pharm_Flowsheet table" |
||
| Line 1: | Line 1: | ||
The '''L_Pharm_Flowsheet''' table contains the data we collect in the [[CCMDB.mdb]] about the frequency at which certain [[Drugs Collected | drugs]] are used in the ICU setting. | The '''L_Pharm_Flowsheet table''' table contains the data we collect in the [[CCMDB.mdb]] 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:L_Pharm_Flowsheet table]] | {{#ask: [[Category:L_Pharm_Flowsheet table table]] | ||
| ?FieldName | | ?FieldName | ||
| ?FieldDataType | | ?FieldDataType | ||
| 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 | ||