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.

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

LOS ER Delay Also see "what links here"

Log

• 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.