Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| visit_service_id | text |
|
|
The UUID associated to the visit service, e.g. 3c0566aaa493e2eg283da54fd3a8c2c3. |
|||
| service | text |
|
|
The name of the service, e.g. |
|||
| visit_id | int4 |
|
|
The unique visit id, i.e. 412. |
|||
| visit_state | varchar |
|
|
The state of the visit. One of |
|||
| member_id | int4 |
|
|
The ID of the member associated with the visit, e.g. 2019. |
|||
| membership_id | int4 |
|
|
The ID of the membership associated with the visit, e.g. 1989. |
|||
| funding_plan | text |
|
|
The funding_plan assigned to the membership, e.g. |
|||
| community_name | text |
|
|
The name of the community the affected membership is in, e.g. Brisbane West. |
|||
| helper_id | int4 |
|
|
The ID of the helper that the associated visit service is linked to, e.g. 1403. |
|||
| approx_service_cost | numeric |
|
|
This is an approximation of the cost of the services offered. It is the `expected cost to the member’ divided by the number of services of this visit. Some services are assigned to products that are higher paying than others, and as such, this will be more accurate at the aggregate level than the individual level. |
|||
| approx_service_length_minutes | numeric |
|
|
This is an approximation as to the length of each service. It is the |
|||
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_visit_services_pkey | Primary key | Asc | visit_service_id |
| fct_visit_services_company_id_idx | Performance | Asc | company_id |
| fct_visit_services_membership_id_idx | Performance | Asc | membership_id |
| fct_visit_services_visit_id_idx | Performance | Asc | visit_id |