_whole_slide_imaging

Clinical Data Table - Whole Slide Imaging

Table Columns

field	type	required	phi	phi scrubbing operation
whole_slide_imaging_id	INT64	Yes	Yes	Sub Not Stable between Data Refreshes
person_id	INT64	Yes	Yes	Sub with Stable between Data Refreshes
accession_number	STRING	Yes	Yes	Hash
json_uri	STRING	Yes
tiff_uri	STRING	Yes
spec_source_c	INT64	No
specimen_source_name	STRING	No
specimen_type_c	INT64	No
specimen_type_name	STRING	No
procedure_start_time	DATETIME	No	Yes	Jitter
note_id	INT64	No	Yes	Sub with Stable between Data Refreshes

Columns Description

whole_slide_imaging_id (PK)

Primary key for the whole slide imaging table.

person_id (FK)

OMOP person_id associated with the slide.

accession_number

Accession number from cross walk linking source_deid_slide_id to accession number provided by Roxanna’s Lab, where it also exists in the order_rad_acc_num table and can be linked to the same patient.

json_uri

GCS URI to JSON metadata for the slide.

tiff_uri

GCS URI to TIFF image for the slide.

spec_source_c

Category value for the specimen source.

specimen_source_name

Specimen source from the clarity spec_db_main table.

specimen_type_c

Category value for the specimen type.

specimen_type_name

Specimen type from the clarity spec_db_main table.

procedure_start_time

Date and time when the procedure started from the clarity order_proc table.

note_id (FK)

Foreign key link to the pathology report in the notes table.