Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

How to tie screen fields to database columns

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

116 Views

RSS

DavidL

(@davidl)

Posts: 6

Active Member

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

SLHV

(@slhv)

Posts: 478

Honorable Member

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

lkeith

(@lkeith)

Posts: 457

Honorable Member

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

DavidL

(@davidl)

Posts: 6

Active Member

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

SLHV

(@slhv)

Posts: 478

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0