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

updating pcp

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

4 Users

0 Reactions

52 Views

RSS

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

Is it ok to change PrimaryCareDoctorId column in patientprofile table with an update query. Will changing this affect anything else. I usually dont update, insert or delete in database but when there is a pcp turnover. updating pcp in by going into each patient registration becomes hectic.

Posted : November 12, 2016 12:57 pm

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

If it were me, I would run a SQL trace while updating the pcp on a test patient and see if it is updating any other table before trying it. I have done things like batch change a patients home LOC when closing an office without any issues. Never tried a PCP though..

Posted : November 14, 2016 2:15 am

SLHV

(@slhv)

Posts: 478

Honorable Member

I have done a referring like this a few times with out issue.

Posted : November 14, 2016 5:02 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

I've updated the PrimaryCareDoctorId a few times, and I didn't see any issue with it. One thing to note is that whenever the PCP is added/changed in registration, it automatically adds the new pcp to the patient's contacts. If you are still needing this functionality, you'll also need to add the to the PatientRelationship table.

Posted : November 14, 2016 7:08 am

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

thank you all for you suggestions. I can confidently make changes now.

Posted : November 15, 2016 2:07 pm

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