Schema reference / Tables / view MDX source

paced_auditory_serial_addition_test

The Paced Auditory Serial Addition Test (PASAT) measures the cognitive function that specifically assesses auditory information processing speed and flexibility, as well as calcul…

The Paced Auditory Serial Addition Test (PASAT) measures the cognitive function that specifically assesses auditory information processing speed and flexibility, as well as calculation ability of a patient. It is the third component of the Multiple Sclerosis Functional Composite (MSFC), a series of three tests to document the course of Multiple Sclerosis.

Purpose. To record the measurements recorded during a Paced Auditory Serial Addition Test, normally as part of the Multiple Sclerosis Functional Composite suite of tests.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.paced_auditory_serial_addition_test.v1`	openEHR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`form_id`	`uuid` → `form`	no	The form this entry was recorded on.	—
`form_block_id`	`uuid`	yes	The block within the form, when the entry is bound to one.	—
`event_type`	`text`	yes	null represents any_event	—
`total_correct_answers`	`integer`	yes	Total Correct Answers	`/data[at0002]/events[at0064]/data[at0001]/items[at0015]`
`first_half_total_correct_answers`	`integer`	yes	First Half Total Correct Answers	`/data[at0002]/events[at0064]/data[at0001]/items[at0029]`
`second_half_total_correct_answers`	`integer`	yes	Second Half Total Correct Answers	`/data[at0002]/events[at0064]/data[at0001]/items[at0030]`
`total_errors_of_commission`	`integer`	yes	Total Errors of Commission	`/data[at0002]/events[at0064]/data[at0001]/items[at0031]`
`total_errors_of_omission`	`integer`	yes	Total Errors of Omission	`/data[at0002]/events[at0064]/data[at0001]/items[at0032]`
`percentage_of_correct_answers_numerator` `percentage_of_correct_answers_denominator`	numeric, numeric `numeric`, `numeric`	yes	Percentage of Correct Answers	`/data[at0002]/events[at0064]/data[at0001]/items[at0063]`
`test_not_completed`	`boolean`	yes	Test Not Completed?	`/data[at0002]/events[at0064]/data[at0001]/items[at0055]`
`reason_for_non_completion`	`text`	yes	Reason for Non-completion	`/data[at0002]/events[at0064]/data[at0001]/items[at0049]`
`confounding_factors`	`text`	yes	Confounding Factors	`/data[at0002]/events[at0064]/state[at0050]/items[at0054]`
`number_sequence_used` `number_sequence_used_code` `number_sequence_used_system` `number_sequence_used_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Number Sequence Used	`/protocol[at0007]/items[at0012]`
`practice_trial_conducted`	`boolean`	yes	Practice Trial Conducted?	`/protocol[at0007]/items[at0068]`
`additional_attempts`	`boolean`	yes	Additional Attempts?	`/protocol[at0007]/items[at0069]`
`reason_for_additional_attempts`	`text`	yes	Reason for Additional Attempts	`/protocol[at0007]/items[at0070]`

Constraints

check (total_correct_answers is null or total_correct_answers between 0 and 60)
check (first_half_total_correct_answers is null or first_half_total_correct_answers between 0 and 30)
check (second_half_total_correct_answers is null or second_half_total_correct_answers between 0 and 30)
check (total_errors_of_commission is null or total_errors_of_commission between 0 and 60)
check (total_errors_of_omission is null or total_errors_of_omission between 0 and 60)
check ((percentage_of_correct_answers_numerator is null and percentage_of_correct_answers_denominator is null) or (percentage_of_correct_answers_numerator is not null and percentage_of_correct_answers_denominator is not null))
check (percentage_of_correct_answers_denominator is null or percentage_of_correct_answers_denominator <> 0)
check (percentage_of_correct_answers_denominator is null or percentage_of_correct_answers_denominator = 100)
check (percentage_of_correct_answers_numerator is null or percentage_of_correct_answers_numerator between 0 and 60)
check ((number_sequence_used_code is null and number_sequence_used_system is null and number_sequence_used_valueset_id is null and number_sequence_used is null) or (number_sequence_used is not null and number_sequence_used_code is not null and number_sequence_used_system is not null and number_sequence_used_valueset_id is not null))

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`number_sequence_used_valueset_id, number_sequence_used_code, number_sequence_used_system, number_sequence_used`	`valueset_code`	restrict

Indexes

paced_auditory_serial_addition_test_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.paced_auditory_serial_addition_test.v1/number_sequence_used`	2