---
title: "bvc"
description: "A checklist which assists in the prediction of imminent violent behaviour."
---

A checklist which assists in the prediction of imminent violent behaviour.

**Purpose.** To record the results for each component parameter and their total sum for the BVC score.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.bvc.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. | — |
| `event_type` | `text` | yes | null represents any_event | — |
| `confused`<br />`confused_code`<br />`confused_system`<br />`confused_numeric`<br />`confused_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Confused | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |
| `irritable`<br />`irritable_code`<br />`irritable_system`<br />`irritable_numeric`<br />`irritable_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Irritable | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]` |
| `boisterous`<br />`boisterous_code`<br />`boisterous_system`<br />`boisterous_numeric`<br />`boisterous_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Boisterous | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]` |
| `physical_threats`<br />`physical_threats_code`<br />`physical_threats_system`<br />`physical_threats_numeric`<br />`physical_threats_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Physical threats | `/data[at0001]/events[at0002]/data[at0003]/items[at0008]` |
| `verbal_threats`<br />`verbal_threats_code`<br />`verbal_threats_system`<br />`verbal_threats_numeric`<br />`verbal_threats_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Verbal threats | `/data[at0001]/events[at0002]/data[at0003]/items[at0007]` |
| `attacking_objects`<br />`attacking_objects_code`<br />`attacking_objects_system`<br />`attacking_objects_numeric`<br />`attacking_objects_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Attacking objects | `/data[at0001]/events[at0002]/data[at0003]/items[at0009]` |
| `total_score` | `integer` | yes | Total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0017]` |
| `interpretation`<br />`interpretation_code`<br />`interpretation_system`<br />`interpretation_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Interpretation | `/data[at0001]/events[at0002]/data[at0003]/items[at0030]` |

## Constraints

```sql
check ((confused_code is null and confused_system is null and confused_numeric is null and confused is null) or (confused_valueset_id is not null and confused_code is not null and confused_system is not null and confused_numeric is not null and confused is not null))
check ((irritable_code is null and irritable_system is null and irritable_numeric is null and irritable is null) or (irritable_valueset_id is not null and irritable_code is not null and irritable_system is not null and irritable_numeric is not null and irritable is not null))
check ((boisterous_code is null and boisterous_system is null and boisterous_numeric is null and boisterous is null) or (boisterous_valueset_id is not null and boisterous_code is not null and boisterous_system is not null and boisterous_numeric is not null and boisterous is not null))
check ((physical_threats_code is null and physical_threats_system is null and physical_threats_numeric is null and physical_threats is null) or (physical_threats_valueset_id is not null and physical_threats_code is not null and physical_threats_system is not null and physical_threats_numeric is not null and physical_threats is not null))
check ((verbal_threats_code is null and verbal_threats_system is null and verbal_threats_numeric is null and verbal_threats is null) or (verbal_threats_valueset_id is not null and verbal_threats_code is not null and verbal_threats_system is not null and verbal_threats_numeric is not null and verbal_threats is not null))
check ((attacking_objects_code is null and attacking_objects_system is null and attacking_objects_numeric is null and attacking_objects is null) or (attacking_objects_valueset_id is not null and attacking_objects_code is not null and attacking_objects_system is not null and attacking_objects_numeric is not null and attacking_objects is not null))
check (total_score is null or total_score between 0 and 6)
check ((interpretation_code is null and interpretation_system is null and interpretation_valueset_id is null and interpretation is null) or (interpretation is not null and interpretation_code is not null and interpretation_system is not null and interpretation_valueset_id 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 |
| `confused_valueset_id, confused_code, confused_system, confused, confused_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `irritable_valueset_id, irritable_code, irritable_system, irritable, irritable_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `boisterous_valueset_id, boisterous_code, boisterous_system, boisterous, boisterous_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `physical_threats_valueset_id, physical_threats_code, physical_threats_system, physical_threats, physical_threats_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `verbal_threats_valueset_id, verbal_threats_code, verbal_threats_system, verbal_threats, verbal_threats_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `attacking_objects_valueset_id, attacking_objects_code, attacking_objects_system, attacking_objects, attacking_objects_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `interpretation_valueset_id, interpretation_code, interpretation_system, interpretation` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `bvc_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/attacking_objects` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/boisterous` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/confused` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/interpretation` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/irritable` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/physical_threats` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.bvc.v1/verbal_threats` | 2 |

