CourseProfile

Overview

This is a dimension entity which contains basic information about course profiles.

Which course profiles are included?

Only profiles that can be used in courses are present in the entity.

Usage in itslearning

This is information about profiles user used in course.

images/download/attachments/41661307/image2018-7-9_14_55_17.png

images/download/attachments/41661307/image2018-7-9_14_55_57.png

Notes

  • The entity shows the latest version of course profiles.

Relationships

CourseProfile is linked to:

Diagram

images/download/attachments/41661307/CourseProfile.PNG

Entity Details

Name

Data type

Nullable

Description

CourseProfileId

Edm.Int32

false

business ID

CourseProfileTitle

Edm.String

course profile name

IsDeleted

Edm.Boolean

flag if a profile is deleted

DeletedDate

Edm.DateTime

deletion date

SQL code:

CREATE TABLE [Dwh].[CourseProfile]([CourseProfileId] [INT] NOT NULL ,[CourseProfileTitle] [NVARCHAR]( 100 ) NULL ,[IsDeleted] [bit] NULL ,[DeletedDate] [DATETIME] NULL ) ALTER TABLE Dwh.CourseProfile ADD CONSTRAINT PK_CourseProfile PRIMARY KEY (CourseProfileId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/CourseProfiles?$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" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
<id>http://schemas.datacontract.org/2004/07/</id>
<title />
<updated>2016-12-21T09:38:40Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(-1)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(-1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(-1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(-1)/Cour
seVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">-1</d:CourseProfileId>
<d:CourseProfileTitle>Other</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">false</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(3)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3)/Cours
eVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId>
<d:CourseProfileTitle>Administrator</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">false</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(4)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(4)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(4)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(4)/Cours
eVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">4</d:CourseProfileId>
<d:CourseProfileTitle>Teacher</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">false</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(5)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5)/Cours
eVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseProfileTitle>Student</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">false</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(6)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(6)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(6)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(6)/Cours
eVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">6</d:CourseProfileId>
<d:CourseProfileTitle>Guest</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">false</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(316)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(316)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(316)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(316)/Cou
rseVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">316</d:CourseProfileId>
<d:CourseProfileTitle>Sven Teacher</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">true</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">2010-12-16T18:36:12</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(3757)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3757)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3757)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3757)/Co
urseVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">3757</d:CourseProfileId>
<d:CourseProfileTitle>MyCourseProfile</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">true</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">2012-04-26T17:50:01</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(3945)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3945)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3945)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(3945)/Co
urseVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">3945</d:CourseProfileId>
<d:CourseProfileTitle>Aspirant</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">true</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">2012-06-28T16:38:10</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(5377)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5377)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5377)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5377)/Co
urseVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">5377</d:CourseProfileId>
<d:CourseProfileTitle>1</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">true</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">2013-05-13T10:36:21</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseProfiles(5378)</id>
<category term="Itslearning.Reporting.Data.Models.CourseProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5378)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5378)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/CourseProfiles(5378)/Co
urseVisits" />
<title />
<updated>2016-12-21T09:38:40Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseProfileId m:type="Edm.Int32">5378</d:CourseProfileId>
<d:CourseProfileTitle>test</d:CourseProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">false</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:DeletedDate>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#CourseProfiles","value":[
{
"CourseProfileId":-1,"CourseProfileTitle":"Other","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"CourseProfileId":3,"CourseProfileTitle":"Administrator","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"CourseProfileId":4,"CourseProfileTitle":"Teacher","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"CourseProfileId":5,"CourseProfileTitle":"Student","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"CourseProfileId":6,"CourseProfileTitle":"Guest","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"CourseProfileId":316,"CourseProfileTitle":"Sven Teacher","IsDeleted":true,"DeletedDate":"2010-12-16T18:36:12"
},{
"CourseProfileId":3757,"CourseProfileTitle":"MyCourseProfile","IsDeleted":true,"DeletedDate":"2012-04-26T17:50:01"
},{
"CourseProfileId":3945,"CourseProfileTitle":"Aspirant","IsDeleted":true,"DeletedDate":"2012-06-28T16:38:10"
},{
"CourseProfileId":5377,"CourseProfileTitle":"1","IsDeleted":true,"DeletedDate":"2013-05-13T10:36:21"
},{
"CourseProfileId":5378,"CourseProfileTitle":"test","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
}
]
}