fct_service_usage


Description

The individual usage event of a service by a customer at a studio (organization_unit).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
service_usage_id int8 19 null

The primary key of this table. System column calculated by the source System.
created_user varchar 256 null

The name of the user account who created the service usage record.
service_id int8 19 null
dim_service.service_id fct_service_usage_service_id_fkey R

The service that was used.
customer_id int8 19 √ null
dim_customer.customer_id fct_service_usage_customer_id_fkey R

The customer who used the service. Can be null if customer data was anonymized or data was imported from another system.
employee_id int8 19 √ null
dim_employee.employee_id fct_service_usage_employee_id_fkey R

The employee who handled the service usage. Can be null if service usage was created by the system (self-service/api).
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_service_usage_organization_unit_id_fkey R

The studio (organization_unit) where the service was used. Can be null if data was imported from another system.
inclusive_contingent_id int8 19 √ null
dim_inclusive_contingent.inclusive_contingent_id fct_service_usage_inclusive_contingent_id_fkey R

The inclusive contingent used for the service. Can be null if the service was used without an inclusive contingent.
purchased_contingent_id int8 19 √ null
dim_purchased_contingent.purchased_contingent_id fct_service_usage_purchased_contingent_id_fkey R

The purchased contingent used for the service. Can be null if the service was used without an purchased contingent.
start_date_time timestamp 29,6 null

The local timestamp when the service usage started.
end_date_time timestamp 29,6 √ null

The local timestamp when the service usage ended.
contingent_usages int4 10 null

The number of how much of a contingent was used for this service. Eg. 1 for a single drink or 30 for 30 minutes usage of tanning bed.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation