STAMP Add-On Data

The oncology_stamp_add_on_data table includes the panel name and pipeline version from the Stanford Molecular Pathology Lab, as well as the patient identifier and accession number. These fields (patient identifier and accession number) can be used to establish a link to the Philips ISPM onc_philips_mtb_pat_diag_orders table.

Please note that multiple records may correspond to the same accession number. The assay_performed_derived and pipeline_version_derived fields can be used to link to the STAMP panel metadata.

August 2025 Release: Table Columns

Column Name	Type	PHI	PHI-Scrubbing Operation
accession_number	STRING	Yes	Hash
assay_performed_derived	STRING	No	None
assay_performed_source	STRING	No	None
person_id	INT64	Yes	Stable Between Data Refreshes
pipeline_version_derived	STRING	No	None
pipeline_version_source	STRING	No	None
stanford_patient_uid	STRING	Yes	Del

May 2025 Release: Table Columns

Column Name	Type	PHI	PHI-Scrubbing Operation
accession_number	STRING	Yes	Hash
assay_performed	STRING	No	None
person_id	INT64	Yes	Stable Between Data Refreshes
pipeline_version	STRING	No	None
stanford_patient_uid	STRING	Yes	Del

Columns Description

accession_number

Identifier for the specimen. This field can be used to link to the pat_diag_orders table. Note that there can be multiple records with the same accession number.

assay_performed_derived

This value is derived from the assay_performed_source field and is used to link to the assay_performed column in the stamp_pipeline_gene_data table.

assay_performed_source (assay_performed)

Stanford Molecular Pathology Lab panel name

person_id

Person_id as corresponds to the OMOP dataset

pipeline_version_derived

This value is derived from the pipeline_version_source field and is used to link to the pipeline_version column in the stamp_pipeline_gene_data table.

pipeline_version_source (pipeline_version)

Stanford Molecular Pathology Lab panel pipeline version

stanford_patient_uid

Internal Stanford tracking ID (this is the patient’s MRN | DOB)