Query created PatientFollow: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 2: Line 2:


== Log ==  
== Log ==  
2022-09-06 - changed definition from <code>PatientFollow_old: (Nz([Accept_DtTm],[Arrive_DtTm])>#2020-10-15# Or [Dispo_Dttm]>#2020-10-15#)</code> to <code></code> because the old definition left records with accept/arrive before but dispo after without boarding locs.
2022-06-28 - created query, applied it to [[Created_Variables_Common_2021 table]]/[[ER Delay]]
2022-06-28 - created query, applied it to [[Created_Variables_Common_2021 table]]/[[ER Delay]]



Revision as of 13:57, 2022 September 6

The query created_PatientFollow in CFE contains a definition of whether the record was set up under the rules following PatientFollow Project or before. The concept is used in many places so a single query was implemented to make sure this is done consistently everywhere.

Log

2022-09-06 - changed definition from PatientFollow_old: (Nz([Accept_DtTm],[Arrive_DtTm])>#2020-10-15# Or [Dispo_Dttm]>#2020-10-15#) to because the old definition left records with accept/arrive before but dispo after without boarding locs. 2022-06-28 - created query, applied it to Created_Variables_Common_2021 table/ER Delay

Related articles

Related articles: