Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
Line 19: | Line 19: | ||
}} | }} | ||
* [[Query s tmp Boarding Loc date item]] - has question for Julie | * [[Query s tmp Boarding Loc date item]] - has question for Julie | ||
This is a list of queries that relate to accept, arrive | This is a list of queries that relate to accept, arrive | ||
{{#ask: [[DICRelatedConcepts::Accept DtTm]] || [[DICRelatedConcepts::Arrive DtTm]] | {{#ask: [[DICRelatedConcepts::Accept DtTm]] || [[DICRelatedConcepts::Arrive DtTm]] [[DICStatus::implemented]] || [[DICStatus::needs review]] | ||
|?DICApp = App | |?DICApp = App | ||
|?DICStatus = Status | |?DICStatus = Status | ||
Line 27: | Line 27: | ||
|format=broadtable | |format=broadtable | ||
|limit=100}} | |limit=100}} | ||
<!-- | |||
relatedConcepts not yet implemented in Cargo. | |||
{{#cargo_query: | |||
tables=table1=DataIntegrityChecks | |||
|join on=table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc. | |||
|fields=field1=fieldAlias1,field2=Alias2, etc. | |||
|where=Status<> "retired" and Status<>"declined" | |||
|order by=table2.fieldF, etc. | |||
|limit=1000 | |||
|default=textIfNoData | |||
|more results text=MoreOrInsteadOfLimitZero | |||
|no html | |||
|format=ul dynamic table | |||
}} | |||
--> | |||
== Plan/notes == | == Plan/notes == |
Revision as of 13:16, 2022 March 31
We used to collect only Admit DtTm; at some point this was split into Accept DtTm and Arrive DtTm. With the collection of Boarding Loc and Service tmp entry under 2021-07 rules, this duplicates info:
- Accept DtTm is the same as first Service tmp entry DtTm if pt comes from ER
- Arrive DtTm is the same as first Boarding Loc DtTm or second Boarding Loc DtTm
This page is about the process of eliminating the collection of Admit DtTm and Accept DtTm to avoid that duplication and inconsistencies resulting from it.
Target date
As discussed with Julie, our target date for this change is Oct 1. Ttenbergen 14:39, 2021 September 2 (CDT)
|
Related Cross-checks
_dev_CCMDB _dev_CFE
|
|
- Query s tmp Boarding Loc date item - has question for Julie
This is a list of queries that relate to accept, arrive
App | Status | |
---|---|---|
Query check long transfer delay | CCMDB.accdb | needs review |
Function long LOS() | CCMDB.accdb | needs review |
Query check CCI each count vs LOS | CCMDB.accdb | needs review |
Query cardiac arrest throughout admission | Centralized data front end.accdb | needs review |
Query Import request matcher | DSM Labs Consistency check.accdb | needs review |
Plan/notes
Is there a target date for eliminating this field? Ttenbergen 15:10, 2021 April 15 (CDT) |
|
|
|
|