Site hosted by Angelfire.com: Build your free website today!

Report Generation

 

To create reports based on the PharmaBains solution database you must first have an Oracle Report Builder.  These reports have been designed for printing and are best displayed in paper format, but could be run in web format as well.

 

To run a report, you must first open the Oracle Report Builder. Select one of the following three files from which you would like to create a report.

 

PatientBillingHistory.jsp

PatientDrugHistoryreport.jsp

PatientOutcome.jsp

 

The Patient Billing History file contains all patients as well as the billing totals for each drug.  There is a total for the amount billed per drug per patient, the total the patient was billed for all drugs, as well as a grand total of a patient-billing amount stated at the end of the report.

 

To run the report you must choose the run paper report from the menu bar.

 

 

The image below demonstrates the last page of the report in the Report Builder to illustrate the total and grand total formats.

 

 

 

 

To print the report left click on the printer image on the top left hand corner of the screen.

 

 

 The patient drug history report shows the patient prescription history. It is ordered based on drug and Phn. 

Below is a sample of the Patient Prescription History report.

 

 

 

The third report option is the Patient Outcome Report.  This report displays the patient outcomes from particular drug treatments.  Pharmacy clinicians studying patient outcomes from their drug prescription will use this report. It is ordered by Din.