Subject level responses or results of ASSESEMENT_PANELs.

Name Type Description Foreign Key
assessment_component_accession varchar(15) Primary key
age_at_onset_preferred float Standardized age value
age_at_onset_reported varchar(100) Reported age value
age_at_onset_unit_preferred varchar(40) Standardized value in the LK_TIME_UNIT table
age_at_onset_unit_reported varchar(25) Reported unit
assessment_panel_accession varchar(15) Foreign key reference to ASSESSMENT_PANEL table assessment_panel.assessment_panel_accession
is_clinically_significant varchar(1) Y/N field to specify whether the practitioner viewed this measure as clinically relevant to the patient
location_of_finding_preferred varchar(256) Standardized name or code for the location of finding.
location_of_finding_reported varchar(256) Localization of a finding when organ_or_body_system is insufficiently precise
name_preferred varchar(150) Standardized name or idenitifier
name_reported varchar(150) Name or identifier
organ_or_body_system_preferred varchar(100) Standardized name or code for the body system in the organism
organ_or_body_system_reported varchar(100) Reported name or code for the body system in the organism
planned_visit_accession varchar(15) Foreign key reference to PLANNED_VISIT table
reference_range_accession varchar(15) Foreign key reference to REFERENCE_RANGE table reference_range.reference_range_accession
result_unit_preferred varchar(40) Standardized value
result_unit_reported varchar(40) Reported value
result_value_category varchar(40) Reported value
result_value_preferred float Standardized value
result_value_reported varchar(250) Reported value
study_day float Reported value
subject_accession varchar(15) Foreign key reference to SUBJECT table subject.subject_accession
subject_position_preferred varchar(40) Standardized value
subject_position_reported varchar(40) Reported value
time_of_day varchar(40) Reported value
verbatim_question varchar(250) Question posed for assessment panels whose type is questionnaire
who_is_assessed varchar(40) For assessment panels whose type is family history; values are self, Mother, Father, etc
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Name Column Description
PRIMARY assessment_component_accession BTREE
idx_assessment_component_assessment_panel assessment_panel_accession BTREE
idx_assessment_component_subject subject_accession BTREE
idx_assessment_component_planned_visit planned_visit_accession BTREE
idx_assessment_workspace workspace_id BTREE
fk_assessment_component_5 reference_range_accession BTREE
fk_assessment_component_6 result_unit_preferred BTREE
fk_assessment_component_7 age_at_onset_unit_preferred BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top