--- title: "asa_status" description: "Classification system adopted by the American Society of Anesthesiologists (ASA) as part of a pre-surgical risk assessment." --- 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`](/docs/tables/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 ```sql 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`](/docs/tables/form) | cascade | | `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade | | `classification_valueset_id, classification_code, classification_system, classification, classification_numeric` | [`valueset_code`](/docs/tables/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 |