We have created a custom table within our CPS database that contains data that is provided from our payers. This data contains Preventive Measures that the patient is due for. What I would like to do with this data is to pull it into a form with some additional logic, from which the clinical staff can take some actions.
Does anyone know of a way to pull info from a Custom Table into a VFE form? Any feedback would be appreciated.
Amar
I've designed an interface to the Centricity database, actually any SQL database. You submit a SQL query string, the interface returns the requested data as a string, fields delimited by "^", records delimited by "|". I've used this interface in a variety of forms. There is no limit to what you can do. Please feel free to contact me. [email protected]
We use this, it works well for obtaining data that is not available with data symbols or by using mldefs, it is also frequently a lot faster than using mldefs depending on the application.