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. |
| 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)". DEPRECATED: Use engagement_type_v2 instead.’ |
| engagement_type_v2 | varchar |
|
|
‘The type of engagement of the helper. One of “contractor”, “employee”, “volunteer”.’ |
| employee_type | varchar |
|
|
‘The type of employment of the helper. One of “full_time”, “part_time”, “casual”.’ |
| 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. |
| 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 system code associated with the reason for archiving the helper. E.g. - created_in_error - other - resigned_wants_more_hours - resigned_wants_regular_hours - resigned_wants_full_time - resigned_not_contractor - resigned_platform_problems - resigned_industry_change - resigned_wants_more_money - resigned_found_higher_paid_job - resigned_found_full_time - resigned_completed_study - resigned_retiring - resigned_relocating - resigned_wants_career_advancement - resigned_maternity_leave - resigned_paternity_leave - resigned_extended_leave - resigned_other - terminated_unrelated_ciminal_offence - terminated_related_ciminal_offence - terminated_breach_of_terms - terminated_didnt_meet_standards - terminated_unreasonable_expectations - terminated_other - scim_group_staffers_disabled Note that if the value is NULL, then the reason is a custom reason defined by the company. In this case, see archive_reason_description. |
| archive_reason_description | varchar |
|
|
An explanation for why the helper was archived. E.g. “Created in error”. |
| 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 |
|
|
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 |