View source for 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]]


[[Category:FAQ]]