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