Where does the pharmacy data get stored in the database
From VistApedia
Revision as of 22:35, 24 June 2014 by DavidWhitten (talk | contribs)
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]]
