fct_schedule_rules


Description

These are the rules that are associated with recurring visits. The rules include the start and end time of a visit, the products being offered, and the associated members and helpers.

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
dim_sah_service_ids.id Implied Constraint R

The ID of the product that is associated with the schedule rule. E.g. 43.
previous_hcp_product_id int8
dim_products.product_id Implied Constraint R

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 July 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: weekly.
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 recurrence_type, an interval of 2 means every two weeks.
company_id int8
dim_companies.company_id Implied Constraint R

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

Relationships

Close relationships within degrees of separation