Notifications
Clear all
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
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
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
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
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
Hi There,
Does anybody has a more complete list of WhatChange variable?
Thanks in advance,
Best 😉
Francisco
Posted : February 23, 2021 5:02 am
