/******************************************************************************
   NAME:       clean_out_outppharm4X_arms.sql
   PURPOSE:    This script will remove all records from the outppharm schema
   ADDITIONAL INFORMATION:

    
   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.1        02/04/2008  M. Jacobsen      - Initial Release
******************************************************************************/
    
-- Remove all entries from Outpatient Pharmacy schema
delete from activity_log;
delete from pharmacy_instruction;
delete from OUTPPHARM_TREATMENT_FACTOR;
delete from MEDICATION_INSTRUCTION;
delete from dispense_comment;
delete from current_provider_comment;
delete from outpatient_med_dsp;
delete from patient_INSTRUCTION;
delete from expanded_patient_instruction;
delete from other_patient_instruction;
delete from cancel_comment;
delete from outppharm_sig;
delete from OUTPATIENT_MED_PRM;

commit;

