
TRUNCATE TABLE PPSNEPL.EPL_NATIONAL_SETTINGS;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_FDB_GENERIC_NAME;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_FDB_DOSAGE_FORM;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_FDB_DRUG_UNITS;                                                                                                  
TRUNCATE TABLE PPSNEPL.EPL_FDB_DRUG_INGREDIENT;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_FDB_DRUG_CLASS;                                                                                                  
TRUNCATE TABLE PPSNEPL.EPL_FDB_PRODUCT;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_FDB_NDC;                                                                                                         
TRUNCATE TABLE PPSNEPL.EPL_FDB_ADD;                                                                                                         
TRUNCATE TABLE PPSNEPL.EPL_FDB_UPDATE;                                                                                                      
TRUNCATE TABLE PPSNEPL.EPL_FDB_AUTO_ADD;                                                                                                    
TRUNCATE TABLE PPSNEPL.EPL_FDB_AUTO_UPDATE;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_FDB_MONOGRAPH_PEM;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_FDB_GCNSEQNO_PEM;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_MIGRATION_ERROR;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_MIGRATION_FILE;                                                                                                  
TRUNCATE TABLE PPSNEPL.EPL_MIGRATION_CONTROL;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_OI_ADMIN_SCHED_ASSOCS;                                                                                           
TRUNCATE TABLE PPSNEPL.EPL_MED_INSTRUCT_WARDS;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_MEDICATION_INSTRUCTIONS;                                                                                         
TRUNCATE TABLE PPSNEPL.EPL_OI_MED_ROUTE_ASSOCS;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_DF_MED_RT_DF_ASSOCS;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_PACKAGE_USE_ASSOCS;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_LOCAL_MED_ROUTES;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_LOCAL_POSSIBLE_DOSAGES;                                                                                          
TRUNCATE TABLE PPSNEPL.EPL_SEQ_NUMS;                                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_PARTIAL_SAVE_MGT;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_VADF_EDITABLE_PROPERTIES;                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_MULTI_TEXT;                                                                                                      
TRUNCATE TABLE PPSNEPL.EPL_VADF_NONLIST_VALUES;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_VADF_ASSOC_VALUES;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_VADF_OWNERS;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_REQUEST_DETAILS;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_REQUESTS;                                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_NDCS;                                                                                                            
TRUNCATE TABLE PPSNEPL.EPL_PACKAGE_TYPES;                                                                                                   
TRUNCATE TABLE PPSNEPL.EPL_MANUFACTURERS;                                                                                                   
TRUNCATE TABLE PPSNEPL.EPL_PROD_DRUG_TEXT_L_ASSOCS;                                                                                         
TRUNCATE TABLE PPSNEPL.EPL_PROD_WARN_LABEL_N_ASSOCS;                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_PROD_WARN_LABEL_L_ASSOCS;                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_PRODUCT_LABS;                                                                                                    
TRUNCATE TABLE PPSNEPL.EPL_PRODUCT_VITALS;                                                                                                  
TRUNCATE TABLE PPSNEPL.EPL_PROD_INGREDIENT_ASSOCS;                                                                                          
TRUNCATE TABLE PPSNEPL.EPL_SYNONYMS;                                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_PROD_SPEC_HANDLING_ASSOCS;                                                                                       
TRUNCATE TABLE PPSNEPL.EPL_NDC_BY_OUTPATIENT_SITE_NDC;                                                                                      
TRUNCATE TABLE PPSNEPL.EPL_NATIONAL_POSSIBLE_DOSAGES;                                                                                       
TRUNCATE TABLE PPSNEPL.EPL_ATC_CANISTERS;                                                                                                   
TRUNCATE TABLE PPSNEPL.EPL_PROD_DRUG_CLASS_ASSOCS;                                                                                          
TRUNCATE TABLE PPSNEPL.EPL_IFCAP_ITEM_NUMBERS;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_PROD_DRUG_TEXT_N_ASSOCS;                                                                                         
TRUNCATE TABLE PPSNEPL.EPL_PRODUCTS;                                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_DOSE_UNIT_SYNONYMS;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_DOSE_UNITS;                                                                                                      
TRUNCATE TABLE PPSNEPL.EPL_VA_DRUG_CLASSES;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_CLASS_TYPES;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_PRINT_FIELDS;                                                                                                    
TRUNCATE TABLE PPSNEPL.EPL_ITEM_AUDIT_HISTORY_DETAILS;                                                                                      
TRUNCATE TABLE PPSNEPL.EPL_VA_GEN_NAMES;                                                                                                    
TRUNCATE TABLE PPSNEPL.EPL_STANDARD_MED_ROUTES;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_LABS;                                                                                                            
TRUNCATE TABLE PPSNEPL.EPL_ORDER_UNITS;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_DF_UNITS;                                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_DF_NOUNS;                                                                                                        
TRUNCATE TABLE PPSNEPL.EPL_CMOP_ID_GENERATOR;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_NDF_SYNCH_QUEUE;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_SITE_UPDATE_SCHEDULES;                                                                                           
TRUNCATE TABLE PPSNEPL.HIBERNATE_UNIQUE_KEY;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_SEARCH_CRITERIA;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_WARN_LABELS;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_OI_DRUG_TEXT_L_ASSOCS;                                                                                           
TRUNCATE TABLE PPSNEPL.EPL_OI_DRUG_TEXT_N_ASSOCS;                                                                                           
TRUNCATE TABLE PPSNEPL.EPL_VITALS;                                                                                                          
TRUNCATE TABLE PPSNEPL.EPL_ORDERABLE_ITEMS;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_VADF_LOVS;                                                                                                       
TRUNCATE TABLE PPSNEPL.EPL_VA_DFS;                                                                                                          
TRUNCATE TABLE PPSNEPL.EPL_DISPENSE_UNITS_PER_DOSE;                                                                                         
TRUNCATE TABLE PPSNEPL.EPL_DOSAGE_FORMS;                                                                                                    
TRUNCATE TABLE PPSNEPL.EPL_SPECIAL_HANDLING;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_INTERFACE_COUNTERS;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_SEARCH_TEMPLATES;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_PRINT_TEMPLATES;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_NOTIFICATION_STATUS;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_LOCAL_CONSOLE_INFO;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_PACKAGE_USAGES;                                                                                                  
TRUNCATE TABLE PPSNEPL.EPL_NOTIF_USER_PREFS;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_DT_SYNONYMS;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_DRUG_TEXT;                                                                                                       
TRUNCATE TABLE PPSNEPL.EPL_INTENDED_USES;                                                                                                   
TRUNCATE TABLE PPSNEPL.EPL_VA_DISPENSE_UNITS;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_SESSION_PREFERENCES;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_DRUG_UNITS;                                                                                                      
TRUNCATE TABLE PPSNEPL.EPL_WARDS;                                                                                                           
TRUNCATE TABLE PPSNEPL.EPL_HOSPITAL_LOCATIONS;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_ADMIN_SCHEDULES;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_USERS;                                                                                                           
TRUNCATE TABLE PPSNEPL.EPL_INGREDIENTS;                                                                                                     
TRUNCATE TABLE PPSNEPL.EPL_OI_SCHEDULE_TYPES;                                                                                               
TRUNCATE TABLE PPSNEPL.EPL_ITEM_AUDIT_HISTORY;                                                                                              
TRUNCATE TABLE PPSNEPL.EPL_NOTIFICATIONS;                                                                                                   
TRUNCATE TABLE PPSNEPL.EPL_SITE_CONFIGS;                                                                                                    
TRUNCATE TABLE PPSNEPL.EPL_SCHEDULE_TYPES;                                                                                                  
TRUNCATE TABLE PPSNEPL.EPL_CMOP_ID_HISTORY;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_CS_FED_SCHEDULES;                                                                                                
TRUNCATE TABLE PPSNEPL.EPL_PHARMACY_SYSTEM;                                                                                                 
TRUNCATE TABLE PPSNEPL.EPL_VUID_STATUS_HISTORY;                                                                                             
TRUNCATE TABLE PPSNEPL.EPL_REDUCED_COPAY;                                                                                                   
