---
title: "housing_record"
description: "Details about a single home or other residential setting of an individual during a specified period of time."
---

Details about a single home or other residential setting of an individual during a specified period of time.

**Purpose.** To record details about a single home or other residential setting of an individual during a specified period of time.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-CLUSTER.housing_record.v1` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `name_label` | `text` | yes | Name/label | `/items[at0005]` |
| `description` | `text` | yes | Description | `/items[at0016]` |
| `date_commenced` | `timestamptz` | yes | Date commenced | `/items[at0007]` |
| `residential_setting`<br />`residential_setting_code`<br />`residential_setting_system`<br />`residential_setting_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Residential setting | `/items[at0001]` |
| `tenure`<br />`tenure_code`<br />`tenure_system`<br />`tenure_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Tenure | `/items[at0013]` |
| `date_ceased` | `timestamptz` | yes | Date ceased | `/items[at0008]` |
| `comment` | `text` | yes | Comment | `/items[at0014]` |

## Constraints

```sql
check ((residential_setting_code is null and residential_setting_system is null and residential_setting_valueset_id is null) or (residential_setting is not null and residential_setting_code is not null and residential_setting_system is not null and residential_setting_valueset_id is not null))
check ((tenure_code is null and tenure_system is null and tenure_valueset_id is null) or (tenure is not null and tenure_code is not null and tenure_system is not null and tenure_valueset_id is not null))
```

## References

| Columns | Target | On delete |
|---|---|---|
| `residential_setting_valueset_id, residential_setting_code, residential_setting_system, residential_setting` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `tenure_valueset_id, tenure_code, tenure_system, tenure` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`housing_summary_housing_record`](/docs/tables/housing_summary_housing_record) via `housing_record_id`