expanded_prostate_cancer_index_composite

A questionnaire used to measure the health-related quality of life (HRQoL) in patients with prostate cancer.

A questionnaire used to measure the health-related quality of life (HRQoL) in patients with prostate cancer.

Purpose. To record the results from the health-related quality of life (HRQoL) questionnaire in patients with prostate cancer.

Source

Columns

Constraints

check ((over_the_past_4_weeks_how_often_have_you_lea_f807ab_code is null and over_the_past_4_weeks_how_often_have_you_lea_f807ab_system is null and over_the_past_4_weeks_how_often_have_you_lea_f807ab_numeric is null and over_the_past_4_weeks_how_often_have_you_lea_f807ab is null) or (over_the_past_4_weeks_how_often_have_you_lea_f807ab_valueset_id is not null and over_the_past_4_weeks_how_often_have_you_lea_f807ab_code is not null and over_the_past_4_weeks_how_often_have_you_lea_f807ab_system is not null and over_the_past_4_weeks_how_often_have_you_lea_f807ab_numeric is not null and over_the_past_4_weeks_how_often_have_you_lea_f807ab is not null))
check ((over_the_past_4_weeks_how_often_have_you_uri_e87258_code is null and over_the_past_4_weeks_how_often_have_you_uri_e87258_system is null and over_the_past_4_weeks_how_often_have_you_uri_e87258_numeric is null and over_the_past_4_weeks_how_often_have_you_uri_e87258 is null) or (over_the_past_4_weeks_how_often_have_you_uri_e87258_valueset_id is not null and over_the_past_4_weeks_how_often_have_you_uri_e87258_code is not null and over_the_past_4_weeks_how_often_have_you_uri_e87258_system is not null and over_the_past_4_weeks_how_often_have_you_uri_e87258_numeric is not null and over_the_past_4_weeks_how_often_have_you_uri_e87258 is not null))
check ((over_the_past_4_weeks_how_often_have_you_had_ed7c4e_code is null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e_system is null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e_numeric is null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e is null) or (over_the_past_4_weeks_how_often_have_you_had_ed7c4e_valueset_id is not null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e_code is not null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e_system is not null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e_numeric is not null and over_the_past_4_weeks_how_often_have_you_had_ed7c4e is not null))
check ((which_of_the_following_best_describes_your_u_aae48a_code is null and which_of_the_following_best_describes_your_u_aae48a_system is null and which_of_the_following_best_describes_your_u_aae48a_numeric is null and which_of_the_following_best_describes_your_u_aae48a is null) or (which_of_the_following_best_describes_your_u_aae48a_valueset_id is not null and which_of_the_following_best_describes_your_u_aae48a_code is not null and which_of_the_following_best_describes_your_u_aae48a_system is not null and which_of_the_following_best_describes_your_u_aae48a_numeric is not null and which_of_the_following_best_describes_your_u_aae48a is not null))
check ((how_many_pads_or_adult_diapers_per_day_did_y_179cda_code is null and how_many_pads_or_adult_diapers_per_day_did_y_179cda_system is null and how_many_pads_or_adult_diapers_per_day_did_y_179cda_numeric is null and how_many_pads_or_adult_diapers_per_day_did_y_179cda is null) or (how_many_pads_or_adult_diapers_per_day_did_y_179cda_valueset_id is not null and how_many_pads_or_adult_diapers_per_day_did_y_179cda_code is not null and how_many_pads_or_adult_diapers_per_day_did_y_179cda_system is not null and how_many_pads_or_adult_diapers_per_day_did_y_179cda_numeric is not null and how_many_pads_or_adult_diapers_per_day_did_y_179cda is not null))
check ((how_big_a_problem_if_any_had_each_of_the_fol_197d92_code is null and how_big_a_problem_if_any_had_each_of_the_fol_197d92_system is null and how_big_a_problem_if_any_had_each_of_the_fol_197d92_numeric is null and how_big_a_problem_if_any_had_each_of_the_fol_197d92 is null) or (how_big_a_problem_if_any_had_each_of_the_fol_197d92_valueset_id is not null and how_big_a_problem_if_any_had_each_of_the_fol_197d92_code is not null and how_big_a_problem_if_any_had_each_of_the_fol_197d92_system is not null and how_big_a_problem_if_any_had_each_of_the_fol_197d92_numeric is not null and how_big_a_problem_if_any_had_each_of_the_fol_197d92 is not null))
check ((how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_code is null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_system is null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_numeric is null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb is null) or (how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_valueset_id is not null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_code is not null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_system is not null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb_numeric is not null and how_big_a_problem_if_any_had_each_of_the_fol_a2b2fb is not null))
check ((how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_code is null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_system is null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_numeric is null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7 is null) or (how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_valueset_id is not null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_code is not null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_system is not null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7_numeric is not null and how_big_a_problem_if_any_had_each_of_the_fol_b9e2f7 is not null))
check ((how_big_a_problem_if_any_had_each_of_the_fol_627727_code is null and how_big_a_problem_if_any_had_each_of_the_fol_627727_system is null and how_big_a_problem_if_any_had_each_of_the_fol_627727_numeric is null and how_big_a_problem_if_any_had_each_of_the_fol_627727 is null) or (how_big_a_problem_if_any_had_each_of_the_fol_627727_valueset_id is not null and how_big_a_problem_if_any_had_each_of_the_fol_627727_code is not null and how_big_a_problem_if_any_had_each_of_the_fol_627727_system is not null and how_big_a_problem_if_any_had_each_of_the_fol_627727_numeric is not null and how_big_a_problem_if_any_had_each_of_the_fol_627727 is not null))
check ((how_big_a_problem_if_any_had_each_of_the_fol_88fabf_code is null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf_system is null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf_numeric is null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf is null) or (how_big_a_problem_if_any_had_each_of_the_fol_88fabf_valueset_id is not null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf_code is not null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf_system is not null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf_numeric is not null and how_big_a_problem_if_any_had_each_of_the_fol_88fabf is not null))
check ((how_big_a_problem_if_any_had_each_of_the_fol_1668ca_code is null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca_system is null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca_numeric is null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca is null) or (how_big_a_problem_if_any_had_each_of_the_fol_1668ca_valueset_id is not null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca_code is not null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca_system is not null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca_numeric is not null and how_big_a_problem_if_any_had_each_of_the_fol_1668ca is not null))
check ((overall_how_big_a_problem_has_your_urinary_f_b45fb3_code is null and overall_how_big_a_problem_has_your_urinary_f_b45fb3_system is null and overall_how_big_a_problem_has_your_urinary_f_b45fb3_numeric is null and overall_how_big_a_problem_has_your_urinary_f_b45fb3 is null) or (overall_how_big_a_problem_has_your_urinary_f_b45fb3_valueset_id is not null and overall_how_big_a_problem_has_your_urinary_f_b45fb3_code is not null and overall_how_big_a_problem_has_your_urinary_f_b45fb3_system is not null and overall_how_big_a_problem_has_your_urinary_f_b45fb3_numeric is not null and overall_how_big_a_problem_has_your_urinary_f_b45fb3 is not null))
check ((how_often_have_you_had_rectal_urgency_felt_l_8ee584_code is null and how_often_have_you_had_rectal_urgency_felt_l_8ee584_system is null and how_often_have_you_had_rectal_urgency_felt_l_8ee584_numeric is null and how_often_have_you_had_rectal_urgency_felt_l_8ee584 is null) or (how_often_have_you_had_rectal_urgency_felt_l_8ee584_valueset_id is not null and how_often_have_you_had_rectal_urgency_felt_l_8ee584_code is not null and how_often_have_you_had_rectal_urgency_felt_l_8ee584_system is not null and how_often_have_you_had_rectal_urgency_felt_l_8ee584_numeric is not null and how_often_have_you_had_rectal_urgency_felt_l_8ee584 is not null))
check ((how_often_have_you_had_uncontrolled_leakage__d92a0f_code is null and how_often_have_you_had_uncontrolled_leakage__d92a0f_system is null and how_often_have_you_had_uncontrolled_leakage__d92a0f_numeric is null and how_often_have_you_had_uncontrolled_leakage__d92a0f is null) or (how_often_have_you_had_uncontrolled_leakage__d92a0f_valueset_id is not null and how_often_have_you_had_uncontrolled_leakage__d92a0f_code is not null and how_often_have_you_had_uncontrolled_leakage__d92a0f_system is not null and how_often_have_you_had_uncontrolled_leakage__d92a0f_numeric is not null and how_often_have_you_had_uncontrolled_leakage__d92a0f is not null))
check ((how_often_have_you_had_stools_bowel_movement_a62e45_code is null and how_often_have_you_had_stools_bowel_movement_a62e45_system is null and how_often_have_you_had_stools_bowel_movement_a62e45_numeric is null and how_often_have_you_had_stools_bowel_movement_a62e45 is null) or (how_often_have_you_had_stools_bowel_movement_a62e45_valueset_id is not null and how_often_have_you_had_stools_bowel_movement_a62e45_code is not null and how_often_have_you_had_stools_bowel_movement_a62e45_system is not null and how_often_have_you_had_stools_bowel_movement_a62e45_numeric is not null and how_often_have_you_had_stools_bowel_movement_a62e45 is not null))
check ((how_often_have_you_had_bloody_stools_during__82616a_code is null and how_often_have_you_had_bloody_stools_during__82616a_system is null and how_often_have_you_had_bloody_stools_during__82616a_numeric is null and how_often_have_you_had_bloody_stools_during__82616a is null) or (how_often_have_you_had_bloody_stools_during__82616a_valueset_id is not null and how_often_have_you_had_bloody_stools_during__82616a_code is not null and how_often_have_you_had_bloody_stools_during__82616a_system is not null and how_often_have_you_had_bloody_stools_during__82616a_numeric is not null and how_often_have_you_had_bloody_stools_during__82616a is not null))
check ((how_often_have_your_bowel_movements_been_pai_49fd2b_code is null and how_often_have_your_bowel_movements_been_pai_49fd2b_system is null and how_often_have_your_bowel_movements_been_pai_49fd2b_numeric is null and how_often_have_your_bowel_movements_been_pai_49fd2b is null) or (how_often_have_your_bowel_movements_been_pai_49fd2b_valueset_id is not null and how_often_have_your_bowel_movements_been_pai_49fd2b_code is not null and how_often_have_your_bowel_movements_been_pai_49fd2b_system is not null and how_often_have_your_bowel_movements_been_pai_49fd2b_numeric is not null and how_often_have_your_bowel_movements_been_pai_49fd2b is not null))
check ((how_many_bowel_movements_have_you_had_on_a_t_cb75c5_code is null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5_system is null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5_numeric is null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5 is null) or (how_many_bowel_movements_have_you_had_on_a_t_cb75c5_valueset_id is not null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5_code is not null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5_system is not null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5_numeric is not null and how_many_bowel_movements_have_you_had_on_a_t_cb75c5 is not null))
check ((how_often_have_you_had_crampy_pain_in_your_a_df1dc4_code is null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4_system is null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4_numeric is null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4 is null) or (how_often_have_you_had_crampy_pain_in_your_a_df1dc4_valueset_id is not null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4_code is not null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4_system is not null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4_numeric is not null and how_often_have_you_had_crampy_pain_in_your_a_df1dc4 is not null))
check ((how_big_a_problem_if_any_has_each_of_the_fol_b129d4_code is null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4_system is null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4_numeric is null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4 is null) or (how_big_a_problem_if_any_has_each_of_the_fol_b129d4_valueset_id is not null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4_code is not null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4_system is not null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4_numeric is not null and how_big_a_problem_if_any_has_each_of_the_fol_b129d4 is not null))
check ((how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_code is null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_system is null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_numeric is null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed is null) or (how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_valueset_id is not null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_code is not null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_system is not null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed_numeric is not null and how_big_a_problem_if_any_has_each_of_the_fol_e1a3ed is not null))
check ((how_big_a_problem_if_any_has_each_of_the_fol_073936_code is null and how_big_a_problem_if_any_has_each_of_the_fol_073936_system is null and how_big_a_problem_if_any_has_each_of_the_fol_073936_numeric is null and how_big_a_problem_if_any_has_each_of_the_fol_073936 is null) or (how_big_a_problem_if_any_has_each_of_the_fol_073936_valueset_id is not null and how_big_a_problem_if_any_has_each_of_the_fol_073936_code is not null and how_big_a_problem_if_any_has_each_of_the_fol_073936_system is not null and how_big_a_problem_if_any_has_each_of_the_fol_073936_numeric is not null and how_big_a_problem_if_any_has_each_of_the_fol_073936 is not null))
check ((how_big_a_problem_if_any_has_each_of_the_fol_655348_code is null and how_big_a_problem_if_any_has_each_of_the_fol_655348_system is null and how_big_a_problem_if_any_has_each_of_the_fol_655348_numeric is null and how_big_a_problem_if_any_has_each_of_the_fol_655348 is null) or (how_big_a_problem_if_any_has_each_of_the_fol_655348_valueset_id is not null and how_big_a_problem_if_any_has_each_of_the_fol_655348_code is not null and how_big_a_problem_if_any_has_each_of_the_fol_655348_system is not null and how_big_a_problem_if_any_has_each_of_the_fol_655348_numeric is not null and how_big_a_problem_if_any_has_each_of_the_fol_655348 is not null))
check ((how_big_a_problem_if_any_has_each_of_the_fol_a79b96_code is null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96_system is null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96_numeric is null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96 is null) or (how_big_a_problem_if_any_has_each_of_the_fol_a79b96_valueset_id is not null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96_code is not null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96_system is not null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96_numeric is not null and how_big_a_problem_if_any_has_each_of_the_fol_a79b96 is not null))
check ((how_big_a_problem_if_any_has_each_of_the_fol_d753e0_code is null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0_system is null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0_numeric is null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0 is null) or (how_big_a_problem_if_any_has_each_of_the_fol_d753e0_valueset_id is not null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0_code is not null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0_system is not null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0_numeric is not null and how_big_a_problem_if_any_has_each_of_the_fol_d753e0 is not null))
check ((overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_code is null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_system is null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_numeric is null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f is null) or (overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_valueset_id is not null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_code is not null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_system is not null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f_numeric is not null and overall_how_big_a_problem_have_your_bowel_ha_3f4b3f is not null))
check ((how_would_you_rate_each_of_the_following_dur_2862da_code is null and how_would_you_rate_each_of_the_following_dur_2862da_system is null and how_would_you_rate_each_of_the_following_dur_2862da_numeric is null and how_would_you_rate_each_of_the_following_dur_2862da is null) or (how_would_you_rate_each_of_the_following_dur_2862da_valueset_id is not null and how_would_you_rate_each_of_the_following_dur_2862da_code is not null and how_would_you_rate_each_of_the_following_dur_2862da_system is not null and how_would_you_rate_each_of_the_following_dur_2862da_numeric is not null and how_would_you_rate_each_of_the_following_dur_2862da is not null))
check ((how_would_you_rate_each_of_the_following_dur_d399d0_code is null and how_would_you_rate_each_of_the_following_dur_d399d0_system is null and how_would_you_rate_each_of_the_following_dur_d399d0_numeric is null and how_would_you_rate_each_of_the_following_dur_d399d0 is null) or (how_would_you_rate_each_of_the_following_dur_d399d0_valueset_id is not null and how_would_you_rate_each_of_the_following_dur_d399d0_code is not null and how_would_you_rate_each_of_the_following_dur_d399d0_system is not null and how_would_you_rate_each_of_the_following_dur_d399d0_numeric is not null and how_would_you_rate_each_of_the_following_dur_d399d0 is not null))
check ((how_would_you_rate_each_of_the_following_dur_3465c0_code is null and how_would_you_rate_each_of_the_following_dur_3465c0_system is null and how_would_you_rate_each_of_the_following_dur_3465c0_numeric is null and how_would_you_rate_each_of_the_following_dur_3465c0 is null) or (how_would_you_rate_each_of_the_following_dur_3465c0_valueset_id is not null and how_would_you_rate_each_of_the_following_dur_3465c0_code is not null and how_would_you_rate_each_of_the_following_dur_3465c0_system is not null and how_would_you_rate_each_of_the_following_dur_3465c0_numeric is not null and how_would_you_rate_each_of_the_following_dur_3465c0 is not null))
check ((how_would_you_describe_the_usual_quality_of__f2cf0c_code is null and how_would_you_describe_the_usual_quality_of__f2cf0c_system is null and how_would_you_describe_the_usual_quality_of__f2cf0c_numeric is null and how_would_you_describe_the_usual_quality_of__f2cf0c is null) or (how_would_you_describe_the_usual_quality_of__f2cf0c_valueset_id is not null and how_would_you_describe_the_usual_quality_of__f2cf0c_code is not null and how_would_you_describe_the_usual_quality_of__f2cf0c_system is not null and how_would_you_describe_the_usual_quality_of__f2cf0c_numeric is not null and how_would_you_describe_the_usual_quality_of__f2cf0c is not null))
check ((how_would_you_describe_the_frequency_of_your_d00bb8_code is null and how_would_you_describe_the_frequency_of_your_d00bb8_system is null and how_would_you_describe_the_frequency_of_your_d00bb8_numeric is null and how_would_you_describe_the_frequency_of_your_d00bb8 is null) or (how_would_you_describe_the_frequency_of_your_d00bb8_valueset_id is not null and how_would_you_describe_the_frequency_of_your_d00bb8_code is not null and how_would_you_describe_the_frequency_of_your_d00bb8_system is not null and how_would_you_describe_the_frequency_of_your_d00bb8_numeric is not null and how_would_you_describe_the_frequency_of_your_d00bb8 is not null))
check ((how_often_have_you_awakened_in_the_morning_o_1c9dfc_code is null and how_often_have_you_awakened_in_the_morning_o_1c9dfc_system is null and how_often_have_you_awakened_in_the_morning_o_1c9dfc_numeric is null and how_often_have_you_awakened_in_the_morning_o_1c9dfc is null) or (how_often_have_you_awakened_in_the_morning_o_1c9dfc_valueset_id is not null and how_often_have_you_awakened_in_the_morning_o_1c9dfc_code is not null and how_often_have_you_awakened_in_the_morning_o_1c9dfc_system is not null and how_often_have_you_awakened_in_the_morning_o_1c9dfc_numeric is not null and how_often_have_you_awakened_in_the_morning_o_1c9dfc is not null))
check ((during_the_last_4_weeks_how_often_did_you_ha_74fd7c_code is null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c_system is null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c_numeric is null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c is null) or (during_the_last_4_weeks_how_often_did_you_ha_74fd7c_valueset_id is not null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c_code is not null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c_system is not null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c_numeric is not null and during_the_last_4_weeks_how_often_did_you_ha_74fd7c is not null))
check ((during_the_last_4_weeks_how_often_did_you_ha_d3f869_code is null and during_the_last_4_weeks_how_often_did_you_ha_d3f869_system is null and during_the_last_4_weeks_how_often_did_you_ha_d3f869_numeric is null and during_the_last_4_weeks_how_often_did_you_ha_d3f869 is null) or (during_the_last_4_weeks_how_often_did_you_ha_d3f869_valueset_id is not null and during_the_last_4_weeks_how_often_did_you_ha_d3f869_code is not null and during_the_last_4_weeks_how_often_did_you_ha_d3f869_system is not null and during_the_last_4_weeks_how_often_did_you_ha_d3f869_numeric is not null and during_the_last_4_weeks_how_often_did_you_ha_d3f869 is not null))
check ((overall_how_would_you_rate_your_ability_to_f_fffad9_code is null and overall_how_would_you_rate_your_ability_to_f_fffad9_system is null and overall_how_would_you_rate_your_ability_to_f_fffad9_numeric is null and overall_how_would_you_rate_your_ability_to_f_fffad9 is null) or (overall_how_would_you_rate_your_ability_to_f_fffad9_valueset_id is not null and overall_how_would_you_rate_your_ability_to_f_fffad9_code is not null and overall_how_would_you_rate_your_ability_to_f_fffad9_system is not null and overall_how_would_you_rate_your_ability_to_f_fffad9_numeric is not null and overall_how_would_you_rate_your_ability_to_f_fffad9 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_ea43c3_code is null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3_system is null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3 is null) or (how_big_a_problem_during_the_last_4_weeks_if_ea43c3_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3_code is not null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3_system is not null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_ea43c3 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_cc52d9_code is null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9_system is null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9 is null) or (how_big_a_problem_during_the_last_4_weeks_if_cc52d9_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9_code is not null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9_system is not null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_cc52d9 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_345ccb_code is null and how_big_a_problem_during_the_last_4_weeks_if_345ccb_system is null and how_big_a_problem_during_the_last_4_weeks_if_345ccb_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_345ccb is null) or (how_big_a_problem_during_the_last_4_weeks_if_345ccb_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_345ccb_code is not null and how_big_a_problem_during_the_last_4_weeks_if_345ccb_system is not null and how_big_a_problem_during_the_last_4_weeks_if_345ccb_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_345ccb is not null))
check ((overall_how_big_a_problem_has_your_sexual_fu_e6a765_code is null and overall_how_big_a_problem_has_your_sexual_fu_e6a765_system is null and overall_how_big_a_problem_has_your_sexual_fu_e6a765_numeric is null and overall_how_big_a_problem_has_your_sexual_fu_e6a765 is null) or (overall_how_big_a_problem_has_your_sexual_fu_e6a765_valueset_id is not null and overall_how_big_a_problem_has_your_sexual_fu_e6a765_code is not null and overall_how_big_a_problem_has_your_sexual_fu_e6a765_system is not null and overall_how_big_a_problem_has_your_sexual_fu_e6a765_numeric is not null and overall_how_big_a_problem_has_your_sexual_fu_e6a765 is not null))
check ((over_the_last_4_weeks_how_often_have_you_exp_be8ad1_code is null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1_system is null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1_numeric is null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1 is null) or (over_the_last_4_weeks_how_often_have_you_exp_be8ad1_valueset_id is not null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1_code is not null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1_system is not null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1_numeric is not null and over_the_last_4_weeks_how_often_have_you_exp_be8ad1 is not null))
check ((how_often_have_you_had_breast_tenderness_dur_2f8607_code is null and how_often_have_you_had_breast_tenderness_dur_2f8607_system is null and how_often_have_you_had_breast_tenderness_dur_2f8607_numeric is null and how_often_have_you_had_breast_tenderness_dur_2f8607 is null) or (how_often_have_you_had_breast_tenderness_dur_2f8607_valueset_id is not null and how_often_have_you_had_breast_tenderness_dur_2f8607_code is not null and how_often_have_you_had_breast_tenderness_dur_2f8607_system is not null and how_often_have_you_had_breast_tenderness_dur_2f8607_numeric is not null and how_often_have_you_had_breast_tenderness_dur_2f8607 is not null))
check ((during_the_last_4_weeks_how_often_have_you_f_a70e2c_code is null and during_the_last_4_weeks_how_often_have_you_f_a70e2c_system is null and during_the_last_4_weeks_how_often_have_you_f_a70e2c_numeric is null and during_the_last_4_weeks_how_often_have_you_f_a70e2c is null) or (during_the_last_4_weeks_how_often_have_you_f_a70e2c_valueset_id is not null and during_the_last_4_weeks_how_often_have_you_f_a70e2c_code is not null and during_the_last_4_weeks_how_often_have_you_f_a70e2c_system is not null and during_the_last_4_weeks_how_often_have_you_f_a70e2c_numeric is not null and during_the_last_4_weeks_how_often_have_you_f_a70e2c is not null))
check ((during_the_last_4_weeks_how_often_have_you_f_f678e5_code is null and during_the_last_4_weeks_how_often_have_you_f_f678e5_system is null and during_the_last_4_weeks_how_often_have_you_f_f678e5_numeric is null and during_the_last_4_weeks_how_often_have_you_f_f678e5 is null) or (during_the_last_4_weeks_how_often_have_you_f_f678e5_valueset_id is not null and during_the_last_4_weeks_how_often_have_you_f_f678e5_code is not null and during_the_last_4_weeks_how_often_have_you_f_f678e5_system is not null and during_the_last_4_weeks_how_often_have_you_f_f678e5_numeric is not null and during_the_last_4_weeks_how_often_have_you_f_f678e5 is not null))
check ((how_much_change_in_your_weight_have_you_expe_7d44a4_code is null and how_much_change_in_your_weight_have_you_expe_7d44a4_system is null and how_much_change_in_your_weight_have_you_expe_7d44a4_numeric is null and how_much_change_in_your_weight_have_you_expe_7d44a4 is null) or (how_much_change_in_your_weight_have_you_expe_7d44a4_valueset_id is not null and how_much_change_in_your_weight_have_you_expe_7d44a4_code is not null and how_much_change_in_your_weight_have_you_expe_7d44a4_system is not null and how_much_change_in_your_weight_have_you_expe_7d44a4_numeric is not null and how_much_change_in_your_weight_have_you_expe_7d44a4 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_24ade9_code is null and how_big_a_problem_during_the_last_4_weeks_if_24ade9_system is null and how_big_a_problem_during_the_last_4_weeks_if_24ade9_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_24ade9 is null) or (how_big_a_problem_during_the_last_4_weeks_if_24ade9_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_24ade9_code is not null and how_big_a_problem_during_the_last_4_weeks_if_24ade9_system is not null and how_big_a_problem_during_the_last_4_weeks_if_24ade9_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_24ade9 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_f1fb37_code is null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37_system is null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37 is null) or (how_big_a_problem_during_the_last_4_weeks_if_f1fb37_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37_code is not null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37_system is not null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_f1fb37 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_a26493_code is null and how_big_a_problem_during_the_last_4_weeks_if_a26493_system is null and how_big_a_problem_during_the_last_4_weeks_if_a26493_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_a26493 is null) or (how_big_a_problem_during_the_last_4_weeks_if_a26493_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_a26493_code is not null and how_big_a_problem_during_the_last_4_weeks_if_a26493_system is not null and how_big_a_problem_during_the_last_4_weeks_if_a26493_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_a26493 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_e7f214_code is null and how_big_a_problem_during_the_last_4_weeks_if_e7f214_system is null and how_big_a_problem_during_the_last_4_weeks_if_e7f214_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_e7f214 is null) or (how_big_a_problem_during_the_last_4_weeks_if_e7f214_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_e7f214_code is not null and how_big_a_problem_during_the_last_4_weeks_if_e7f214_system is not null and how_big_a_problem_during_the_last_4_weeks_if_e7f214_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_e7f214 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_8f61e0_code is null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0_system is null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0 is null) or (how_big_a_problem_during_the_last_4_weeks_if_8f61e0_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0_code is not null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0_system is not null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_8f61e0 is not null))
check ((how_big_a_problem_during_the_last_4_weeks_if_8cac63_code is null and how_big_a_problem_during_the_last_4_weeks_if_8cac63_system is null and how_big_a_problem_during_the_last_4_weeks_if_8cac63_numeric is null and how_big_a_problem_during_the_last_4_weeks_if_8cac63 is null) or (how_big_a_problem_during_the_last_4_weeks_if_8cac63_valueset_id is not null and how_big_a_problem_during_the_last_4_weeks_if_8cac63_code is not null and how_big_a_problem_during_the_last_4_weeks_if_8cac63_system is not null and how_big_a_problem_during_the_last_4_weeks_if_8cac63_numeric is not null and how_big_a_problem_during_the_last_4_weeks_if_8cac63 is not null))
check ((overall_how_satisfied_are_you_with_the_treat_a8fd28_code is null and overall_how_satisfied_are_you_with_the_treat_a8fd28_system is null and overall_how_satisfied_are_you_with_the_treat_a8fd28_numeric is null and overall_how_satisfied_are_you_with_the_treat_a8fd28 is null) or (overall_how_satisfied_are_you_with_the_treat_a8fd28_valueset_id is not null and overall_how_satisfied_are_you_with_the_treat_a8fd28_code is not null and overall_how_satisfied_are_you_with_the_treat_a8fd28_system is not null and overall_how_satisfied_are_you_with_the_treat_a8fd28_numeric is not null and overall_how_satisfied_are_you_with_the_treat_a8fd28 is not null))
check ((urinary_summary_score_magnitude is null and urinary_summary_score_units is null) or (urinary_summary_score_magnitude is not null and urinary_summary_score_units is not null))
check ((bowel_summary_score_magnitude is null and bowel_summary_score_units is null) or (bowel_summary_score_magnitude is not null and bowel_summary_score_units is not null))
check ((sexual_summary_score_magnitude is null and sexual_summary_score_units is null) or (sexual_summary_score_magnitude is not null and sexual_summary_score_units is not null))
check ((hormonal_summary_score_magnitude is null and hormonal_summary_score_units is null) or (hormonal_summary_score_magnitude is not null and hormonal_summary_score_units is not null))
check ((urinary_function_subscale_magnitude is null and urinary_function_subscale_units is null) or (urinary_function_subscale_magnitude is not null and urinary_function_subscale_units is not null))
check ((urinary_bother_subscale_magnitude is null and urinary_bother_subscale_units is null) or (urinary_bother_subscale_magnitude is not null and urinary_bother_subscale_units is not null))
check ((urinary_incontinence_subscale_magnitude is null and urinary_incontinence_subscale_units is null) or (urinary_incontinence_subscale_magnitude is not null and urinary_incontinence_subscale_units is not null))
check ((urinary_irritative_obstructive_subscale_magnitude is null and urinary_irritative_obstructive_subscale_units is null) or (urinary_irritative_obstructive_subscale_magnitude is not null and urinary_irritative_obstructive_subscale_units is not null))
check ((bowel_function_subscale_magnitude is null and bowel_function_subscale_units is null) or (bowel_function_subscale_magnitude is not null and bowel_function_subscale_units is not null))
check ((bowel_bother_subscale_magnitude is null and bowel_bother_subscale_units is null) or (bowel_bother_subscale_magnitude is not null and bowel_bother_subscale_units is not null))
check ((sexual_function_subscale_magnitude is null and sexual_function_subscale_units is null) or (sexual_function_subscale_magnitude is not null and sexual_function_subscale_units is not null))
check ((sexual_bother_subscale_magnitude is null and sexual_bother_subscale_units is null) or (sexual_bother_subscale_magnitude is not null and sexual_bother_subscale_units is not null))
check ((hormonal_function_subscale_magnitude is null and hormonal_function_subscale_units is null) or (hormonal_function_subscale_magnitude is not null and hormonal_function_subscale_units is not null))
check ((hormonal_bother_subscale_magnitude is null and hormonal_bother_subscale_units is null) or (hormonal_bother_subscale_magnitude is not null and hormonal_bother_subscale_units is not null))

Unique

• form_block_id

References

Indexes

• expanded_prostate_cancer_index_composite_form_id_idx on form_id

Value sets