Reporting Module

Owned by Harsh Chhabra (Unlicensed)
Last updated: Jun 16, 2013 by John V Stoecker (Unlicensed)

Overview :

Raxa laboratory module needs to generate a variety of reports: mainly daily log, exception reports, monthly statistics of patients and orders, quality control charts.which is currently unavailable. The aim of this project is to add a module after which we will be able to generate various stats .This can be achieved by creating a web interface using html-javascript/Jsp integrated through(with) java and java BIRT, BIRT:which is responsible for report generation.It includes authorized access and security also.

Major Features of the module:

  • Online web interface for creating reports, including
    • log in page for doctors
    • list of all possible reports to choose from
    • ability to export lists as html, excel, csv, pdf, email and print
  • BIRT engine will only authorize the current doctor to access their own patients
  • Testing will certify that doctors cannot access unauthorized patients
  • The logged in doctor can see the all stats of patients visited to them, like how many treated for specific diseases,How many seen by him till or in particular time.
  • All possible information available for each patient : what tests he/she had,contact information , visiting dates and over all progress.
  • Orders and purchase reports.
  • Information on particular drug.
  • How many patients treated well till now by a doctor and how many having still status as open.

List of Reports:

  • Patient discharge reports
    • Full patient history including all details of encounters, orders, and obs
    • Current patient history with all OUTPATIENT, SCREENERVITALS, and PRESCRIPTION encounters from today (or last active day)
  • Clinic overview reports
    • List of all patients seen with certain time period (day/month/year)
    • Daily log report with all activity
  • Drug reports
    • List of all drugs prescribed to patients over a certain time peiod
  • Disease reports
    • List of all obs created over a certain time period

Implementation detail:

1.Create reports using current database through BIRT.

2.Integrate it through java using BIRT engine api.

3.Integrate with user interface using Jsps.

  • Interface to generate report ,allow user to set parameters for customized report includes security checks for unauthorized access.
  • View report ,options to save it  and print it.

Brief Work Timeline:

  • Till 17 or 18 June :Very first report on patients ,patients visited to a doctor as web app on server. 
  • Till mid term evaluation(July end :Almost one and half month) : create other reports in order given by mentor.

Deliverables/Deadlines:

  • Mid term evaluation:
    • Login page complete, page containing list of reports made
    • 6 reports complete
    • Framework for security done for all reports
    • Tested to be secure using (your testing framework)
  • Final evaluation:
    • Pending reports complete
    • Time left for additional reports
    • Nice-to-haves:
      • (Nice-to-haves, extra features here)



See proposed details on google-melange.