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/41660986/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"
}
]
}