Admit DtTm

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. This page gives some definitions and how we have implemented them.

Proposed definition

If Visit Admit DtTm > #2020-10-15# then  
   earliest Service tmp entry DtTm in profile
else
   if available, Accept DtTm, else if 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
Link suspect negative transit time query	Centralized data front end.accdb	implemented

Relevance

List of related concepts

LOS ER Delay more to come as we refine things... Also see "what links here"