Schema reference / Tables / view MDX source

asa_status

Classification system adopted by the American Society of Anesthesiologists (ASA) as part of a pre-surgical risk assessment.

Purpose. To record the classification system adopted by the American Society of Anesthesiologists (ASA) as part of a pre-surgical risk assessment.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.asa_status.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.	—
`classification` `classification_code` `classification_system` `classification_numeric` `classification_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Classification	`/data[at0015]/events[at0016]/data[at0017]/items[at0001]`
`emergency_e`	`boolean`	yes	Emergency (E)	`/data[at0015]/events[at0016]/data[at0017]/items[at0020]`

Constraints

check ((classification_code is null and classification_system is null and classification_numeric is null and classification is null) or (classification_valueset_id is not null and classification_code is not null and classification_system is not null and classification_numeric is not null and classification is not null))

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`classification_valueset_id, classification_code, classification_system, classification, classification_numeric`	`valueset_code`	restrict

Indexes

asa_status_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.asa_status.v1/classification`	6