Due : October 8, 2009
ACCESS ASSIGNMENT
Dr. Freeman (Dr. Fre) wishes to plan his summer vacation schedule including family outings and various medical conferences around the world. In order to do so, he must obtain a comprehensive overview of all his surgical procedures dating 3/99-9/99 including the times of each. For the more risky surgical procedures (Sur Proc Related Risk > 1), he needs more time to prepare. He must also notify anesthesiology well ahead of time for patients “at risk” for their procedure (ASA Class > 2,) giving them adequate preparation time as well. As you might suppose, Dr. Freeman has also requested the specific procedures as well as relevant information as to why the patient would be considered “at risk”.
Go to http://vubme.vuse.vanderbilt.edu/King/seniordesign.zip and download the patient database. Create a query to obtain all the relevant information needed for Dr. Freeman’s assessment.
a.) How many cases does Dr. Freeman have to consider over this time period? (include cases that do not have a scheduled date)
b.) How many of these patients are undergoing a risky surgical procedure?
c.) How many of these patients are considered “at risk” for the anesthesiologist’s procedure?
1. From the info you acquired, speculate the reasons why these patients are considered at risk. Be specific.
d.) Dr. Freeman was hoping to take his family to Disney World this summer. He has discount airlines tickets and free passes for dates 6/9/99-6/17/99. Is this feasible? Why/why not?
e.) The American Medical Association Conference is in Honolulu, HA, 5/16/99-5/19/99. Should Dr. Freeman plan to attend-why/why not?
Finally, generate a report containing all the relevant information for Dr. Freeman’s assessment of “at risk” patients so that he can go ahead & notify anesthesiology. (Hint : remember, ASA Class > 2)
Print this out and turn it in with answers to the following info above.
You may work in groups of up to three members on this assignment, be sure to put all names on the material posted to Oak.