Abstract: The present invention discloses about a web based portal developed for physician's clinical research & related clinic operations workflow management. The web based portal is a software application that offers the capability to integrate with pharmacy order processing systems, which helps to keep track of patient prescription history in an automated environment. For specifically selected patients, the application extracts pharmacy ordering data from order processing systems and attaches this same data to the electronic patient medical profile. This greatly assists the physician in knowing the status of the patient's prescription history at any given point in time. Further the application offers the capability to integrate with related lab test results using HL7 interface system which helps in creating a comprehensive laboratory test results environment to patient medical profile in automated manner.