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

30 minutes

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 Hour at 15 minutes past

queueinteractiondatadaily

Every Hour at 30 minutes past

userinteractiondatadaily

Every Hour at 45 minutes past

userpresencedatadaily

Cron (Bulk)

Once a day at 1AM

queueinteractiondatadaily/weekly/monthly

userinteractiondatadaily/weekly/monthly

userpresencedatadaily/weekly/monthly

 

 

    • Related Articles

    • CXiaaS: Customer hosted installation

      You can host our solution within your own nominated data centre cloud-hosted environment. All you need is a Linux or Windows Server and an SQL server of your choice. We install our adapter, provide available analytics templates for out-of-the-box ...

    • CXiaaS Onboarding checklist

      The below is a list of items to be confirmed as part of an effective onboarding for CXiaaS Item Reference Genesys Client ID and Secret configured Customer Science provides a process to create this with a defined permissions role Genesys Cloud OAuth ...

    • 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 ...