Notifications
Clear all
Topic starter
Being new to CPS 12, we are trying to locate in the database several fields shown in the screens that aren't so obvious as to what table they would belong to. We do have the data dictionary, but only lists the database tables and columns, not where the columns appear in the screens.
Has anyone found any documentation or tool to show, for example, where the fee is stored that is used for billing on a claim? There are so many tables, and some of the same fields reside in several tables, so which one is shown on a specific screen?
In another software package we used previously, there was a handy option to display every SQL query that produced the data shown on the screen. That was so helpful. Does CPS 12 or any third party package have anything even close to that?
Thanks!
DavidL
Posted : February 25, 2015 11:52 am
From my notes:
SQL trace (Ctrl+Shift+S) - This trace captures SQL commands sent to the database while the trace is on.
User interactions trace (UI) (Ctrl+Alt+U) - This creates a snapshot of user interactions you can use to diagnose the problem.
MEL trace (Ctrl+Alt+M) (Chart) - This trace is helpful in troubleshooting problems with MEL statements. It shows what each step in the MEL function returns and the values of both variables and constants.
Posted : February 25, 2015 12:28 pm
It sounds like you are looking more on the PM side for the charges. If so, take a look at the gtProcedures table. That is the only place I could find what I would be looking for if I were wanting to pull charges...I assume you are looking at Crystal reports?
Just wondering, do you use the Centricity Analytics? That is very handy to pull in charges, ins payments, patient payments, etc as well as other things such as appt schedules, patient demographics etc.
Posted : February 25, 2015 1:20 pm
Topic starter
SLHV,
When would I do the keystrokes you mentioned for the SQL trace and UI trace, and where do I find the results of what those captured? Do they go into a table or clipboard?
Thanks,
DavidL
Posted : February 26, 2015 12:25 pm
I just tested it since it has been quite some time since I used it. The output path is %userprofile%\appdata\local\centricity\logs.
I noticed I missed part of my notes. Shft+Ctrl-T is a more detailed trace. This information was inexplicably found in the CPS System Planning & Requirements Guide under Troubleshooting.
Posted : February 26, 2015 12:44 pm
