L_Pharmacy_pre_2012 table
Jump to navigation
Jump to search
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)