S Drugs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{LegacyContent
| explanation=Very old process, but the facet/dropdown data is in here
| successor=[[L Pharm Flowsheet]]
| content=
'''Pharmacy Elements Collected for Critical Care'''
'''Pharmacy Elements Collected for Critical Care'''


The '''S_Drugs''' TABLE contains all the possible values for the [[L_Pharm]] table in the [[HanDBase]] program on the [[PDA]] and in [[CCMDB.mdb]].
There used to be a table s_Drugs, but it is not in any of our data sources any longer. It's not clear when it was deleted.  
Drug counts are selected and entered into the PDA from the [[S_Drugs]] list.  


The "database code number" in the table below joins the [[L_Pharm]] table to resolve the drug in there.


== Limit of 16 ==
== Limit of 16 ==
Only 16 drugs are allowed to be entered for any given patient.  
Only 16 drugs were allowed to be entered for any given patient.  
This restriction was hard-coded because a number had to be decided upon to accomodate the flat file data structure of [[TMSX]].
 
You can actually enter as many as you want in PDA/Access, but only the 16 with the highest priority will be sent.
 


This restriction was hard-coded because a number had to be decided upon to accommodate the flat file data structure of [[TMSX]].


==S_Drugs Table==
==S_Drugs Table==
'''Note: For an the most up-to-date list, see your PDA and the CCMDB.mdb - this is for orientation only.'''
{{{!}} class="wikitable"  
 
{{!}}-  
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
! Drug
|-  
! Database Code Number
|style="font-size:11pt" width="200" height="32"  valign="bottom" | Drug
! Quantity
|style="font-size:8pt" width="48" align="center" valign="bottom" | Database Code Number
! BaseUnit
|style="font-size:8pt" width="48" align="center" valign="bottom" | Quantity
{{!}}-
|style="font-size:8pt" width="48" align="center" valign="bottom" | BaseUnit
{{!}} No Value
 
{{!}} 0
|- style="font-size:11pt"
{{!}} 0
| height="14"  valign="bottom" |  No Value
{{!}} 0
| align="center" valign="bottom" | 0
| align="center" valign="bottom" | 0
| align="center" valign="bottom" | 0
 
|- style="font-size:11pt"
| height="14"  valign="bottom" | Cefotaxime IV 1 g
| align="center" valign="bottom" | 4
| align="center" valign="bottom" | 1
| align="center" valign="bottom" | 1
 
|- style="font-size:11pt"
| height="14"  valign="bottom" | Ceftazidime IV 1 g
| align="center" valign="bottom" | 6
| align="center" valign="bottom" | 1
| align="center" valign="bottom" | 1
 
|- style="font-size:11pt"
| height="14"  valign="bottom" | Ceftazidime IV 500mg
| align="center" valign="bottom" | 6
| align="center" valign="bottom" | 0.5
| align="center" valign="bottom" | 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ceftazidime IV 500 mg
{{!}} Cefotaxime IV 1 g
| align="center" valign="bottom" | 6
{{!}} 4
| align="center" valign="bottom" | 0.5
{{!}} 1
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ceftriaxone IV 1 g
{{!}} Ceftazidime IV 1 g
| align="center" valign="bottom" | 7
{{!}} 6
| align="center" valign="bottom" | 1
{{!}} 1
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cefuroxime IV 200 mg
{{!}} Ceftazidime IV 500mg
| align="center" valign="bottom" | 8
{{!}} 6
| align="center" valign="bottom" | 200
{{!}} 0.5
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cefuroxime IV 250 mg
{{!}} Ceftazidime IV 500 mg
| align="center" valign="bottom" | 8
{{!}} 6
| align="center" valign="bottom" | 250
{{!}} 0.5
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cefuroxime IV 750 mg
{{!}} Ceftriaxone IV 1 g
| align="center" valign="bottom" | 8
{{!}} 7
| align="center" valign="bottom" | 750
{{!}} 1
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro IV 200 mg
{{!}} Cefuroxime IV 200 mg
| align="center" valign="bottom" | 9
{{!}} 8
| align="center" valign="bottom" | 200
{{!}} 200
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro IV 400 mg
{{!}} Cefuroxime IV 250 mg
| align="center" valign="bottom" | 9
{{!}} 8
| align="center" valign="bottom" | 400
{{!}} 250
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro IV 600 mg
{{!}} Cefuroxime IV 750 mg
| align="center" valign="bottom" | 9
{{!}} 8
| align="center" valign="bottom" | 600
{{!}} 750
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro IV400 mg
{{!}} Cipro IV 200 mg
| align="center" valign="bottom" | 9
{{!}} 9
| align="center" valign="bottom" | 400
{{!}} 200
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Clindamycin IV 600 mg
{{!}} Cipro IV 400 mg
| align="center" valign="bottom" | 11
{{!}} 9
| align="center" valign="bottom" | 600
{{!}} 400
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Clindamycin IV 250 mg
{{!}} Cipro IV 600 mg
| align="center" valign="bottom" | 11
{{!}} 9
| align="center" valign="bottom" | 250
{{!}} 600
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Clindamycin IV 300 mg
{{!}} Cipro IV400 mg
| align="center" valign="bottom" | 11
{{!}} 9
| align="center" valign="bottom" | 300
{{!}} 400
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Clindamycin IV 450 mg
{{!}} Clindamycin IV 600 mg
| align="center" valign="bottom" | 11
{{!}} 11
| align="center" valign="bottom" | 450
{{!}} 600
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Clindamycin IV 900 mg
{{!}} Clindamycin IV 250 mg
| align="center" valign="bottom" | 11
{{!}} 11
| align="center" valign="bottom" | 900
{{!}} 250
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Imipenem IV 250 mg
{{!}} Clindamycin IV 300 mg
| align="center" valign="bottom" | 18
{{!}} 11
| align="center" valign="bottom" | 250
{{!}} 300
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Dobut inf. 250 mg
{{!}} Clindamycin IV 450 mg
| align="center" valign="bottom" | 29
{{!}} 11
| align="center" valign="bottom" | 250
{{!}} 450
| align="center" valign="bottom" | 250
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Dobut inf. 500 mg
{{!}} Clindamycin IV 900 mg
| align="center" valign="bottom" | 29
{{!}} 11
| align="center" valign="bottom" | 500
{{!}} 900
| align="center" valign="bottom" | 250
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Dop inf. 200 mg
{{!}} Imipenem IV 250 mg
| align="center" valign="bottom" | 30
{{!}} 18
| align="center" valign="bottom" | 200
{{!}} 250
| align="center" valign="bottom" | 200
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Dop inf. 400 mg
{{!}} Dobut inf. 250 mg
| align="center" valign="bottom" | 30
{{!}} 29
| align="center" valign="bottom" | 400
{{!}} 250
| align="center" valign="bottom" | 200
{{!}} 250


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Norepi inf. 4 mg
{{!}} Dobut inf. 500 mg
| align="center" valign="bottom" | 40
{{!}} 29
| align="center" valign="bottom" | 4
{{!}} 500
| align="center" valign="bottom" | 8
{{!}} 250


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Norepi inf. 8 mg
{{!}} Dop inf. 200 mg
| align="center" valign="bottom" | 40
{{!}} 30
| align="center" valign="bottom" | 8
{{!}} 200
| align="center" valign="bottom" | 8
{{!}} 200


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Norepi inf. 16 mg
{{!}} Dop inf. 400 mg
| align="center" valign="bottom" | 40
{{!}} 30
| align="center" valign="bottom" | 16
{{!}} 400
| align="center" valign="bottom" | 8
{{!}} 200


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Phenyl inf. 30 mg
{{!}} Norepi inf. 4 mg
| align="center" valign="bottom" | 41
{{!}} 40
| align="center" valign="bottom" | 30
{{!}} 4
| align="center" valign="bottom" | 50
{{!}} 8


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Phenyl inf. 50 mg
{{!}} Norepi inf. 8 mg
| align="center" valign="bottom" | 41
{{!}} 40
| align="center" valign="bottom" | 50
{{!}} 8
| align="center" valign="bottom" | 50
{{!}} 8


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Phenyl inf. 100 mg
{{!}} Norepi inf. 16 mg
| align="center" valign="bottom" | 41
{{!}} 40
| align="center" valign="bottom" | 100
{{!}} 16
| align="center" valign="bottom" | 50
{{!}} 8


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro Tab 250 mg
{{!}} Phenyl inf. 30 mg
| align="center" valign="bottom" | 59
{{!}} 41
| align="center" valign="bottom" | 250
{{!}} 30
| align="center" valign="bottom" | 250
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro Tab 500 mg
{{!}} Phenyl inf. 50 mg
| align="center" valign="bottom" | 59
{{!}} 41
| align="center" valign="bottom" | 500
{{!}} 50
| align="center" valign="bottom" | 250
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Cipro Tab 750 mg
{{!}} Phenyl inf. 100 mg
| align="center" valign="bottom" | 59
{{!}} 41
| align="center" valign="bottom" | 750
{{!}} 100
| align="center" valign="bottom" | 250
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone inf. 150 mg
{{!}} Cipro Tab 250 mg
| align="center" valign="bottom" | 67
{{!}} 59
| align="center" valign="bottom" | 150
{{!}} 250
| align="center" valign="bottom" | 150
{{!}} 250


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone inf. 200 mg
{{!}} Cipro Tab 500 mg
| align="center" valign="bottom" | 67
{{!}} 59
| align="center" valign="bottom" | 200
{{!}} 500
| align="center" valign="bottom" | 150
{{!}} 250


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone inf. 450 mg
{{!}} Cipro Tab 750 mg
| align="center" valign="bottom" | 67
{{!}} 59
| align="center" valign="bottom" | 450
{{!}} 750
| align="center" valign="bottom" | 150
{{!}} 250


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone inf. 300mg
{{!}} Amiodarone inf. 150 mg
| align="center" valign="bottom" | 67
{{!}} 67
| align="center" valign="bottom" | 300
{{!}} 150
| align="center" valign="bottom" | 150
{{!}} 150


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone inf. 600 mg
{{!}} Amiodarone inf. 200 mg
| align="center" valign="bottom" | 67
{{!}} 67
| align="center" valign="bottom" | 600
{{!}} 200
| align="center" valign="bottom" | 150
{{!}} 150


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Propofol inf. 200 mg
{{!}} Amiodarone inf. 450 mg
| align="center" valign="bottom" | 82
{{!}} 67
| align="center" valign="bottom" | 200
{{!}} 450
| align="center" valign="bottom" | 1
{{!}} 150


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Propofol bolus IV 10 mg
{{!}} Amiodarone inf. 300mg
| align="center" valign="bottom" | 82
{{!}} 67
| align="center" valign="bottom" | 10
{{!}} 300
| align="center" valign="bottom" | 1
{{!}} 150


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Propofol bolus IV 20 mg
{{!}} Amiodarone inf. 600 mg
| align="center" valign="bottom" | 82
{{!}} 67
| align="center" valign="bottom" | 20
{{!}} 600
| align="center" valign="bottom" | 1
{{!}} 150


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Propofol inf. 500 mg
{{!}} Propofol inf. 200 mg
| align="center" valign="bottom" | 82
{{!}} 82
| align="center" valign="bottom" | 500
{{!}} 200
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Propofol inf. 1000mg
{{!}} Propofol bolus IV 10 mg
| align="center" valign="bottom" | 82
{{!}} 82
| align="center" valign="bottom" | 1000
{{!}} 10
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Propofol bolus 20 mg
{{!}} Propofol bolus IV 20 mg
| align="center" valign="bottom" | 82
{{!}} 82
| align="center" valign="bottom" | 20
{{!}} 20
| align="center" valign="bottom" | 1
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Heparin SQ 2500 u
{{!}} Propofol inf. 500 mg
| align="center" valign="bottom" | 90
{{!}} 82
| align="center" valign="bottom" | 2500
{{!}} 500
| align="center" valign="bottom" | 5000
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Heparin SQ 5000 u
{{!}} Propofol inf. 1000mg
| align="center" valign="bottom" | 90
{{!}} 82
| align="center" valign="bottom" | 5000
{{!}} 1000
| align="center" valign="bottom" | 5000
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Heparin SQ 7500 u
{{!}} Propofol bolus 20 mg
| align="center" valign="bottom" | 90
{{!}} 82
| align="center" valign="bottom" | 7500
{{!}} 20
| align="center" valign="bottom" | 5000
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Milrinone inf. 10 mg
{{!}} Heparin SQ 2500 u
| align="center" valign="bottom" | 91
{{!}} 90
| align="center" valign="bottom" | 10
{{!}} 2500
| align="center" valign="bottom" | 10
{{!}} 5000


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Milrinone bolus IV 2 mg
{{!}} Heparin SQ 5000 u
| align="center" valign="bottom" | 91
{{!}} 90
| align="center" valign="bottom" | 2
{{!}} 5000
| align="center" valign="bottom" | 10
{{!}} 5000


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Milrinone inf 10 mg
{{!}} Heparin SQ 7500 u
| align="center" valign="bottom" | 91
{{!}} 90
| align="center" valign="bottom" | 10
{{!}} 7500
| align="center" valign="bottom" | 10
{{!}} 5000


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ceftizoxime IV 250 mg
{{!}} Milrinone inf. 10 mg
| align="center" valign="bottom" | 96
{{!}} 91
| align="center" valign="bottom" | 250
{{!}} 10
| align="center" valign="bottom" | 1
{{!}} 10


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ceftizoxime IV 500 mg
{{!}} Milrinone bolus IV 2 mg
| align="center" valign="bottom" | 96
{{!}} 91
| align="center" valign="bottom" | 500
{{!}} 2
| align="center" valign="bottom" | 1
{{!}} 10


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone Tab 100 mg
{{!}} Milrinone inf 10 mg
| align="center" valign="bottom" | 97
{{!}} 91
| align="center" valign="bottom" | 100
{{!}} 10
| align="center" valign="bottom" | 200
{{!}} 10


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Amiodarone Tab 200 mg
{{!}} Ceftizoxime IV 250 mg
| align="center" valign="bottom" | 97
{{!}} 96
| align="center" valign="bottom" | 200
{{!}} 250
| align="center" valign="bottom" | 200
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 25 mg
{{!}} Ceftizoxime IV 500 mg
| align="center" valign="bottom" | 98
{{!}} 96
| align="center" valign="bottom" | 25
{{!}} 500
| align="center" valign="bottom" | 50
{{!}} 1


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 50 mg
{{!}} Amiodarone Tab 100 mg
| align="center" valign="bottom" | 98
{{!}} 97
| align="center" valign="bottom" | 50
{{!}} 100
| align="center" valign="bottom" | 50
{{!}} 200


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 75 mg
{{!}} Amiodarone Tab 200 mg
| align="center" valign="bottom" | 98
{{!}} 97
| align="center" valign="bottom" | 75
{{!}} 200
| align="center" valign="bottom" | 50
{{!}} 200


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 5 mg
{{!}} Metoprolol Tab 25 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 5
{{!}} 25
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 12.5 mg
{{!}} Metoprolol Tab 50 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 12.5
{{!}} 50
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 37.5 mg
{{!}} Metoprolol Tab 75 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 37.5
{{!}} 75
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 100 mg
{{!}} Metoprolol Tab 5 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 100
{{!}} 5
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 125mg
{{!}} Metoprolol Tab 12.5 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 125
{{!}} 12.5
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 150 mg
{{!}} Metoprolol Tab 37.5 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 150
{{!}} 37.5
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 75mg
{{!}} Metoprolol Tab 100 mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 75
{{!}} 100
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Metoprolol Tab 125 mg
{{!}} Metoprolol Tab 125mg
| align="center" valign="bottom" | 98
{{!}} 98
| align="center" valign="bottom" | 125
{{!}} 125
| align="center" valign="bottom" | 50
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | ASA Tab 325 mg
{{!}} Metoprolol Tab 150 mg
| align="center" valign="bottom" | 99
{{!}} 98
| align="center" valign="bottom" | 325
{{!}} 150
| align="center" valign="bottom" | 325
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | ASA Tab 81.25 mg
{{!}} Metoprolol Tab 75mg
| align="center" valign="bottom" | 99
{{!}} 98
| align="center" valign="bottom" | 81.25
{{!}} 75
| align="center" valign="bottom" | 325
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | ASA Tab 81 mg
{{!}} Metoprolol Tab 125 mg
| align="center" valign="bottom" | 99
{{!}} 98
| align="center" valign="bottom" | 81.25
{{!}} 125
| align="center" valign="bottom" | 325
{{!}} 50


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lasix Tab 120 mg
{{!}} ASA Tab 325 mg
| align="center" valign="bottom" | 100
{{!}} 99
| align="center" valign="bottom" | 120
{{!}} 325
| align="center" valign="bottom" | 40
{{!}} 325


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lasix Tab 160 mg
{{!}} ASA Tab 81.25 mg
| align="center" valign="bottom" | 100
{{!}} 99
| align="center" valign="bottom" | 160
{{!}} 81.25
| align="center" valign="bottom" | 40
{{!}} 325


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lasix Tab 20 mg
{{!}} ASA Tab 81 mg
| align="center" valign="bottom" | 100
{{!}} 99
| align="center" valign="bottom" | 20
{{!}} 81.25
| align="center" valign="bottom" | 40
{{!}} 325


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lasix Tab 40 mg
{{!}} Lasix Tab 120 mg
| align="center" valign="bottom" | 100
{{!}} 100
| align="center" valign="bottom" | 40
{{!}} 120
| align="center" valign="bottom" | 40
{{!}} 40


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lasix Tab 80 mg
{{!}} Lasix Tab 160 mg
| align="center" valign="bottom" | 100
{{!}} 100
| align="center" valign="bottom" | 80
{{!}} 160
| align="center" valign="bottom" | 40
{{!}} 40


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lasix Tab 60 mg
{{!}} Lasix Tab 20 mg
| align="center" valign="bottom" | 100
{{!}} 100
| align="center" valign="bottom" | 60
{{!}} 20
| align="center" valign="bottom" | 40
{{!}} 40


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Enalapril Tab 5 mg
{{!}} Lasix Tab 40 mg
| align="center" valign="bottom" | 101
{{!}} 100
| align="center" valign="bottom" | 5
{{!}} 40
| align="center" valign="bottom" | 5
{{!}} 40


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Enalapril Tab 2.5 mg
{{!}} Lasix Tab 80 mg
| align="center" valign="bottom" | 101
{{!}} 100
| align="center" valign="bottom" | 2.5
{{!}} 80
| align="center" valign="bottom" | 5
{{!}} 40


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Enalapril Tab 7.5 mg
{{!}} Lasix Tab 60 mg
| align="center" valign="bottom" | 101
{{!}} 100
| align="center" valign="bottom" | 7.5
{{!}} 60
| align="center" valign="bottom" | 5
{{!}} 40


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Enalapril Tab 10 mg
{{!}} Enalapril Tab 5 mg
| align="center" valign="bottom" | 101
{{!}} 101
| align="center" valign="bottom" | 10
{{!}} 5
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Enalapril Tab 15mg
{{!}} Enalapril Tab 2.5 mg
| align="center" valign="bottom" | 101
{{!}} 101
| align="center" valign="bottom" | 15
{{!}} 2.5
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lisinopril Tab 10 mg
{{!}} Enalapril Tab 7.5 mg
| align="center" valign="bottom" | 102
{{!}} 101
| align="center" valign="bottom" | 10
{{!}} 7.5
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lisinopril Tab 2.5 mg
{{!}} Enalapril Tab 10 mg
| align="center" valign="bottom" | 102
{{!}} 101
| align="center" valign="bottom" | 2.5
{{!}} 10
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lisinopril Tab 5 mg
{{!}} Enalapril Tab 15mg
| align="center" valign="bottom" | 102
{{!}} 101
| align="center" valign="bottom" | 5
{{!}} 15
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Lisinopril Tab 20 mg
{{!}} Lisinopril Tab 10 mg
| align="center" valign="bottom" | 102
{{!}} 102
| align="center" valign="bottom" | 20
{{!}} 10
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Fosinopril Tab 10 mg
{{!}} Lisinopril Tab 2.5 mg
| align="center" valign="bottom" | 103
{{!}} 102
| align="center" valign="bottom" | 10
{{!}} 2.5
| align="center" valign="bottom" | 10
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Fosinopril Tab 5mg
{{!}} Lisinopril Tab 5 mg
| align="center" valign="bottom" | 103
{{!}} 102
| align="center" valign="bottom" | 5
{{!}} 5
| align="center" valign="bottom" | 10
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Fosinopril Tab 5 mg
{{!}} Lisinopril Tab 20 mg
| align="center" valign="bottom" | 103
{{!}} 102
| align="center" valign="bottom" | 5
{{!}} 20
| align="center" valign="bottom" | 10
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ramipril Tab 2.5 mg
{{!}} Fosinopril Tab 10 mg
| align="center" valign="bottom" | 104
{{!}} 103
| align="center" valign="bottom" | 2.5
{{!}} 10
| align="center" valign="bottom" | 5
{{!}} 10


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ramipril Tab 5 mg
{{!}} Fosinopril Tab 5mg
| align="center" valign="bottom" | 104
{{!}} 103
| align="center" valign="bottom" | 5
{{!}} 5
| align="center" valign="bottom" | 5
{{!}} 10


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ramipril Tab 1.25 mg
{{!}} Fosinopril Tab 5 mg
| align="center" valign="bottom" | 104
{{!}} 103
| align="center" valign="bottom" | 1.25
{{!}} 5
| align="center" valign="bottom" | 5
{{!}} 10


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ramipril Tab 7.5 mg
{{!}} Ramipril Tab 2.5 mg
| align="center" valign="bottom" | 104
{{!}} 104
| align="center" valign="bottom" | 7.5
{{!}} 2.5
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ramipril Tab 10 mg
{{!}} Ramipril Tab 5 mg
| align="center" valign="bottom" | 104
{{!}} 104
| align="center" valign="bottom" | 10
{{!}} 5
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Ramipril 1.25mg
{{!}} Ramipril Tab 1.25 mg
| align="center" valign="bottom" | 104
{{!}} 104
| align="center" valign="bottom" | 1.25
{{!}} 1.25
| align="center" valign="bottom" | 5
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Atorvastatin Tab 10 mg
{{!}} Ramipril Tab 7.5 mg
| align="center" valign="bottom" | 105
{{!}} 104
| align="center" valign="bottom" | 10
{{!}} 7.5
| align="center" valign="bottom" | 20
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Atorvastatin Tab 20 mg
{{!}} Ramipril Tab 10 mg
| align="center" valign="bottom" | 105
{{!}} 104
| align="center" valign="bottom" | 20
{{!}} 10
| align="center" valign="bottom" | 20
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Atorvastatin Tab 40 mg
{{!}} Ramipril 1.25mg
| align="center" valign="bottom" | 105
{{!}} 104
| align="center" valign="bottom" | 40
{{!}} 1.25
| align="center" valign="bottom" | 20
{{!}} 5


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Atorvastatin Tab 80 mg
{{!}} Atorvastatin Tab 10 mg
| align="center" valign="bottom" | 105
{{!}} 105
| align="center" valign="bottom" | 80
{{!}} 10
| align="center" valign="bottom" | 20
{{!}} 20


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Pravastatin Tab 10 mg
{{!}} Atorvastatin Tab 20 mg
| align="center" valign="bottom" | 106
{{!}} 105
| align="center" valign="bottom" | 10
{{!}} 20
| align="center" valign="bottom" | 20
{{!}} 20


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Pravastatin Tab 20 mg
{{!}} Atorvastatin Tab 40 mg
| align="center" valign="bottom" | 106
{{!}} 105
| align="center" valign="bottom" | 20
{{!}} 40
| align="center" valign="bottom" | 20
{{!}} 20


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Simvastatin Tab 10 mg
{{!}} Atorvastatin Tab 80 mg
| align="center" valign="bottom" | 107
{{!}} 105
| align="center" valign="bottom" | 10
{{!}} 80
| align="center" valign="bottom" | 20
{{!}} 20


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Simvastatin Tab 20 mg
{{!}} Pravastatin Tab 10 mg
| align="center" valign="bottom" | 107
{{!}} 106
| align="center" valign="bottom" | 20
{{!}} 10
| align="center" valign="bottom" | 20
{{!}} 20


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Simvastatin Tab 40 mg
{{!}} Pravastatin Tab 20 mg
| align="center" valign="bottom" | 107
{{!}} 106
| align="center" valign="bottom" | 40
{{!}} 20
| align="center" valign="bottom" | 20
{{!}} 20


|- style="font-size:11pt"
{{!}}-
| height="14"  valign="bottom" | Nitroglycerin paste/patch
{{!}} Simvastatin Tab 10 mg
| align="center" valign="bottom" | 108
{{!}} 107
| align="center" valign="bottom" | 1
{{!}} 10
| align="center" valign="bottom" | 1
{{!}} 20


|}
{{!}}-
{{!}} Simvastatin Tab 20 mg
{{!}} 107
{{!}} 20
{{!}} 20


== Data Structure ==
{{!}}-
To see the data structure of the [[CCMDB.mdb]] refer to the master version at
{{!}} Simvastatin Tab 40 mg
*{{UNC | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master}}
{{!}} 107
{{!}} 40
{{!}} 20


To see the data structure of the [[HanDBase]] program refer to the master version at
{{!}}-
*{{UNC | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\L_HanDBase\Master| \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\L_HanDBase\Master}}
{{!}} Nitroglycerin paste/patch
{{!}} 108
{{!}} 1
{{!}} 1


{{!}}}


== Related Articles ==
== Related articles ==  
*[[L_Pharm]]
{{Related Articles}}
*[[Pharmacy Collection Other Sites]]
*[[Pharmacy Collection HSC]]




[[Category: Data structure]]
[[Category: Legacy Pharmacy]]
[[Category: Pharmacy]]
}}

Latest revision as of 15:58, 2023 May 17

Legacy Content

This page contains Legacy Content.
  • Explanation: Very old process, but the facet/dropdown data is in here
  • Successor: L Pharm Flowsheet

Click Expand to show legacy content.

Pharmacy Elements Collected for Critical Care

There used to be a table s_Drugs, but it is not in any of our data sources any longer. It's not clear when it was deleted.

The "database code number" in the table below joins the L_Pharm table to resolve the drug in there.

Limit of 16

Only 16 drugs were allowed to be entered for any given patient.

This restriction was hard-coded because a number had to be decided upon to accommodate the flat file data structure of TMSX.

S_Drugs Table

Drug Database Code Number Quantity BaseUnit
No Value 0 0 0
Cefotaxime IV 1 g 4 1 1
Ceftazidime IV 1 g 6 1 1
Ceftazidime IV 500mg 6 0.5 1
Ceftazidime IV 500 mg 6 0.5 1
Ceftriaxone IV 1 g 7 1 1
Cefuroxime IV 200 mg 8 200 1
Cefuroxime IV 250 mg 8 250 1
Cefuroxime IV 750 mg 8 750 1
Cipro IV 200 mg 9 200 1
Cipro IV 400 mg 9 400 1
Cipro IV 600 mg 9 600 1
Cipro IV400 mg 9 400 1
Clindamycin IV 600 mg 11 600 1
Clindamycin IV 250 mg 11 250 1
Clindamycin IV 300 mg 11 300 1
Clindamycin IV 450 mg 11 450 1
Clindamycin IV 900 mg 11 900 1
Imipenem IV 250 mg 18 250 1
Dobut inf. 250 mg 29 250 250
Dobut inf. 500 mg 29 500 250
Dop inf. 200 mg 30 200 200
Dop inf. 400 mg 30 400 200
Norepi inf. 4 mg 40 4 8
Norepi inf. 8 mg 40 8 8
Norepi inf. 16 mg 40 16 8
Phenyl inf. 30 mg 41 30 50
Phenyl inf. 50 mg 41 50 50
Phenyl inf. 100 mg 41 100 50
Cipro Tab 250 mg 59 250 250
Cipro Tab 500 mg 59 500 250
Cipro Tab 750 mg 59 750 250
Amiodarone inf. 150 mg 67 150 150
Amiodarone inf. 200 mg 67 200 150
Amiodarone inf. 450 mg 67 450 150
Amiodarone inf. 300mg 67 300 150
Amiodarone inf. 600 mg 67 600 150
Propofol inf. 200 mg 82 200 1
Propofol bolus IV 10 mg 82 10 1
Propofol bolus IV 20 mg 82 20 1
Propofol inf. 500 mg 82 500 1
Propofol inf. 1000mg 82 1000 1
Propofol bolus 20 mg 82 20 1
Heparin SQ 2500 u 90 2500 5000
Heparin SQ 5000 u 90 5000 5000
Heparin SQ 7500 u 90 7500 5000
Milrinone inf. 10 mg 91 10 10
Milrinone bolus IV 2 mg 91 2 10
Milrinone inf 10 mg 91 10 10
Ceftizoxime IV 250 mg 96 250 1
Ceftizoxime IV 500 mg 96 500 1
Amiodarone Tab 100 mg 97 100 200
Amiodarone Tab 200 mg 97 200 200
Metoprolol Tab 25 mg 98 25 50
Metoprolol Tab 50 mg 98 50 50
Metoprolol Tab 75 mg 98 75 50
Metoprolol Tab 5 mg 98 5 50
Metoprolol Tab 12.5 mg 98 12.5 50
Metoprolol Tab 37.5 mg 98 37.5 50
Metoprolol Tab 100 mg 98 100 50
Metoprolol Tab 125mg 98 125 50
Metoprolol Tab 150 mg 98 150 50
Metoprolol Tab 75mg 98 75 50
Metoprolol Tab 125 mg 98 125 50
ASA Tab 325 mg 99 325 325
ASA Tab 81.25 mg 99 81.25 325
ASA Tab 81 mg 99 81.25 325
Lasix Tab 120 mg 100 120 40
Lasix Tab 160 mg 100 160 40
Lasix Tab 20 mg 100 20 40
Lasix Tab 40 mg 100 40 40
Lasix Tab 80 mg 100 80 40
Lasix Tab 60 mg 100 60 40
Enalapril Tab 5 mg 101 5 5
Enalapril Tab 2.5 mg 101 2.5 5
Enalapril Tab 7.5 mg 101 7.5 5
Enalapril Tab 10 mg 101 10 5
Enalapril Tab 15mg 101 15 5
Lisinopril Tab 10 mg 102 10 5
Lisinopril Tab 2.5 mg 102 2.5 5
Lisinopril Tab 5 mg 102 5 5
Lisinopril Tab 20 mg 102 20 5
Fosinopril Tab 10 mg 103 10 10
Fosinopril Tab 5mg 103 5 10
Fosinopril Tab 5 mg 103 5 10
Ramipril Tab 2.5 mg 104 2.5 5
Ramipril Tab 5 mg 104 5 5
Ramipril Tab 1.25 mg 104 1.25 5
Ramipril Tab 7.5 mg 104 7.5 5
Ramipril Tab 10 mg 104 10 5
Ramipril 1.25mg 104 1.25 5
Atorvastatin Tab 10 mg 105 10 20
Atorvastatin Tab 20 mg 105 20 20
Atorvastatin Tab 40 mg 105 40 20
Atorvastatin Tab 80 mg 105 80 20
Pravastatin Tab 10 mg 106 10 20
Pravastatin Tab 20 mg 106 20 20
Simvastatin Tab 10 mg 107 10 20
Simvastatin Tab 20 mg 107 20 20
Simvastatin Tab 40 mg 107 40 20
Nitroglycerin paste/patch 108 1 1

Related articles

Related articles: