PowerBI Data Model for CCMDB: Difference between revisions

Line 20:

** I think I have it set up to do EMIPs correctly

* LOSs contains measures to calculate LOS_ER, LOS_Reg (legit med stay), and LOS_Over (time between initial transfer ready and the last dispo for the hospitalization

{{DT|

{{DT| '''ER Delay and Overstay'''

* Need to make sure I do things this way and include this in the right pages:

* Need to make sure I do things this way and include this in the right pages, possibly [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] but a lot of other pages touch on this, so maybe it needs to be a template? It may not be consistent everywhere:

Note from email from Julie 2024-20-24:

I do not use any cut-off e.g. 2020-10-15 because the tmp has been populated by boarding data since July 2018 for ICU and Sept 2019 for Med. The cut-off Oct 2020 Patient Follow only applies for tmp Service but not for tmp Boarding loc. By the way. the patient follow started early at Grace Oct 1, 2020 (they piloted it), while HSC and STB started Oct15, 2020. Similar with EMIPs, I have two sources of ER-delay namely 1. from Accept and Arrive 2. from Tmp : first boarding dttm and second boarding dttm. If both have values, I use the one from the tmp source. }}

@@ Line 20: / Line 20: @@
 ** I think I have it set up to do EMIPs correctly
 * LOSs contains measures to calculate LOS_ER, LOS_Reg (legit med stay), and LOS_Over (time between initial transfer ready and the last dispo for the hospitalization
-{{DT|
+{{DT| '''ER Delay and Overstay'''
-* Need to make sure I do things this way and include this in the right pages:
+* Need to make sure I do things this way and include this in the right pages, possibly [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] but a lot of other pages touch on this, so maybe it needs to be a template? It may not be consistent everywhere:
 Note from email from Julie 2024-20-24:
 I do not use any cut-off  e.g. 2020-10-15 because the tmp has been populated by boarding data since July 2018 for ICU and Sept 2019 for Med.  The cut-off Oct 2020 Patient Follow only applies for tmp Service but not for tmp Boarding loc.  By the way. the patient follow started early at Grace  Oct 1, 2020  (they piloted it),  while HSC and STB started Oct15, 2020.   Similar with EMIPs, I have two sources of ER-delay namely 1. from Accept and Arrive 2. from Tmp : first boarding dttm and second boarding dttm.  If both have values, I use the one from the tmp source. }}