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.
...
- 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:
User 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>
...