Spreadsheet: 776751d1649883336-automate-daily-report-sample-daily-census
Sheet: 4.10

 |  | Daily Census |  |  |  |  |  |  |  |  |  |  |  | 2022-04-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-10 00:00:00
 | RM/BED | AdmDate | Resident Name | Physician | Payor | Secondary | Notes | RM/BED | AdmDate | Resident Name | Physician | Payor | Secondary | Notes |  | Projected Admissions |  |  |  |  |  |  |  | Admissions |  |  |  | Medicare (A)
 | 101A |  |  |  |  |  |  | 230A |  |  |  |  |  |  |  | Resident Name | Location | Payor | Date Rec'd | Date Expected | Floor | Room | CM | Name | Room | From | Payor | Kaiser (K)
 | 102A |  |  |  |  |  |  | 230B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 112A | Hospital | HMO | HMO (H)
 | 103A |  |  |  |  |  |  | 230C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] | 114A | Hospital | Medicare | HMO/PPO RUG
 | 104A |  |  |  |  |  |  | 231A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SJH (SJH)
 | 105A |  |  |  |  |  |  | 231B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Skilled Patients
 | 106A |  |  |  |  |  |  | 231C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medi-Cal (M)
 | 107A |  |  |  |  |  |  | 232A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Private (P)
 | 108A |  |  |  |  |  |  | 232B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hospice (HO)
 | 109A |  |  |  |  |  |  | 232C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bedholds (B)
 | 110A |  |  |  |  |  |  | 233A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discharges |  |  |  | In-House Census
 | 111A |  |  |  |  |  |  | 233B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Room | TO | Payor | In-House Census by Floor
 | 112A | 2022-04-10 00:00:00 | Doe, [NAME] | Park |  |  |  | 234A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | 113A | Home | HMO | First
 | 113A |  |  |  |  |  |  | 234B |  |  |  |  |  |  |  | Projected Discharges |  |  |  |  |  |  |  |  |  |  |  | Second
 | 114A | 2022-04-10 00:00:00 | Smith, [NAME] | Geiss |  |  |  | 234C |  |  |  |  |  |  |  | Resident Name | Room | LCD | DC | Payor | Location | Time | Day |  |  |  |  | Third
 | 115A |  |  |  |  |  |  | 235A
 | 116A |  |  |  |  |  |  | 235B
 | 117A |  |  |  |  |  |  | 235C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Payor/Room Changes
 | 119A |  |  |  |  |  |  | 236A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | From | To | Date
 | 121A |  |  |  |  |  |  | 236B
 | 122A |  |  |  |  |  |  | 237A
 | 123A |  |  |  |  |  |  | 237B
 | 124A |  |  |  |  |  |  | 237C
 | 125A |  |  |  |  |  |  | 238A
 | 126A |  |  |  |  |  |  | 238B
 | 127A |  |  |  |  |  |  | 301A
 | 128A |  |  |  |  |  |  | 301B
 | 129A |  |  |  |  |  |  | 302A
 | 130A |  |  |  |  |  |  | 302B
 | 201A |  |  |  |  |  |  | 302C
 | 201B |  |  |  |  |  |  | 303A
 | 201C |  |  |  |  |  |  | 303B
 | 202A |  |  |  |  |  |  | 303C
 | 202B |  |  |  |  |  |  | 304A
 | 202C |  |  |  |  |  |  | 304B
 | 203A |  |  |  |  |  |  | 305A
 | 203B |  |  |  |  |  |  | 305B
 | 203C |  |  |  |  |  |  | 305C
 | 204A |  |  |  |  |  |  | 306A |  |  |  |  |  |  |  | Hospital/Bedhold
 | 204B |  |  |  |  |  |  | 306B |  |  |  |  |  |  |  | Resident Name | DATE | Hospital | Resident Name | Date
 | 205A |  |  |  |  |  |  | 306C
 | 205B |  |  |  |  |  |  | 307A
 | 206A |  |  |  |  |  |  | 307B
 | 206B |  |  |  |  |  |  | 308A
 | 206C |  |  |  |  |  |  | 308B
 | 207A |  |  |  |  |  |  | 308C
 | 207B |  |  |  |  |  |  | 309A
 | 207C |  |  |  |  |  |  | 309B
 | 208A |  |  |  |  |  |  | 310A
 | 208B |  |  |  |  |  |  | 310B
 | 208C |  |  |  |  |  |  | 310C
 | 209A |  |  |  |  |  |  | 311A
 | 209B |  |  |  |  |  |  | 311B
 | 210A |  |  |  |  |  |  | 312A
 | 210B |  |  |  |  |  |  | 312B
 | 210C |  |  |  |  |  |  | 313A
 | 211A |  |  |  |  |  |  | 313B
 | 211B |  |  |  |  |  |  | 313C
 | 211C |  |  |  |  |  |  | 314A
 | 212A |  |  |  |  |  |  | 314B
 | 212B |  |  |  |  |  |  | 314C
 | 212C |  |  |  |  |  |  | 315A
 | 213A |  |  |  |  |  |  | 315B
 | 213B |  |  |  |  |  |  | 316A
 | 213C |  |  |  |  |  |  | 316B
 | 214A |  |  |  |  |  |  | 317A
 | 214B |  |  |  |  |  |  | 317B
 | 215A |  |  |  |  |  |  | 319A
 | 215B |  |  |  |  |  |  | 319B
 | 215C |  |  |  |  |  |  | 321A
 | 216A |  |  |  |  |  |  | 321B
 | 216B |  |  |  |  |  |  | 322A
 | 216C |  |  |  |  |  |  | 322B
 | 217A |  |  |  |  |  |  | 323A
 | 217B |  |  |  |  |  |  | 324A
 | 217C |  |  |  |  |  |  | 324B
 | 219A |  |  |  |  |  |  | 325B
 | 219B |  |  |  |  |  |  | 326A
 | 219C |  |  |  |  |  |  | 326B
 | 221A |  |  |  |  |  |  | 327B
 | 221B |  |  |  |  |  |  | 328B
 | 222A |  |  |  |  |  |  | 329A
 | 222B |  |  |  |  |  |  | 329B
 | 222C |  |  |  |  |  |  | 330A
 | 223A |  |  |  |  |  |  | 330B |  |  |  |  |  |  |  |  |  |  |  |  | Date | Shift | Floor
 | 223B |  |  |  |  |  |  | 331A
 | 223C |  |  |  |  |  |  | 331B
 | 224A |  |  |  |  |  |  | 332A
 | 224B |  |  |  |  |  |  | 332B
 | 224C |  |  |  |  |  |  | 333A
 | 225A |  |  |  |  |  |  | 333B
 | 225B |  |  |  |  |  |  | 334A
 | 225C |  |  |  |  |  |  | 334B
 | 226A |  |  |  |  |  |  | 336A
 | 226B |  |  |  |  |  |  | 336B
 | 226C |  |  |  |  |  |  | 337A
 | 227A |  |  |  |  |  |  | 337B
 | 227B |  |  |  |  |  |  | 338B
 | 227C |  |  |  |  |  |  | 335B
 | 228A |  |  |  |  |  |  | 336A
 | 228B |  |  |  |  |  |  | 336B
 | 228C |  |  |  |  |  |  | 337A
 | 229A |  |  |  |  |  |  | 337B
 | 229B |  |  |  |  |  |  | 338A
 | 229C |  |  |  |  |  |  | 338B