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

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