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:
User should know the participant id or participant registration id to make changes in database.
Run 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>; |