CCMDB Wiki

Visit Admit DtTm differences within same admission: Difference between revisions

← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
No edit summary
No edit summary
 
(2 intermediate revisions by one other user not shown)
Line 4: Line 4:


It was decided that the next few times Julie sees such a problem she’ll forward them to Tina, who’ll analyze the reason(s). This may be an ADT/Cognos error and it may require reporting it to be fixed to Chastity. It was later decided that Pagasa is the one who catches these while running [[Link_suspect_not_same_visitAdmitDtTm query]], and would therefore be the one to forward examples to Tina.  
It was decided that the next few times Julie sees such a problem she’ll forward them to Tina, who’ll analyze the reason(s). This may be an ADT/Cognos error and it may require reporting it to be fixed to Chastity. It was later decided that Pagasa is the one who catches these while running [[Link_suspect_not_same_visitAdmitDtTm query]], and would therefore be the one to forward examples to Tina.  
* This continues to happen infrequently, but the decision was made at TASK that we would not change the Visit Admit DtTm, however Pagasa will change those Visit Admit DtTm fields for those profiles where there are multiple records and the Visit Admit DtTm is wrong in one of the profiles.  Tina said copy/paste should be used and not to change manually. [[User:Lkaita|Lisa Kaita]] 11:59, 2024 February 22 (CST)


This may be related to an older task in Tina's outlook "Chastity - exclusion of "fixed" data" - not sure if that ever went anywhere.  
This may be related to an older task in Tina's outlook "Chastity - exclusion of "fixed" data" - not sure if that ever went anywhere.  


{{DiscussTask |  
{{Discuss |  
* Do we still see occasional mismatches? [[User:Ttenbergen|Ttenbergen]] 13:40, 2022 December 8 (CST)
* This came up again during [[Re-analysis and generation of Overstay2 model]]. We need to add here what we learned and what we need to do about this. [[User:Ttenbergen|Ttenbergen]] 15:12, 23 February 2025 (CST)
** There are still few which showed up. Last Oct5, 2023,  a new problem came up - this is a case where the Visit Admit Dttm is after the Admission Dttm and/or Discharge Dttm.  The error was brought up by a requestor who is interested on the days in hospital prior to ICU admission - when he calculated the difference between the Admission Dttm and Visit Adm Dttm, he found cases with negative values. In the WIKI, it is said that the Visit Adm Dttm is used as an identifier and not as a Date. When Lisa checked the reason why the Visit Adm dttm is after admission, it was because the automated COGNOS showed up the next hospital admission. With this purpose/use brought to our attention by users, should we now check the automated COGNOS Visit Admit dttm?  --[[User:JMojica|JMojica]] 09:13, 2023 November 23 (CST)}}
}}


== Log ==
== Log ==
* 2025-02-23 - this came up again during the [[Re-analysis and generation of Overstay2 model]]
* 2022-12-08 - email to Pagasa to request examples
* 2022-12-08 - email to Pagasa to request examples
* 2022-?? various discussions
* 2022-?? various discussions
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Visit_Admit_DtTm_differences_within_same_admission"