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

Form Component count

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

5 Posts

4 Users

0 Reactions

58 Views

RSS

mrooney

(@mrooney)

Posts: 50

Trusted Member

Topic starter

Does anyone know the best way to get the form component count from EMR? We would like to know how many forms are in our EMR.

Posted : July 1, 2015 6:42 am

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

You can run a simple Crystal Report to return this number...

1. Use the FORM table

2. Group by FORM.FID

3. Insert summary of DistinctCount of FORM.FID

4. Done!

This will return every form component including obsolete. The EMR application keeps the versions of a form page to support users who still have a chart update in progress using an older version of an on-screen form.

If you want only active form components add {FORM.ACTIVE}="D" to Record Selection.

If you would prefer to get a count on the form sets then...

1. Use the FORMSET table

2. Group by FORMSET.FSID

3. Insert summary of DistincCount of FORMSET.FSID

4. Done

If you want only active forms add {FORMSET.ACTIVE}="D" to Record Selection.

Posted : July 1, 2015 8:40 am

mgryder

(@mgryder)

Posts: 11

Active Member

If you would like to do this directly in SQL you can use the following query:

SELECTcount([FID])asCountofForms

FROM[FORM]

whereactive='d'

Posted : July 1, 2015 9:13 am

mrooney

(@mrooney)

Posts: 50

Trusted Member

Topic starter

Thank you both.

Posted : July 1, 2015 4:23 pm

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Are there any known performance issues with having a high count in the FORM table?

Posted : July 2, 2015 11:12 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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