cpax

A scoring system to measure physical morbidity in critical care.

A scoring system to measure physical morbidity in critical care.

Purpose. To record the results for each component parameter for the Chelsea Critical Care Physical Assessment Tool (CPAx).

Source

Columns

Constraints

check ((respiratory_function_code is null and respiratory_function_system is null and respiratory_function_numeric is null and respiratory_function is null) or (respiratory_function_valueset_id is not null and respiratory_function_code is not null and respiratory_function_system is not null and respiratory_function_numeric is not null and respiratory_function is not null))
check ((cough_code is null and cough_system is null and cough_numeric is null and cough is null) or (cough_valueset_id is not null and cough_code is not null and cough_system is not null and cough_numeric is not null and cough is not null))
check ((moving_within_the_bed_e_g_rolling_code is null and moving_within_the_bed_e_g_rolling_system is null and moving_within_the_bed_e_g_rolling_numeric is null and moving_within_the_bed_e_g_rolling is null) or (moving_within_the_bed_e_g_rolling_valueset_id is not null and moving_within_the_bed_e_g_rolling_code is not null and moving_within_the_bed_e_g_rolling_system is not null and moving_within_the_bed_e_g_rolling_numeric is not null and moving_within_the_bed_e_g_rolling is not null))
check ((supine_to_sitting_on_the_edge_of_the_bed_code is null and supine_to_sitting_on_the_edge_of_the_bed_system is null and supine_to_sitting_on_the_edge_of_the_bed_numeric is null and supine_to_sitting_on_the_edge_of_the_bed is null) or (supine_to_sitting_on_the_edge_of_the_bed_valueset_id is not null and supine_to_sitting_on_the_edge_of_the_bed_code is not null and supine_to_sitting_on_the_edge_of_the_bed_system is not null and supine_to_sitting_on_the_edge_of_the_bed_numeric is not null and supine_to_sitting_on_the_edge_of_the_bed is not null))
check ((dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_code is null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_system is null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_numeric is null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4 is null) or (dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_valueset_id is not null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_code is not null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_system is not null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4_numeric is not null and dynamic_sitting_i_e_when_sitting_on_the_edge_6c9be4 is not null))
check ((standing_balance_code is null and standing_balance_system is null and standing_balance_numeric is null and standing_balance is null) or (standing_balance_valueset_id is not null and standing_balance_code is not null and standing_balance_system is not null and standing_balance_numeric is not null and standing_balance is not null))
check ((sit_to_stand_starting_position_lte_90_hip_flexion_code is null and sit_to_stand_starting_position_lte_90_hip_flexion_system is null and sit_to_stand_starting_position_lte_90_hip_flexion_numeric is null and sit_to_stand_starting_position_lte_90_hip_flexion is null) or (sit_to_stand_starting_position_lte_90_hip_flexion_valueset_id is not null and sit_to_stand_starting_position_lte_90_hip_flexion_code is not null and sit_to_stand_starting_position_lte_90_hip_flexion_system is not null and sit_to_stand_starting_position_lte_90_hip_flexion_numeric is not null and sit_to_stand_starting_position_lte_90_hip_flexion is not null))
check ((transferring_from_bed_to_chair_code is null and transferring_from_bed_to_chair_system is null and transferring_from_bed_to_chair_numeric is null and transferring_from_bed_to_chair is null) or (transferring_from_bed_to_chair_valueset_id is not null and transferring_from_bed_to_chair_code is not null and transferring_from_bed_to_chair_system is not null and transferring_from_bed_to_chair_numeric is not null and transferring_from_bed_to_chair is not null))
check ((stepping_code is null and stepping_system is null and stepping_numeric is null and stepping is null) or (stepping_valueset_id is not null and stepping_code is not null and stepping_system is not null and stepping_numeric is not null and stepping is not null))
check ((grip_strength_predicted_mean_for_age_and_gen_4c02fd_code is null and grip_strength_predicted_mean_for_age_and_gen_4c02fd_system is null and grip_strength_predicted_mean_for_age_and_gen_4c02fd_numeric is null and grip_strength_predicted_mean_for_age_and_gen_4c02fd is null) or (grip_strength_predicted_mean_for_age_and_gen_4c02fd_valueset_id is not null and grip_strength_predicted_mean_for_age_and_gen_4c02fd_code is not null and grip_strength_predicted_mean_for_age_and_gen_4c02fd_system is not null and grip_strength_predicted_mean_for_age_and_gen_4c02fd_numeric is not null and grip_strength_predicted_mean_for_age_and_gen_4c02fd is not null))
check (total_score is null or total_score between 0 and 50)

Unique

• form_block_id

References

Indexes

• cpax_form_id_idx on form_id

Value sets