Admit DtTm: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 5: Line 5:
{{DJ |  
{{DJ |  
* 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)  }}
  If [[Visit Admit DtTm]] > #2020-10-15# then   
  If [[Visit Admit DtTm]] > #2020-10-15# then   
     earliest [[Service tmp entry]] DtTm in profile
     earliest [[Service tmp entry]] DtTm in profile

Revision as of 17:59, 2022 February 8

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)
  • SMW


  • Cargo


  • Categories
If Visit Admit DtTm > #2020-10-15# 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)

 AppStatus
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Function long LOS()CCMDB.accdbneeds review
Link suspect negative transit time queryCentralized data front end.accdbimplemented

Relevance

List of related concepts   

Also see "what links here"

Related articles

Related articles: