Data warehouse API data model reference

Diagram

The diagram below shows the entities that make up the data warehouse model:

Orange denote unique keys

Blue denote entity relationships.

* Generated with: http://pragmatiqa.com/xodata/#

Note: The full Data Warehouse model reference is exposed at "your_dedicated_data_warehouse_base_url/$metadata" (e.g. https://reporting.itslearning.com/odata/engine7/$metadata). This is the OData standard for publishing service metadata.

Entities, Relationships and Use in itslearning

Below is a list of all entities including description, fields, relationships and overview of how/where they appear in itslearning. You can navigate from entity to entity through the relationship links.

• AssessmentGrade

• AssessmentScale

• AssessmentStatus

• ConsumerType

• Course

• CourseElement

• CourseElementFileAssociation

• CourseMembership

• CourseProfile

• CourseVisit

• Date

• ElementCategory

• ElementType

• File

• LearningItem

• LearningObjective

• LearningObjectiveAssessment

• LearningObjectiveAssessmentStatus

• LearningObjectiveCourseElement

• LearningObjectiveProgress

• Organization

• OrganizationMembership

• Scorm

• ScormStatus

• SiteProfile

• Term

• Time

• User

• UserCourseSession

• UserElementSession

• UserGrade

• UserLogin

• UserSession