---
title: "FCT_SPACE_PAGE_MEMBERSHIP"
slug: "fct-space-membership"
updated: 2026-05-29T10:35:43Z
published: 2026-05-29T10:35:43Z
canonical: "docs.thrivelearning.com/fct-space-membership"
---

> ## 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

> [!NOTE]
> 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
> 
> 
> 
> ![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(780).png?sv=2026-02-06&spr=https&st=2026-11-04T03%3A47%3A21Z&se=2026-11-04T04%3A47%3A21Z&sr=c&sp=r&sig=DAQYg2NNIAWFkgzBO5kmUjxozBNMtV7hyIxTYOhuV%2Fs%3D)
> 
> 
> 
> ![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(781).png?sv=2026-02-06&spr=https&st=2026-11-04T03%3A47%3A21Z&se=2026-11-04T04%3A47%3A21Z&sr=c&sp=r&sig=DAQYg2NNIAWFkgzBO5kmUjxozBNMtV7hyIxTYOhuV%2Fs%3D)
> 
> 
> 
> ![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(782).png?sv=2026-02-06&spr=https&st=2026-11-04T03%3A47%3A21Z&se=2026-11-04T04%3A47%3A21Z&sr=c&sp=r&sig=DAQYg2NNIAWFkgzBO5kmUjxozBNMtV7hyIxTYOhuV%2Fs%3D)

| **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 |