fct_care_management_tasks


Description

Care Management Tasks are tasks assigned to care team members to manage and track care-related activities such as logging tickets, scheduling meal deliveries, etc.

Organisations will be allocated a set number of hours to perform their care management hours, and they will be claiming expense based on their utilisation of the allocated hours.

This model provides insights into the tasks assigned, their duration, the associated costs and care team members. Use this model to: - Hours utilised on care management tasks. - Track care management hours across helpers/staffers, community, etc. - Analyze task costs and durations. - Analyze task performance across care team members.

Columns

Column Type Children Parents Comments
time_tracking_log_id int8

The ID of the time tracking log associated with the task. E.g. 789.
company_id int8

The company ID. E.g. 456.
created_by_id int8

The profile ID of the worker who created the task. E.g. 123.
membership_id int8

The ID of the membership associated with the task. E.g. 12345.
product_id int8

The ID of the product associated with the task. E.g. 678.
source_id int8

The ID of the source associated with the task. E.g. 456.
task_charge_in_cents float8

The charge for the task in cents. E.g. 5000.
task_duration_in_minutes float8

The duration of the task in minutes. E.g. 60.
task_duration_in_hours float8

The duration of the task in hours with decimal minutes. E.g. 1.25 is 1 hour 15 minutes
sah_funding_source varchar
community_names text

The names of the communities associated with this task. E.g. “Anita,Clients,Wellbeing Team”.
created_by_current_primary_role text

The current primary role of the user who created the task. E.g. “Helper”, “Staffer”, etc.
created_by_profile_link text

A link to the profile of the user who created the task. E.g. https:///admin/profiles/123.
funding_scheme_type varchar

The funding scheme type associated with the task, E.g. “hcp”, “self_funded”, etc.
membership_link text

A link to the membership details. E.g. https:///admin/memberships/12345.
product text
source_type varchar

The type of source associated with the task, E.g. “Ticket”, “Observation”, etc.
funding_plan text

A derived column that adds hcp approved level to the funding scheme type, if the funding scheme type is hcp. Otherwise it is the funding scheme type. E.g. hcp 3 or ndis.
higher_needs_client bool

Whether or not we categorise this client as higher needs (hcp approved level 3 or above). True or False. E.g. True
billable bool

Whether or not this task is billable. True or False. E.g. True.
created_at_in_company_tz timestamp

The date and time the task was created in the company timezone. E.g.: 2021-03-02 00:12:59.
invoiced_at_in_company_tz timestamp

The date and time the task was invoiced in the company timezone. E.g.: 2021-03-02 00:12:59.
took_place_on date

The date on which this time tracking log took place. E.g. “2023-01-01”

Indexes

Constraint Name Type Sort Column(s)
fct_care_management_tasks_pkey Primary key Asc time_tracking_log_id
fct_care_management_tasks_community_names_idx Performance Asc community_names
fct_care_management_tasks_company_id_idx Performance Asc company_id
fct_care_management_tasks_created_by_current_primary_role_idx Performance Asc created_by_current_primary_role
fct_care_management_tasks_created_by_id_idx Performance Asc created_by_id
fct_care_management_tasks_source_type_idx Performance Asc source_type

Relationships

Close relationships within degrees of separation