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