Time

Overview

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

What time is 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 hasn't used in itslearning, this is a technical table (standard technical table in Data Warehouse).

Notes

  • For each customer this entity contains 24 rows for each full hour.

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 (primary key)

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 time

SQL query:

; WITH numbers as ( SELECT 0 AS num UNION ALL SELECT num + 1 FROM numbers WHERE num < 59 ) SELECT TimeKey = Hour* 100 + Minute,TimeTitle = CONVERT ( varchar ( 5 ), CAST ( TimeFromParts (Hour,Minute, 0 , 0 , 0 ) AS TIME ), 120 ),Hour = format (Hour, '0#' ),Minute = format (Minute, '0#' ),TimeValue = TimeFromParts (Hour,Minute, 0 , 0 , 0 ) FROM ( SELECT num as Minute FROM numbers WHERE num BETWEEN 0 AND 59 ) M JOIN ( SELECT num as Hour FROM numbers WHERE num BETWEEN 0 AND 23 ) H on 1 = 1 WHERE MINUTE = 0 ORDER BY HOUR, MINUTE

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