---
title: "FCT_MENTORSHIP_RELATIONSHIPS"
slug: "fct-mentorship-relationships"
updated: 2026-09-14T09:48:32Z
published: 2026-09-14T09:48:32Z
canonical: "docs.thrivelearning.com/fct-mentorship-relationships"
---

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

> [!CAUTION]
> Relationships are now referenced as Connections within the platform UI and Insights reporting

> [!NOTE]
> FCT_MENTORSHIP_RELATIONSHIPS records all mentoring/coaching/sponsorship relationships within platform spaces. The table can be joined to DIM_SPACES on Space ID, many to 1, to show spaces which have relationships. It can also be joined to DIM_USER_SERVICE_USER on Participant ID, many to 1, to show which users have mentoring/coaching/sponsorship relationships

![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(824).png?sv=2026-02-06&spr=https&st=2026-11-04T04%3A57%3A40Z&se=2026-11-04T05%3A57%3A40Z&sr=c&sp=r&sig=ENKNU%2BdVOTQ4pmszVsbhwnGDtP%2BEO8cOurqwZSNwh8g%3D)

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | **CURRENT AVAILABLE VALUES** | **EXAMPLE** |
| --- | --- | --- | --- | --- |
| **Created At** | TIMESTAMP_NTZ(9) | Datetime the relationship was created (match datetime) |  | 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 |
| Has Goals Match | Boolean | True/False indicator to show if the mentoring relationship included a match on goals | TRUE, FALSE | FALSE |
| Has Profile Field Match | Boolean | True/False indicator to show if the mentoring relationship included a match on profile fields | TRUE, FALSE | TRUE |
| Has Skills Match | Boolean | True/False indicator to show if the mentoring relationship included a match on skills | TRUE, FALSE | TRUE |
| **Last Message Sent** | TIMESTAMP_NTZ(9) | Datetime the last message was sent by the given user for this relationship (participant based) Note**:** this figure is derived by matching conversation participants to relationship participants - there is no direct key linking conversations to relationships. If the same two people have been matched in more than one relationship (e.g. rematched after a prior relationship ended), their message activity will be attributed in full to **every** matching relationship. This means a relationship that has since ended may still show a recent "Last Message Sent" date if the same pair are chatting under a newer relationship. |  | 2025-01-01T00:00:00.000+0000 |
| **Messages Sent** | NUMBER(18,0) | A count of messages sent by the given user for this relationship (participant based) Note**:** this figure is derived by matching conversation participants to relationship participants - there is no direct key linking conversations to relationships. If the same two people have been matched in more than one relationship (e.g. rematched after a prior relationship ended), their message activity will be attributed in full to **every** matching relationship, not divided between them. Do not sum this field across more than one Relationship ID (e.g. by tenant, space, or any other grouping), as this will double-count messages for any rematched pairs. |  | 5 |
| **Participant ID** | VARCHAR(16777216) | Unique identifier for the user, can be used along with the space details and role to asertain if the partipant is a mentor or/and mentee |  | 123a12b3cd4e5f67g890h1ij |
| **Participant Role** | VARCHAR(16777216) | Flag to show if the participant is a program mentee or mentor (please note they can be both) | program mentee, program mentor | program mentor |
| Program Type | VARCHAR(16777216) | Establishes the type of program the relationship was formed within | mentoring, coaching, sponsorship | mentoring |
| **Relationship ID** | VARCHAR(16777216) | Identifier for the relationship between mentor and mentee |  | 123a12b3cd4e5f67g890h1ij |
| Relationship Match Source | VARCHAR(16777216) | Shows the methods the match was formed upon | profile fields skills goals unknown If multiple ‘and’ will seperate the above | profile fields and skills |
| **Space ID** | VARCHAR(16777216) | Identifier for the space |  | 123a12b3cd4e5f67g890h1ij |
| **Space Name** | VARCHAR(16777216) | Name of the space |  | Sales Team Mentoring |
| **Status** | VARCHAR(16777216) | The current status of the relationship | active, concluded | active |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **Updated At** | TIMESTAMP_NTZ(9) | Datetime the relationship was last updated (match last updated) |  | 2025-01-01T00:00:00.000+0000 |