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
- CourseTemplate
- CourseVisit
- Date
- ElementCategory
- ElementType
- File
- LearningItem
- LearningObjective
- LearningObjectiveAssessment
- LearningObjectiveAssessmentStatus
- LearningObjectiveCourseElement
- LearningObjectiveProgress
- Organization
- OrganizationMembership
- Plan
- PlanElement
- Scorm
- ScormStatus
- SiteProfile
- Term
- Time
- User
- UserCourseSession
- UserElementSession
- UserGrade
- UserLogin
- UserSession
- CalendarEvent
- UserAttendance