| 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 |
lk_time_unit.name |
| 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 |
lk_unit_of_measure.name |
| 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 |