What is the current state of data within a healthcare organization?  The data sets are included below.  The findings should include recommended changes based on how the healthcare organization's data is collected and organized. Sample data sets will need a lot of work.

    

2018 Health Care Cost Information System (HCCIS) Data Health Economics Program Minnesota Department of Health Current as of 10-15-2020 Minnesota Hospitals Bottom Line (Revenue in Excess of Expenses) Hospital Name Essentia Health Ada Ada Aitkin Riverwood Healthcare Center Mayo Clinic Health System - Albert Lea and Austir Albert Lea Alomere Health Alexandria Community Behavioral Health Hospital-Alexandria Alexandria Community Behavioral Health Hospital - Annandali Annandale Anoka Metro Regional Treatment Center Anoka Appleton Arlington Aurora Appleton Municipal Hospital and Nursing Home Ridgeview Sibley Medical Center Essentia Health Northern Pines Sanford Bagley Medical Center LakeWood Health Center Community Behavioral Health Hospital - Baxter Community Behavioral Health Hospital - Bemidji Sanford Bemidji Medical Center Swift County-Benson Hospital Bigfork Valley Hospital United Hospital District St. Joseph's Medical Center St. Francis Medical Center PrairieCare Buffalo Hospital Fairview Ridges Hospital Cambridge Medical Center Sanford Canby Medical Center Mayo Clinic Health System - Cannon Falls Cloquet Memorial Hospital Association Cook Hospital & C&NC Mercy Hospital* Hospital City Riverview Healthcare Association. Cuyuna Regional Medical Center Johnson Memorial Health Services Essentia Health Deer Diver Bagley Baudette Baxter Bemidji Bemidji Benson Bigfork Blue Earth Brainerd Breckenridge Brooklyn Park Buffalo Burnsville Cambridge Canby Cannon Falls Cloquet Cook Coon Rapids Crookston Crosby Dawson Deer River Report Year End Date CAH 6/30/2018 Yes 9/30/2018 Yes 12/31/2018 No 12/31/2018 No 6/30/2018 No 6/30/2018 No 6/30/2018 No 9/30/2018 Yes 12/31/2018 Yes 6/30/2018 Yes 6/30/2018 Yes 6/30/2018 Yes 6/30/2018 No 6/30/2018 No 6/30/2018 No 12/31/2018 Yes 12/31/2018 Yes 12/31/2018 Yes 6/30/2018 No 6/30/2018 Yes 12/31/2018 No 12/31/2018 No 12/31/2018 No 12/31/2018 No 6/30/2018 Yes 12/31/2018 Yes 9/30/2018 Yes 12/31/2018 Yes 12/31/2018 No 9/30/2018 Yes 3/31/2018 Yes 9/30/2018 Yes 6/30/2018 Yes Total Charges from Patient Care (#0740) 10,202,989 123,026,861 526,382,133 399,336,901 8,727,587 21,107,179 18,994,939 13,984,868 14,320,912 615,018,586 22,072,350 22,250,447 58,526,682 474,945,060 43,924,422 187,815.844 714,071,107 190,163,346 18,679,220 50,233,456 105,205,916 15,932,957 1,946,225,059 90,703,662 269,698,981 16,499,588 49 620 369 Total Adjustments & Uncollectibles (# 0760) (2,718,462) (60,356,060) (293,283,452) (231,845,581) (1,773,288) (6,135,894) (8,865,041) (6,395,260) (5,399,899) (362,636,145) (7,723,777) (7,141,190) (31,350,408) (271,082,446) (20,698,355) (106,676,645) (447,996,510) (114,549,578) (7,171,300) (18,384,461) (53,838,026) (5,628,528) (1,262,061,459) (43,089,379) (144,254,672) (6,066,989) (21 510 987) Net Patient Revenue (0740+0760)* (#0750) 0750-(0740+0760) 7,484,527 62,670,801 233,098,681 167,491,320 - 6,954,299 14,971,285 10,129,898 7,589,608 8,921,013 252,382,441 14,348,573 15,109,257 27,176,274 203,862,614 23,226,067 81,139,199 266,074,597 75,613,768 11,507,920 31,848,995 51,367,890 10,304,429 684,163,600 47,614,283 125,444,309 10,432,599 28 109 382 Total Other Operating Revenue (# 0770) 478,052 1,033,536 7,774,414 5,825,261 533,206 587,506 94,085 658,569 46,016 11,899,301 370,029 404,110 1,771,680 3,989,074 426,840 2,197,693 2,465,578 3,198,704 158,878 821,403 1,525,312 198,660 19,973,713 285,396 8,018,185 1,196,833 1 147 592 Total Operating Revenue (#0780) 0780=(0750+0770) 7,962,579 63,704,337 240,873,095 173,316,581 7,065,289 7,118,073 46,733,141 7,487,505 15,558,791 10,223,983 8,248,177 8,967,029 7,266,213 6,781,591 264,281,742 14,718,602 15,513,367 28,947,954 207,851,688 23,652,907 30,080,619 83,336,892 268,540,175 78,812,472 11,666,798 32,670,398 52,893,202 10,503,089 704,137,313 47,899,679 133,462,494 11,629,432 29 256 974 Total Operating Expenses (#0790) 6,976,852 59,590,117 247,087,161 157,129,927 7,065,289 7,118,073 46.733,141 6,525,626 14,641,631 14,213,749 7,291,922 9,072,644 7,266,213 6,781,591 244,546,062 13,012,132 14,330,299 28,755,814 189,140,272 22,351,286 25,925,959 76,844,695 236,455,219 75,761,075 10,736,007 29,705,220 58,454,142 9,975,564 642,526,495 43,886,238 102,946,768 11,003,560 28 522 788 Income/(Loss) Total Non- From Hospital Operating Operations Revenue (#0700) (#0820) 0700-(0780-0790) 985,727 4,114,220 (6,214,066) 16,186,654 - - 961,879 917,160 (3,989,766) 956,255 (105,615) 19,735,680 1,706,470 1,183,068 192,140 18,711,416 1,301,621 4,154,660 6,492,197 32,084,956 3,051,397 930,791 2,965,178 (5,560,940) 527,525 61,610,818 4,013,441 30,515,726 625,872 734 186 533,149 1,999,346 5,065,560 (631,548) 322,074 102,703 279,031 47,819 844,062 180,545 46,342 552,925 180,494 12,206,228 3,738,373 18,545 110 70 1,094 154,193 82,306 1,097,466 176,476 105,686 295,740 603,123 602 178 Total Non- Operating Expenses 0 (#0830) 2,794 23,339 40,866 103,378 253,558 136 231,711 523,042 1,159,364 43,819 22,854 54,495 137,310 111,992 41 312 Extraordinary Net Income Items; Gains/ Before Income (Losses) Tax (# 0831) (#0834) (89) (452,038) 0834-(0700+0820-0830+0831) 1,516,082 6,113,566 (1,171,845) 15,514,240 1,180,575 766,305 (3,710,824) 1,003,938 738,447 19,684,514 1,752,812 1,212,951 372,634 Income Tax (#0837) 29,758,280 5,039,994 4,154,660 6,466,923 32,062,212 2,996,972 931,885 3,119,371 (5,478,634) 1,624,991 61,649,984 4,119,127 30,359,428 1,117,003 1.295.052 Revenue In Excess of Expenses 2 (# 0800) 0800-(0834-0837) 1,516,082 6,113,566 (1,171,845) 15,514,240 - 1,180,575 766,305 (3,710,824) 1,003,938 738,447 19,684,514 1,752,812 1,212,951 372,634 29,758,280 5,039,994 4,154,660 6,466,923 32,062,212 2,996,972 931,885 3,119,371 (5,478,634) 1,624,991 61,649,984 4,119,127 30,359,428 1,117,003 1.295.052