Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| schedule_rule_id | int4 |
|
|
The unique ID associated with each schedule rule. E.g. 273. |
| member_id | int4 |
|
|
The ID of the member associated with the schedule rule. E.g. 2019. |
| member_profile_id | int4 |
|
|
The profile ID of the member that is associated with the schedule rule. E.g. 10. |
| membership_id | int4 |
|
|
The ID of the membership associated with the schedule rule. E.g. 2019. |
| helper_id | int4 |
|
|
The ID of the helper that is associated with the schedule rule. E.g. 10. |
| helper_profile_id | int4 |
|
|
The profile ID of the helper that is associated with the schedule rule. E.g. 10. |
| product_id | int4 |
|
|
The ID of the product that is associated with the schedule rule. E.g. 43. |
| previous_hcp_product_id | int8 |
|
|
The original hcp product id after the SAH mapping. This value only exists if the mapping has been completed, and is then the valid product_id on the visit before November 1st 2025. After this date the product_id is valid. E.g. 165.’ |
| product | text |
|
|
The name of the product being offered by the Care Worker to the Client that is associated with this schedule rule. E.g. “24 Hour High Level Care Block”. |
| start_time | text |
|
|
The start time of the recurring visit in an integer format. E.g. 0800. |
| end_time | text |
|
|
The end time of the recurring visit in an integer format. E.g. 1800. |
| recurrence_type | text |
|
|
The recurrence_type of the visit. Currently only one value: |
| recurrence_commencing_at | date |
|
|
The date when the series of recurring visits starts. E.g. 2021-03-02. |
| recurrence_concluding_at | date |
|
|
The date when the series of recurring visits ends. E.g. 2021-03-02. |
| recurrence_interval | int4 |
|
|
The spacing of the visits. E.g. For a weekly |
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
| 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. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_schedule_rules_pkey | Primary key | Asc | schedule_rule_id |
| fct_schedule_rules_company_id_idx | Performance | Asc | company_id |
| fct_schedule_rules_helper_id_idx | Performance | Asc | helper_id |
| fct_schedule_rules_member_id_idx | Performance | Asc | member_id |
| fct_schedule_rules_membership_id_idx | Performance | Asc | membership_id |
| fct_schedule_rules_recurrence_commencing_at_idx | Performance | Asc | recurrence_commencing_at |