dim_products


Description

Products are offered by Care Workers on a visit. Companies have different ways of using this, which translate to different naming or descriptive conventions. Most are related closely to the services that helpers provide (e.g. Domestic Assistance, Nursing, etc.) along with any additional time considerations (e.g. 12 Hour Overnight Block). Products are directly related to how the Care Workers are paid, so some companies are more specific than others. They’re usually linked to the service a helper provides, but for flexibility don’t have to be. They can be linked to codes for finance and claiming.

Columns

Column Type Children Parents Comments
product_id int8
fct_contract_products.product_id Implied Constraint R
fct_event_attendees.product_id Implied Constraint R
fct_schedule_rules.previous_hcp_product_id Implied Constraint R
fct_visits.previous_hcp_product_id Implied Constraint R

The unique product ID, e.g. 43.
product_link text
product_uuid uuid

The unique identifier for a product, e.g. a2311fd4-02a8-4452-99g2-fg391c5173a0.
state text

The state of the product. One of either “current” or “archived”.
product text

The name of the product being offered by the Care Worker to the Client, e.g. “24 Hour High Level Care Block”.
description text

The description of the product being offered by the Care Worker to the Client, e.g. “General in-home aged care support.”.
funding_scheme_type varchar

The funding scheme that the product belongs to. E.g. hcp.
suggested_price numeric

The suggested price of this product in whole amounts, this is set by the company. E.g. 56.50.
suggested_tenant_percent numeric

The suggested company percentage of this product, e.g. 0.20.
quantity_type varchar

Multiplier for the price when working out the cost of a visit. e.g. “per_hour”, or “per_visit”.
support_category text

This is part of the NDIS support code.
sequence_number text

This is part of the NDIS support code.
registration_group text

This is part of the NDIS support code.
outcome_domain text

This is part of the NDIS support code.
support_purpose text

This is part of the NDIS support code.
services_for_the_product text

The string aggregated list of all services that use this product. E.g. ‘Companionship, Nursing’.
total_schedule_rules int8
scheduled_exceptional_visits int8
scheduled_exceptional_visits_after_july_1 int8
created_at timestamp

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

The date and time last updated (in UTC), e.g.: 2021-03-17 22:59:01.116801.
archived_at timestamp

The date and time the product was archived (in UTC), e.g.: 2021-03-17 22:59:01.116801.
company_id int8
dim_companies.company_id Implied Constraint R

The company ID, e.g.: 345.

Indexes

Constraint Name Type Sort Column(s)
dim_products_pkey Primary key Asc product_id
dim_products_company_id_idx Performance Asc company_id

Relationships

Close relationships within degrees of separation