Which tables in OpenSpecimen contains PHI?

TableColumn
catissue_participant
  1. LAST_NAME

  2. FIRST_NAME

  3. MIDDLE_NAME

  4. BIRTH_DATE

  5. SOCIAL_SECURITY_NUMBER

  6. DEATH_DATE

  7. EMPI_ID


catissue_part_medical_idMEDICAL_RECORD_NUMBER
catissue_specimen_coll_groupSURGICAL_PATHOLOGY_NUMBER
catissue_participant_aud, catissue_part_medical_id_aud, catissue_specimen_coll_group_audComplete table
Consent fileFiles uploaded are stored in os-data folder on the application server