Admit DtTm: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 6: | Line 6: | ||
* somewhere I read 2021-10-01, elsewhere -15, which one is right? | * somewhere I read 2021-10-01, elsewhere -15, which one is right? | ||
** I have looked at the tmp Service and the earliest date is Oct 17, 2019 (??) followed by Feb 12, 2020, then Mar 10,2020, etc. even earlier than oct 15, 2020. there are 175 records with date earlier than Oct 1, 2020. how about a cut-off OCT 1, 2020? --[[User:JMojica|JMojica]] 16:59, 2022 February 8 (CST) | ** I have looked at the tmp Service and the earliest date is Oct 17, 2019 (??) followed by Feb 12, 2020, then Mar 10,2020, etc. even earlier than oct 15, 2020. there are 175 records with date earlier than Oct 1, 2020. how about a cut-off OCT 1, 2020? --[[User:JMojica|JMojica]] 16:59, 2022 February 8 (CST) | ||
*** Agreed, we should use -10-01. I will need to update [[Created_AdmitDtTm query]] because it actually doesn't have a cut-off at all. Do we want to clean out any [[Service tmp entry]] from before Oct 1? We would need to update the start dttm on that page as well. [[User:Ttenbergen|Ttenbergen]] 13:51, 2022 February 9 (CST) }} | *** Agreed, we should use -10-01. I will need to update [[Created_AdmitDtTm query]] because it actually doesn't have a cut-off at all. Do we want to clean out any [[Service tmp entry]] from before Oct 1? We would need to update the start dttm on that page as well. Actually, now that I say this: didn't we start Oct 1 at GRA and everywhere else Oct 15? [[User:Ttenbergen|Ttenbergen]] 13:51, 2022 February 9 (CST) }} | ||
Revision as of 13:52, 9 February 2022
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
Admit DtTm is not as simple of a concept as it might seem, and it's definition and storage in our database has changed over time.
|
|
If Visit Admit DtTm > #2020-10-01# then earliest Service tmp entry DtTm in profile else if available, Accept DtTm, else Arrive DtTm
This is implemented as Created_AdmitDtTm query.
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" |