Difference between revisions of "Where does the pharmacy data get stored in the database"
From VistApedia
DavidWhitten (talk | contribs) |
DavidWhitten (talk | contribs) |
||
| Line 1: | Line 1: | ||
= 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: | The Pharmacy data gets stored in the following FileMan Files: | ||
| Line 124: | Line 124: | ||
* [[FILE 59.8]] [[OUTPATIENT CLINIC SORT GROUP]] | * [[FILE 59.8]] [[OUTPATIENT CLINIC SORT GROUP]] | ||
* [[FILE 59.9]] [[PBM PATIENT DEMOGRAPHICS]] | * [[FILE 59.9]] [[PBM PATIENT DEMOGRAPHICS]] | ||
| − | + | ||
[[Category:FAQ]] | [[Category:FAQ]] | ||
Latest revision as of 22:35, 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
