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

New fields in PRESCRIB table - Erxrenewal Statuses

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

73 Views

RSS

aroberts

(@aroberts)

Posts: 176

Reputable Member

Topic starter

Afternoon - SQL question, There are several new tables in the system and would like to use them but don't know what they mean for reporting. For example there is a column in PRESCRIB called ERXRENEWAL STATUSES with options including: A, AC, AP, C,CT, D,DN, & DR

Anyone know what they mean? I think they just showed up after 12.3 ?

Posted : January 27, 2020 6:28 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

According to the data dictionary, this is the description of the field -

'Code denoting the status of an electronic prescription. Denied New to Follow, Denied, Approved, Approved with Changes'

We only have 'C' in our environment but we do not accept refill requests from the pharmacy. I would guess it goes something like AC - Approved with Changes, A - Approved, AP - Approval Pending, etc. but I would find some patient data to verify each one. I believe 'C' is for Cancelled. I believe the ones we write new in the application are set to NULL.

Posted : January 27, 2020 8:27 am

aroberts

(@aroberts)

Posts: 176

Reputable Member

Topic starter

Thank you! I think I must have a really old data dictionary- appreciate the help!

Posted : January 28, 2020 12:40 am

[email protected]

(@rogercortezlawndale-org)

Posts: 1

New Member

Can anyone confirm that "C" means Cancelled?

Posted : October 27, 2020 7:35 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