Note:
One row per Tenant ID, per User ID, per Primary Content ID to be returned. Priority is dependant upon status (open, overdue, schedule and completed superceed archived), then ordered by Due Date ASC, Available Date ASC and Last Completed At DESC
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Assignment ID | VARCHAR(16777216) | Identifier for the assignment | 123a12b3cd4e5f67g890h1ij | |
Audience ID | VARCHAR(16777216) | Identifier for the enrolled audience | 123a12b3cd4e5f67g890h1ij | |
Available Date | TIMESTAMP_NTZ(9) | Datetime the enrolment was available to complete | 2025-01-01T00:00:00.000+0000 | |
Created At | TIMESTAMP_NTZ(9) | Datetime the enrolment 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 | |
Due Date | TIMESTAMP_NTZ(9) | Datetime the enrolment is due | 2025-01-01T00:00:00.000+0000 | |
Enrolment | NUMBER(1,0) | If the audience linked is not empty —> then 1 | 1, 0 | 1 |
Enrolment Status | VARCHAR(16777216) | Current status of the enrolment | complete, null, archived, scheduled, overdue, open | complete |
Enrolments ID | VARCHAR(16777216) | Identifier for the enrolment | 123a12b3cd4e5f67g890h1ij | |
Last Completed At | TIMESTAMP_NTZ(9) | Datetime the content was last completed | 2025-01-01T00:00:00.000+0000 | |
Primary Content ID | VARCHAR(16777216) | Identifier for the primary content of the enrolment | 123a12b3cd4e5f67g890h1ij | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the enrolment was last updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |