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.

Usage in itslearning

Profiles can be found in Admin menu, Profiles page.

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

Id of a course profile

CourseProfileTitle

Edm.String

Course profile title

IsDeleted

Edm.Boolean

Flag that determines if the profile is deleted

DeletedDate

Edm.DateTime

Deletion date

T_ModifiedDate

Edm.DateTime

false

Date and time the entity was last modified in data warehouse

CREATE TABLE [Dwh].[CourseProfile]([CourseProfileId] [INT] NOT NULL ,[CourseProfileTitle] [NVARCHAR]( 100 ) NULL ,[IsDeleted] [bit] NULL ,[DeletedDate] [DATETIME] NULL, [T_ModifiedDate] [DATETIME] NOT 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"
}
]
}