Admit DtTm

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.

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? --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. Actually, now that I say this: didn't we start Oct 1 at GRA and everywhere else Oct 15? Ttenbergen 13:51, 2022 February 9 (CST) I think we allow them to start earlier to practice but required them starting Oct1 and 15. that is why we have the earlier dates.--JMojica 16:24, 2022 February 16 (CST) Yes that explains dates before Oct 1. What I am concerned about is that we only have consistent data after Oct 15 (when all sites were doing it), not after Oct 1 (when only GRA was doing it), so that's what should be in the formula. Ttenbergen 17:31, 2022 February 17 (CST)

• SMW

• Cargo

• Categories

_Dev_CFE; _Dev_CCMDB Once discussion above is settled I need to update Created AdmitDtTm query accordingly. Julie explained that she has cleaned all the data, so we don't need to check for VADTTM at all, we can just say if present, use first service

added: 2022-02-09 action: 2022-03-09

• Cargo

• Categories

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

LOS ER Delay Also see "what links here"