L Pharmacy pre 2012 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,545 edits
No edit summary
mNo edit summary
 
(4 intermediate revisions by 2 users not shown)
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 ==
== Structure ==
To see the most up-to-date data structure of this table, see the master files.
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) ||
|-
|-
! name !! position !! type !! description
|| '''P1''' || long integer || dose count for drug 1
|-
|-
| D_ID || 2 || string(18) || [[D_ID]]
|| '''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 ==
== 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]])
*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
*End Date : Dec 31, 2011


== see also ==
== see also ==
* [[:Category:Pharmacy]]
* [[:Category:Pharmacy]]
* [[L Pharm Flowsheet 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]]

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.

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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Pharmacy_pre_2012_table&oldid=159647"