preference_value_sets


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of preference_value_sets.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Answer lists for preference codes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
loinc_code VARCHAR 50 null
answer_code VARCHAR 100 null
patient_care_experience_preferences.value_code Defined in XML R
patient_treatment_intervention_preferences.value_code Defined in XML R
answer_system VARCHAR 255 null
patient_care_experience_preferences.value_code_system Defined in XML R
patient_treatment_intervention_preferences.value_code_system Defined in XML R
answer_display VARCHAR 255 null
patient_care_experience_preferences.value_display Defined in XML R
patient_treatment_intervention_preferences.value_display Defined in XML R
answer_definition TEXT 65535 √ NULL
sort_order INT 10 √ 0
active BOOLEAN 3 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
loinc_code Performance Asc loinc_code

Relationships

Close relationships within degrees of separation