We have some providers that previously used CPS 12.04 (I believe it was 4?) and they still contract through a vendor to host their old CPS to allow them access. They have been having technical difficulties and the client is still not accessible. I have access to the raw SQL db. Does anyone have any custom crystal reports or SQL views that would provide us with something similar to a chart summary, historical med list etc? I am familiar with SQL, Crystal, Oracle EMR tables and downloaded data schema for CPS so I could start to build but this has already been down for a bit so we are in a time crunch to build from scratch and validate. And/or if anyone has ability to extract all the records into a file, that would be welcome info also. Thanks!
I can help you. Contact me via email.