SiteProfile

Overview

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

Which course profiles are included?

Only profiles that can be used in the platform are present.

Usage in itslearning

images/download/attachments/41661368/image2018-7-10_11_58_46.png

images/download/attachments/41661368/image2018-7-10_12_41_54.png

Notes

  • The entity shows the latest version of site profiles.

Relationships

SiteProfile is linked to:

Diagram

images/download/attachments/41661368/SiteProfile.PNG

Entity Details

name

Data type

nullable

Description

SiteProfileId

Edm.Int32

false

Id of a site profile

SiteProfileTitle

Edm.String

Site 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

SQL code

CREATE TABLE [Dwh].[SiteProfile]([SiteProfileId] [INT] NOT NULL ,[SiteProfileTitle] [NVARCHAR]( 100 ) NULL ,[IsDeleted] [bit] NULL ,[DeletedDate] [DATETIME] NULL, [T_ModifiedDate] [DATETIME] NOT NULL ) ALTER TABLE Dwh.SiteProfile ADD CONSTRAINT PK_SiteProfile PRIMARY KEY (SiteProfileId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/SiteProfiles?$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-21T10:17:24Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/SiteProfiles(-1)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(-1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(-1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(-1)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(-1)/UserLogins
" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">-1</d:SiteProfileId>
<d:SiteProfileTitle>Other</d:SiteProfileTitle>
<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/SiteProfiles(7)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(7)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(7)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(7)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(7)/UserLogins"
/>
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SiteProfileTitle>System Administrator</d:SiteProfileTitle>
<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/SiteProfiles(8)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(8)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(8)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(8)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(8)/UserLogins"
/>
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">8</d:SiteProfileId>
<d:SiteProfileTitle>Administrator</d:SiteProfileTitle>
<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/SiteProfiles(9)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(9)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(9)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(9)/UserLogins"
/>
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SiteProfileTitle>Staff</d:SiteProfileTitle>
<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/SiteProfiles(10)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(10)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(10)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(10)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(10)/UserLogins
" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">10</d:SiteProfileId>
<d:SiteProfileTitle>Student</d:SiteProfileTitle>
<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/SiteProfiles(11)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(11)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(11)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(11)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(11)/UserLogins
" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">11</d:SiteProfileId>
<d:SiteProfileTitle>Guest</d:SiteProfileTitle>
<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/SiteProfiles(12)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(12)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(12)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(12)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(12)/UserLogins
" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">12</d:SiteProfileId>
<d:SiteProfileTitle>AICC</d:SiteProfileTitle>
<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/SiteProfiles(14)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(14)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(14)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(14)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(14)/UserLogins
" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">14</d:SiteProfileId>
<d:SiteProfileTitle>Parent</d:SiteProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">true</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">2012-10-04T17:48:02</d:DeletedDate>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/SiteProfiles(161)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(161)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(161)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(161)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(161)/UserLogin
s" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">161</d:SiteProfileId>
<d:SiteProfileTitle>Early learner</d:SiteProfileTitle>
<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/SiteProfiles(324)</id>
<category term="Itslearning.Reporting.Data.Models.SiteProfile" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(324)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(324)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Users" type="application/atom+xml;type=feed" title="Users" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(324)/Users" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserLogins" type="application/atom+xml;type=feed" title="UserLogins" href="https://reporting.itslearning.com/odata/engine7/SiteProfiles(324)/UserLogin
s" />
<title />
<updated>2016-12-21T10:17:24Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SiteProfileId m:type="Edm.Int32">324</d:SiteProfileId>
<d:SiteProfileTitle>fun</d:SiteProfileTitle>
<d:IsDeleted m:type="Edm.Boolean">true</d:IsDeleted>
<d:DeletedDate m:type="Edm.DateTime">2015-08-25T09:03:59</d:DeletedDate>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#SiteProfiles","value":[
{
"SiteProfileId":-1,"SiteProfileTitle":"Other","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":7,"SiteProfileTitle":"System Administrator","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":8,"SiteProfileTitle":"Administrator","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":9,"SiteProfileTitle":"Staff","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":10,"SiteProfileTitle":"Student","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":11,"SiteProfileTitle":"Guest","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":12,"SiteProfileTitle":"AICC","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":14,"SiteProfileTitle":"Parent","IsDeleted":true,"DeletedDate":"2012-10-04T17:48:02"
},{
"SiteProfileId":161,"SiteProfileTitle":"Early learner","IsDeleted":false,"DeletedDate":"9999-12-31T00:00:00"
},{
"SiteProfileId":324,"SiteProfileTitle":"fun","IsDeleted":true,"DeletedDate":"2015-08-25T09:03:59"
}
]
}

[09:17:14 AM] Magdalena Iwaniec: jest update[09:17:21 AM] Magdalena Iwaniec: a oto szczegóły:[09:17:41 AM] Magdalena Iwaniec: na trend line są wyświetlane "exceptional scores" w formie gwiazdek[09:17:51 AM] Magdalena Iwaniec: z tym że finalny layout będzie nieco inny[09:18:16 AM] Magdalena Iwaniec: nie będzie gwiazdek, natomiast linie będą w tych miejscach przekraczały taki marker "100%"[09:18:27 AM] Magdalena Iwaniec: powinnam to wrzucić dziś po południu[09:18:55 AM] Magdalena Iwaniec: ale można już sprawdzać, czy dla danego ucznia assessmenty ze score > 100% się wyświetlają czy nie[09:19:05 AM] Magdalena Iwaniec: druga rzecz: scatter chart[09:19:27 AM] Karolina Prusaczyk: ok, a gwiazdki będą na wykresie Assessments, prawda?[09:19:46 AM] Magdalena Iwaniec: tam te kulki nie są jeszcze prawidłowo rozmieszczone w pioniebędą niedługo wyrównane, tak aby assessmenty z tymi samymi wynikami znajdowały się w jednej linii[09:20:09 AM] Magdalena Iwaniec: no właśnie, i jeszcze z prawej strony zostaną dołożnone gwiazdki[09:21:13 AM] Magdalena Iwaniec: natomiast Progress Bar jest w miarę ok
Będzie jeszcze "uładniony", ale liczba tasków dla każdego ucznia powinna być prawidłowa. Statusy poszczególnych tasków (completed, open...etc) również[09:22:51 AM] Karolina Prusaczyk: super, dzięki wielkie za szczegóły, w razie czego, będę dopytywać, ok?[09:23:04 AM] Karolina Prusaczyk: po stronie danych Piotrek coś już zmieniał?[09:23:04 AM] Magdalena Iwaniec: jasne :) zapraszam[09:23:20 AM] Magdalena Iwaniec: po stronie danych to ja zrobiłam małe filtrowanie[09:23:28 AM] Magdalena Iwaniec: więc wszystko powinno być ok