epic_cp

A questionnaire used to measure urinary incontinence, urinary irritation, bowel, sexual, and hormonal health-related quality of life (HRQoL) for use in the routine clinical care o…

A questionnaire used to measure urinary incontinence, urinary irritation, bowel, sexual, and hormonal health-related quality of life (HRQoL) for use in the routine clinical care of prostate cancer patients.

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

Source

Columns

Constraints

check ((_1_overall_how_much_of_a_problem_has_your_ur_d9a867_code is null and _1_overall_how_much_of_a_problem_has_your_ur_d9a867_system is null and _1_overall_how_much_of_a_problem_has_your_ur_d9a867_valueset_id is null and _1_overall_how_much_of_a_problem_has_your_ur_d9a867 is null) or (_1_overall_how_much_of_a_problem_has_your_ur_d9a867 is not null and _1_overall_how_much_of_a_problem_has_your_ur_d9a867_code is not null and _1_overall_how_much_of_a_problem_has_your_ur_d9a867_system is not null and _1_overall_how_much_of_a_problem_has_your_ur_d9a867_valueset_id is not null))
check ((_2_which_of_the_following_best_describes_you_bb2c13_code is null and _2_which_of_the_following_best_describes_you_bb2c13_system is null and _2_which_of_the_following_best_describes_you_bb2c13_numeric is null and _2_which_of_the_following_best_describes_you_bb2c13 is null) or (_2_which_of_the_following_best_describes_you_bb2c13_valueset_id is not null and _2_which_of_the_following_best_describes_you_bb2c13_code is not null and _2_which_of_the_following_best_describes_you_bb2c13_system is not null and _2_which_of_the_following_best_describes_you_bb2c13_numeric is not null and _2_which_of_the_following_best_describes_you_bb2c13 is not null))
check ((_3_how_many_pads_or_adult_diapers_per_day_ha_66821c_code is null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c_system is null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c_numeric is null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c is null) or (_3_how_many_pads_or_adult_diapers_per_day_ha_66821c_valueset_id is not null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c_code is not null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c_system is not null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c_numeric is not null and _3_how_many_pads_or_adult_diapers_per_day_ha_66821c is not null))
check ((_4_how_big_a_problem_if_any_has_urinary_drip_823ba4_code is null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4_system is null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4_numeric is null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4 is null) or (_4_how_big_a_problem_if_any_has_urinary_drip_823ba4_valueset_id is not null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4_code is not null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4_system is not null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4_numeric is not null and _4_how_big_a_problem_if_any_has_urinary_drip_823ba4 is not null))
check (urinary_incontinence_symptom_score is null or urinary_incontinence_symptom_score between 0 and 12)
check ((_5_how_big_a_problem_if_any_has_each_of_the__3f228e_code is null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e_system is null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e_numeric is null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e is null) or (_5_how_big_a_problem_if_any_has_each_of_the__3f228e_valueset_id is not null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e_code is not null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e_system is not null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e_numeric is not null and _5_how_big_a_problem_if_any_has_each_of_the__3f228e is not null))
check ((_5_how_big_a_problem_if_any_has_each_of_the__afe867_code is null and _5_how_big_a_problem_if_any_has_each_of_the__afe867_system is null and _5_how_big_a_problem_if_any_has_each_of_the__afe867_numeric is null and _5_how_big_a_problem_if_any_has_each_of_the__afe867 is null) or (_5_how_big_a_problem_if_any_has_each_of_the__afe867_valueset_id is not null and _5_how_big_a_problem_if_any_has_each_of_the__afe867_code is not null and _5_how_big_a_problem_if_any_has_each_of_the__afe867_system is not null and _5_how_big_a_problem_if_any_has_each_of_the__afe867_numeric is not null and _5_how_big_a_problem_if_any_has_each_of_the__afe867 is not null))
check ((_5_how_big_a_problem_if_any_has_each_of_the__f7da1d_code is null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d_system is null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d_numeric is null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d is null) or (_5_how_big_a_problem_if_any_has_each_of_the__f7da1d_valueset_id is not null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d_code is not null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d_system is not null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d_numeric is not null and _5_how_big_a_problem_if_any_has_each_of_the__f7da1d is not null))
check (urinary_irritation_obstruction_symptom_score is null or urinary_irritation_obstruction_symptom_score between 0 and 12)
check ((_6_how_big_a_problem_if_any_has_each_of_the__fb2344_code is null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344_system is null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344_numeric is null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344 is null) or (_6_how_big_a_problem_if_any_has_each_of_the__fb2344_valueset_id is not null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344_code is not null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344_system is not null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344_numeric is not null and _6_how_big_a_problem_if_any_has_each_of_the__fb2344 is not null))
check ((_6_how_big_a_problem_if_any_has_each_of_the__44d9c9_code is null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9_system is null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9_numeric is null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9 is null) or (_6_how_big_a_problem_if_any_has_each_of_the__44d9c9_valueset_id is not null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9_code is not null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9_system is not null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9_numeric is not null and _6_how_big_a_problem_if_any_has_each_of_the__44d9c9 is not null))
check ((_6_how_big_a_problem_if_any_has_each_of_the__33f95a_code is null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a_system is null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a_numeric is null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a is null) or (_6_how_big_a_problem_if_any_has_each_of_the__33f95a_valueset_id is not null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a_code is not null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a_system is not null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a_numeric is not null and _6_how_big_a_problem_if_any_has_each_of_the__33f95a is not null))
check (bowel_symptom_score is null or bowel_symptom_score between 0 and 12)
check ((_7_how_would_you_rate_your_ability_to_reach__da97ab_code is null and _7_how_would_you_rate_your_ability_to_reach__da97ab_system is null and _7_how_would_you_rate_your_ability_to_reach__da97ab_numeric is null and _7_how_would_you_rate_your_ability_to_reach__da97ab is null) or (_7_how_would_you_rate_your_ability_to_reach__da97ab_valueset_id is not null and _7_how_would_you_rate_your_ability_to_reach__da97ab_code is not null and _7_how_would_you_rate_your_ability_to_reach__da97ab_system is not null and _7_how_would_you_rate_your_ability_to_reach__da97ab_numeric is not null and _7_how_would_you_rate_your_ability_to_reach__da97ab is not null))
check ((_8_how_would_you_describe_the_usual_quality__f9e7a2_code is null and _8_how_would_you_describe_the_usual_quality__f9e7a2_system is null and _8_how_would_you_describe_the_usual_quality__f9e7a2_numeric is null and _8_how_would_you_describe_the_usual_quality__f9e7a2 is null) or (_8_how_would_you_describe_the_usual_quality__f9e7a2_valueset_id is not null and _8_how_would_you_describe_the_usual_quality__f9e7a2_code is not null and _8_how_would_you_describe_the_usual_quality__f9e7a2_system is not null and _8_how_would_you_describe_the_usual_quality__f9e7a2_numeric is not null and _8_how_would_you_describe_the_usual_quality__f9e7a2 is not null))
check ((_9_overall_how_much_of_a_problem_has_your_se_36adac_code is null and _9_overall_how_much_of_a_problem_has_your_se_36adac_system is null and _9_overall_how_much_of_a_problem_has_your_se_36adac_numeric is null and _9_overall_how_much_of_a_problem_has_your_se_36adac is null) or (_9_overall_how_much_of_a_problem_has_your_se_36adac_valueset_id is not null and _9_overall_how_much_of_a_problem_has_your_se_36adac_code is not null and _9_overall_how_much_of_a_problem_has_your_se_36adac_system is not null and _9_overall_how_much_of_a_problem_has_your_se_36adac_numeric is not null and _9_overall_how_much_of_a_problem_has_your_se_36adac is not null))
check (sexual_symptom_score is null or sexual_symptom_score between 0 and 12)
check ((_10_how_big_a_problem_if_any_has_each_of_the_78437e_code is null and _10_how_big_a_problem_if_any_has_each_of_the_78437e_system is null and _10_how_big_a_problem_if_any_has_each_of_the_78437e_numeric is null and _10_how_big_a_problem_if_any_has_each_of_the_78437e is null) or (_10_how_big_a_problem_if_any_has_each_of_the_78437e_valueset_id is not null and _10_how_big_a_problem_if_any_has_each_of_the_78437e_code is not null and _10_how_big_a_problem_if_any_has_each_of_the_78437e_system is not null and _10_how_big_a_problem_if_any_has_each_of_the_78437e_numeric is not null and _10_how_big_a_problem_if_any_has_each_of_the_78437e is not null))
check ((_10_how_big_a_problem_if_any_has_each_of_the_2db3c4_code is null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4_system is null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4_numeric is null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4 is null) or (_10_how_big_a_problem_if_any_has_each_of_the_2db3c4_valueset_id is not null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4_code is not null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4_system is not null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4_numeric is not null and _10_how_big_a_problem_if_any_has_each_of_the_2db3c4 is not null))
check ((_10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_code is null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_system is null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_numeric is null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba is null) or (_10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_valueset_id is not null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_code is not null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_system is not null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba_numeric is not null and _10_how_big_a_problem_if_any_has_each_of_the_0ca4ba is not null))
check (vitality_hormonal_symptom_score is null or vitality_hormonal_symptom_score between 0 and 12)
check (overall_prostate_cancer_qol_score is null or overall_prostate_cancer_qol_score between 0 and 60)

Unique

• form_block_id

References

Indexes

• epic_cp_form_id_idx on form_id

Value sets