DtTm for First Boarding Loc and First Service
Work in progress to replace Template:First Service and Boarding Loc same Ttenbergen 12:15, 2023 January 25 (CST)
When data is first entered as per Using Cognos2 to keep track of patients, the Service tmp entry is entered as in the Cognos2 data. This is so the data can be compared to new entries in CSS and CE.
Once the patient is discharged for a given record, the first Boarding Loc DtTm to be consistent with the first Service tmp entry; see . This is because we do not want to include time spent at a Boarding Loc under a different service in our reporting. It also allows us to do a cross-check query check_tmp_Boarding_Loc_Service_first_same to prevent accidental inconsistencies.
Background
We decided during Task Team Meeting - Rolling Agenda and Minutes 2021#ICU Database Task Group Meeting – April 22, 2021 that the first Service tmp entry DtTm should be the same as that for the first Boarding Loc entry.
This decision was based on popular demand rather than logic, reason or data integrity. We had previously entered the actual unit start dttm because as the start of the boarding loc entry for two reasons:
- it is the actual time a pt arrived on that unit, so it's a more intuitive data point for someone not familiar with our data
- it allows clean matching to Cognos entries so the various Cognos tools can identify if an entry has already been dealt with
Related articles
| Related articles: |