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