dim_helpers


Description

This model contains helpers, also known as care workers, as well as any third party providers that are employed or contracted. Helpers sign contracts with memberships, with information such as products and services offered and their pricing arrangements. This enables them to visit a specific membership. Helpers can have default prices that they wish to charge for products, which show up as defaults when setting up contracts, but can be overriden by the contract prices. A helper is a part of multiple communities.

Columns

Column Type Children Parents Comments
helper_id int4

The unique helper ID, e.g.: 57.
state text

The current status of the helper, e.g. current or archived.
helper_link text
is_staffer bool

Whether the helper is a staff member, e.g. True or False.
is_care_worker bool

Whether the helper is a care worker, e.g. True or False.
is_third_party bool

Whether the helper a third party, where a third party is an external supplier of goods or services. E.g. True or False.
is_supplier bool

Whether the helper is a third party supplier of non-clinical goods and/or services. E.g. True or False.
is_clinician bool

Whether the helper is a third party supplier of clinical services. E.g. True or False.
engagement_type varchar

The type of engagement of the helper. One of “contractor”, “full_time” (full-time employee), “part_time” (part-time employee), “casual” (casual employee), “volunteer” (a volunteer has no ABN/Company name/Employee information). or “employee” (an employee of unknown type - created before full_time, part_time, and casual were introduced and not subsequently updated)".
weekly_capacity_in_hours numeric

The amount of hours a helper has capacity for in a given week. E.g. 40.
is_active bool

True if the Helper has completed any visits in the last 14 days, otherwise False. E.g. True or False.
company_name varchar

The company name of the helper. This is conditionally required if the care worker is a contractor. Employee workers fallback to the corporate helper’s company name. E.g. Jane Doe Care.
is_gst_registered bool

Whether the helper has a Goods and Services Tax (GST). Important if the helper is a contractor. E.g. True or false.
valid_abn bool

If the care worker has an Australian Business Number (ABN). It is only valid for contractors. E.g. True or False.
created_at timestamp

The date and time the helper was created (in UTC), e.g.: 2021-03-02 00:12:59.996101.
archived_at timestamp

The date and time the helper was archived (in UTC), e.g.: 2021-03-17 22:59:01.116801.
archive_reason varchar

The reason the helper was archived, e.g. resigned_retiring.
profile_id int4

The ID of the associated profile of the helper, e.g. 1534.
profile_uuid varchar

The UUID of the associated profile of the helper, e.g. a2311fd4-02a8-4452-99g2-fg391c5173a0.
timezone text

A string representation of the timezone of the helper, e.g. Australia/Hobart.
company_id int8
dim_companies.company_id Implied Constraint R

The company ID, e.g. 345.

Indexes

Constraint Name Type Sort Column(s)
dim_helpers_pkey Primary key Asc helper_id
dim_helpers_company_id_idx Performance Asc company_id

Relationships

Close relationships within degrees of separation