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.
| 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 |
Data Structure
To see the data structure of the CCMDB.mdb refer to the master version at
- \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master | \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs\Master