/
Which tables in OpenSpecimen contains PHI?
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

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

Related content

Create/Edit Forms
Create/Edit Forms
Read with this
De-identification of OpenSpecimen data
De-identification of OpenSpecimen data
More like this
FAQs
Read with this
Security considerations
Security considerations
More like this
How to mark PHI fields in query forms?
How to mark PHI fields in query forms?
Read with this
Data Dictionary
Data Dictionary
More like this
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com