Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| membership_leave_period_id | int8 |
|
|
The unique ID associated with each leave period. E.g. 273. |
| membership_id | int8 |
|
|
The ID of the member associated with the leave period. E.g. 2019. |
| leave_type | varchar |
|
|
The type of leave, which can be one of: hospital, transition_care, respite, other. |
| other_type | varchar |
|
|
The type of leave if leave_type is other. |
| start_date | date |
|
|
The start date of the leave period (in local time). E.g.: 2024-03-02. |
| end_date | date |
|
|
The end date of the leave period (in local time). E.g.: 2024-03-08. |
| created_at | timestamp |
|
|
The date and time created (in UTC). E.g. 2021-03-02 00:12:59. |
| updated_at | timestamp |
|
|
The date and time updated (in UTC). E.g. 2021-05-02 00:10:57. |
| suspend_package | bool |
|
|
Whether the home care package is suspended during the leave period. One of True, False. |
| suspend_recurring_visits | bool |
|
|
Whether recurring visits are suspended during the leave period. One of True, False. |
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_membership_leave_periods_pkey | Primary key | Asc | membership_leave_period_id |
| fct_membership_leave_periods_company_id_idx | Performance | Asc | company_id |
| fct_membership_leave_periods_membership_id_idx | Performance | Asc | membership_id |