Note:
Only tasks with an entryFor ‘pathway_basic_task’ and a status of ‘approved’ or ‘completed’ are included in this dataset
Where a pathway is assigned the latest enrolment data is shown based of the latest available date. Archived enrolments are excludedSuspended users are not included within this data set
This table does not include any archived or deleted pathways, contents or tasks
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
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 |