Created FirstTransferReady query: Difference between revisions
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..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| 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 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 [[ | 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 ]]. | ||