L Pharmacy pre 2012 table: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-'''L Pharmacy pre 2012''' is table that contains [[Legacy Drugs before 2012]], linked to [[L_Log table]] by [[D_ID]].
+{{DISPLAYTITLE:L_Pharmacy_pre_2012 table}}The '''L_Pharmacy_pre_2012''' table contains [[Legacy Drugs before 2012]], linked to [[L_Log table]] by [[D_ID]].
 == Structure ==
@@ Line 6: / Line 6: @@
 The structure is basically D_ID, followed by alternating p# and d# columns following [[Legacy Drugs before 2012]].
-== Collection date for  ICU only ==
+{| class="wikitable sortable"
+|-
+!| 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 ( [[Site and Location table |  Data Collection start dates -click here]])
 *End Date : Dec 31, 2011
 == see also ==
 * [[:Category:Pharmacy]]
-* [[L_Pharm_Flowsheet table 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]]