ipss

An assessment score used to screen for, diagnose, and track symptoms of benign prostatic hyperplasia (BPH).

An assessment score used to screen for, diagnose, and track symptoms of benign prostatic hyperplasia (BPH).

Purpose. To record the results for each component parameter and their total sum for the IPSS.

Source

Columns

Constraints

check ((incomplete_emptying_code is null and incomplete_emptying_system is null and incomplete_emptying_numeric is null and incomplete_emptying is null) or (incomplete_emptying_valueset_id is not null and incomplete_emptying_code is not null and incomplete_emptying_system is not null and incomplete_emptying_numeric is not null and incomplete_emptying is not null))
check ((frequency_code is null and frequency_system is null and frequency_numeric is null and frequency is null) or (frequency_valueset_id is not null and frequency_code is not null and frequency_system is not null and frequency_numeric is not null and frequency is not null))
check ((intermittency_code is null and intermittency_system is null and intermittency_numeric is null and intermittency is null) or (intermittency_valueset_id is not null and intermittency_code is not null and intermittency_system is not null and intermittency_numeric is not null and intermittency is not null))
check ((urgency_code is null and urgency_system is null and urgency_numeric is null and urgency is null) or (urgency_valueset_id is not null and urgency_code is not null and urgency_system is not null and urgency_numeric is not null and urgency is not null))
check ((weak_stream_code is null and weak_stream_system is null and weak_stream_numeric is null and weak_stream is null) or (weak_stream_valueset_id is not null and weak_stream_code is not null and weak_stream_system is not null and weak_stream_numeric is not null and weak_stream is not null))
check ((straining_code is null and straining_system is null and straining_numeric is null and straining is null) or (straining_valueset_id is not null and straining_code is not null and straining_system is not null and straining_numeric is not null and straining is not null))
check ((nocturia_code is null and nocturia_system is null and nocturia_numeric is null and nocturia is null) or (nocturia_valueset_id is not null and nocturia_code is not null and nocturia_system is not null and nocturia_numeric is not null and nocturia is not null))
check (total_score_s is null or total_score_s between 0 and 35)
check ((quality_of_life_code is null and quality_of_life_system is null and quality_of_life_numeric is null and quality_of_life is null) or (quality_of_life_valueset_id is not null and quality_of_life_code is not null and quality_of_life_system is not null and quality_of_life_numeric is not null and quality_of_life is not null))

Unique

• form_block_id

References

Indexes

• ipss_form_id_idx on form_id

Value sets