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

Using XID in record selection (CPS)

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

130 Views

RSS

JClarkLRGH

(@jclarklrgh)

Posts: 31

Eminent Member

Topic starter

Howdy CHUG,

We recently converted to CPS 11 from Centricity EMR 9.5. When writing reports against EMR 9.5 (Oracle) I was always able to use something like "{SOMETABLE.XID} >= X" (where X is a very large number than an inactive value would never exceed) to select active XID values only from that table.

I've noticed that the active row value appears to be 1.00e+18 rather than the 1e35 value that I was used to seeing in the past, but regardless I was expecting some variation on the above select logic to work.

Can anyone point me in the right direction to help select only rows with active XID values from CPS 11?

Thanks in advance!

Posted : January 20, 2014 5:39 am

JNordberg

(@jnordberg)

Posts: 61

Trusted Member

JClarkLRGH said:

Howdy CHUG,

We recently converted to CPS 11 from Centricity EMR 9.5. When writing reports against EMR 9.5 (Oracle) I was always able to use something like "{SOMETABLE.XID} >= X" (where X is a very large number than an inactive value would never exceed) to select active XID values only from that table.

I've noticed that the active row value appears to be 1.00e+18 rather than the 1e35 value that I was used to seeing in the past, but regardless I was expecting some variation on the above select logic to work.

Can anyone point me in the right direction to help select only rows with active XID values from CPS 11?

Thanks in advance!

Have you had any success in figuring out how to use the XID in CPS11?

Based on the data schema documentation, we have been looking into how to select/display only the last value entered for any observation HDID and thought that maybe the XID value could be used for this.

Posted : January 29, 2014 10:45 pm

JClarkLRGH

(@jclarklrgh)

Posts: 31

Eminent Member

Topic starter

Just use the LASTLABS view.

Posted : January 30, 2014 1:17 am

JNordberg

(@jnordberg)

Posts: 61

Trusted Member

JClarkLRGH said:

Just use the LASTLABS view.

Thanks.

We were trying to see, for an observation not already included in a view, if we could select the last value for it without having to create another view. Is this not at all possible when using Crystal?

Posted : January 30, 2014 1:23 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

The LASTLABS view is the PID, HDID and the most recent date of every obs term in the database. If you join it to the rptobs table you can pull in all the data. Have to join each column

like

"from ml.lastlabs l left join ml.rptobs r 
on l.pid = r.pid and l.maxlabdate = r.obsdate  and l.hdid = r.hdid"

Posted : January 30, 2014 1:41 am

JNordberg

(@jnordberg)

Posts: 61

Trusted Member

DavidShower said:

The LASTLABS view is the PID, HDID and the most recent date of every obs term in the database. If you join it to the rptobs table you can pull in all the data. Have to join each column

like
"from ml.lastlabs l left join ml.rptobs r
on l.pid = r.pid and l.maxlabdate = r.obsdate  and l.hdid = r.hdid"
 
 
 
Thanks for the help

Posted : January 30, 2014 1:57 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