Change the status of disabled patient to active on OS 3.2

[jennifercai]

We want to un-disable a patient who was disabled a while ago. We changed the status from “Disabled” to “Active” in the table of catissue_participant. But I still can see this patient from GUI OS. Restarting the tomcat server does not help.

How can we do it at the database back end?

Jennifer

[Vinayaklonushte]

Hi @jennifercai,

You have to change status in below two tables to re-activate participant.

1. catissue_coll_prot_reg
2. catissue_participant

Apart from that you have to remove timestamp appended to below columns if not null:

1. catissue_coll_prot_reg:

• barcode
• protocol_participant_id

2. catissue_participant

• social_security_number
• empi_id

3. catissue_part_medical_id

• medical_record_number

Thanks
Vinayak

[srikanth_adiga]

Though we want to highlight that this is highly undiserable to do all this directly on the database using SQLs.

It is best to recreate the records again.

Also we have in our roadmap to provide UI option to reactivate deleted objects.

~Sri