How to reactivate deleted participant ?

There is no easy way to reactivate a deleted participant. It will take a lot of jugglery at the database end, firing SQLs, etc.

We do not recommend doing this and should be done at your risk.

The database admin can reactivate a disabled participant by changing status in participant related tables.

OpenSpecimen stores participant details in the following tables:

Participant registration details: 'catissue_coll_prot_reg' table
Participant details: 'catissue_participant' table
Participant MRN details: 'catissue_part_medical_id' table

Also, all the unique columns like MRN, SSN, etc are updated with a timestamp field so that later on a new patient with the same SSN or MRN can be added again. You will need to revert all this back to regain the old data again.

Follow the below-mentioned steps to reactivate participant:

Users should know the participant id or participant registration id to make changes in the database.

Run the following command to re-activate participant

Update catissue_coll_prot_reg set activity_status = 'Active' where identifier = <participant registration id>

OR

Update catissue_coll_prot_reg set activity_status = 'Active' where participant_id = <participant id>
Select participant_id from catissue_coll_prot_reg where identifier = <participant registration id>;
Update catissue_participant set activity_status = 'Active' where identifier = <participant id from above query>

OR

Update catissue_participant set activity_status = 'Active' where identifier = <participant id>

Remove appended timestamp and update below columns:

Table	Column	Command
catissue_coll_prot_reg	barcode	update catissue_coll_prot_reg set barcode = <barcode> where identifier = <collection_protocol_registration_id>
catissue_coll_prot_reg	protocol_participant_id	update catissue_coll_prot_reg set protocol_participant_id = <protocol_participant_id> where identifier = <collection_protocol_registration_id>
catissue_participant	social_security_number	update catissue_participant set social_security_number = <social_security_number> where identifier = <participant_id>;
catissue_participant	empi_id	update catissue_participant set empi_id = <empi_id> where identifier = <participant_id>;
catissue_part_medical_id	medical_record_number	update catissue_part_medical_id set medical_record_number = <medical_record_number> where participant_id = <participant_id>;