⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_MENTORSHIP_SESSIONS records all mentoring sessions within platform spaces. The table can be joined to DIM_SPACES on Space ID, many to 1, to show spaces which have sessions in place. It can also be joined to DIM_USER_SERVICE_USER on Participant ID, many to 1, to show which users have mentoring sessions
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Created At | TIMESTAMP_NTZ(9) | Datetime the session entry 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 | |
End Date | TIMESTAMP_NTZ(9) | End date and time for the session | 2025-01-01T01:00:00.000+0000 | |
Mentoring Session Duration Minutes | NUMBER(18,0) | Duration in minutes of the session, difference between Start Date and End Date | 60 | |
Owner ID | VARCHAR(16777216) | Unique identifier for the user who owns the session | 123a12b3cd4e5f67g890h1ij | |
Participant ID | VARCHAR(16777216) | Unique identifier for the user(s) participating in the session | 123a12b3cd4e5f67g890h1ij | |
Participant Status | VARCHAR(16777216) | The status for each participant for the session | accepted, pending | accepted |
Relationship ID | VARCHAR(16777216) | Identifier for the relationship between mentor and mentee | 123a12b3cd4e5f67g890h1ij | |
Session ID | VARCHAR(16777216) | Unique identifier for the session | 123a12b3cd4e5f67g890h1ij | |
Space ID | VARCHAR(16777216) | Identifier for the space | 123a12b3cd4e5f67g890h1ij | |
Space Name | VARCHAR(16777216) | Name of the space | Sales Team Mentoring | |
Start Date | TIMESTAMP_NTZ(9) | Start date and time for the session | 2025-01-01T00:00:00.000+0000 | |
Status | VARCHAR(16777216) | The current status of the session | scheduled | scheduled |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Title | VARCHAR(16777216) | Freetext to show the session title | Sharing best practice to raise sales | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the session entry was last updated | 2025-01-01T00:00:00.000+0000 |