Data Retrieval Using DML and ICD-10 Codes in Healthcare

School: Macomb Community College - Course: HITT 1210 - Subject: Accounting

HITT 1211 Project Week 10 Instructions You are to read the following report request.Then using Data Manipulation Language (DML) and ICD 10 CM/PCS codes, you are to retrieve the data from the database (Excel report).List your search process and then provide the patient names you found that met the criteria for your request. 1) First you need to determine the ICD-10-CM or PCS code needed in each scenario. 2) Then using the data tab on excel, use the filter funnel.This will put little down arrows under each column in the excel spreadsheet. 3) Go through each scenario and "filter" your criteria until you have the patients who meet each scenario need. Request 1 Find all patients who left AMA with a diagnosis of a typical chest pain. Jennifer Reader and Stone Jackson Request 2 Provide a listing of all patients with a diagnosis of anxiety with depression due to an acute stress reaction and were discharged to a psychiatric hospital. Max Verlander, Richard Q. Jackson, and Dora R. Mark Request 3 Provide a listing of all patients discharged with an insurance type of Allstate, who are age 70 and had a diagnosis of congestive heart failure. Patricia A. Miller Request 4 Search for all male patients who had a radical prostatectomy performed via laparoscopic robotic assistance that went home and had Blue Cross health insurance. John M. Doe Jr., Stephen W. Ross, and David V. Moots

Expert's Answer

Your future, our responsibilty submit your task on time.

Order Now

Need Urgent Academic Assistance?

Price Starts from $10 Per Page

*
*
*
*

TOP
Order Notification

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.