integrated medical care n.
Skip this Video
Loading SlideShow in 5 Seconds..
Integrated Medical Care PowerPoint Presentation
Download Presentation
Integrated Medical Care

Loading in 2 Seconds...

play fullscreen
1 / 10

Integrated Medical Care - PowerPoint PPT Presentation

  • Uploaded on

Integrated Medical Care. Jennifer An Tom Granovsky Jason Kirschtel Jacob Lippold Yifeng Wang. Project Background. Tom interned at Integrated Medical Care in the Summer of 2012.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Integrated Medical Care

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
integrated medical care

Integrated Medical Care

Jennifer An

Tom Granovsky

Jason Kirschtel

Jacob Lippold

Yifeng Wang

project background
Project Background
  • Tom interned at Integrated Medical Care in the Summer of 2012.
  • His job was to locate inactive patient’s files which were stored throughout hundreds of boxes by using trial and error.
  • It was possible for it to take multiple hours to find one patient’s file because weren’t organized.
business problem
Business Problem
  • All inactive patient’s files must be held for 7 years since their last visit
  • Patient’s inactive files were thrown into the boxes
  • To find the file, you had to search through each box.
  • Very time consuming and unorganized
  • Need a more organized way to locate patient’s files when they need medical information
business opportunity
Business Opportunity
  • Provide the company with a list of the most used insurance companies.
  • Sort which doctors can treat specific injuries, and show how busy they currently are.
  • Show the most common types of injuries treated, to help keep inventory up to date.
  • Get reports of when files can be discarded (after 7 years).
business value
Business Value
  • The database will increase efficiency, and increase organization throughout the company.
  • This database will give IMC a way to locate files in a matter of minutes rather than hours.

ERD Design




  • Social Security # (P)
  • First Name
  • Last Name
  • Birth Date
  • Insurance
  • Validated
  • Box #
  • Special Notes
  • Social Security # (F)
  • Employee ID (F)
  • Injury ID (P)
  • Date of Accident
  • Injury Type
  • Treatment Type
  • Diagnosis
  • Visit Date
  • Special Notes
  • Employee ID (P)
  • First Name
  • Last Name
  • Field of Medicine
  • Date of Employment
  • This database gives the company a tool find which box a patient’s file is located in.
  • It also provides reports listing which patient is assigned to which doctor, and tells us which doctor handles specific injuries.
  • Integrated Medical Care should improve efficiency and decrease lag time when locating patient files.