Inpatient Readmissions

Content Type

User Generated

User

ororggre

Subject

Health Medical

Description

Database Assignment #2Inpatient Readmissions

All data in this assignment is fictitious. Medical record numbering identifies each individual patient from your study in HIT 1200.Remember, patients may have the same name, but they do not have the same medical record number.

For a quick study of the ACA section establishing the Hospital Readmissions Reduction Program for this assignment, read http://healthaffairs.org/blog/2014/07/24/examining...

Please note that for the purposes of this assignment, HF (heart failure) will be correlated to CHF (congestive heart failure, and PN (pneumonia) will be correlated to pneu or pneumonia.

Case Study

Willie Getwell Hospital has identified the CMS IPPS proposed legislation and in preparation for this legislation, they are tracking their 30-day readmission data.They have recently set in place an organization-wide education and discharge medication verification program for their patients.Please help the health information management director gather appropriate information to be shared with hospital leadership.She hopes the December numbers will continue to show an improvement.

You are provided an excel spreadsheet of information downloaded via a query from the hospital’s database.This is your sample data of November and December records.Apply the knowledge you gained from MIS 3100.For example, this assignment demonstrates how if the hospital were to change electronic health records, why information, such as data dictionaries, from one EHR would need to be identical to the other, or an interface would have to be developed.

Objective #1:

In the 1^st and 2^nd excel worksheet tabs, sort the November and December discharge data pertaining to AMI, CHF, and pneumonia to determine any readmissions within 30 days for the hospital for December discharges for these specific diagnoses identified by ICD-9 coding: AMI 410.0-410.9, CHF 428, pneumonia 486 on primary diagnosis.Recommend copying the November and then the December discharge data side by side in a blank worksheet tab FOR EACH ICD-9 code.Sort both November and December by the column for the ICD code.Compare November against December to find the duplicate readmissions FOR EACH ICD-9 code.

Transfer your calculations (the number of duplicate readmissions) determined for December 30-day readmissions onto the 3rd tab, 2010 IPPS 30-day Readmit Rates for each ICD-9 code in the yellow highlighted column..In the 3^rd tab, derive the percentage of readmits by month and diagnosis in the format provided.Have Excel compute the percentage for you.In cell B12 enter the formula to divide Readmits for AMI by Total Discharges.Pull the formula to the right through to act on the remaining months.Do the same for CHF and Pneu.

Objective #2:

Apply the 2010 data to reporting graphics (using a excel-generated chart) to demonstrate trending.Apply titles and labels.What chart describes the trend most clearly?Presentation should clarify the trend clearly to the hospital leadership. Highlight all of these rows and columns in the 3^rd tab, including the header rows.Choose the Insert tab from the Ribbon at the top of Excel.Choose Charts.Try several charts.Which chart displays the trend most effectively?

Objective #3:

Were Willie Getwell Hospital’s efforts to improve their 30-day readmission rates preliminarily effective according to the information gathered from this assignment?Summarize your analysis textually in a textbox.Insert a text box.Compose a paragraph summarizing your analysis.Describe the trend for each of the ICD-9 codes.Have Getwell Hospital’s efforts been effective?Describe research that you have found that addresses this subject.

Objective #4:

Present your analysis in a hospital board-worthy presentation. Create a 4^th tab within the spreadsheet. Name the fourth worksheet tab Summary 2010 30-day Readm Trend.Note that presentation is a factor in the rubric criteria.Use color to tie coordinating elements together.Label your chart.Include a list of your references.

In a fourth worksheet tab, present your summary information:

1. The numbers determined for 30 day readmissions

2. Trending chart

3. Textual summary

Submit the entire spreadsheet as a document in Assignment Files.

Save assignment with the name:lastname, firstname, DB2 Readmissions.

Anecdotal information regarding this assignment:The ICD-9 coding used in this assignment is to demonstrate that a health information professional may have to look at and understand historical data displayed from ICD-9 coding.The coding required to be identified from this assignment is not meant to be encompassing of all coding required to be tracked for the 30-day readmission criteria for these diagnoses for determination of IPPS.

Data Base Rubric			Max Points:120
	0	3		5	10	20	30
Accuracy		3-4 errors		1-2 errors			No errors present
Complete: All instructions preformed	None of the elements present	1 element present			2 elements present		All elements present
Presentation					A few presentation elements are used to good effect	Several presentation elements used to good effect.	Chart with title & legends clearly displays trend.Text summary set off effectively.Bolding, highlights, & color fill draws attention to significant elements.Percentages are rounded.Summary tab is printable on one page.
Comprehension	Demonstrates no comprehension	Demonstrates little comprehension		Comprehension is demonstrated	Synthesized information from another source with your analysis.	Synthesize information from more than one quality source with your analysis. Credit source in citation and reference.

Unformatted Attachment Preview

Patient FirstPatient Name LastGender Name Cristy Acey F Jerry Acuff M Zulma Alcon F Kim Alvero F Divina Avina F Lucille Baskerville F Talisha Baskette F Lyman Bedard M Frida Belton F Gisela Beringer F Delsie Bernabe F Annmarie Bisignano F Rocco Boddy M Randy Bogen M Ron Bosque M Lavone Braham M Cleopatra Brakebill F Stephania Cafferty F Bao Cajigas M Eileen Canino F Arletta Caperton F Jenise Carden F Sherman Chien M Kami Condon F Joy Coolbaugh F Angelia Cort F Yolanda Courson F Zoraida Digby F Francesco Domenick M Darell Donner M Rosalyn Dubay F Ronna Dyer F Ezra Edick M Cyndy Effler F Gillian Emrick F Lakeshia Erb F Kristopher Espitia M Hassie Farrelly F Stormy GeogheganF Jacklyn Gothard F Stephen Greenlaw M Hoa Gwin M Camilla Halley F Elden Hallinan M Lyda Hallinan F Otis Handley M DOB Zip Code Medical RecordInsurance # Carrier Adm DateDisch Date 8/8/1985 46825 73- 90- 05 MCARE 10/29/2010 12/12/1955 46755 16- 74- 90 MCARE 10/31/2010 6/28/1952 46755 61- 28- 41 MCARE 11/19/2010 10/10/1990 46755 10- 66- 98 SELFP 11/21/2010 12/9/1952 46755 66- 27- 24 MCAID 11/6/2010 1/28/1930 46825 41- 70- 98 MCARE 11/20/2010 1/17/1951 46231 56- 43- 18 MCAID 11/4/2010 11/6/1948 46755 48- 06- 11 MCARE 10/29/2010 4/13/1942 46231 10- 88- 82 MCAID 11/18/2010 7/27/1945 46755 20- 54-09 MCARE 11/20/2010 8/2/1953 46231 25- 73- 80 SELFP 11/24/2010 4/7/1949 46825 61- 31- 46 MCARE 11/6/2010 6/13/1939 46755 82- 66- 42 MCARE 11/7/2010 8/29/1933 46231 95- 98- 54 MCARE 11/2/2010 7/15/1949 46231 58- 29- 99 MCARE 11/21/2010 8/21/1963 46231 03- 35- 20 MCARE 11/10/2010 7/11/1937 46755 54- 04- 29 MCAID 11/11/2010 3/17/1977 46755 99- 80- 98 MCARE 11/7/2010 4/28/1947 46231 31- 12- 38 MCARE 11/15/2010 6/16/1952 46825 70- 46- 24 MCAID 11/12/2010 10/23/1961 46825 45- 21- 34 MCARE 11/15/2010 2/8/1949 46231 14- 80- 04 MCARE 11/6/2010 1/14/1935 46755 82- 39- 08 MCARE 11/5/2010 2/16/1934 46825 71- 80- 25 MCARE 11/6/2010 2/16/1961 46755 38- 73- 28 MCARE 11/15/2010 5/23/1941 46231 08- 40- 94 MCARE 11/17/2010 8/4/1952 46231 91- 28- 21 MCARE 11/4/2010 12/29/1949 46231 04- 97- 41 MCAID 11/5/2010 12/16/1966 46755 55- 66- 42 MCARE 11/23/2010 3/19/1961 46825 23- 21- 62 MCARE 11/25/2010 2/8/1964 46231 57- 16- 91 SELFP 11/13/2010 3/17/1949 46231 93- 59- 42 MCARE 11/20/2010 5/27/1955 46755 95- 48- 98 MCARE 11/21/2010 8/1/1970 46231 87- 03- 53 MCARE 10/28/2010 11/26/1967 46825 55- 66- 92 MCARE 11/13/2010 8/26/1940 46825 62- 77- 42 MCARE 11/13/2010 1/10/1938 46231 17- 11- 75 MCARE 11/22/2010 8/1/1942 46755 44- 50- 16 MCARE 11/22/2010 7/27/1950 46755 13- 08- 54 MCARE 11/7/2010 11/1/1949 46755 69- 59- 39 MCARE 11/3/2010 6/28/1936 46755 34- 19- 85 MCARE 11/12/2010 12/10/1957 46755 98- 13- 18 MCARE 11/1/2010 12/28/1985 46755 02- 32- 10 MCARE 11/14/2010 11/5/1955 46755 99- 41- 27 MCARE 11/11/2010 1/10/1945 46755 48- 50- 49 MCAID 11/11/2010 11/30/1970 46231 89- 65- 09 MCARE 11/13/2010 Myesha Harter F Ida Haynie F Cherie Heasley F Milford Hochman M Adena Hochmuth F Basilia Hollinger F Mozelle Houpt M Loan Huie M Britt Hultgren F Angella Hussein F Shameka Jahn F Eryn Johnsrud F Cody Kennerly M Kyra Kibby F Trenton Knorr M Sebastian Kohn M Dayle Kropf M Frederic Kua M Kelsie Laliberte F Viva Laman F Otelia Lashua F Elouise Lavallie F Natisha Lavin F Ariel Lebouef F Leon Lenox M Bernie Leonhardt M Elvira Lin F Cassie Loesch F Tracey Lohman F Laronda Magnus F Meaghan Markus F Annett Mccafferty F Ezekiel Mcloud M Ronni Mcmurtry M Sharyl Meints F Clement Molitor M Kala Neeld F Eleonore Paetzold F Vina Pankow F Jack Parada M Leena Paris F Patient FirstPatient Name LastGender Name Era Pesola M Agustina Plott F Shayne Popejoy M Fanny Potvin F Olene Poyner F 11/7/1950 46231 76- 20- 06 MCARE 11/17/2010 7/9/1961 46755 94- 31- 83 MCARE 11/7/2010 10/12/1945 46755 86- 80- 33 MCARE 11/7/2010 12/1/1940 46755 75- 77- 24 MCARE 11/7/2010 12/5/1941 46825 93- 42- 07 MCARE 11/11/2010 7/8/1983 46231 93- 61- 22 MCARE 11/4/2010 12/13/1952 46825 57- 99- 37 MCAID 11/15/2010 10/1/1975 46755 37- 78- 45 MCARE 11/15/2010 3/25/1940 46755 91- 13-05 MCARE 11/24/2010 9/15/1947 46231 93- 48- 05 MCAID 11/24/2010 9/26/1937 46755 31- 21- 17 MCARE 11/24/2010 10/24/1939 46755 88- 09- 63 MCARE 11/14/2010 8/12/1957 46755 53- 65- 44 MCARE 11/16/2010 5/14/1958 46825 21- 26- 24 MCAID 11/5/2010 6/9/1970 46231 51- 67- 90 MCARE 11/19/2010 5/31/1956 46231 79- 45- 16 MCARE 11/21/2010 1/31/1935 46825 11- 88- 49 MCARE 11/14/2010 12/29/1948 46231 73- 21- 48 MCARE 11/10/2010 10/11/1934 46755 48- 97- 51 MCARE 11/23/2010 9/16/1929 46825 79- 82- 87 MCARE 11/22/2010 6/29/1949 46231 25- 51- 29 MCARE 11/14/2010 8/1/1964 46825 86- 52- 94 MCARE 10/30/2010 4/28/1941 46825 21- 27- 58 MCARE 11/6/2010 12/14/1947 46755 24- 09- 52 MCARE 11/14/2010 4/3/1938 46825 60- 11- 76 MCARE 11/14/2010 4/12/1950 46755 87- 80- 16 MCARE 11/17/2010 7/28/1931 46825 87- 31- 52 MCARE 11/13/2010 10/16/1936 46755 13- 96- 23 MCARE 11/23/2010 3/11/1961 46231 47- 18- 97 MCARE 11/23/2010 11/17/1949 46755 61- 28- 75 MCARE 11/20/2010 11/10/1946 46231 29- 48- 49 SELFP 11/8/2010 10/8/1928 46755 57- 86- 44 MCARE 11/21/2010 8/29/1951 46825 45- 78- 54 MCARE 11/19/2010 4/22/1951 46755 64- 27- 34 MCARE 11/14/2010 4/11/1933 46231 55- 60- 63 SELFP 11/20/2010 10/2/1941 46825 24- 04- 63 MCARE 11/18/2010 9/10/1942 46231 31- 03- 16 MCARE 11/14/2010 6/19/1944 46755 56- 24- 68 MCARE 10/31/2010 4/11/1936 46825 94- 24- 75 SELFP 11/22/2010 11/10/1960 46231 03- 35-09 MCARE 11/4/2010 2/4/1961 46231 44- 74- 93 MCARE 11/4/2010 DOB Zip Code Medical RecordInsurance # Carrier Adm DateDisch Date 3/22/1952 46825 42- 75- 27 MCARE 11/17/2010 11/24/1954 46755 86- 70- 25 MCARE 11/26/2010 9/15/1949 46825 93- 77- 70 MCARE 11/8/2010 11/13/1942 46825 49- 72- 16 MCARE 11/9/2010 4/2/1961 46825 92- 75- 61 MCARE 11/1/2010 Erick Tamra Katrina Janessa Lizette Savannah Lane Neil Ling Evangelina Crista Tania Tina Adeline Cary Livia Reed Nan Adelle Laura Darin Nilsa Lashawna Latia Crysta Treasa Maurita Inga Nevada Susannah Marquis Ardell Hortencia Preas M Purtee F Quesenberry F Rakestraw F Reindl F Remer F Rhodes M Ribeiro M Ritz M Robinett F Rowles F Sacks F Sandifer F Sanford F Scheurer M Shankle F Shattles M Shotwell F Spinner F Stead F Tolman M Torpey F Vreeland F Waite F Weis F Weissinger F Wiener F Wommack F Wrona F Yarbrough F Yeater M Yeung F Yost F 8/4/1984 6/7/1960 8/18/1936 2/7/1959 3/22/1976 8/18/1937 7/8/1943 8/8/1941 12/16/1947 4/19/1955 12/31/1932 12/10/1931 8/15/1988 3/12/1941 6/19/1955 2/18/1935 11/5/1947 8/21/1944 1/4/1933 11/17/1972 8/21/1945 12/12/1929 11/5/1976 6/23/1954 5/27/1963 11/9/1946 6/4/1932 5/10/1944 6/3/1969 12/29/1935 11/4/1930 4/23/1967 6/30/1940 46755 46755 46231 46825 46755 46755 46231 46755 46231 46231 46231 46755 46755 46755 46755 46231 46755 46231 46825 46755 46825 46231 46755 46755 46231 46231 46231 46231 46755 46755 46755 46755 46231 31- 17- 06 54- 66- 49 97- 69- 29 85- 58- 87 12- 39- 26 80- 10- 23 34- 78- 18 95- 65- 03 99- 43- 61 04- 37- 45 38- 81- 78 43- 68- 50 56- 64- 95 86- 13- 30 70- 45- 87 09- 67- 24 70- 02- 99 57- 81- 87 87- 11- 84 98- 33- 81 56- 95- 74 35- 81- 92 28- 19- 78 93- 87- 17 65- 01- 33 11- 62- 30 57- 69- 44 30- 04- 10 02- 87- 66 18- 72- 27 96- 07- 85 48- 71- 53 32- 97- 16 MCARE MCARE BCBSH MCARE MCARE MCARE MCARE MCARE MCARE SELFP MCARE MCARE MCARE MCARE MCAID MCARE MCARE MCAID MCARE MCARE MCAID MCARE MCARE MCAID BCBSH MCARE MCARE MCARE MCAID MCARE MCARE MCARE BCBSH 11/18/2010 11/8/2010 11/10/2010 11/21/2010 11/21/2010 11/13/2010 10/29/2010 10/29/2010 11/14/2010 11/15/2010 11/4/2010 11/5/2010 11/20/2010 11/18/2010 11/22/2010 11/26/2010 11/27/2010 10/28/2010 11/4/2010 11/3/2010 10/31/2010 11/8/2010 11/6/2010 11/16/2010 10/29/2010 11/3/2010 11/16/2010 11/11/2010 11/27/2010 10/31/2010 11/5/2010 11/8/2010 11/20/2010 dm DateDisch Date Primary Diagnosis Diagnosis 2Diagnosis 3Diagnosis 4 11/2/2010 996,62 585,6 250,4 588 11/4/2010 428 404,91 491,21 585,9 11/23/2010 786,59 786,59 428 458,8 11/30/2010 786,59 401,9 V45.81 296,8 11/9/2010 492 512,1 491,21 E879.8 11/23/2010 428 996,09 425,4 V53.32 11/8/2010 413,9 794,39 496 574,2 11/1/2010 786,59 491,21 401,9 530,81 11/22/2010 428 414,01 586 564,09 11/26/2010 414,01 427,31 402,9 272,4 11/4/2010 413,9 424 427,81 427,31 11/10/2010 428 599 427,31 496 11/10/2010 428 453,42 453,41 425,4 11/8/2010 427,1 427,1 425,8 404,91 11/23/2010 427,31 427,31 401,9 272 11/13/2010 453,41 401,9 530,81 272,4 11/11/2010 786,59 599 473 401,9 11/7/2010 486 786,3 428 276,9 11/19/2010 453,41 289,81 V10.05 V12.51 11/18/2010 162,3 427 512,1 338,12 11/18/2010 441,4 518 780,6 11/9/2010 444,22 707,03 444,22 599 11/8/2010 427,31 V12.59 V10.42 11/14/2010 428 414,01 441,4 401,9 11/19/2010 453,41 459,81 558,9 401,9 11/10/2010 410,71 414,01 401,9 272,5 11/7/2010 410,71 599 411,1 428 11/9/2010 507 584,9 491,21 403,9 11/27/2010 427,32 204,1 427,31 11/23/2010 493,92 296,54 466 530,81 11/17/2010 428 486 491,21 599 11/26/2010 427,81 412 305,1 11/24/2010 411,1 410,71 715,9 733 11/3/2010 427,31 305,1 525,9 11/16/2010 486 518,81 491,21 599 11/19/2010 410,71 404,91 585,4 428 11/26/2010 780,2 807,2 E936.3 E935.2 11/23/2010 786,5 414,01 401,9 250 11/13/2010 410,71 410,71 414,2 443,89 11/7/2010 410,71 292,81 518 728,88 11/16/2010 486 599 276,51 11/7/2010 411,1 272 530,81 11/18/2010 441,4 11/15/2010 486 584,9 599 295,3 11/27/2010 786,59 780,2 401,9 724,2 11/16/2010 428 707,03 511,9 427,31 11/19/2010 427,31 414,01 272 401,9 11/11/2010 435,8 435,8 427,1 427,31 11/10/2010 491,21 491,21 599 427 11/9/2010 428 425,4 414,01 530,81 11/13/2010 786,59 401,9 300,4 553,3 11/7/2010 453,41 415,19 305,1 11/17/2010 428 578,1 412 427,31 11/18/2010 426 410,71 440 426,4 11/27/2010 428 415,19 453,41 574,01 11/26/2010 427,69 428 401,9 272 11/18/2010 794,39 438,2 402,9 272,4 11/1/2010 427,89 786,59 401,9 E941.3 11/19/2010 414,01 410,41 401,9 327,23 11/9/2010 786,59 714 695,4 401,9 11/23/2010 486 486 293 290 11/16/2010 428 584,9 404,91 250,52 11/17/2010 427,31 435,9 427,1 428 11/16/2010 410,71 427,31 428 427,81 11/26/2010 428 486 438,2 276,1 11/18/2010 285,21 584,9 276,4 599 11/3/2010 786,59 593,4 591 276,1 11/10/2010 428 486 491,21 714 11/8/2010 453,41 162,9 196,1 787,01 11/16/2010 518,81 402,01 733,13 599 11/27/2010 518,81 426,53 560,39 427 11/23/2010 427,31 427,31 428 443,89 11/17/2010 428 496 250 11/27/2010 458,29 627,1 182 345,9 11/25/2010 794,31 401,9 250 V45.01 11/23/2010 786,6 512,1 496 250 11/12/2010 466 278 305,1 V17.3 11/23/2010 996,74 453,8 183 283 11/11/2010 491,21 276,2 441,4 V46.2 11/18/2010 996,62 585,6 425,4 41,11 11/22/2010 428 454,2 496 427,31 11/16/2010 780,6 496 280,9 780,6 11/7/2010 414,01 411,1 491,21 272 11/3/2010 427,81 203 585,4 285,22 11/26/2010 453,4 415,11 996,77 444,22 11/10/2010 997,2 585,6 403,11 287,31 11/10/2010 411,1 401,9 272,4 790,21 dm DateDisch Date Primary Diagnosis Diagnosis 1Diagnosis 2Diagnosis 3 11/20/2010 428 425,4 427,81 427,31 11/29/2010 786,51 530,81 790,5 305,1 11/11/2010 786,59 414,01 401,9 250 11/9/2010 415 518,81 517,2 710,1 11/3/2010 486 518,89 305,1 V16.1 11/22/2010 11/10/2010 11/13/2010 11/23/2010 11/17/2010 11/21/2010 11/2/2010 11/30/2010 11/17/2010 11/8/2010 11/9/2010 11/8/2010 11/22/2010 11/13/2010 11/28/2010 11/29/2010 11/1/2010 11/17/2010 11/8/2010 11/5/2010 11/3/2010 11/10/2010 11/10/2010 11/18/2010 11/4/2010 11/7/2010 11/22/2010 11/17/2010 11/29/2010 11/4/2010 11/8/2010 11/11/2010 11/23/2010 453,41 486 786,59 562,11 428 496 411,1 278,01 786,59 V15.81 411,1 600 786,51 585,9 414,01 250 250,13 250,13 420,9 244,9 427,31 401,9 414,01 401,9 428 454,2 486 531,4 414,01 411,1 428 425,4 441,4 V10.05 466 401,9 786,59 414,02 780,2 305,1 276,4 518,81 411,1 401 493,91 486 486 276,51 428 250 786,59 414,01 441,4 491,21 428 404,91 451 444,22 162,9 198,3 491,21 491,21 786,51 300 428 584,9 401,9 372,1 401,9 V45.82 593,9 401,9 427,69 250,92 272 272,4 530,81 401,9 584,9 427,1 780,57 V04.81 780,79 496 272 715,9 593,9 782,3 204,1 599 599 280,9 600,9 416,8 790,29 401,9 496 272 276,4 530,81 518,81 250,4 585,9 292,84 416,9 585,4 401,9 197,7 486 530,81 404,91 295,72 305,1 427,31 403,9 327,23 600,91 425,4 433,1 253,6 458 401,9 585,4 Patient FirstPatient Name LastGender Name Jerry Acuff M Hermine Agrawal F Maria Alloway F Erika Ammon F Gert April F Shary Asaro F Nicole Austin F Patty Backman F Cindy Baity F Lucille Baskerville F Alberto Beavers M Kate Blank F Kyle Bosque M Virginie Bourassa F Isaac Bulman M Wanda Burstein F Alex Bushard M Larry Buzbee M Claudette Cauley F Paula Cawthon F Victor Champlin M Harvey Cirilo M Tony Clendening M Ian Clerk M Van Cordeiro M Vince Corkery M Richard Cosio M Richard Cosio M Josephine Cuadrado F Lee Cullison M Rebekah Dahlin F Chantal Dahmen F Emily Delpozo F Peter Fabry M Fiona Farrington F Danny Felker M Julia Filson F Sebastien Fortes M Olga Forward F Katia Fraser F Marco Fryar M Ana Gaal F Arlene Gamache F Joaquin Gamble M Colin Ghee M Dolly Gibby F DOB Zip Code 12/12/1955 46755 46755 3/14/1955 46825 7/22/1974 46825 7/10/1940 46231 1/10/1948 46231 2/18/1929 8/6/1990 46755 46755 2/20/1955 46825 10/12/1934 1/28/1930 46825 46755 12/23/1926 46755 9/26/1968 46755 1/19/1972 46755 2/20/1955 46825 8/11/1959 8/12/1965 46231 46755 4/27/1927 46755 3/30/1972 46825 8/14/1935 7/5/1968 46231 3/13/1961 46755 46825 8/25/1954 46231 3/14/1955 46755 3/8/1956 7/28/1944 46825 8/15/1970 46755 7/18/1947 46755 7/18/1947 46755 46755 4/3/1966 46231 7/26/1972 8/5/1952 46755 46231 11/9/1932 46755 3/14/1955 46755 12/6/1941 46825 12/25/1942 46231 12/20/1937 46231 4/7/1968 9/6/1944 46755 10/10/1952 46825 46755 10/2/1970 46231 6/9/1974 46755 5/6/1927 46755 2/18/1929 46231 6/5/1964 46825 8/28/1936 46231 6/5/1938 Medical Record Insurance # Carrier Adm DateDisch Date 16- 74- 90 MCARE 11/25/2010 12/1/2010 29- 12- 83 MCARE 12/15/2010 12/18/2010 80- 61- 82 MCARE 12/22/2010 12/24/2010 14- 41- 17 MCARE 12/1/2010 12/8/2010 99- 89- 46 MCARE 12/19/2010 12/23/2010 48- 19- 76 MCAID 12/17/2010 12/21/2010 63- 28- 60 MCAID 12/15/2010 12/19/2010 71- 55- 31 MCARE 12/25/2010 12/30/2010 41- 30-04 MCARE 12/19/2010 12/21/2010 41- 70- 98 MCARE 11/30/2010 12/3/2010 50- 65- 29 SELFP 12/20/2010 12/24/2010 28- 64- 49 MCARE 12/4/2010 12/8/2010 26- 57- 01 MCARE 12/1/2010 12/5/2010 76- 93- 40 MCARE 12/16/2010 12/21/2010 32- 44- 54 BCBSH 12/22/2010 12/27/2010 67- 47- 90 MCARE 12/13/2010 12/15/2010 60- 24- 51 BCBSH 12/11/2010 12/15/2010 16- 52- 26 MCARE 12/2/2010 12/9/2010 53- 07- 42 MCARE 12/5/2010 12/7/2010 54- 87- 15 MCARE 12/14/2010 12/19/2010 16- 63- 40 MCARE 12/12/2010 12/14/2010 17- 95- 49 MCARE 12/20/2010 12/23/2010 91- 06- 19 BCBSH 12/24/2010 12/31/2010 22- 83- 29 MCARE 12/13/2010 12/18/2010 62- 94- 70 MCARE 12/2/2010 12/4/2010 46- 79- 96 MCARE 12/22/2010 12/24/2010 64- 29- 37 MCARE 12/18/2010 12/20/2010 64- 29- 37 MCARE 12/28/2010 12/30/2010 70- 49- 65 MCARE 12/3/2010 12/5/2010 53- 17- 74 BCBSH 12/19/2010 12/24/2010 36- 24- 80 MCAID 12/1/2010 12/3/2010 35- 48- 39 MCARE 11/29/2010 12/1/2010 50- 02- 70 BCBSH 12/16/2010 12/23/2010 27- 96- 28 MCAID 12/7/2010 12/12/2010 44- 79-06 MCARE 12/16/2010 12/18/2010 28- 54- 20 BCBSH 12/3/2010 12/7/2010 21- 22- 99 BCBSH 12/16/2010 12/18/2010 07- 93- 81 MCARE 12/1/2010 12/4/2010 78- 75- 48 MCARE 11/30/2010 12/3/2010 67- 77- 54 MCARE 12/21/2010 12/24/2010 92- 08- 19 BCBSH 12/3/2010 12/5/2010 97- 99- 50 MCARE 12/4/2010 12/7/2010 99- 39- 26 MCARE 12/17/2010 12/21/2010 33- 88-07 BCBSH 12/6/2010 12/8/2010 20- 78- 91 MCARE 12/10/2010 12/15/2010 28- 19- 99 MCARE 11/30/2010 12/4/2010 Helene Gillham F Hanna Goodwill F Grace Guard F Rose Hammack F Matthew Hartwell M Franklin Hauge M Omar Heacock M Danielle Heath F Karl Herzberg M Isaias Hoerr M Sam Holtzclaw M Tammy Howery F Edouard Hunsucker M Ida Husain F Tanya Huston F Teddy Jimenez M Oscar Jiminez M Fred Judkins M Leslie Kimbro F Bonnie Kluesner F Bill Lasky M Chris Locklin M Wilfred Mcateer M Ingrid Mccardell F Pablo MccormackM Don Mccoy M Henri Mccray M Odette Mcilrath F Gonzalo Meisinger M Nicholas Merida M Lorenzo Mershon M Nestor Mills M Gaston Montesino M Whitney Musgrove F Sean Nemeth M Philippe Nowack M Florence Nowicki F Teresa Oakes F Fay Ohler F Rafael Osterman M Tobias Oxley M Vina Pankow F Laura Paramo F Debby Parkison F Mindy PasquarielloF Patient FirstPatient Name LastGender Name Melissa Pawlak F 1/4/1955 10/2/1951 5/4/1949 9/9/1956 10/19/1974 2/29/1944 2/15/1940 11/29/1937 9/14/1968 5/6/1962 5/15/1930 5/15/1930 2/15/1940 9/9/1956 7/5/1934 9/9/1956 6/5/1938 3/22/1945 8/21/1972 12/26/1930 11/20/1930 10/31/1933 5/5/1937 10/26/1958 2/8/1945 2/22/1939 2/20/1955 3/8/1956 2/9/1948 7/10/1940 1/14/1973 12/14/1947 12/6/1947 10/20/1965 9/9/1956 3/8/1956 3/15/1943 9/15/1973 7/26/1942 1/10/1930 6/5/1938 4/11/1936 7/18/1972 4/17/1938 2/15/1940 DOB 7/24/1975 46755 46825 46755 46755 46755 46755 46755 46755 46825 46231 46825 46755 46755 46825 46755 46755 46231 46231 46755 46231 46231 46231 46231 46755 46231 46231 46755 46231 46231 46825 46231 46755 46231 46231 46231 46755 46231 46231 46755 46755 46755 46825 46825 46755 46231 Zip Code 46755 47- 44- 98 MCARE 12/24/2010 12/27/2010 53- 40-08 BCBSH 12/2/2010 12/5/2010 48- 05- 23 SELFP 12/4/2010 12/8/2010 26- 58- 22 BCBSH 12/10/2010 12/12/2010 45- 10- 82 MCARE 12/16/2010 12/18/2010 77- 91-04 MCARE 12/21/2010 12/23/2010 37- 41- 33 MCARE 11/30/2010 12/7/2010 28- 86- 83 MCAID 12/12/2010 12/16/2010 67- 06- 52 MCARE 12/14/2010 12/18/2010 36- 76- 95 MCARE 11/30/2010 12/5/2010 22- 24- 72 MCARE 12/8/2010 12/12/2010 55- 41- 03 MCARE 12/19/2010 12/24/2010 51- 70- 81 MCARE 11/28/2010 12/5/2010 80- 97- 82 MCARE 12/3/2010 12/8/2010 26- 08- 42 MCARE 11/29/2010 12/4/2010 43- 12- 19 MCAID 12/2/2010 12/7/2010 32- 80- 55 MCARE 12/25/2010 12/29/2010 41- 83- 74 MCARE 12/6/2010 12/8/2010 56- 35- 41 MCAID 12/20/2010 12/27/2010 54- 30- 75 MCARE 12/12/2010 12/15/2010 11- 79- 44 MCARE 12/2/2010 12/7/2010 18- 01- 34 MCAID 12/22/2010 12/24/2010 74- 99- 21 MCARE 12/3/2010 12/7/2010 63- 61- 70 MCARE 11/27/2010 12/2/2010 07- 58- 43 MCARE 11/30/2010 12/3/2010 45- 51- 85 MCAID 12/18/2010 12/22/2010 77- 72- 70 MCARE 12/5/2010 12/8/2010 65- 72- 97 MCARE 12/8/2010 12/11/2010 26- 02- 64 MCAID 12/1/2010 12/5/2010 81- 43- 75 SELFP 12/7/2010 12/11/2010 24- 63- 41 MCARE 11/26/2010 12/3/2010 50- 26- 76 MCARE 11/29/2010 12/3/2010 59- 92- 64 MCARE 12/14/2010 12/18/2010 08- 52- 70 SELFP 12/20/2010 12/24/2010 19- 56- 29 BCBSH 12/21/2010 12/24/2010 55- 36- 23 MCARE 12/22/2010 12/24/2010 88- 76- 73 MCARE 12/24/2010 12/26/2010 44- 35- 79 MCARE 12/6/2010 12/13/2010 42- 75-04 MCARE 12/3/2010 12/5/2010 56- 62- 98 MCARE 12/29/2010 12/31/2010 55- 02- 78 BCBSH 12/18/2010 12/21/2010 94- 24- 75 SELFP 11/29/2010 12/3/2010 63- 26- 14 MCARE 11/28/2010 12/5/2010 46- 55- 89 BCBSH 12/20/2010 12/24/2010 54- 23- 26 SELFP 12/8/2010 12/10/2010 Medical Record Insurance # Carrier Adm DateDisch Date 42- 40- 38 BCBSH 12/1/2010 12/3/2010 Cristobal Ernesto Rina Rina Fernand Beryl Nana Irma Earl Gordon Dorian Tina Nate Paulette Arthur Valerie Sally Sally Jerry Vicky Lisa Nadine Gabrielle Kirk Humberto Walter Sara Barry Wendy Bret Otto Michael Andrea Crysta Karen Jose Bertha Joyce Ophelia Erin Rene Prescott M Ramage M Ransdell F Ransdell F Redinger M Roybal F Ruddick F Rumery F Ruther M Rutherford M Sabine M Sandifer F SantistevanM Schaff F Schmitt M SchoenrockF Schuld F Schuld F Seckman M Shipley F Stanwood F Steinman F Stjean F Stockton M Swart M Swearngin M Talbott F Temples M Twedt F Vong M Walck M WallingfordM Wein F Weis F Welborn F Welter M Wetter F Wilcher F Willits F Wiltshire F WinegardenM 11/24/1937 5/29/1942 12/6/1941 12/6/1941 8/29/1942 8/21/1930 6/2/1942 2/19/1959 1/28/1940 8/1/1948 11/8/1939 8/15/1988 2/15/1940 7/10/1940 1/10/1930 11/5/1957 12/6/1941 12/6/1941 12/27/1962 5/15/1930 9/8/1972 2/18/1929 6/20/1946 12/6/1971 1/3/1956 1/10/1930 2/22/1939 4/19/1930 5/2/1933 3/19/1931 5/6/1949 6/7/1976 5/21/1928 5/27/1963 7/24/1968 3/18/1965 5/15/1930 1/6/1968 7/10/1940 12/6/1941 3/8/1956 46825 46825 46825 46825 46825 46825 46755 46231 46755 46755 46755 46755 46231 46755 46755 46755 46231 46231 46231 46755 46231 46825 46231 46755 46755 46825 46825 46825 46231 46231 46825 46231 46231 46231 46825 46755 46231 46231 46755 46755 46825 10- 78- 29 70- 52- 79 60- 22- 99 60- 22- 99 63- 20- 57 31- 01- 13 63- 93- 45 67- 07- 96 82- 02- 92 32- 21- 65 10- 49- 82 03- 01 -88 31- 80- 46 47- 55- 95 50- 82- 88 58- 84- 26 38- 78- 59 38- 78- 59 95- 99- 43 47- 87- 35 82- 33- 95 50- 03- 42 92- 75- 70 90- 37- 47 22- 85- 48 42- 30- 20 02- 59- 45 50- 72- 39 36- 07- 01 16- 07- 40 94- 44- 87 19- 68- 85 69- 83- 15 65- 01- 33 10- 66- 65 82- 57- 90 61- 67- 58 71- 21- 41 87- 37- 45 61- 27- 05 72- 66- 37 MCARE MCARE MCARE MCARE MCARE MCARE MCARE MCARE BCBSH MCARE MCARE MCARE MCARE SELFP BCBSH MCARE MCARE MCARE MCARE BCBSH MCARE MCARE MCAID MCARE BCBSH MCARE BCBSH MCARE MCAID MCARE MCARE BCBSH SELFP BCBSH MCARE MCARE MCARE MCARE SELFP MCARE SELFP 12/2/2010 12/18/2010 12/20/2010 12/25/2010 11/30/2010 12/17/2010 12/2/2010 12/18/2010 12/10/2010 12/23/2010 11/27/2010 11/29/2010 12/20/2010 12/5/2010 11/30/2010 12/29/2010 12/4/2010 12/23/2010 11/30/2010 12/5/2010 12/11/2010 12/24/2010 11/28/2010 12/23/2010 11/29/2010 12/19/2010 12/27/2010 11/26/2010 11/30/2010 12/14/2010 12/16/2010 12/25/2010 11/28/2010 12/23/2010 11/28/2010 12/21/2010 11/27/2010 12/25/2010 12/17/2010 11/24/2010 12/3/2010 12/4/2010 12/25/2010 12/24/2010 12/29/2010 12/2/2010 12/24/2010 12/6/2010 12/23/2010 12/17/2010 12/26/2010 12/1/2010 12/2/2010 12/24/2010 12/7/2010 12/4/2010 12/31/2010 12/7/2010 12/26/2010 12/2/2010 12/7/2010 12/18/2010 12/28/2010 12/2/2010 12/27/2010 12/2/2010 12/21/2010 12/31/2010 12/1/2010 12/4/2010 12/21/2010 12/19/2010 12/27/2010 12/1/2010 12/29/2010 12/2/2010 12/23/2010 12/4/2010 12/27/2010 12/24/2010 12/1/2010 12/7/2010 Primary Diagnosis Diagnosis 2Diagnosis 3Diagnosis 4 428 491,21 585,9 786,59 593,4 591 276,1 404,91 707,03 410,71 599 414,01 411,1 491,21 272 786,59 491,21 401,9 530,81 411,1 278,01 427,69 250,92 410,71 427,31 428 427,81 451 444,22 401,9 433,1 491,21 786,59 401,9 300,01 428 996,09 425,4 V53.32 428 996,09 425,4 V53.32 414,01 250 530,81 401,9 428 438,2 404,91 496 427,32 204,1 427,31 414,01 411,1 599 280,9 426 410,71 440 426,4 444,22 707,03 444,22 599 414,01 427,31 402,9 272,4 428 454,2 593,9 782,3 441,4 518 780,6 491,21 491,21 599 427 518,81 426,53 560,39 427 428 486 491,21 599 428 453,42 453,41 425,4 250,13 250,13 584,9 427,1 428 424 250 496 492 512,1 491,21 E879.8 492 512,1 427,31 401,9 780,79 496 486 276,1 250,02 414,8 486 531,4 204,1 599 428 496 593,9 401,9 428 584,9 404,91 250,52 780,2 305,1 507 584,9 491,21 403,9 491,21 276,2 441,4 V46.2 786,5 414,01 401,9 250 786,59 599 473 401,9 410,71 404,91 585,4 428 427,89 786,59 401,9 E941.3 427,31 435,9 427,1 428 428 785,51 518,81 570 794,39 438,2 402,9 272,4 786,59 780,2 401,9 724,2 441,4 V10.05 491,21 491,21 486 458 428 425,4 600,9 416,8 428 578,1 412 427,31 410,71 410,71 414,2 443,89 427,31 414,01 272 401,9 466 401,9 790,29 496 410,71 518,81 415,19 453,42 410,71 292,81 518 728,88 427,69 428 401,9 272 415 518,81 517,2 710,1 285,21 584,9 276,4 599 427,31 291,81 577,1 491,21 786,59 562,11 401,9 V45.82 466 278 305,1 V17.3 427,31 427,31 428 443,89 786,59 414,01 401,9 250 786,59 V15.81 411,1 272 530,81 411,1 401 530,81 305,1 428 250 585,9 428 404,91 585,4 425,4 428 415,19 453,41 574,01 996,62 585,6 425,4 41,11 427,31 V12.59 V10.42 453,4 415,11 996,77 444,22 493,91 486 518,81 427,31 427,81 203 585,4 285,22 428 496 250 453,41 486 401,9 372,1 427,31 427,31 401,9 272 996,62 585,6 403,91 682,3 411,1 600 272 786,59 401,9 300,4 553,3 453,41 459,81 558,9 401,9 786,51 300 530,81 401,9 996,74 453,8 183 283 428 414,01 441,4 401,9 428 599 424,9 412 427,31 305,1 525,9 997,2 585,6 403,11 287,31 411,1 410,71 715,9 733 486 494 515 276,9 453,4 415,11 444,22 486 584,9 599 295,3 413,9 424 427,81 427,31 276,4 518,81 276,4 295,72 Primary Diagnosis Diagnosis 2Diagnosis 3Diagnosis 4 453,41 415,19 305,1 786,59 162,3 486 486 411,1 411,1 458,29 786,59 453,41 453,41 441,4 410,71 518,81 411,1 427,81 493,92 486 486 786,6 780,6 428 786,51 428 486 486 996,62 428 162,9 486 401 435,8 453,41 518,81 428 786,51 794,31 410,71 428 786,59 420,9 786,59 401,9 V45.81 296,8 427 512,1 338,12 786,3 428 276,9 786,3 428 276,9 707,12 707,14 428 411,1 401,9 427,31 627,1 182 345,9 714 695,4 401,9 289,81 V10.05 V12.51 162,9 196,1 787,01 404,91 38,9 272,2 412 296,54 599 599 512,1 496 707,03 585,9 404,91 518,89 486 585,6 425,4 198,3 276,51 305 435,8 401,9 491,21 250 427 401,9 599 427,31 414,02 244,9 414,01 585,4 428 518,81 491,21 401,9 790,21 305,1 466 530,81 276,51 276,51 496 250 280,9 780,6 511,9 427,31 272,4 491,21 585,9 305,1 V16.1 293 290 250,4 588 414,01 530,81 197,7 253,6 250,4 403,9 305,9 305,1 427,1 427,31 530,81 272,4 483,8 276,1 585,9 427,31 250 V45.01 411,1 428 401,9 530,81 401,9 272 780,57 V04.81 292,84 327,23 Inpatient Prospective Payment Services 30-day Readmission Rates Core Measure Jan-10 Feb-10 Mar-10 Readmits AMI 5 5 3 CHF 3 8 5 Pneu 6 9 5 Total Discharges Percentage of Readmits AMI CHF Pneu 133 155 122 Apr-10 May-10 Jun-10 5 6 8 6 7 9 7 8 5 125 139 144 401 427,31 785,1 486 410,71 428 428 518,81 786,59 414,01 447,1 411,1 518,81 305 786,59 427,31 494 518,81 785,51 427,31 38,9 576,2 401,9 440,4 411,1 491,21 305,9 305,1 496 V17.3 401,9 496 515 276,9 415,19 453,42 518,81 570 401,9 530,81 518,81 491,21 577,1 535,3 427,31 356,9 447,1 441,4 401,9 427,31 483,8 276,1 428 411,1 411,1 427,81 404,91 428 401 518,81 996,62 411,1 428 491,21 486 428 786,51 427,31 427,1 707,12 272,2 427,31 707,03 424 293 491,21 585,6 530,81 438,2 786,59 276,1 599 427 291,81 414,01 V45.82 707,14 428 401,9 790,21 402,9 530,81 410,71 599 250 496 780,2 304,3 428,1 415 403,91 682,3 272 724,1 404,91 496 401,9 300,01 250,02 414,8 424,9 412 427,31 577,1 491,21 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 4 6 5 5 5 4 6 8 4 5 4 4 3 3 4 133 122 123 130 125 Dec-10
Purchase answer to see full attachment

Tags: excell patient

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi,Find attached the completed work.Feel free to ask for any clarification or editing if need be.Looking forward to working with you in the future.Thank you.

Patient First Name
Eileen
Susannah
Ling
Darin
Viva
Angelia
Yolanda
Lakeshia
Stormy
Jacklyn
Frederic
Ezra
Hoa
Leena
Janessa
Savannah
Nilsa
Talisha
Delsie
Gisela
Cody
Kala
Neil
Tania
Cary
Fanny
Evangelina
Loan
Randy
Ron
Sherman
Cyndy
Myesha
Dayle
Bernie
Crista
Francesco
Angella
Ronna
Eleonore
Eryn
Jerry
Lucille
Frida
Annmarie
Rocco

Patient Last Name
Canino
Yarbrough
Ritz
Tolman
Laman
Cort
Courson
Erb
Geoghegan
Gothard
Kua
Edick
Gwin
Paris
Rakestraw
Remer
Torpey
Baskette
Bernabe
Beringer
Kennerly
Neeld
Ribeiro
Sacks
Scheurer
Potvin
Robinett
Huie
Bogen
Bosque
Chien
Effler
Harter
Kropf
Leonhardt
Rowles
Domenick
Hussein
Dyer
Paetzold
Johnsrud
Acuff
Baskerville
Belton
Bisignano
Boddy

Gender
F
F
M
M
F
F
F
F
F
F
M
M
M
F
F
F
F
F
F
F
M
F
M
F
M
F
F
M
M
M
M
F
F
M
M
F
M
F
F
F
F
M
F
F
F
M

DOB
6/16/1952
12/29/1935
12/16/1947
8/21/1945
9/16/1929
5/23/1941
8/4/1952
8/26/1940
7/27/1950
11/1/1949
12/29/1948
5/27/1955
12/10/1957
2/4/1961
2/7/1959
8/18/1937
12/12/1929
1/17/1951
8/2/1953
7/27/1945
8/12/1957
9/10/1942
8/8/1941
12/10/1931
6/19/1955
11/13/1942
4/19/1955
10/1/1975
8/29/1933
7/15/1949
1/14/1935
8/1/1970
11/7/1950
1/31/1935
4/12/1950
12/31/1932
12/16/1966
9/15/1947
3/17/1949
6/19/1944
10/24/1939
12/12/1955
1/28/1930
4/13/1942
4/7/1949
6/13/1939

Zip Code
46825
46755
46231
46825
46825
46231
46231
46825
46755
46755
46231
46755
46755
46231
46825
46755
46231
46231
46231
46755
46755
46231
46755
46755
46755
46825
46231
46755
46231
46231
46755
46231
46231
46825
46755
46231
46755
46231
46231
46755
46755
46755
46825
46231
46825
46755

Kami
Rosalyn
Otis
Milford
Mozelle
Britt
Sebastian
Kelsie
Elouise
Elvira
Sharyl
Era
Katrina
Tina
Livia
Crysta
Inga
Hortencia
Ida
Arletta
Camilla
Reed
Maurita
Jenise
Nevada
Vina
Lavone
Bao
Joy
Basilia
Natisha
Erick
Cassie
Meaghan
Nan
Stephania
Gillian
Stephen
Elden
Trenton
Olene
Adeline
Latia
Cherie
Ezekiel
Marquis
Divina

Condon
Dubay
Handley
Hochman
Houpt
Hultgren
Kohn
Laliberte
Lavallie
Lin
Meints
Pesola
Quesenberry
Sandifer
Shankle
Weis
Wommack
Yost
Haynie
Caperton
Halley
Shattles
Wiener
Carden
Wrona
Pankow
Braham
Cajigas
Coolbaugh
Hollinger
Lavin
Preas
Loesch
Markus
Shotwell
Cafferty
Emrick
Greenlaw
Hallinan
Knorr
Poyner
Sanford
Waite
Heasley
Mcloud
Yeater
Avina

F
F
M
M
M
F
M
F
F
F
F
M
F
F
F
F
F
F
F
F
F
M
F
F
F
F
M
M
F
F
F
M
F
F
F
F
F
M
M
M
F
F
F
F
M
M
F

2/16/1934
2/8/1964
11/30/1970
12/1/1940
12/13/1952
3/25/1940
5/31/1956
10/11/1934
8/1/1964
7/28/1931
4/11/1933
3/22/1952
8/18/1936
8/15/1988
2/18/1935
5/27/1963
5/10/1944
6/30/1940
7/9/1961
10/23/1961
12/28/1985
11/5/1947
6/4/1932
2/8/1949
6/3/1969
4/11/1936
8/21/1963
4/28/1947
2/16/1961
7/8/1983
4/28/1941
8/4/1984
10/16/1936
11/10/1946
8/21/1944
3/17/1977
11/26/1967
6/28/1936
11/5/1955
6/9/1970
4/2/1961
3/12/1941
6/23/1954
10/12/1945
8/29/1951
11/4/1930
12/9/1952

46825
46231
46231
46755
46825
46755
46231
46755
46825
46825
46231
46825
46231
46755
46231
46231
46231
46231
46755
46825
46755
46755
46231
46231
46755
46825
46231
46231
46755
46231
46825
46755
46755
46231
46231
46755
46825
46755
46755
46231
46825
46755
46755
46755
46825
46755
46755

Lashawna
Darell
Zoraida
Ariel
Leon
Kristopher
Laura
Clement
Hassie
Agustina
Lane
Ardell
Zulma
Kim
Lyman
Cleopatra
Lyda
Adena
Kyra
Otelia
Shayne
Tamra
Lizette
Adelle
Treasa
Laronda
Tracey
Shameka
Cristy
Ronni
Annett
Jack

Vreeland
Donner
Digby
Lebouef
Lenox
Espitia
Stead
Molitor
Farrelly
Plott
Rhodes
Yeung
Alcon
Alvero
Bedard
Brakebill
Hallinan
Hochmuth
Kibby
Lashua
Popejoy
Purtee
Reindl
Spinner
Weissinger
Magnus
Lohman
Jahn
Acey
Mcmurtry
Mccafferty
Parada

F
M
F
F
M
M
F
M
F
F
M
F
F
F
M
F
F
F
F
F
M
F
F
F
F
F
F
F
F
M
F
M

11/5/1976
3/19/1961
12/29/1949
12/14/1947
4/3/1938
1/10/1938
11/17/1972
10/2/1941
8/1/1942
11/24/1954
7/8/1943
4/23/1967
6/28/1952
10/10/1990
11/6/1948
7/11/1937
1/10/1945
12/5/1941
5/14/1958
6/29/1949
9/15/1949
6/7/1960
3/22/1976
1/4/1933
11/9/1946
11/17/1949
3/11/1961
9/26/1937
8/8/1985
4/22/1951
10/8/1928
11/10/1960

46755
46825
46231
46755
46825
46231
46755
46825
46755
46755
46231
46755
46755
46755
46755
46755
46755
46825
46825
46231
46825
46755
46755
46825
46231
46755
46231
46755
46825
46755
46755
46231

Medical Record #
70- 46- 24
18- 72- 27
99- 43- 61
56- 95- 74
79- 82- 87
08- 40- 94
91- 28- 21
62- 77- 42
13- 08- 54
69- 59- 39
73- 21- 48
95- 48- 98
98- 13- 18
44- 74- 93
85- 58- 87
80- 10- 23
35- 81- 92
56- 43- 18
25- 73- 80
20- 54-09
53- 65- 44
31- 03- 16
95- 65- 03
43- 68- 50
70- 45- 87
49- 72- 16
04- 37- 45
37- 78- 45
95- 98- 54
58- 29- 99
82- 39- 08
87- 03- 53
76- 20- 06
11- 88- 49
87- 80- 16
38- 81- 78
55- 66- 42
93- 48- 05
93- 59- 42
56- 24- 68
88- 09- 63
16- 74- 90
41- 70- 98
10- 88- 82
61- 31- 46
82- 66- 42

Insurance Carrier
MCAID
MCARE
MCARE
MCAID
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCAID
SELFP
MCARE
MCARE
MCARE
MCARE
MCARE
MCAID
MCARE
SELFP
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCARE
MCAID
MCARE
MCARE
MCARE
MCARE
MCARE
MCAID
MCARE
MCARE

Adm Date
Disch Date
11/12/2010
11/18/2010
10/31/2010
11/4/2010
11/14/2010
11/17/2010
10/31/2010
11/3/2010
10/30/2010
11/18/2010
11/16/2010
11/10/2010
11/4/2010
11/7/2010
11/13/2010
11/19/2010
11/7/2010
11/13/2010
11/3/2010
11/7/2010
11/10/2010
11/16/2010
11/21/2010
11/24/2010
11/1/2010
11/7/2010
11/4/2010
11/10/2010
11/21/2010
11/23/2010
11/19/2010
11/21/2010
11/8/2010
11/10/2010
11/4/2010
11/8/2010
11/6/2010
11/4/2010
11/2/2010
11/26/2010
11/16/2010
11/19/2010
11/17/2010
11/7/2010
11/3/2010
11/30/2010
11/26/2010
11/8/2010
11/22/2010
11/28/2010
11/26/2010
11/9/2010
11/7/2010
11/8/2010
11/15/2010
11/18/2010
11/2/2010
11/8/2010
11/21/2010
11/23/2010
11/5/2010
11/8/2010
10/28/2010
11/3/2010
11/17/2010
11/19/2010
11/14/2010
11/17/2010
11/17/2010
11/23/2010
11/19/2010
11/9/2010
11/23/2010
11/27/2010
11/24/2010
11/26/2010
11/20/2010
11/26/2010
10/31/2010
11/3/2010
10/30/2010
11/1/2010
10/31/2010
11/4/2010
11/20/2010
11/23/2010
11/18/2010
11/22/2010
11/6/2010
11/10/2010
11/7/2010
11/10/2010

71- 80- 25
57- 16- 91
89- 65- 09
75- 77- 24
57- 99- 37
91- 13-05
79- 45- 16
48- 97- 51
86- 52- 94
87- 31- 52
55- 60- 63
42-...