User can re-activate deleted / 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
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>; |