CCMDB Wiki

Created FirstTransferReady query

Revision as of 16:55, 29 December 2021 by Ttenbergen (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Created_FirstTransferReady_query&oldid=153702"