You may be right but the manual talks about changing the OID SS_7703 but it does not work. I have full system access to the database but I prefer not to make any changes directly in PG.
Lets hope we get a solution from OpenClinica LLC
Sent: Friday, May 10, 2013 6:27 PM
To: [email protected]
Subject: Re: [Users] How to change subject OID to the same number as Subject number
i've just begun to use OpenClinica but i think the only solution would be manipulating the SS_OID in the DB directly.
SS_OID is a DB Key, when u change it be sure to change all dependencies in other tables as well.
I have, right now, no access to the DB of our OC Installation. But i'll try later and will write further explanation if needed.
As we are using postgres pgAdmin is the tool to use. This implies, that you have the autorisation and access to the DB. If not you have to contact your sysadmin.
Maybe I'm totally wrong, so maybe another high experienced OC user can write some explanation to.
Master Student - Medical Informatics - University of Heilbronn & Heidelberg
Am 10.05.2013 um 11:33 schrieb "Krister Kristianson" :
I need help to change the subject OID for one patient. The hospital staff by mistake entered 7703 instead of 403 for one of the patients. I was able to change the subject number but the SS_OID still shows SS_7703. I have looked in the manual but I can’t find instructions to actually change SS_OID!
This e-mail (including any attached documents) is proprietary and confidential and may contain legally privileged information. It is intended for the named recipient(s) only. If you are not the intended recipient, you may not review, retain, copy or distribute this message, and we kindly ask you to notify the sender by reply e-mail immediately and delete this message from your system. E-mail is susceptible to unauthorised alterations which may corrupt the message of the e-mail. e-Source Technology CDCM AB only sends and receives e-mails on the basis that e-Source Technology CDCM AB is not liable for any unauthorised alterations.