Name

Alias

Description

userid

 Fact.GCUserID

The GUID of the user

startdate

 Date.RowDate

 The start of the 30 min Interval (in UTC Time For User Presence Data) (In LTC for Daily, Weekly & Monthly Tables) 

startdateltcDate.RowDateLTC
The start of the 30 min interval in Local Time (Defined in Config)
User Presence Data Only Not The Daily, Weekly, Monthly Tables

systempresenceid

Fact.SystemPresence

 The Basic System Presence

presenceid

Fact.OrgPresence

The Organisational Presence (Only Different from System Presence if custom SubStatus' are used)

presencetime

 Raw.PresenceTime

The Total Presence Time in Seconds

routingid

Fact.RoutingStatus

Off Queue, IDLE, INTERACTING, NOT RESPONDING, COMMUNICATE

routingtime

Raw.RoutingTime

The Total Routing Time



Archive Tables


The Daily Table is populated every morning at 2 am for the previous day. 

The Weekly table is populated on a Monday morning at 2 am for the previous week, running from Mon-Sun.  

The Monthly table is populated on the first of the month at 2 am for the previous month.