L Pharmacy pre 2012 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| Line 37: | Line 37: | ||
* [[L_Pharm_Flowsheet table]] - current data structure (as opposed to this legacy data) | * [[L_Pharm_Flowsheet table]] - current data structure (as opposed to this legacy data) | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
Latest revision as of 10:34, 30 July 2025
The L_Pharmacy_pre_2012 table contains Legacy Drugs before 2012, linked to L_Log table by D_ID.
Structure
To see the most up-to-date data structure of this table, see the master files.
The structure is basically D_ID, followed by alternating p# and d# columns following Legacy Drugs before 2012.
| field | type | description |
|---|---|---|
| D_ID | Text(18) | |
| P1 | long integer | dose count for drug 1 |
| D1 | long integer | day count for drug 1 |
| P2 | long integer | dose count for drug 2 |
| D2 | long integer | day count for drug 2 |
| ... | ... | |
| P109 | long integer | dose count for drug 109 |
| D109 | long integer | day count for drug 109 |
Collection date for ICU only
- Start Date : Varies depending on the collection start date of the site ( Data Collection start dates -click here)
- End Date : Dec 31, 2011
see also
- Category:Pharmacy
- L_Pharm_Flowsheet table - current data structure (as opposed to this legacy data)