public.adherenceexcdata

Description

Adherence Detailed Exception Data

Name	Type	Nullable	Comment
keyid	varchar(100)	false	Primary Key
userid	varchar(50)	true	User GUID
startdate	timestamp without time zone	true	Start Time (UTC)
startdateltc	timestamp without time zone	true	Start Time (LTC)
enddate	timestamp without time zone	true	End Time (UTC)
enddateltc	timestamp without time zone	true	End Time (LTC)
durationsecs	integer	true	Total Duration of Exception in sec(s) - Tolerance Time in sec(s)
tolerance	integer	true	The tolerance before exception starts
actualdurationsecs	integer	true	The actual time of the exception
scheduledactivitycategory	varchar(50)	true	The Activity Category
actualactivitycategory	varchar(50)	true	The Actual Activity Category
systempresence	varchar(50)	true	Presense GUID
routingstatus	varchar(50)	true	Routing Status GUID
impact	varchar(50)	true	Impact of the Exception
updated	timestamp without time zone	true	Date Row Updated (UTC)

Name	Type	Definition
adherenceexcdata_pkey	PRIMARY KEY	PRIMARY KEY (keyid)

Name	Definition
adherenceexcdata_pkey	CREATE UNIQUE INDEX adherenceexcdata_pkey ON public.adherenceexcdata USING btree (keyid)

Related Articles
public.vwadherenceexcdata
Description See AdherenceExcData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwadherenceexcdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric ...
public.mvwconvvoiceoverviewdata
Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
public.mvwconvvoicesentimentdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...
public.vwteammemberdata
Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...
public.jobminimumdefinition
Description Columns Name Type Default Nullable Children Parents Comment jobid integer nextval(‘jobminimumdefinition_jobid_seq’::regclass) false jobname varchar(255) true maxsyncspan varchar(50) true lookbackspan varchar(50) true Constraints Name Type ...