FCT_PATHWAY_CONTENT_TASK_COMPLETIONS details for each pathway and user who has either been assigned the pathway or has completed a piece of content/task within it all all content/tasks and what has or has not yet been completed. The table can be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have pathway assignments and/or completions
Only tasks with an entryFor ‘pathway_basic_task’ and a status of ‘approved’ or ‘completed’ are included in this datase
Where a pathway is assigned the latest enrolment data is shown based of the latest available date. Archived enrolments are excluded
Suspended users are not included within this data set
This table does not include any archived or deleted pathways, contents or tasks. This table does not include any archived or deleted pathways, contents or tasks. Only published pathways, contents and tasks are included
Only users who have been assigned a pathway or have completed at least one content item from within a pathway will show in the table
Only content that is visible to the user will show in this table
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Available Date | TIMESTAMP_NTZ(9) | Datetime the enrolment was available to complete | 2025-01-01T00:00:00.000+0000 | |
Completion Type | VARCHAR(18) | The type of completion | Content Completion, Task Completion | Content Completion |
Content/Task Completion Criteria | VARCHAR(16777216) | For each individual content item or task within a pathway this details what the completion criteria is for that content item or task | Auto, External Confirmation, None - Switched Off, Pathway - Accept Historical Completions, Pathway - Accept Recent Completions, Task, Task - Evidence required, Task - Manager approval and evidence required, Task - Manager approval required, User Confirmation | Auto |
Content/Task Description | VARCHAR(16777216) | The description for the individual pieces of content/tasks within the pathway | A quick guide to support you to achieve your sales goals | |
Content/Task ID | VARCHAR(16777216) | Identifier for the content | 123a12b3cd4e5f67g890h1ij | |
Content/Task Position | NUMBER(38,0) | The order in which the content/tasks show within the section | 1 | |
Content/Task Tag List | VARCHAR(16777216) | Comma-separated list of tags linked to this content/task. Replaces the legacy "Content/Task Tags" (VARIANT) column | sales, teamwork | |
⚠️ Deprecated | VARIANT | Tags linked to this content/task. Returned as a VARIANT array - use "Content/Task Tag List" instead, which provides the same data as a comma-separated string for filtering within platform Insights reporting. This column is due to be deprecated |
| |
Content/Task Title | VARCHAR(16777216) | The title for the individual pieces of content/tasks within the pathway | How to boost your sales this quarter | |
Content/Task Type | VARCHAR(16777216) | The type of content i.e. video, url. Will show PathwayBasicTask for tasks | video | |
Due Date | TIMESTAMP_NTZ(9) | Datetime the enrolment is due | 2025-01-01T00:00:00.000+0000 | |
Earliest Completion Timestamp | TIMESTAMP_NTZ(9) | Datetime the individual content/task within the pathway was first complete | 2025-01-01T00:00:00.000+0000 | |
VARCHAR(16777216) | User email address | john.smith@emailaddress.com | ||
Enrolment Status | VARCHAR(16777216) | Current status of the enrolment | complete, null, archived, scheduled, overdue, open | complete |
Is Approval Req | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | FALSE |
Is Assigned | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Is Completed | NUMBER(1,0) | Where the content/task has been completed this will show as 1 | 1, 0 | 0 |
Is Private | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Is Section Restriction Enabled | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Is Visible | NUMBER(1,0) | If the content is either not private or is private and the user has visibility of it this will show as 1 The data set is limited to only show where Is Visible = 1 | 1 | 1 |
Item Type | VARCHAR(7) | Shows whether each row is Content or Task item | Content, Task | Content |
Last Completed At | TIMESTAMP_NTZ(9) | Datetime the overall pahway was last completed | 2025-01-01T00:00:00.000+0000 | |
Latest Completion Timestamp | TIMESTAMP_NTZ(9) | Datetime the individual content/task within the pathway was last complete | 2025-01-01T00:00:00.000+0000 | |
Number of Completions | NUMBER(18,0) | A count of all completions for this piece of content by the user | 2 | |
Pathway Completion Criteria | VARCHAR(16777216) | Auto, External Confirmation, None - Switched Off, Pathway - Accept Historical Completions, Pathway - Accept Recent Completions, User Confirmation | Pathway - Accept Recent CompletionsDetails the completion criteria for the pathway as a whole | |
Pathway Description | VARCHAR(16777216) | The description for the overall pathway | A sales focused pathway to support you wtith your sales goals | |
Pathway ID | VARCHAR(16777216) | Identifier for the pathway | 123a12b3cd4e5f67g890h1ij | |
Pathway Tag List | VARCHAR(16777216) | Comma-separated list of tags linked to this pathway. Replaces the legacy "Pathway Tags" (VARIANT) columnsales, teamwork | ||
⚠️ Deprecated | VARIANT | Tags linked to this pathway. Returned as a VARIANT array - use "Pathway Tag List" instead, which provides the same data as a comma-separated string for filtering within platform Insights reporting. This column is due to be deprecated | [“sales”, “teamwork”] | |
Pathway Title | VARCHAR(16777216) | The title for the overall pathway | Your Sales Goals | |
Section ID | VARCHAR(16777216) | Identifier for the section | 123a12b3cd4e5f67g890h1ij | |
Section Position | NUMBER(38,0) | The order in which the sections show within the pathway | 1 | |
Section Summary | VARCHAR(16777216) | The summary for the section | In this section we will explore your sales goals and how we can support you to achieve them | |
Section Title | VARCHAR(16777216) | The title for the section | Section 1: Your Sales Goals | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User Full Name | VARCHAR(16777216) | User full name | John Smith | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |