Difference between revisions of "Admit DtTm"

From CCMDB Wiki
Jump to navigation Jump to search
(One intermediate revision by the same user not shown)
Line 7: Line 7:
     if available, [[Accept DtTm]], else if [[Arrive DtTm]]
     if available, [[Accept DtTm]], else if [[Arrive DtTm]]

This is implemented as [[query created_AdmitDtTm]] in [[CFE]].  
This is implemented as [[Created_AdmitDtTm query]].
{{Data Integrity Check List}}

== Relevance ==
== Relevance ==

Latest revision as of 16:25, 2021 September 22

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
   if available, Accept DtTm, else if Arrive DtTm

This is implemented as Created_AdmitDtTm query.

Data Integrity Checks (automatic list)

Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbneeds review


List of related concepts   

Also see "what links here"

Related articles

Related articles: