Documentation Index

Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt

Use this file to discover all available pages before exploring further.

FCT_SPACE_PAGE_MEMBERSHIP

Prev Next

FCT_SPACE_PAGE_MEMBERSHIP relates to who has been added to spaces either individually or by a group membership. The table can be joined to DIM_SPACES on PageID

COLUMN NAME

DATA TYPE (FIELD SIZE)

DESCRIPTION

CURRENT AVAILABLE VALUES

EXAMPLE

Created At

TIMESTAMP_NTZ(9)

Datetime the membership was created

2025-01-01T00:00:00.000+0000

Doc Created At

TIMESTAMP_NTZ(9)

Timestamp inherited from parent snowflake object(s)

2025-01-01T00:00:00.000+0000

Doc Updated At

TIMESTAMP_NTZ(9)

Timestamp inherited from parent snowflake object(s)

2025-01-01T00:00:00.000+0000

Group ID

VARCHAR(16777216)

Identifier for the group

123a12b3cd4e5f67g890h1ij

Is Program Mentee

BOOLEAN

Indicator to show if the user has a program mentee role

TRUE, FALSE

TRUE

Is Program Mentor

BOOLEAN

Indicator to show if the user has a program mentor role

TRUE, FALSE

FALSE

Is Published

BOOLEAN

Indicator to show if the space was published when the member/group was added to it. If true then a notification is sent immediately, if not they are notified once it has been published

TRUE, FALSE, null

TRUE

Is Space Admin

BOOLEAN

Indicator to show if the user has a space admin role

TRUE, FALSE

FALSE

Is Space Member

BOOLEAN

Indicator to show if the user has a space member role

TRUE, FALSE

TRUE

Membership ID

VARCHAR(16777216)

Identifier for the group membership

123a12b3cd4e5f67g890h1ij

Page ID

VARCHAR(16777216)

Identifier for the page

This is currently a duplicate of the Space ID

123a12b3cd4e5f67g890h1ij

Principal Type

VARCHAR(16777216)

Shows whether the user was added individually or through a group. The user can appear multiple times if added both individually and via groups

group, user

user

Published At

TIMESTAMP_NTZ(9)

Datetime the membership was published

2025-01-01T00:00:00.000+0000

Roles

VARCHAR(16777216)

Comma seperated list of all roles the user has

space member, program mentee

Space ID

VARCHAR(16777216)

Identifier for the space

123a12b3cd4e5f67g890h1ij

Space Name

VARCHAR(16777216)

Name of the space

Sales Team Mentoring

Tenant ID

VARCHAR(16777216)

Identifier for the tenant

eu-west-2_abcdefGh1

Updated At

TIMESTAMP_NTZ(9)

Datetime the membership was last updated

2025-01-01T00:00:00.000+0000

User ID

VARCHAR(16777216)

Identifier for the user

123a12b3cd4e5f67g890h1ij