Notifications
Clear all
Topic starter
Is there anyway to see the time an obsterm was populated? I know the obsterm date/times default to the time the visit is opened, but is there a way to see the exact time the field was populated?
Posted : January 2, 2018 2:58 am
You could look at the DB_CREATE_DATE or DB_UPDATED_DATE in the OBS table in the database. Or, if you have clinical auditing turned on you could right click on the document and look at View Contributors List.
Posted : January 2, 2018 4:06 am
Topic starter
Thank you David! I will look into that 🙂
Posted : January 2, 2018 6:50 am
Your profile says that you use CEMR (Oracle) so I can provide you with an oracle example. If you are on CPS/MSSQL let me know and I can make some changes to the code.
If you are comfortable with SQL you can use the OBSID column. It is a ge emr timestamp field but any ge timestamp field can be converted to a date. The below SQL should pull all of the WEIGHT obs values for the patientid 123456 along with the date they were entered. The sql query was written from memory and not tested as I am not currently connected to an EMR database at home.
select ml.convert_id_to_date(obs.obsid) obs_entered, obshead.name obsname, obs.obsvalue from obs
inner join obshead on obshead.hdid = obs.hdid
inner join person on person.pid = obs.pid
where person.patientid = '123456' and obshead.name = 'WEIGHT'
and obs.change = 2
Posted : January 2, 2018 2:58 pm
Topic starter
Thank you so much! I do have EMR so I will definitely test this SQL query.
Thanks for your help
Posted : January 3, 2018 8:11 am
If you are like our clinic, we use EXTERNALID instead of patientid so our where clause would have something like this instead
PERSON.EXTERNALID = '123456789'
I tested the query just now and it works.
Posted : January 3, 2018 8:15 am
