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: @@
-'''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 ==
 To see the most up-to-date data structure of this table, see the master files.
-{| class="wikitable sortable"
+The structure is basically D_ID, followed by alternating p# and d# columns following [[Legacy Drugs before 2012]].
+{| 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
 |-
-! name !! type !! description
+|| '''D2''' || long integer || day count for drug 2
 |-
-| D_ID || string(18) || [[D_ID]]
+|| ... || ... ||
 |-
-| ... || ...
+|| '''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]] - current data structure (as opposed to this legacy data)
 [[Category: Data structure]]