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

Active Users in EMR with the Group Name

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

84 Views

RSS

[email protected]

(@omailhotadclinic-com)

Posts: 26

Trusted Member

Topic starter

Does anyone know how does the GID field in USRINFO join with GROUPLIST table? I need the get the list of active user with the group name.

Posted : December 31, 2015 10:28 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

The column GroupList in the table USR/USERINFO is a comma-separated list of groups to which the user belongs. Each group ID in the list is a GID in the USRGROUP table. The tricky part is parsing the list. Good Luck.

Posted : December 31, 2015 12:22 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

This is how I approached the very same issue. I use the Group field to know what team a doctor is on, or if the doctor is a resident. The following example groups all my residents together, but you can see the ' //"R2018" ' that I could have used. This assumes each doctor would only meet one condition. To simplify, I used a local variable GrpList that was passed the GROUPLIST data from the USERINFO file - in this case, a renamed reference PCP_USERINFO since I often also link to the Document and call that DOC_USERINFO.

//Nov 1 2013 = logic to pull first 'floor' out of group field
//July 2 2014 = added codes for r17 and r18
local stringvar GrpList;
GrpList := {PCP_USRINFO.GROUPLIST};
if(instr(1,GrpList,"1698831238257470")>0) then "PDC"
else if(instr(1,GrpList,"1335347352101420")>0) then "4A"
else if(instr(1,GrpList,"1335347352151420")>0) then "4B"
else if(instr(1,GrpList,"1335347352201420")>0) then "5_"
else if(instr(1,GrpList,"1335347352251420")>0) then "6A"
else if(instr(1,GrpList,"1698910784006150")>0) then "6B"
else if(instr(1,GrpList,"1678806963406480")>0) then "Res" //"R2013"
else if(instr(1,GrpList,"1678806963456480")>0) then "Res" //"R2014"
else if(instr(1,GrpList,"1678806993006480")>0) then "Res" //"R2015"
else if(instr(1,GrpList,"1684935172056650")>0) then "Res" //"R2016"
else if(instr(1,GrpList,"1711622697258470")>0) then "Res" //"R2017"
else if(instr(1,GrpList,"1711622727008470")>0) then "Res" //"R2018"
else if(instr(1,GrpList,"1698831238257470")>0) then "PDC"
else "_unk"

Posted : January 4, 2016 3:32 am

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