L Pharmacy pre 2012 table: Difference between revisions

Latest revision as of 13:49, 2023 June 15

The L_Pharmacy_pre_2012 table contains Legacy Drugs before 2012, linked to L_Log table by D_ID.

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.

Start Date : Varies depending on the collection start date of the site ( Data Collection start dates -click here)
End Date : Dec 31, 2011

@@ Line 1: / Line 1: @@
-The '''L_Pharmacy_pre_2012''' table 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