Notifications
Clear all
Topic starter
In the interface, I can click on a completed order and the docment with the corresponding results is accessible. How would I link completed orders to the results for that order in a extract from CPS?
I need to have the CPT code for the order and the codes/values for the results.
I don't see a link between the orders document and the subsequent results document in any of the database documentation.
Thank you,
John
Posted : April 1, 2015 6:49 am
Look in the ORDERS table. There is a field called RESULTSDIDLIST that is a comma separated list of the all the result document SDIDs.
Posted : April 1, 2015 12:13 pm