DIM_CONTENT_SERVICE_CONTENTS

Archived At

TIMESTAMP_NTZ(9)

Datetime the content was archived

2025-01-01T00:00:00.000+0000

Artefact ID

VARCHAR(16777216)

Identifier for the artefact; various content types such as file, url, elearning will have an artefact id. This identifier changes when new versions of the artefact are uploaded

123a12b3cd4e5f67g890h1ij

Assigned Audiences (ID)

VARIANT

List of audience IDs this content is assigned too

[“123a12b3cd4e5f67g890h1ij“]

Assigned Audiences (Name)

VARCHAR(16777216)

List of audience names this content is assigned too

Sales North East

Audiences Shared With (ID)

VARIANT

List of audience IDs this content has been shared with

[“123a12b3cd4e5f67g890h1ij“]

Audiences Shared With (Name)

VARCHAR(16777216)

List of audience names this content has been shared with

Sales North East

Author

VARCHAR(16777216)

Content author ID

123a12b3cd4e5f67g890h1ij

Author Email

VARCHAR(16777216)

Content author email address

john.smith@emailaddress.com

Author First Name

VARCHAR(16777216)

Content author first name

John

Author Full Name

VARCHAR(16777216)

Content author full name - concatenation of first and last names

John Smith

Author Last Name

VARCHAR(16777216)

Content author last name

Smith

Author Ref

VARCHAR(16777216)

Content author ref

ABC123

Available Translations

VARIANT

List of languages/transalations available (e.g. - en-us, de, en-gb etc.)

[ "en-us", "fr-ca" ]

CPD Category (ID)

VARCHAR(16777216)

ID of the CPD category the content relates to

123a12b3cd4e5f67g890h1ij

Can Reshare

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

TRUE

Collaboration Id

VARCHAR(16777216)

ID of the collaboration who own the content

123a12b3cd4e5f67g890h1ij

Collaboration Name

VARCHAR(16777216)

Name of the collaboration who own the content

Sales Training

Completion

VARCHAR(16777216)

Completion types for the content

external, default, disabled, auto, null, historical, confirm

external

Content Body Updated At

TIMESTAMP_NTZ(9)

Datetime the content body was last updated

2025-01-01T00:00:00.000+0000

Content ID

VARCHAR(16777216)

Identifier for the content

123a12b3cd4e5f67g890h1ij

Content Tags

VARIANT

Tags linked to this content

[“sales”, “teamwork”]

Content Title

VARCHAR(16777216)

Content title

How to boost your sales this quarter

Content Type

VARCHAR(16777216)

Type of content (e.g. - url, file, video etc.)

2025-01-01T00:00:00.000+0000

Created At

TIMESTAMP_NTZ(9)

Datetime the content was created

2025-01-01T00:00:00.000+0000

Default Duration

NUMBER(38,0)

Default content duration in minutes

15

Deleted

BOOLEAN

Boolean flag (true/false) to show if the content has been deleted

TRUE, FALSE, null

FALSE

Deleted At

TIMESTAMP_NTZ(9)

Datetime the content was deleted

2025-01-01T00:00:00.000+0000

Deleted By (ID)

VARCHAR(16777216)

ID of the user who deleted the content

123a12b3cd4e5f67g890h1ij

Description

VARCHAR(16777216)

Content description

A quick guide to support you to achieve your sales goals

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

Erasure

VARIANT

Details of the content deletion including deleted datetime, deleted by details and whether it is a hard or soft deletion

{

 "deletedAt": "2025-01-01T00:00:00.000Z",

 "deletedBy": {

   "type": "user",

   "value": "123a12b3cd4e5f67g890h1ij"

 },

 "isHard": true,

 "isSoft": false

}

Error Messages

VARIANT

Error messages related to the creation and uploading of content (e.g. - Unsupported format type, Scorm CAM 1.3 version is not supported”, No asset or sco items found etc.)

[

 "Unsupported format type"

]

Event Log

VARIANT

Details of the content and related events such as draft created and content published. Along with associated timestamps

[

 {

   "createdAt": "2025-01-01T00:00:00.000",

   "eventType": "contentDraftCreated",

   "loggedBy": {

     "type": "service",

     "value": "video-artefact-service"

   }

 },

 {

   "createdAt": "2025-01-01T00:00:00.000",

   "eventType": "contentPublished",

   "loggedBy": {

     "type": "user",

     "value": "123a12b3cd4e5f67g890h1ij"

   }

 },

 {

   "createdAt": "2025-01-01T00:00:00.000",

   "eventType": "contentArchived",

   "loggedBy": {

     "type": "user",

     "value": "123a12b3cd4e5f67g890h1ij"

   }

 },

 {

   "createdAt": "2025-01-01T00:00:00.000",

   "eventType": "contentDeleted",

   "loggedBy": {

     "type": "user",

     "value": "123a12b3cd4e5f67g890h1ij"

   }

 }

]

External Reference

VARCHAR(16777216)

External reference for the content

123456789

Has Picture

BOOLEAN

Boolean flag (true/false) to show if the content has an image

TRUE, FALSE, null

FALSE

Internal Version (__v)

VARCHAR(16777216)

Internal version number derived from the number of events within Versions

1

Is Allowed To Comment

BOOLEAN

Boolean flag (true/false) to show if comments are enabled for this piece of content

TRUE, FALSE, null

TRUE

Is Archived

BOOLEAN

Boolean flag (true/false) to show if the content has been archived

TRUE, FALSE, null

FALSE

Is Official

BOOLEAN

Boolean flag (true/false) to show if the content is endorsed

TRUE, FALSE, null

TRUE

Is Private

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

FALSE

Is Visible

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

TRUE

Linked Contents

BOOLEAN

List of content IDs this content is linked with

[“123a12b3cd4e5f67g890h1ij“]

Linked Contents (Title)

VARCHAR(16777216)

List of content titles this content is linked with

Sales Top Tips

Marked Ready

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

FALSE

Material Type

VARCHAR(16777216)

Type of content material (e.g. - zip, mp3, jpeg etc.)

pptx

Notifications

VARIANT

Legacy field which is no longer in use, around who would receive notifications for the content

{

 "userName": {

   "firstName": "John",

   "lastName": "Smith"

 }

}

Processing Status

VARCHAR(16777216)

Shows the processing status of the content

failed, processing, null, complete, preprocessing

processing

Provider

VARCHAR(16777216)

The name of the content provider (e.g. - udemy, linkedIn, blinkist etc.)

andersPink

Published At

TIMESTAMP_NTZ(9)

Datetime the content was published

2025-01-01T00:00:00.000+0000

Set Duration

NUMBER(38,0)

Set content duration in minutes

15

Skill Boosts

VARIANT

Where completion of the content is linked to boosting learner skills the skill name and level is recorded

[

 {

   "criteria": "on_completion",

   "level": 1024,

   "name": "sales"

 }

]

Tenant ID

VARCHAR(16777216)

Identifier for the tenant

eu-west-2_abcdefGh1

Thumbnail Updated At

TIMESTAMP_NTZ(9)

Datetime the content thumbnail was last updated

2025-01-01T00:00:00.000+0000

Updated At

TIMESTAMP_NTZ(9)

Datetime the content was last updated - this may include audience updates

2025-01-01T00:00:00.000+0000

User IDs with Private Content Access

ARRAY

List of all user ids who can access this content, if the content is set to private

[“123a12b3cd4e5f67g890h1ij“]

Users Shared With (Full Name)

VARCHAR(16777216)

List of user names this content has been shared with

[“John Smith“]

Users Shared With (ID)

VARIANT

List of user IDs this content has been shared with

[“123a12b3cd4e5f67g890h1ij“]

Users from Assigned Audiences (ID)

ARRAY

Array of all user IDs the content has been assigned too

[“123a12b3cd4e5f67g890h1ij“]

Users from Audiences Shared With (ID)

ARRAY

Array of all user IDs the content has been shared with

[“123a12b3cd4e5f67g890h1ij“]

Version

NUMBER(38,0)

Shows the current version of the content

1

Versions

VARIANT

Shows the content version history including the artefactId for each version

[

 {

   "artefactId": "123a12b3cd4e5f67g890h1ij",

   "version": 1

 }

]