Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

HistoricalInfo WhatChange Column

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

68 Views

RSS

jbarta

(@jbarta)

Posts: 12

Active Member

Topic starter

I have a pretty recent database dictionary for Centricity, but when I look at the HistoricalInfo table the dictionary gives you a limited number of descriptions for the ids in the WhatChange column. When I query our HistoricalInfo table there are 249 distinct values in the WhatChange column. Does anyone have a more extensive list of the descriptions for the ids in the WhatChange column?

Posted : January 8, 2019 10:03 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

What I am seeing in my emr 9.12 documentation is:

Numeric bitmap that indicates which field was changed, affects which values are shown in bold.

Posted : January 9, 2019 4:36 am

jbarta

(@jbarta)

Posts: 12

Active Member

Topic starter

Thanks for responding. I have the same information plus a small list of what some of the numeric values map to:

Numeric bitmap that indicates which field was changed, affects which values are shown in bold.

NAME_CHANGE = 2
WORKPHONE_CHANGE = 4
ALTPHONE_CHANGE = 8
FAX_CHANGE = 16
EMAIL_CHANGE = 32
ADDRESS1_CHANGE = 64
ADDRESS2_CHANGE = 128
CITY_CHANGE = 256
STATE_CHANGE = 512
ZIP_CHANGE = 1024
COUNTRY_CHANGE = 2048
RESPPROVID_CHANGE = 4096
CELLPHONE_CHANGE = 8192
PAGER_CHANGE = 16384

I was hoping for a more extensive list then this.

Posted : January 9, 2019 4:54 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I am going to guess, but those are about the only fields within the Historicalinfo table.

Interestingly, they are all exponents of the number 2; 2^1, 2^2, etc...

Thus, if you get a 'whatchange' value of 12, I bet that means workphone and altphone changed. Add them up.

For those really geeky, and remember binary, octal, hex,.... this might be easier to grasp.

think of workphone as 0100 (binary representation of 4)

altphone as 1000 (binary of 8)

thus, a code for the field of 1100 (equals 12 in decimal) and would mean those two items changed.

Posted : January 9, 2019 5:09 am

jbarta

(@jbarta)

Posts: 12

Active Member

Topic starter

I see the logic there, but when I query the value 12 and look up one of the patients in Centricity, it appears that Address 1 and Address 2 changed. But I believe you are on to something.

Posted : January 9, 2019 5:26 am

franciscol

(@franciscol)

Posts: 1

New Member

Hi There,

Does anybody has a more complete list of WhatChange variable?

Thanks in advance,

Best 😉

Francisco

Posted : February 23, 2021 5:02 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0