dUtcHalfHour

Data Feeds Tables
Last Updated:
June 14, 2021
by
Jesse Langstaff
| Version: 10
| 2,106 views
| 1 follower
 
members are following updates on this item.
Publication details
Published
on
April 20, 2018
by
Jesse Langstaff

Description

Provides a record of all half hour periods with corresponding time information in 11 time zones. A new row is added every half hour.

URL

 /odata/dUtcHalfHour

Keys

NameData TypeConnects to:
utc_half_hour_keyEdm.Int32

Attributes

NameData TypeConnects to:
utc_dtEdm.DateTimeOffsetUTC date time in the format mm/dd/yyyy HH:MM:SS.
utc_day_keyEdm.Int32Day of the current half hour period in UTC time. Day 1 corresponds to January 1, 2004.
us_eastern_dtEdm.DateTimeOffsetEastern date time in the format mm/dd/yyyy HH:MM:SS.
us_eastern_half_hour_keyEdm.Int32 Eastern time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
us_eastern_day_keyEdm.Int32 Day of the current half hour period in Eastern time. Day 1 corresponds to January 1, 2004.
us_central_dtEdm.DateTimeOffsetCentral date time in the format mm/dd/yyyy HH:MM:SS.
us_central_half_hour_keyEdm.Int32Central time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
us_central_day_keyEdm.Int32Day of the current half hour period in Central time. Day 1 corresponds to January 1, 2004.
us_mountain_dtEdm.DateTimeOffsetMountain date time in the format mm/dd/yyyy HH:MM:SS.
us_mountain_half_hour_keyEdm.Int32 Mountain time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
us_mountain_day_keyEdm.Int32Day of the current half hour period in Mountain time. Day 1 corresponds to January 1, 2004.
us_pacific_dtEdm.DateTimeOffset Pacific date time in the format mm/dd/yyyy HH:MM:SS.
us_pacific_half_hour_keyEdm.Int32 Pacific time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
us_pacific_day_keyEdm.Int32Day of the current half hour period in Pacific time. Day 1 corresponds to January 1, 2004.
arabia_st_dtEdm.DateTimeOffsetArabia date time in the format mm/dd/yyyy HH:MM:SS.
arabia_st_half_hour_keyEdm.Int32Arabia time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
arabia_st_day_keyEdm.Int32Day of the current half hour period in Arabia time. Day 1 corresponds to January 1, 2004.
uk_dtEdm.DateTimeOffsetUnited Kingdom date time in the format mm/dd/yyyy HH:MM:SS.
uk_half_hour_keyEdm.Int32United Kingdom time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
uk_day_keyEdm.Int32Day of the current half hour period in United Kingdom time. Day 1 corresponds to January 1, 2004.
eu_central_dtEdm.DateTimeOffsetCentral European date time in the format mm/dd/yyyy HH:MM:SS.
eu_central_half_hour_keyEdm.Int32Central European time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
eu_central_day_keyEdm.Int32Day of the current half hour period in Central European time. Day 1 corresponds to January 1, 2004.
eu_eastern_dtEdm.DateTimeOffsetEastern European date time in the format mm/dd/yyyy HH:MM:SS.
eu_eastern_half_hour_keyEdm.Int32Eastern European time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
eu_eastern_day_keyEdm.Int32Day of the current half hour period in Eastern European time. Day 1 corresponds to January 1, 2004.
bz_dtEdm.DateTimeOffsetBrazil date time in the format mm/dd/yyyy HH:MM:SS.
bz_half_hour_keyEdm.Int32Brazil time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
bz_day_keyEdm.Int32Day of the current half hour period in Brazil time. Day 1 corresponds to January 1, 2004.
nt_dtEdm.DateTimeOffsetNewfoundland date time in the format mm/dd/yyyy HH:MM:SS.
nt_half_hour_keyEdm.Int32Newfoundland time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
nt_day_keyEdm.Int32Day of the current half hour period in Newfoundland time. Day 1 corresponds to January 1, 2004.
atl_dtEdm.DateTimeOffset Atlantic date time in the format mm/dd/yyyy HH:MM:SS.
atl_half_hour_keyEdm.Int32Atlantic time half hour value. Starts at 1  on January 1, 2004 at 12AM and increments by 1 every half hour.
atl_day_keyEdm.Int32Day of the current half hour period in Atlantic time. Day 1 corresponds to January 1, 2004.


Related Content (31)

  • Analytics: Time
    /community/news_center/tips/analytics_time
    Blog
    published
    May 22, 2019
    by
    Jim Tigwell
    When your analytics goals are refined, time starts to matter a lot. It's not enough to know how often users are active in your digital workplace, but what times they're most engaged. Are they loggin…
  • fCommunityConcurrentUsers
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcommunityconcurrentusers
    Wiki
    published
    June 12, 2018
    by
    Jesse Langstaff
    DescriptionProvides data on what half hour periods Users have been active in a digital workplace.URL /odata/fCommunityConcurrentUsersKeysNameData TypeConnects to:user_key…
  • Data Feeds Tables
    /support/knowledgebase/all_articles/analytics/datafeed_tables
    {{related-content-type-Wiki}}
    published
    April 19, 2018
    by
    Jesse Langstaff
  • lkpURL
    /support/knowledgebase/all_articles/analytics/datafeed_tables/lkpurl
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a reference to the URL paths of objects in a digital workplace.URL /odata/lkpURLKeysNameData TypeConnects to:url_keyEdm.Int32dContentNav (url_…
  • fMemberPoint
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fmemberpoint
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides the total points earned by Members in a digital workplace.URL /odata/fMemberPointKeysNameData TypeConnects to:user_keyEdm.Int32dUser (user_key…
  • flWikiLabelCategory
    /support/knowledgebase/all_articles/analytics/datafeed_tables/flwikilabelcategory
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionAdding a Label to a Wiki Article adds a row to this table.URL /odata/flWikiLabelCategoryKeysNameData TypeConnects to:label_keyEdm.Int32lkpLabel (label_…
  • flWikiContainerLabelCategory
    /support/knowledgebase/all_articles/analytics/datafeed_tables/flwikicontainerlabelcategory
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionAdding a Label to a Wiki Channel adds a row to this table.URL /odata/flWikiContainerLabelCategoryKeysNameData TypeConnects to:label_keyEdm.Int32lkpLabe…
  • flForumLabelCategory
    /support/knowledgebase/all_articles/analytics/datafeed_tables/flforumlabelcategory
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionAdding a Label to a Forum Article adds a row to this table.URL  /odata/flForumLabelCategoryKeysNameData TypeConnects to:label_keyEdm.Int32lkpLabel (lab…
  • flDocumentLabelCategory
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fldocumentlabelcategory
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionAdding a Label to a Document adds a row to this table.URL /odata/flDocumentLabelCategoryKeysNameData TypeConnects to:label_keyEdm.Int32lkpLabel (label_…
  • flCommunityMemberProfileField
    /support/knowledgebase/all_articles/analytics/datafeed_tables/flcommunitymemberprofilefield
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of member profile fields and whether a member has data in them.URL /odata/flCommunityMemberProfileFieldKeysNameData TypeConnects to:user_key…
  • flCalendarLabelCategory
    /support/knowledgebase/all_articles/analytics/datafeed_tables/flcalendarlabelcategory
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionAdding a Label to a Calendar Event adds a row to this table.URL /odata/flCalendarLabelCategoryKeysNameData TypeConnects to:label_keyEdm.Int32lkpLabel (…
  • flBlogLabelCategory
    /support/knowledgebase/all_articles/analytics/datafeed_tables/flbloglabelcategory
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionAdding a Label to a Blog Article adds a row to this table.URL /odata/flBlogLabelCategoryKeysNameData TypeConnects to:label_keyEdm.Int32lkpLabel (label_…
  • fFolder
    /support/knowledgebase/all_articles/analytics/datafeed_tables/ffolder
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Folder Channel Folders in a digital workplace.URL  /odata/fFolderKeysNameData TypeConnects to:user_keyEdm.Int32…
  • fContentWiki
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentwiki
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Wiki Channel Articles in a digital workplace.URL  /odata/fContentWikiKeysNameData TypeConnects to:wiki_keyEdm.Int64…
  • fContentMicroblog
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentmicroblog
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Microblog Posts in a digital workplace.URL /odata/fContentMicroblogKeysNameData TypeConnects to:user_keyEdm.Int32 …
  • fContentForumTopic
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentforumtopic
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Forum Channel Topics in a digital workplace.URL /odata/fContentForumTopicKeysNameData TypeConnects to:forum_keyEdm.…
  • fContentForumReply
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentforumreply
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Forum Channel Replies in a digital workplace.URL /odata/fContentForumReplyKeysNameData TypeConnects to:forum_reply_ke…
  • fContentDocument
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentdocument
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Folder Channel Documents in a digital workplace.URL  /odata/fContentDocumentKeysNameData TypeConnects to:user_keyEd…
  • fContentCalendar
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentcalendar
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Calendar Channel Events in a digital workplace.URL /odata/fContentCalendarKeysNameData TypeConnects to:user_keyEdm.…
  • fContentBlog
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontentblog
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Blog Channel Articles in a digital workplace.URL /odata/fContentBlogKeysNameData TypeConnects to:user_keyEdm.Int32…
  • fContainerWiki
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainerwiki
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Blog Channels in a digital workplace. Does not include activity on Channel contents. URL /odata/fContainerWikiKeysNameData Type…
  • fContainerSpace
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainerspace
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Spaces in a digital workplace. Does not include activity on Igloo Objects nested below a Space.  URL  /odata/fContainerSpaceKeysNam…
  • fContainerPage
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainerpage
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Pages in a digital workplace. Does not include activity on Igloo Objects nested below a Page. URL /odata/fContainerPageKeysNameDa…
  • fContainerMicroblog
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainermicroblog
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Microblog Channels in a digital workplace. Does not include activity on Channel contents.URL /odata/fContainerMicroblogKeysNameDa…
  • fContainerForum
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainerforum
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Forum Channels in a digital workplace. Does not include activity on Channel contents.URL  /odata/fContainerForumKeysNameData Type…
  • fContainerFolder
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainerfolder
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Folder Channels in a digital workplace. Does not include activity on Channel contents. URL /odata/fContainerFolderKeysNameData Ty…
  • fContainerCalendar
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainercalendar
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Calendar Channels in a digital workplace. Does not include activity on Channel contents. URL  /odata/fContainerCalendarKeysNameDa…
  • fContainerBlog
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fcontainerblog
    Wiki
    published
    April 20, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all user activity on Blog Channels in a digital workplace. Does not include activity on Channel contents.URL /odata/fContainerBlogKeysNameData TypeC…
  • fBadgePoint
    /support/knowledgebase/all_articles/analytics/datafeed_tables/fbadgepoint
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of points being added and removed.URL /odata/fBadgePointKeysNameData TypeConnects to:awarded_badge_keyEdm.Int32lkpAwardedBadge (award…
  • dContentForumTopic
    /support/knowledgebase/all_articles/analytics/datafeed_tables/dcontentforumtopic
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all Forum Topics within the digital workplace. Creating a new Forum Topic, archiving an existing Forum Topic, or changing a Forum Topic's Type will add a row to this …
  • dContentDocument
    /support/knowledgebase/all_articles/analytics/datafeed_tables/dcontentdocument
    Wiki
    published
    April 19, 2018
    by
    Jesse Langstaff
    DescriptionProvides a record of all Folder Channel Content within the digital workplace. Adding a File to the digital workplace, archiving a File, or changing a File's extension will add a row to th…
Load MoreHide
Viewed 2,106 times