UserCourseSession

Overview

This is a fact entity which contains basic information about user sessions in courses.

Which user course sessions are included?

The entity contains all current and historical sessions. It shows, how long the user uses the course, how long was logged in the course.

Notes

  • The entity shows the information using time stamps.This entity hasn't used in itslearning in the application. This is technical table.

RelationShips

UserCourseSession is linked to:

Diagram

images/download/attachments/45732173/UserCourseSession.PNG

Entity Details

Name

Data type

Nullable

Description

MonthlyDateId

Edm.Int32

false

monthly date id




(primary key)

DateId

Edm.Int32

false

date id

UserId

Edm.Int32

false

user id logging

CourseId

Edm.Int32

false

course id

CourseProfileId

Edm.Int32

false

user site profile id

CourseOrganizationId

Edm.DateTime

false

course organization id

ConsumerTypeId

Edm.Int32

false

consumer type id

CourseSessionStartDate

Edm.DateTime

false

session start time

date time start loggin user in the course

CourseSessionEndDate

Edm.DateTime

false

session end time

date time logaut user on the course

CourseSessionDurationMinutes

Edm. Int64

false

session duration

Formula: CourseSessionEndDate - CourseSessionStartDate [secound]

how long user was login in course

SQL code

CREATE TABLE [Dwh].[UserCourseSession]([MonthlyDateId] [INT] NOT NULL ,[DateId] [INT] NOT NULL ,[UserId] [INT] NOT NULL ,[CourseId] [INT] NOT NULL ,[CourseProfileId] [INT] NOT NULL ,[CourseOrganizationId] [INT] NOT NULL ,[ConsumerTypeId] [INT] NOT NULL ,[CourseSessionStartDate] [DATETIME] NOT NULL ,[CourseSessionEndDate] [DATETIME] NOT NULL ,[CourseSessionDurationMinutes] [BIGINT] NOT NULL ) ALTER TABLE Dwh.UserCourseSession ADD CONSTRAINT PK_UserCourseSession PRIMARY KEY (UserId,CourseId,CourseSessionStartDate);

Request body

URI
https://reporting.itslearning.com/odata/engine7/UserCourseSessions?$top=10

Response body - XML

XML response
<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reporting.itslearning.com/odata/engine7" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xml
ns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
<id>http://schemas.datacontract.org/2004/07/</id>
<title />
<updated>2018-04-23T13:18:56Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSession
StartDate=datetime'2018-04-18T11:21:21')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSession
StartDate=datetime'2018-04-18T11:21:21')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSes
sionStartDate=datetime'2018-04-18T11:21:21')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180401</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180418</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">4</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-04-18T11:21:21</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-04-18T11:24:21</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">3</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSession
StartDate=datetime'2018-04-18T14:37:46')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSession
StartDate=datetime'2018-04-18T14:37:46')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSes
sionStartDate=datetime'2018-04-18T14:37:46')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180401</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180418</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">4</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-04-18T14:37:46</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-04-18T14:37:46</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessio
nStartDate=datetime'2018-03-27T11:22:37')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessio
nStartDate=datetime'2018-03-27T11:22:37')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSe
ssionStartDate=datetime'2018-03-27T11:22:37')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180327</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">25</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">5</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-27T11:22:37</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-27T11:22:37</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessio
nStartDate=datetime'2018-03-27T11:32:06')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessio
nStartDate=datetime'2018-03-27T11:32:06')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSe
ssionStartDate=datetime'2018-03-27T11:32:06')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180327</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">25</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">5</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-27T11:32:06</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-27T11:33:12</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">1</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessio
nStartDate=datetime'2018-02-26T09:19:54')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessio
nStartDate=datetime'2018-02-26T09:19:54')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSe
ssionStartDate=datetime'2018-02-26T09:19:54')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180201</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180226</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">81</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-02-26T09:19:54</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-02-26T09:19:54</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-02-26T09:19:50')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-02-26T09:19:50')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSe
ssionStartDate=datetime'2018-02-26T09:19:50')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180201</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180226</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">87</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-02-26T09:19:50</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-02-26T09:19:50</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-07T16:31:30')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-07T16:31:30')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSe
ssionStartDate=datetime'2018-03-07T16:31:30')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180307</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">87</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-07T16:31:30</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-07T16:33:30</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">2</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-07T16:37:30')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-07T16:37:30')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSe
ssionStartDate=datetime'2018-03-07T16:37:30')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180307</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">87</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-07T16:37:30</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-07T16:37:30</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-07T16:40:30')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-07T16:40:30')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSe
ssionStartDate=datetime'2018-03-07T16:40:30')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180307</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">87</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-07T16:40:30</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-07T16:43:30</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">3</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')</id>
<category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-08T08:50:03')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessio
nStartDate=datetime'2018-03-08T08:50:03')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSe
ssionStartDate=datetime'2018-03-08T08:50:03')/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,Course
Id=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/Organization" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId
=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/ConsumerType" />
<title />
<updated>2018-04-23T13:18:56Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180308</d:DateId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:CourseId m:type="Edm.Int32">87</d:CourseId>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId>
<d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-08T08:50:03</d:CourseSessionStartDate>
<d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-08T08:51:03</d:CourseSessionEndDate>
<d:CourseSessionDurationMinutes m:type="Edm.Int64">1</d:CourseSessionDurationMinutes>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#UserCourseSessions","value":[
{
"MonthlyDateId":20180401,"DateId":20180418,"UserId":1,"CourseId":7,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":4,"CourseSessionStartDate":"2018-04-18T11:21:21","CourseSessionEndDate":"2018-04-18T11:24:21","CourseSessionDurationMinutes":"3"
},{
"MonthlyDateId":20180401,"DateId":20180418,"UserId":1,"CourseId":7,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":4,"CourseSessionStartDate":"2018-04-18T14:37:46","CourseSessionEndDate":"2018-04-18T14:37:46","CourseSessionDurationMinutes":"0"
},{
"MonthlyDateId":20180301,"DateId":20180327,"UserId":1,"CourseId":25,"CourseProfileId":3,"CourseOrganizationId":5,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-27T11:22:37","CourseSessionEndDate":"2018-03-27T11:22:37","CourseSessionDurationMinutes":"0"
},{
"MonthlyDateId":20180301,"DateId":20180327,"UserId":1,"CourseId":25,"CourseProfileId":3,"CourseOrganizationId":5,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-27T11:32:06","CourseSessionEndDate":"2018-03-27T11:33:12","CourseSessionDurationMinutes":"1"
},{
"MonthlyDateId":20180201,"DateId":20180226,"UserId":1,"CourseId":81,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-02-26T09:19:54","CourseSessionEndDate":"2018-02-26T09:19:54","CourseSessionDurationMinutes":"0"
},{
"MonthlyDateId":20180201,"DateId":20180226,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-02-26T09:19:50","CourseSessionEndDate":"2018-02-26T09:19:50","CourseSessionDurationMinutes":"0"
},{
"MonthlyDateId":20180301,"DateId":20180307,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-07T16:31:30","CourseSessionEndDate":"2018-03-07T16:33:30","CourseSessionDurationMinutes":"2"
},{
"MonthlyDateId":20180301,"DateId":20180307,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-07T16:37:30","CourseSessionEndDate":"2018-03-07T16:37:30","CourseSessionDurationMinutes":"0"
},{
"MonthlyDateId":20180301,"DateId":20180307,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-07T16:40:30","CourseSessionEndDate":"2018-03-07T16:43:30","CourseSessionDurationMinutes":"3"
},{
"MonthlyDateId":20180301,"DateId":20180308,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-08T08:50:03","CourseSessionEndDate":"2018-03-08T08:51:03","CourseSessionDurationMinutes":"1"
}
]
}