Admit DtTm: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Definition of a Medicine Laptop Admission" to "Definition of a Medicine Program Admission" |
||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care | The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care Program Admission]]/[[Definition of a Medicine Program Admission]]. | ||
== 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]]. | |||
== 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 26: | 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 09:41, 7 March 2025
The Admit DtTm is the start of a profile as per Definition of a Critical Care Program Admission/Definition of a Medicine Program 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 |
| Query check_tmp_AHC | CCMDB.accdb | needs review |
| Query check_tmp_Overstay2 | 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.