dim_sah_service_ids

Column Type Children Parents Comments

id

int4

dim_members.user_id	Implied Constraint	R
dim_profiles.staffer_id	Implied Constraint	R
dim_profiles.user_id	Implied Constraint	R
fct_helper_communities.community_id	Implied Constraint	R
fct_helper_services.service_id	Implied Constraint	R
fct_schedule_rules.product_id	Implied Constraint	R
fct_visit_services.visit_id	Implied Constraint	R
fct_visits.product_id	Implied Constraint	R

A unique database ID for the sah service ID. E.g. 5.

sah_service_id

text

The support at home service ID. E.g. SERV-0001.

Constraint Name	Type	Sort	Column(s)
dim_sah_service_ids_pkey1	Primary key	Asc	id