Created FirstTransferReady query: Difference between revisions

Created page with "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. 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_FirstService query . Transfer Ready DtTm tmp entry == Related articles == {{Related Articles}} Category:Data str..."
 
mNo edit summary
 
(6 intermediate revisions by the same user not shown)
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 created_FirstTransferReady query in [[CFE]] contains the first time a patient was transfer ready for a given profile according to the different definitions and encodings of transfer ready over time. It returns the earliest date per record from [[Created TransferReady query]].


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_FirstService query ]].
== Log ==
* 2022-09-22 - updated to use [[created_TransferReady query]]


[[Transfer Ready DtTm tmp entry]]
== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}
Line 10: Line 9:
[[Category:Data structure]]
[[Category:Data structure]]
[[Category:Created Variables]]
[[Category:Created Variables]]
[[Category:Transfer Ready]]