Time

Overview

This is a dimension entity which contains basic information about time and other time expressions.

What times are included?

In the entity there are times which illustrate when particular actions, events, and calculations took place. For each action the timestamp is stored. This timestamp can be described more precisely using its properties.

Usage in itslearning

  • This entity is not used in itslearning, this is a technical table (standard technical table in Data Warehouse).

Notes

  • For each customer there are 24 entities, one for each hour of a day

Relationships

Time is linked to:

Diagram

images/download/attachments/284208372/Time.PNG

Entity Details



Name

Data type

Nullable

Description

TimeId

Edm.Int32

false

Technical id of the time

TimeTitle

Edm.String


Time (full hours) stored as text

Hour

Edm.String


Hour as text

Minute

Edm.String


Minute as text

TimeValue

Edm.Time


Time (full hours) stored as a time data type


Request body


URI
https://reporting.itslearning.com/odata/engine7/Times?$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-20T14:27:19Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(0)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(0)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(0)" />
<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/Times(0)/CourseVisits"
/>
<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/Times(0)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">0</d:TimeId>
<d:TimeTitle>00:00</d:TimeTitle>
<d:Hour>00</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT0S</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(100)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(100)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(100)" />
<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/Times(100)/CourseVisits
" />
<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/Times(100)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">100</d:TimeId>
<d:TimeTitle>01:00</d:TimeTitle>
<d:Hour>01</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT1H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(200)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(200)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(200)" />
<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/Times(200)/CourseVisits
" />
<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/Times(200)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">200</d:TimeId>
<d:TimeTitle>02:00</d:TimeTitle>
<d:Hour>02</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT2H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(300)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(300)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(300)" />
<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/Times(300)/CourseVisits
" />
<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/Times(300)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">300</d:TimeId>
<d:TimeTitle>03:00</d:TimeTitle>
<d:Hour>03</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT3H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(400)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(400)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(400)" />
<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/Times(400)/CourseVisits
" />
<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/Times(400)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">400</d:TimeId>
<d:TimeTitle>04:00</d:TimeTitle>
<d:Hour>04</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT4H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(500)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(500)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(500)" />
<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/Times(500)/CourseVisits
" />
<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/Times(500)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">500</d:TimeId>
<d:TimeTitle>05:00</d:TimeTitle>
<d:Hour>05</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT5H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(600)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(600)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(600)" />
<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/Times(600)/CourseVisits
" />
<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/Times(600)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">600</d:TimeId>
<d:TimeTitle>06:00</d:TimeTitle>
<d:Hour>06</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT6H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(700)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(700)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(700)" />
<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/Times(700)/CourseVisits
" />
<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/Times(700)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">700</d:TimeId>
<d:TimeTitle>07:00</d:TimeTitle>
<d:Hour>07</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT7H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(800)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(800)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(800)" />
<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/Times(800)/CourseVisits
" />
<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/Times(800)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">800</d:TimeId>
<d:TimeTitle>08:00</d:TimeTitle>
<d:Hour>08</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT8H</d:TimeValue>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Times(900)</id>
<category term="Itslearning.Reporting.Data.Models.Time" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Times(900)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Times(900)" />
<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/Times(900)/CourseVisits
" />
<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/Times(900)/UserLogins" />
<title />
<updated>2016-12-20T14:27:19Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:TimeId m:type="Edm.Int32">900</d:TimeId>
<d:TimeTitle>09:00</d:TimeTitle>
<d:Hour>09</d:Hour>
<d:Minute>00</d:Minute>
<d:TimeValue m:type="Edm.Time">PT9H</d:TimeValue>
</m:properties>
</content>
</entry>
</feed>


Response body - JSON (default output format)


JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#Times","value":[
{
"TimeId":0,"TimeTitle":"00:00","Hour":"00","Minute":"00","TimeValue":"PT0S"
},{
"TimeId":100,"TimeTitle":"01:00","Hour":"01","Minute":"00","TimeValue":"PT1H"
},{
"TimeId":200,"TimeTitle":"02:00","Hour":"02","Minute":"00","TimeValue":"PT2H"
},{
"TimeId":300,"TimeTitle":"03:00","Hour":"03","Minute":"00","TimeValue":"PT3H"
},{
"TimeId":400,"TimeTitle":"04:00","Hour":"04","Minute":"00","TimeValue":"PT4H"
},{
"TimeId":500,"TimeTitle":"05:00","Hour":"05","Minute":"00","TimeValue":"PT5H"
},{
"TimeId":600,"TimeTitle":"06:00","Hour":"06","Minute":"00","TimeValue":"PT6H"
},{
"TimeId":700,"TimeTitle":"07:00","Hour":"07","Minute":"00","TimeValue":"PT7H"
},{
"TimeId":800,"TimeTitle":"08:00","Hour":"08","Minute":"00","TimeValue":"PT8H"
},{
"TimeId":900,"TimeTitle":"09:00","Hour":"09","Minute":"00","TimeValue":"PT9H"
}
]
}