L_Pharmacy_pre_2012 table

From CCMDB Wiki
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

see also