CXiaaS: Table Update Frequency

CXiaaS: Table Update Frequency

Please find a break down of the various jobs running as part of the Genesys Adapter. Each table is associated with a job and is updated according to the job frequency.

 

Job

Frequency

Table

Adherence

12 hours

adherencedaydata

adherenceexcdata

adherenceactdata

Aggregation

1 hour

userpresencedata

userinteractiondata

queueinteractiondata

Evaluation

30 minutes

evaldata

evalquestiongroupdata

evalquestiondata

EvaluationCatchup

24 hours

evaldata

evalquestiongroupdata

evalquestiondata

FactData

12 hours

activitycodedetails

budetails

divisiondetails

evaldetails

groupdetails

usergroupmappings

mudetails

mumemberdata

odcampaigndetails

planninggroupdetails

presencedetails

queuedetails

skilldetails

userskillmappings

teamdetails
teammemberdata

userdetails

wrapupdetails

HeadcountForecast

12 hours

headcountforecastdata

HoursBlockDaily

12 hours

hoursblockdata

Interaction

30 minutes

detailedinteractiondata

convsummarydata

participantsummarydata

participantattributesdynamic

InteractionPresence

1 hour

userpresencedetaileddata

userinteractionpresencedetaileddata

OAuthUsage

12 hours

oauthusagedata

ODContact

30 minutes

odcontactlistdata

ODDetails

1 hour

odcontactlistdetails

odcompaigndetails

OfferedForecast

24 hours

offeredforecastdata

PresenceDetail

30 minutes

userpresencedetaileddata

QueueMemebership

12 hours

activeqmembersdata

RealTime

30 seconds

userrealtimedata

userrealtimeconvdata

queuerealtimeconvdata

ScheduleDetails

12 hours

scheduledetails

Subscription

12 hours

suboverviewdata

SubUsers

12 hours

subuserusagedata
subscriptiondata

Survey

1 hour

surveydata

surveyquestionanswers

surveyquestiongroupscores

TimeOffReq

12 hours

timeoffrequestdata

UserQueueAudit

1 hour

queueauditdata

UserQueueMapping

12 hours

userqueuemappings

VoiceAnalsysis

1 hour

convvoiceoverviewdata

convvoicesentimentdetaildata

convvoicetopicdetaildata

WFMAudit

1 hour

wfmauditdata

WFMSchedule

1 hour

scheduledata

timeoffdata

Cron

1 hour

mvwconvvoiceoverviewdata

mvwconvvoicesentimentdetaildata

mvwconvvoicetopicdetaildata

mvwevaluationgroupdata

mvwevaluationoverview

mvwevaluationquestiondata

Cron (Daily)

Every day at midnight

queueinteractiondatadaily

Every day at 15 minutes past midnight

userinteractiondatadaily

Every day at 15 minutes past midnight

userpresencedatadaily

Cron (Bulk)

Once a day at 1AM

queueinteractiondatadaily/weekly/monthly

userinteractiondatadaily/weekly/monthly

userpresencedatadaily/weekly/monthly

 

 

    • Related Articles

    • CXiaaS: Genesys Cloud Adapter for External Analytics

      Why do you need analytics? Data Analytics forms the backbone of business intelligence. It enables benchmarking, accurate reporting, KPI tracking and insights into consumer behaviour, allowing you to stay ahead of your competition. Customer Experience ...

    • CXiaaS: Message of the Day

      The message of the day is normally, but not exclusively positioned in the bottom right hand corner of the dashboard. For simplicity, it typically consists of the following two widgets/panels: Text Panel Image Panel Editing the Text Panel To edit the ...

    • Queue Grouping Metrics

      Background Some customers may have excessive numbers of Genesys Cloud queues defined due to the nature of their business and or various legacy reasons. Managing hundreds of queues can present challenges in finding, sorting and filtering queue related ...

    • public.vwusergroupmappings

      Description Table Definition CREATE VIEW vwusergroupmappings AS ( SELECT ugm.id, ugm.name, ud.id AS user_id, ud.name AS user_name, ugm.groupid AS group_id, ugm.updated FROM (usergroupmappings ugm JOIN userdetails ud ON (((ugm.userid)::text = ...

    • Release Notes

      Customer Science releases regular updates to our Genesys Adapter and associated CXiaaS offerings. Please review to understand our current releases: May 2026 May 2026 Version v3.60.5 - May 27, 2026 2026-05-27 New Features Increase throughput for ...