Visit Admit DtTm differences within same admission: Difference between revisions

JMojica (talk | contribs)
No edit summary
No edit summary
Line 7: Line 7:
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 |  
{{DiscussTask | JALT
* Do we still see occasional mismatches? [[User:Ttenbergen|Ttenbergen]] 13:40, 2022 December 8 (CST)
* Do we still see occasional mismatches? [[User:Ttenbergen|Ttenbergen]] 13:40, 2022 December 8 (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)}}
** 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)}}