Admit DtTm: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→Definition) |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
== Definition == | == Definition == | ||
Admit DtTm | The derivation of Admit DtTm has changed over time, involving the fields [[Accept DtTm]], [[Arrive DtTm]] and [[Service tmp entry]] DtTm. Admit DtTm is defined as follows: | ||
SELECT L_Log.Pat_ID, CDate(Nz([Service_DtTm],Nz([Accept_dttm],[Arrive_Dttm]))) AS Admit_DtTm | |||
FROM L_Log LEFT JOIN created_FirstService ON L_Log.Pat_ID = created_FirstService.Pat_ID; | |||
This is implemented as [[Created_AdmitDtTm query]]. | This is implemented as [[Created_AdmitDtTm query]]. | ||
== Transition == | |||
GRA changed to this Oct 1 and everyone else Oct 15. Julie cleaned all the data so we don't need to worry about this: we can simply say if Service tmp DtTm is available, use it. | |||
{{Data Integrity Check List}} | {{Data Integrity Check List}} | ||
| Line 23: | Line 22: | ||
Also see "what links here" | Also see "what links here" | ||
}} | }} | ||
== Log == | |||
* 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here. | |||
== Related articles == | == Related articles == | ||
Latest revision as of 15:34, 2022 April 4
The Admit DtTm is the start of a profile as per Definition of a Critical Care Laptop Admission/Definition of a Medicine Laptop Admission.
Definition
The derivation of Admit DtTm has changed over time, involving the fields Accept DtTm, Arrive DtTm and Service tmp entry DtTm. Admit DtTm is defined as follows:
SELECT L_Log.Pat_ID, CDate(Nz([Service_DtTm],Nz([Accept_dttm],[Arrive_Dttm]))) AS Admit_DtTm FROM L_Log LEFT JOIN created_FirstService ON L_Log.Pat_ID = created_FirstService.Pat_ID;
This is implemented as Created_AdmitDtTm query.
Transition
GRA changed to this Oct 1 and everyone else Oct 15. Julie cleaned all the data so we don't need to worry about this: we can simply say if Service tmp DtTm is available, use it.
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Query check tmp Service and Boarding Loc during admission timeframe | CCMDB.accdb | implemented |
| Function long LOS() | CCMDB.accdb | needs review |
| Link suspect negative transit time query | Centralized data front end.accdb | implemented |
Relevance
| List of related concepts |
|
Also see "what links here" |
Log
- 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.