Notifications
Clear all
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
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
I have done a referring like this a few times with out issue.
Posted : November 14, 2016 5:02 am
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
Topic starter
thank you all for you suggestions. I can confidently make changes now.
Posted : November 15, 2016 2:07 pm
