dim_members


Description

Information about a member’s attributes, their profile, and whether they have a help plan. This includes everything in dim_profiles for the member. A member can appear multiple times if associated with multiple memberships. Note also that some memberships can have more than one member. The distinction between a member and a membership is that a member is a role within a membership that is receiving the care.

Columns

Column Type Children Parents Comments
member_id int4

The ID of the member, e.g. 345.
has_help_plan bool

Whether the member has a help plan or not. One of True, False.
help_plan_evaluation varchar

Whether the member has a help plan evaluated or not. One of True, False.
is_active bool

Whether they are a part of a current membership and have had a visit in the last 14 days. One of True, False.
membership_id int4

The ID of the membership the member is a part of, e.g. 2410.
membership_state text

The state the membership is currently in. One of current, archived, lead, lost_lead.
membership_archived_at timestamp

The datetime (in UTC) the membership was archived, if it has been archived. E.g. 2023-07-31 02:00:00.
membership_archive_reason varchar

The reason the membership was archived, if it has been archived. E.g. residential_aged_care.
community_id int8
dim_communities.community_id Implied Constraint R

The unique community ID, e.g. 123. DEPRECATED, join to dim_memberships and access the community_names field.
community_name text

The name of the community, e.g. “Western Suburbs”. DEPRECATED, join to dim_memberships and access the community_names field.
profile_id int4

The ID of the associated profile of the helper, e.g. 1534.
profile_uuid varchar

The UUID of the associated profile of the helper, e.g. a2311fd4-02a8-4452-99g2-fg391c5173a0.
timezone text

The timezone the member lives in, e.g. Australia/Brisbane.
is_user_invited bool

Whether a user has been created in the app (and invited to activate). One of True, False.
user_invited_at timestamp
user_id int4
dim_sah_service_ids.id Implied Constraint R

The associated user ID in the app, empty if there`s no user, e.g. 25820.
is_user_activated bool

Whether the user has signed in and created a password. One of True, False.
user_activated_at timestamp

The datetime (in UTC) the user signed in and created a password, e.g. 2023-07-28 04:02:56.095589.
created_at timestamp

The date and time created the member was created (in UTC), e.g.: 2021-03-02 00:12:59.996101.
company_id int8
dim_companies.company_id Implied Constraint R

The company ID, e.g.: 345.

Indexes

Constraint Name Type Sort Column(s)
dim_members_pkey Primary key Asc member_id
dim_members_company_id_idx Performance Asc company_id
dim_members_membership_id_idx Performance Asc membership_id
dim_members_profile_id_idx Performance Asc profile_id

Relationships

Close relationships within degrees of separation