pasi_score

A quantitative rating scale for measuring the severity of psoriatic lesions based on area coverage and plaque appearance.

A quantitative rating scale for measuring the severity of psoriatic lesions based on area coverage and plaque appearance.

Purpose. To record the result for each component parameter and the total score for the Psoriasis Area Severity Index (PASI).

Source

Columns

Constraints

check ((head_region_h_erythema_e_code is null and head_region_h_erythema_e_system is null and head_region_h_erythema_e_numeric is null and head_region_h_erythema_e is null) or (head_region_h_erythema_e_valueset_id is not null and head_region_h_erythema_e_code is not null and head_region_h_erythema_e_system is not null and head_region_h_erythema_e_numeric is not null and head_region_h_erythema_e is not null))
check ((head_region_h_infiltration_i_code is null and head_region_h_infiltration_i_system is null and head_region_h_infiltration_i_numeric is null and head_region_h_infiltration_i is null) or (head_region_h_infiltration_i_valueset_id is not null and head_region_h_infiltration_i_code is not null and head_region_h_infiltration_i_system is not null and head_region_h_infiltration_i_numeric is not null and head_region_h_infiltration_i is not null))
check ((head_region_h_desquamation_d_code is null and head_region_h_desquamation_d_system is null and head_region_h_desquamation_d_numeric is null and head_region_h_desquamation_d is null) or (head_region_h_desquamation_d_valueset_id is not null and head_region_h_desquamation_d_code is not null and head_region_h_desquamation_d_system is not null and head_region_h_desquamation_d_numeric is not null and head_region_h_desquamation_d is not null))
check ((head_region_h_body_surface_area_involvement_a_code is null and head_region_h_body_surface_area_involvement_a_system is null and head_region_h_body_surface_area_involvement_a_numeric is null and head_region_h_body_surface_area_involvement_a is null) or (head_region_h_body_surface_area_involvement_a_valueset_id is not null and head_region_h_body_surface_area_involvement_a_code is not null and head_region_h_body_surface_area_involvement_a_system is not null and head_region_h_body_surface_area_involvement_a_numeric is not null and head_region_h_body_surface_area_involvement_a is not null))
check ((head_region_h_score_head_region_magnitude is null and head_region_h_score_head_region_units is null) or (head_region_h_score_head_region_magnitude is not null and head_region_h_score_head_region_units is not null))
check (head_region_h_score_head_region_magnitude is null or (head_region_h_score_head_region_units = '1' and head_region_h_score_head_region_magnitude >= 0))
check ((trunk_region_t_score_trunk_region_magnitude is null and trunk_region_t_score_trunk_region_units is null) or (trunk_region_t_score_trunk_region_magnitude is not null and trunk_region_t_score_trunk_region_units is not null))
check (trunk_region_t_score_trunk_region_magnitude is null or (trunk_region_t_score_trunk_region_units = '1' and trunk_region_t_score_trunk_region_magnitude >= 0))
check ((upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude is null and upper_extremities_region_u_score_upper_extremi_5e18bc_units is null) or (upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude is not null and upper_extremities_region_u_score_upper_extremi_5e18bc_units is not null))
check (upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude is null or (upper_extremities_region_u_score_upper_extremi_5e18bc_units = '1' and upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude >= 0))
check ((lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude is null and lower_extremities_region_l_score_lower_extremi_9eefd4_units is null) or (lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude is not null and lower_extremities_region_l_score_lower_extremi_9eefd4_units is not null))
check (lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude is null or (lower_extremities_region_l_score_lower_extremi_9eefd4_units = '1' and lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude >= 0))
check ((total_pasi_score_magnitude is null and total_pasi_score_units is null) or (total_pasi_score_magnitude is not null and total_pasi_score_units is not null))
check (total_pasi_score_magnitude is null or (total_pasi_score_units = '1' and total_pasi_score_magnitude >= 0))

Unique

• form_block_id

References

Indexes

• pasi_score_form_id_idx on form_id

Value sets