Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| contract_product_id | int8 |
|
|
The unique contract ID of the contract product, e.g. 43. |
|||
| contract_id | int8 |
|
|
The contract ID of the product, e.g. 43. |
|||
| is_contract_active | bool |
|
|
Whether the contract has begun, has not expired and the membership has not been archived. One of True, False. |
|||
| membership_id | int8 |
|
|
The ID of the membership associated with the visit, e.g. 1989. |
|||
| community_id | int8 |
|
|
The unique community ID of the Helper, e.g.: 123. DEPRECATED, join to dim_memberships and access the community_names field. |
|||
| community_name | text |
|
|
The name of the community the helper is a part of, e.g.: Adelaide West. DEPRECATED, join to dim_memberships and access the community_names field. |
|||
| helper_id | int8 |
|
|
The helper ID associated with the contract product, e.g.: 57. |
|||
| product_id | int8 |
|
|
The unique product ID, E.g.: 43. |
|||
| product | text |
|
|
The name of the product being offered by the Care Worker to the Client, e.g. “24 Hour High Level Care Block”. |
|||
| product_description | text |
|
|
The description of the product, e.g. “General in-home aged care support.” |
|||
| price | numeric |
|
|
The price of the product in whole amounts, e.g. 35.00. |
|||
| price_currency | varchar |
|
|
The currency of the price of the product is in, e.g. AUD. |
|||
| tenant_percent | numeric |
|
|
The percent the company receives from this product, E.g. 0.20. |
|||
| suggested_price | numeric |
|
|
The suggested price of this product in whole amounts, e.g. 56.50. |
|||
| suggested_tenant_percent | numeric |
|
|
The suggested tenant percentage of this product, e.g. 0.20. |
|||
| product_quantity_type | varchar |
|
|
The quantity type of the associated product. This indicates how the product is charged. One of |
|||
| product_archived_at | timestamp |
|
|
The date and time the product was archived (in UTC), e.g.: 2021-03-17 22:59:01. |
|||
| contract_beginning_at | timestamp |
|
|
The date and time the contract of the product starts (in UTC), e.g.: 2021-03-17 22:59:01. |
|||
| contract_expired_at | timestamp |
|
|
The date and time the contract of the product expires (in UTC), e.g.: 2021-03-17 22:59:01. |
|||
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_contract_products_pkey | Primary key | Asc | contract_product_id |
| fct_contract_products_company_id_idx | Performance | Asc | company_id |
| fct_contract_products_contract_id_idx | Performance | Asc | contract_id |
| fct_contract_products_helper_id_idx | Performance | Asc | helper_id |
| fct_contract_products_membership_id_idx | Performance | Asc | membership_id |