Revision as of 22:34, 24 June 2014

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