CCMDB Wiki

Created Variables Common 2021 table: Difference between revisions

← Older editNewer edit →
m →To Do: that'll happen no need for reminder
Tag: Manual revert
Line 8: Line 8:
== Update to [[PatientFollow Project]] structure ==
== Update to [[PatientFollow Project]] structure ==
=== ER Delay ===
=== ER Delay ===
{{DJ |
Has been updated to <code>ER_Delay: Nz([created_FirstNonER_BoardingLoc].[dttm],[Arrive_dttm])-Nz([Admit_DtTm])</code>
* I suppose you are changing the columns from adm to ER-delay, are these correct? are you just changing the data source from L_Log to tmp service or changing how to present the LOS - by record or by each service of each record?
** I just changed the source from the L_Log values to the tmp values, where available, ie they would still be by profile.
** I am defining it as <code>ER_Delay: Nz([created_FirstNonER_BoardingLoc].[dttm],[Arrive_dttm])-Nz([Admit_DtTm])</code>, ie you could use the [[created_FirstNonER_BoardingLoc query]] for other things as well. [[User:Ttenbergen|Ttenbergen]] 16:44, 2022 January 11 (CST)
}}


=== Transfer Ready DtTm ===
=== Transfer Ready DtTm ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Created_Variables_Common_2021_table"