View source for S Drugs

 this is a legacy entry; see [[L Pharm Flowsheet]] for new drug collection process

'''Pharmacy Elements Collected for Critical Care'''

The '''S_Drugs''' TABLE contains all the possible values for the [[L_Pharm]] table in [[CCMDB.mdb]].

Drug counts are selected and entered from the [[S_Drugs]] list. 


== Limit of 16 ==
Only 16 drugs are 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]]. 

You can actually enter as many as you want in [[CCMDB.mdb]], but only the 16 with the highest priority will be sent.

==S_Drugs Table==
'''Note: For an the '''most up-to-date list''', go to your s_Drugs table in your CCMDB.mdb - this is for orientation only.'''


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
|- 
|style="font-size:11pt" width="200" height="32"  valign="bottom" | Drug
|style="font-size:8pt" width="48" align="center" valign="bottom" | Database Code Number
|style="font-size:8pt" width="48" align="center" valign="bottom" | Quantity
|style="font-size:8pt" width="48" align="center" valign="bottom" | BaseUnit

|- style="font-size:11pt"
| height="14"  valign="bottom" |  No Value
| 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
| align="center" valign="bottom" | 6
| align="center" valign="bottom" | 0.5
| align="center" valign="bottom" | 1

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Cefuroxime IV 250 mg
| align="center" valign="bottom" | 8
| align="center" valign="bottom" | 250
| align="center" valign="bottom" | 1

|- style="font-size:11pt"
| height="14"  valign="bottom" | Cefuroxime IV 750 mg
| align="center" valign="bottom" | 8
| align="center" valign="bottom" | 750
| align="center" valign="bottom" | 1

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

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

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

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

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Clindamycin IV 300 mg
| align="center" valign="bottom" | 11
| align="center" valign="bottom" | 300
| align="center" valign="bottom" | 1

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

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Dobut inf. 250 mg
| align="center" valign="bottom" | 29
| align="center" valign="bottom" | 250
| align="center" valign="bottom" | 250

|- style="font-size:11pt"
| height="14"  valign="bottom" | Dobut inf. 500 mg
| align="center" valign="bottom" | 29
| align="center" valign="bottom" | 500
| align="center" valign="bottom" | 250

|- style="font-size:11pt"
| height="14"  valign="bottom" | Dop inf. 200 mg
| align="center" valign="bottom" | 30
| align="center" valign="bottom" | 200
| align="center" valign="bottom" | 200

|- style="font-size:11pt"
| height="14"  valign="bottom" | Dop inf. 400 mg
| align="center" valign="bottom" | 30
| align="center" valign="bottom" | 400
| align="center" valign="bottom" | 200

|- style="font-size:11pt"
| height="14"  valign="bottom" | Norepi inf. 4 mg
| align="center" valign="bottom" | 40
| align="center" valign="bottom" | 4
| align="center" valign="bottom" | 8

|- style="font-size:11pt"
| height="14"  valign="bottom" | Norepi inf. 8 mg
| align="center" valign="bottom" | 40
| align="center" valign="bottom" | 8
| align="center" valign="bottom" | 8

|- style="font-size:11pt"
| height="14"  valign="bottom" | Norepi inf. 16 mg
| align="center" valign="bottom" | 40
| align="center" valign="bottom" | 16
| align="center" valign="bottom" | 8

|- style="font-size:11pt"
| height="14"  valign="bottom" | Phenyl inf. 30 mg
| align="center" valign="bottom" | 41
| align="center" valign="bottom" | 30
| align="center" valign="bottom" | 50

|- style="font-size:11pt"
| height="14"  valign="bottom" | Phenyl inf. 50 mg
| align="center" valign="bottom" | 41
| align="center" valign="bottom" | 50
| align="center" valign="bottom" | 50

|- style="font-size:11pt"
| height="14"  valign="bottom" | Phenyl inf. 100 mg
| align="center" valign="bottom" | 41
| align="center" valign="bottom" | 100
| align="center" valign="bottom" | 50

|- style="font-size:11pt"
| height="14"  valign="bottom" | Cipro Tab 250 mg
| align="center" valign="bottom" | 59
| align="center" valign="bottom" | 250
| align="center" valign="bottom" | 250

|- style="font-size:11pt"
| height="14"  valign="bottom" | Cipro Tab 500 mg
| align="center" valign="bottom" | 59
| align="center" valign="bottom" | 500
| align="center" valign="bottom" | 250

|- style="font-size:11pt"
| height="14"  valign="bottom" | Cipro Tab 750 mg
| align="center" valign="bottom" | 59
| align="center" valign="bottom" | 750
| align="center" valign="bottom" | 250

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

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

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

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

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

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

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

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Propofol inf. 1000mg
| align="center" valign="bottom" | 82
| align="center" valign="bottom" | 1000
| align="center" valign="bottom" | 1

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Heparin SQ 2500 u
| align="center" valign="bottom" | 90
| align="center" valign="bottom" | 2500
| align="center" valign="bottom" | 5000

|- style="font-size:11pt"
| height="14"  valign="bottom" | Heparin SQ 5000 u
| align="center" valign="bottom" | 90
| align="center" valign="bottom" | 5000
| align="center" valign="bottom" | 5000

|- style="font-size:11pt"
| height="14"  valign="bottom" | Heparin SQ 7500 u
| align="center" valign="bottom" | 90
| align="center" valign="bottom" | 7500
| align="center" valign="bottom" | 5000

|- style="font-size:11pt"
| height="14"  valign="bottom" | Milrinone inf. 10 mg
| align="center" valign="bottom" | 91
| align="center" valign="bottom" | 10
| align="center" valign="bottom" | 10

|- style="font-size:11pt"
| height="14"  valign="bottom" | Milrinone bolus IV 2 mg
| align="center" valign="bottom" | 91
| align="center" valign="bottom" | 2
| align="center" valign="bottom" | 10

|- style="font-size:11pt"
| height="14"  valign="bottom" | Milrinone inf 10 mg
| align="center" valign="bottom" | 91
| align="center" valign="bottom" | 10
| align="center" valign="bottom" | 10

|- style="font-size:11pt"
| height="14"  valign="bottom" | Ceftizoxime IV 250 mg
| align="center" valign="bottom" | 96
| align="center" valign="bottom" | 250
| align="center" valign="bottom" | 1

|- style="font-size:11pt"
| height="14"  valign="bottom" | Ceftizoxime IV 500 mg
| align="center" valign="bottom" | 96
| align="center" valign="bottom" | 500
| align="center" valign="bottom" | 1

|- style="font-size:11pt"
| height="14"  valign="bottom" | Amiodarone Tab 100 mg
| align="center" valign="bottom" | 97
| align="center" valign="bottom" | 100
| align="center" valign="bottom" | 200

|- style="font-size:11pt"
| height="14"  valign="bottom" | Amiodarone Tab 200 mg
| align="center" valign="bottom" | 97
| align="center" valign="bottom" | 200
| align="center" valign="bottom" | 200

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

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

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

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

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

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

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

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

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

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | ASA Tab 325 mg
| align="center" valign="bottom" | 99
| align="center" valign="bottom" | 325
| align="center" valign="bottom" | 325

|- style="font-size:11pt"
| height="14"  valign="bottom" | ASA Tab 81.25 mg
| align="center" valign="bottom" | 99
| align="center" valign="bottom" | 81.25
| align="center" valign="bottom" | 325

|- style="font-size:11pt"
| height="14"  valign="bottom" | ASA Tab 81 mg
| align="center" valign="bottom" | 99
| align="center" valign="bottom" | 81.25
| align="center" valign="bottom" | 325

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

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

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

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

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

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

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

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

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

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

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Lisinopril Tab 2.5 mg
| align="center" valign="bottom" | 102
| align="center" valign="bottom" | 2.5
| align="center" valign="bottom" | 5

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Fosinopril Tab 10 mg
| align="center" valign="bottom" | 103
| align="center" valign="bottom" | 10
| align="center" valign="bottom" | 10

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

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

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

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

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

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

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

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

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

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

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

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

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Pravastatin Tab 20 mg
| align="center" valign="bottom" | 106
| align="center" valign="bottom" | 20
| align="center" valign="bottom" | 20

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Simvastatin Tab 20 mg
| align="center" valign="bottom" | 107
| align="center" valign="bottom" | 20
| align="center" valign="bottom" | 20

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

|- style="font-size:11pt"
| height="14"  valign="bottom" | Nitroglycerin paste/patch 
| align="center" valign="bottom" | 108
| align="center" valign="bottom" | 1
| align="center" valign="bottom" | 1

|}

== Data Structure ==
To see the data structure of the [[CCMDB.mdb]] refer to the master version at
*{{UNC | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master}}

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

[[Category: Legacy Pharmacy]]