Note:
This table does not include any archived or deleted pathways, contents or tasks. Only published pathways, contents and tasks are included
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
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 | |
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 | |
Is Approval Req | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | FALSE |
Is Private | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Is Section Restriction Enabled | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Item Type | VARCHAR(7) | Shows whether each row is Content or Task item | Content, Task | Content |
Pathway Description | VARCHAR(16777216) | The description for the overall pathway | A sales focused pathway to support you wtith your sales goals |