CDM NGS Extend
Tables (10)
Untitled (genomic_test)
- Key (genomic_test_id) — INTEGER — Primary key — NOT NULL
- care_site_id — INTEGER — Foreign key → care_site.care_site_id — NOT NULL
- Field (genomic_test_name) — VARCHAR(255)
- Field (genomic_test_version) — VARCHAR(50)
- Field (reference_genome) — VARCHAR(50)
- Field (sequencing_device) — VARCHAR(50)
- Field (library_preparation) — VARCHAR(50)
- Field (target_capture) — VARCHAR(50)
- Field (read_type) — VARCHAR(50)
- Field (read_length) — INTEGER
- Field (quality_control_tools) — VARCHAR(255)
- Field (total_reads) — INTEGER
- Field (mean_target_coverage) — FLOAT
- Field (per_target_base_cover_100x) — FLOAT
- Field (alignment_tools) — VARCHAR(255)
- Field (variant_calling_tools) — VARCHAR(255)
- Field (chromosome_corrdinate) — VARCHAR(255)
- Field (annotation_tools) — VARCHAR(255)
- Field (annotation_databases) — VARCHAR(255)
Untitled (target_gene)
- Key (target_gene_id) — INTEGER — Primary key — NOT NULL
- Key (genomic_test_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Field (hgnc_id) — VARCHAR(50)
- Field (hgnc_symbol) — VARCHAR(50)
- Field (chromosome_id)
- Field (start_position)
- Field (end_position)
Untitled (variant_occurence)
- Key (variant_occurence_id) — INTEGER — Primary key — NOT NULL
- procedure_occurrence_id — INTEGER — Foreign key → procedure_occurrence.procedure_occurrence_id — NOT NULL
- specimen_id — INTEGER — Foreign key → specimen.specimen_id — NOT NULL
- specimen_id (reference_specimen_id) — INTEGER — Foreign key → specimen.specimen_id — NOT NULL
- Key (target_gene_id1) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Key (target_gene_id2) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Field (reference_sequence) — VARCHAR(50)
- Field (rs_id) — VARCHAR(50)
- Field (reference_allele) — VARCHAR(255)
- Field (alternate_allele) — VARCHAR(255)
- Field (hgvs_c) — VARCHAR(MAX)
- Field (hgvs_p) — VARCHAR(MAX)
- Field (variant_read_depth) — INTEGER
- Field (total_read_depth) — INTEGER
- Field (variant_exon_number) — INTEGER
- Field (copy_number) — FLOAT
- Field (cnv_locus) — VARCHAR(MAX)
- Field (fusion_breakpoint) — INTEGER
- Field (fusion_supporting_reads) — INTEGER
- Field (sequence_alteration) — VARCHAR(MAX)
- Field (variant_feature) — VARCHAR(MAX)
- Field (genetic_origin) — VARCHAR(50)
- Field (genotype) — VARCHAR(50)
Untitled (variant_annotation)
- Key (variant_annotation_id) — INTEGER — Primary key — NOT NULL
- Key (variant_occurence_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Field (annotation_field) — VARCHAR(MAX)
- Field (value_as_string) — VARCHAR(MAX)
- Field (value_as_number) — FLOAT
- Field (variant_pathogeny)
- Field (variant_class_level)
- Field (variant_tier_level)
- Field (allele_frequency)
- Field (medication)
- Field (clinical_trail_information)
care_site
- care_site_id — INTEGER — Primary key — NOT NULL
- care_site_name — VARCHAR(255)
- place_of_service_concept_id — INTEGER
- location_id — INTEGER — Foreign key → location.location_id
- care_site_source_value — VARCHAR(50)
- place_of_service_source_value — VARCHAR(50)
location
- location_id — INTEGER — Primary key — NOT NULL
- address_1 — VARCHAR(50)
- address_2 — VARCHAR(50)
- city — VARCHAR(50)
- state — VARCHAR(2)
- zip — VARCHAR(9)
- county — VARCHAR(20)
- location_source_value — VARCHAR(50)
person
- person_id — INTEGER — Primary key — NOT NULL
- gender_concept_id — INTEGER — NOT NULL
- year_of_birth — INTEGER — NOT NULL
- month_of_birth — INTEGER
- day_of_birth — INTEGER
- birth_datetime — DATETIME2
- race_concept_id — INTEGER — NOT NULL
- ethnicity_concept_id — INTEGER — NOT NULL
- location_id — INTEGER — Foreign key → location.location_id
- provider_id — INTEGER
- care_site_id — INTEGER — Foreign key → care_site.care_site_id
- person_source_value — VARCHAR(50)
- gender_source_value — VARCHAR(50)
- gender_source_concept_id — INTEGER
- race_source_value — VARCHAR(50)
- race_source_concept_id — INTEGER
- ethnicity_source_value — VARCHAR(50)
- ethnicity_source_concept_id — INTEGER
procedure_occurrence
- procedure_occurrence_id — INTEGER — Primary key — NOT NULL
- person_id — INTEGER — Foreign key → person.person_id — NOT NULL
- procedure_concept_id — INTEGER — NOT NULL
- procedure_date — DATE — NOT NULL
- procedure_datetime — DATETIME2 — NOT NULL
- procedure_type_concept_id — INTEGER — NOT NULL
- modifier_concept_id — INTEGER
- quantity — INTEGER
- provider_id — INTEGER
- visit_occurrence_id — INTEGER — Foreign key → visit_occurrence.visit_occurrence_id
- procedure_source_value — VARCHAR(50)
- procedure_source_concept_id — INTEGER
- qualifier_source_value — VARCHAR(50)
- person_id (person_id2) — INTEGER — Foreign key → person.person_id — NOT NULL
specimen
- specimen_id — INTEGER — Primary key — NOT NULL
- person_id — INTEGER — Foreign key → person.person_id — NOT NULL
- specimen_concept_id — INTEGER — NOT NULL
- specimen_type_concept_id — INTEGER — NOT NULL
- specimen_date — DATE — NOT NULL
- specimen_datetime — DATETIME2
- quantity — FLOAT
- unit_concept_id — INTEGER
- anatomic_site_concept_id — INTEGER
- disease_status_concept_id — INTEGER
- specimen_source_id — VARCHAR(50)
- specimen_source_value — VARCHAR(50)
- unit_source_value — VARCHAR(50)
- anatomic_site_source_value — VARCHAR(50)
- disease_status_source_value — VARCHAR(50)
- person_id (person_id2) — INTEGER — Foreign key → person.person_id — NOT NULL
visit_occurrence
- visit_occurrence_id — INTEGER — Primary key — NOT NULL
- person_id — INTEGER — Foreign key → person.person_id — NOT NULL
- visit_concept_id — INTEGER — NOT NULL
- visit_start_date — DATE — NOT NULL
- visit_start_datetime — DATETIME2
- visit_end_date — DATE — NOT NULL
- visit_end_datetime — DATETIME2
- visit_type_concept_id — INTEGER — NOT NULL
- provider_id — INTEGER
- care_site_id — INTEGER — Foreign key → care_site.care_site_id
- visit_source_value — VARCHAR(50)
- visit_source_concept_id — INTEGER
- admitting_source_concept_id — INTEGER
- admitting_source_value — VARCHAR(50)
- discharge_to_concept_id — INTEGER
- discharge_to_source_value — VARCHAR(50)
- preceding_visit_occurrence_id — INTEGER
- person_id (person_id2) — INTEGER — Foreign key → person.person_id — NOT NULL