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 | auto, null, external, default, historical, confirm | 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 Tags | VARIANT | Tags for the individual pieces of content/tasks within the pathway | [“sales”, “teamwork”] | |
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 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 Tags | VARIANT | Tags for the pathway | [“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 |