Spreadsheet: 739566d1625776294-if-then-and-scanning-for-specifc-text-with-index-and-match-2nd-qtr-jana-and-rebecca-new-format-v2-forum-1-
Sheet: QLIK

MRN ( CLIK VIEW ) | Postoperative Delirium ( ADMITTED PTS DX AJ) | Readmission < 30 days ( GERIATRIC DISCHRGE) |  | ADMITTED PTS MRN | Diagnosis (All) |  | GERIATRIC DISCHARGE MRN | Admit Date ( must be sorted by earliet admitr date) ***** | Disch Date | LoS | Unit | Readmission < 30 days ( GERIATRIC DISCHRGE) added colum formula as well | Readmission < 30 days ( [NAME] added)
967059 |  |  |  | 967059 | Alcohol withdrawal syndrome, with delirium (CMS HCC Code) [1068399] |  | 1198 | 2021-04-30 00:00:00 | 2021-05-13 00:00:00 | 13 | UHS2400
1198 |  |  |  | 3686003 | Acute hyperactive delirium due to multiple etiologies [1147567] |  | 1808 | 2021-03-28 00:00:00 | 2021-04-03 00:00:00 | 6 | UHSAFBP
8940868 |  |  |  | 3789435 | Acute delirium [421614] Altered mental status, unspecified altered mental status type [1331152] |  | 5611 | 2021-04-11 00:00:00 | 2021-04-11 00:00:00 | 1 | UHSED
11734 |  |  |  | 4830293 | Delirium [193617] Polysubstance abuse (CMS HCC Code) [358583] Opiate overdose, accidental or unintentional, initial encounter (CMS HCC Code) [1289900] |  | 11734 | 2021-04-05 00:00:00 | 2021-04-07 00:00:00 | 1 | UHS2200
3686003 |  |  |  | 5146261 | Delirium [193617] Altered mental status, unspecified altered mental status type [1331152] |  | 11734 | 2021-04-28 00:00:00 | 2021-05-02 00:00:00 | 3 | UHS2300
80994 |  |  |  | 6011514 | Dehydration [276.51.ICD-9-CM] Delirium [193617] COPD with acute exacerbation (CMS HCC Code) [410053] |  | 12823 | 2021-05-04 00:00:00 | 2021-05-08 00:00:00 | 3 | UHS3400
2643138 |  |  |  | 6692461 | ESRD on dialysis (CMS HCC Code) [341769] Acute delirium [421614] Sacral wound, initial encounter [785980] Urinary tract infection with hematuria, site unspecified [1331097] Skin ulcer of sacrum, unspecified ulcer stage (CMS HCC Code) [1604923] |  | 16467 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 2 | UHS3300
815967 |  |  |  | 40410771 | Somnolence [186258] Delirium [193617] Injury of head, initial encounter [726891] Fall, initial encounter [738364] Laceration of scalp, initial encounter [775589] |  | 28249 | 2021-05-17 00:00:00 | 2021-05-25 00:00:00 | 8 | UHS3200
6054464 |  |  |  | 1198 | Acute hyperactive delirium due to multiple etiologies [1147567] Other acute osteomyelitis of left foot (CMS HCC Code) [1635793] |  | 36905 | 2021-04-27 00:00:00 | 2021-04-30 00:00:00 | 3 | UHS4200
1030186 |  |  |  | 1808 |  |  | 39966 | 2021-05-18 00:00:00 | 2021-05-22 00:00:00 | 2 | UHS2600
6461495 |  |  |  | 25385 |  |  | 70530 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 1 | UHS3200
5088646 |  |  |  | 27597 |  |  | 80994 | 2021-04-28 00:00:00 | 2021-05-04 00:00:00 | 6 | UHS3300
5454903 |  |  |  | 28249 | Closed fracture of both ankles, initial encounter [789687] |  | 80994 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 1 | UHSSCU
19254010 |  |  |  | 36905 | Gastroparesis [536.3.ICD-9-CM] Gastroesophageal reflux disease without esophagitis [326526] Diabetic ketoacidosis without coma associated with type 1 diabetes mellitus (CMS HCC Code) [1243721] Diabetic ketoacidosis without coma associated with type 2 diabetes mellitus (CMS HCC Code) [1243758] Uncontrolled type 1 diabetes mellitus with hyperglycemia (CMS HCC Code) [1458997] Nonproliferative diabetic retinopathy of right eye with macular edema (CMS HCC Code) [1474846] Hyperlipidemia, unspecified hyperlipidemia type [1515710] Hypertension, unspecified type [1659228] |  | 84566 | 2021-04-03 00:00:00 | 2021-04-05 00:00:00 | 2 | UHS3300
714733 |  |  |  | 39966 | Intractable nausea and vomiting [516670] Combined abdominal pain, vomiting, and diarrhea [1243372] |  | 95323 | 2021-04-14 00:00:00 | 2021-04-23 00:00:00 | 9 | UHS4300
40269323 |  |  |  | 58644 | Dyspnea on exertion [242094] Right leg pain [321811] Chest pain, unspecified type [1519651] |  | 100172 | 2021-04-08 00:00:00 | 2021-04-16 00:00:00 | 8 | UHS2200
9862194 |  |  |  | 673749 | Chest pressure [243890] Elevated troponin [321909] |  | 711927 | 2021-04-20 00:00:00 | 2021-04-24 00:00:00 | 4 | UHSAFBP
40283679 |  |  |  | 673988 | Pneumonia due to COVID-19 virus [[PHONE]] |  | 714733 | 2021-03-31 00:00:00 | 2021-04-05 00:00:00 | 4 | UHS2600
2309938 |  |  |  | 675363 | Hypoxia [300808] Congestive heart failure, unspecified HF chronicity, unspecified heart failure type (CMS HCC Code) [1674973] |  | 714733 | 2021-04-08 00:00:00 | 2021-04-11 00:00:00 | 1 | UHS3400
6143117 |  |  |  | 676593 | Foot pain, right [387523] Inability to ambulate due to ankle or foot [434142] |  | 714733 | 2021-04-23 00:00:00 | 2021-04-29 00:00:00 | 5 | UHS2600