Created FirstTransferReady query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 10: Line 10:
[[Category:Data structure]]
[[Category:Data structure]]
[[Category:Created Variables]]
[[Category:Created Variables]]
[[Category:Transfer Ready]]

Revision as of 08:31, 21 September 2022

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_FirstTransferReady query .


Transfer Ready DtTm tmp entry

Related articles

Related articles: