Notifications
Clear all
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
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
Topic starter
Just use the LASTLABS view.
Posted : January 30, 2014 1:17 am
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
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
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
