Created FirstTransferReady query: Difference between revisions

← Older edit Newer edit →

@@ Line 1: / Line 1: @@
-The query created_FirstTransferReady in [[CFE]] contains the first time a patient was transfer ready for a given profile according to the different definitions used over time.
+The query created_FirstTransferReady in [[CFE]] contains the first time a patient was transfer ready for a given profile, i.e. the earliest [[Transfer Ready DtTm tmp entry]] dttm.
-That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest [[Service tmp entry]] DtTm for the profile as taken from [[Created_FirstTransferReady query ]].
-[[Transfer Ready DtTm tmp entry]]
 == Related articles ==
 {{Related Articles}}