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

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