Where does the pharmacy data get stored in the database

= Where does the pharmacy data get stored in the database? =

The Pharmacy data gets stored in the following FileMan Files:


 * FILE 50          DRUG
 * FILE 50.073      DUE QUESTIONNAIRE
 * FILE 50.0731     DUE ANSWER SHEET
 * FILE 50.0732     DUE QUESTION
 * FILE 50.0733     DUE SECTION
 * FILE 50.2        IV CATEGORY
 * FILE 50.3        PRIMARY DRUG
 * FILE 50.35       DRUG APPLICATION
 * FILE 50.4        DRUG ELECTROLYTES
 * FILE 50.416      DRUG INGREDIENTS
 * FILE 50.6        VA GENERIC
 * FILE 50.605      VA DRUG CLASS
 * FILE 50.606      DOSAGE FORM
 * FILE 50.607      DRUG UNITS
 * FILE 50.608      PACKAGE TYPE
 * FILE 50.609      PACKAGE SIZE
 * FILE 50.612      NATIONAL DRUG TRANSLATION
 * FILE 50.621      PMI-ENGLISH
 * FILE 50.622      PMI-SPANISH
 * FILE 50.623      FILE PMI MAP-ENGLISH
 * FILE 50.623      PMI MAP-ENGLISH
 * FILE 50.624      PMI MAP-SPANISH
 * FILE 50.625      WARNING LABEL-ENGLISH
 * FILE 50.626      WARNING LABEL-SPANISH
 * FILE 50.627      [[WARNING LABEL MAP
 * FILE 50.64       VA DISPENSE UNIT
 * FILE 50.67       NDC/UPN
 * FILE 50.68       VA PRODUCT
 * FILE 50.7        PHARMACY ORDERABLE ITEM
 * FILE 50.8        IV STATS
 * FILE 50.9        DRUG COST
 * FILE 51          MEDICATION INSTRUCTION
 * FILE 51.1        ADMINISTRATION SCHEDULE
 * FILE 51.15       ADMINISTRATION SHIFT
 * FILE 51.2        MEDICATION ROUTES
 * FILE 51.23       STANDARD MEDICATION ROUTES
 * FILE 51.24       DOSE UNITS
 * FILE 51.5        ORDER UNIT
 * FILE 51.7        DRUG TEXT
 * FILE 52          PRESCRIPTION
 * FILE 52.11       PATIENT NOTIFICATION (Rx READY)
 * FILE 52.4        RX VERIFY
 * FILE 52.41       PENDING OUTPATIENT ORDERS
 * FILE 52.43       PRESCRIPTION REFILL REQUEST
 * FILE 52.5        RX SUSPENSE
 * FILE 52.51       PHARMACY EXTERNAL INTERFACE
 * FILE 52.52       CLOZAPINE PRESCRIPTION OVERRIDES
 * FILE 52.53       PHARMACY AUTOMATED DISPENSING DEVICES
 * FILE 52.6        IV ADDITIVES
 * FILE 52.7        IV SOLUTIONS
 * FILE 52.8        PHARMACY ARCHIVE
 * FILE 52.85       EPHARMACY MEDICATION PROFILE PREFERENCES
 * FILE 52.86       EPHARMACY SITE PARAMETERS
 * FILE 52.87       PSO AUDIT LOG
 * FILE 52.9        PHARMACY PRINTED QUEUE
 * FILE 52.91       TPB ELIGIBILITY
 * FILE 52.92       TPB INSTITUTION LETTERS
 * FILE 53          RX PATIENT STATUS
 * FILE 53.1        NON-VERIFIED ORDERS
 * FILE 53.2        UNIT DOSE ORDER SET
 * FILE 53.3        ACTIVITY LOG REASON
 * FILE 53.4        PRE-EXCHANGE NEEDS
 * FILE 53.41       MAR LABELS
 * FILE 53.42       INPATIENT BACKGROUND JOB
 * FILE 53.43       MISCELLANEOUS REPORT FILE
 * FILE 53.44       PHYSICIANS' ORDERS
 * FILE 53.45       INPATIENT USER PARAMETERS
 * FILE 53.46       CLINIC DEFINITION
 * FILE 53.5        PICK LIST
 * FILE 53.55       UNIT DOSE/ATC MEDS
 * FILE 53.66       BCMA IV PARAMETERS
 * FILE 53.68       BCMA MISSING DOSE REQUEST
 * FILE 53.69       BCMA REPORT REQUEST
 * FILE 53.7        BCMA BACKUP DATA
 * FILE 53.71       BCMA BACKUP PARAMETERS
 * FILE 53.77       BCMA UNABLE TO SCAN LOG
 * FILE 53.78       BCMA MEDICATION VARIANCE LOG
 * FILE 53.79       BCMA MEDICATION LOG
 * FILE 54          RX CONSULT
 * FILE 55          PHARMACY PATIENT
 * FILE 55.95       DRUG MANUFACTURER
 * FILE 56          DRUG INTERACTION
 * FILE 57.1        PHARMACY QUICK ORDER
 * FILE 57.5        WARD GROUP
 * FILE 57.6        UNIT DOSE PICK LIST STATS
 * FILE 57.7        MEDICATION ADMINISTERING TEAM
 * FILE 57.8        CLINIC GROUP
 * FILE 58.1        PHARMACY AOU STOCK
 * FILE 58.16       AOU INVENTORY TYPE
 * FILE 58.17       AOU ITEM LOCATION
 * FILE 58.19       PHARMACY AOU INVENTORY
 * FILE 58.2        AOU INVENTORY GROUP
 * FILE 58.3        PHARMACY BACKORDER
 * FILE 58.35       RETURN DRUG
 * FILE 58.36       RETURN DRUG CONTRACTOR
 * FILE 58.5        AR/WS STATS FILE
 * FILE 58.8        DRUG ACCOUNTABILITY STATS
 * FILE 58.81       DRUG ACCOUNTABILITY TRANSACTION
 * FILE 58.811      DRUG ACCOUNTABILITY ORDER
 * FILE 58.812      DA UPLOAD
 * FILE 58.82       CS ORDER STATUS
 * FILE 58.83       CS COMPLETION STATUS
 * FILE 58.84       DRUG ACCOUNTABILITY TRANSACTION TYPE
 * FILE 58.85       CS WORKSHEET
 * FILE 58.86       CS DESTRUCTION
 * FILE 58.87       CS CORRECTION LOG
 * FILE 58.88       CS IRL PROGRAM
 * FILE 58.89       CS ERROR LOG
 * FILE 59          OUTPATIENT SITE
 * FILE 59.1        OUTPATIENT AMIS DATA
 * FILE 59.12       OUTPATIENT PHARMACY MANAGEMENT DATA
 * FILE 59.2        WAITING TIME
 * FILE 59.3        GROUP DISPLAY
 * FILE 59.4        INPATIENT SITE
 * FILE 59.5        IV ROOM
 * FILE 59.6        INPATIENT WARD PARAMETERS
 * FILE 59.7        PHARMACY SYSTEM
 * FILE 59.73       VENDOR DISABLE/ENABLE
 * FILE 59.74       VENDOR INTERFACE DATA
 * FILE 59.8        OUTPATIENT CLINIC SORT GROUP
 * FILE 59.9        PBM PATIENT DEMOGRAPHICS