public.oauthusagedata

Description

Oauth Usage by Client ID per Day

Name	Type	Nullable	Comment
keyid	varchar(100)	false	Primary Key
clientid	varchar(50)	true	Oauth Client GUID
rowdate	timestamp without time zone	true	Date
clientname	varchar(200)	true	Oauth Client Name
organizationid	varchar(50)	true	Home Organization GUID
userid	varchar(50)	true	Oauth Agent GUID
status200	integer	true	Count of 200 Response Codes
status300	integer	true	Count of 200 Response Codes
status400	integer	true	Count of 200 Response Codes
status500	integer	true	Count of 200 Response Codes
status429	integer	true	Count of 429 Response Codes - Rate limiting Responses
updated	timestamp without time zone	true	Date Row Updated (UTC)

Name	Type	Definition
oauthusagedata_pkey	PRIMARY KEY	PRIMARY KEY (keyid)

Name	Definition
oauthusagedata_pkey	CREATE UNIQUE INDEX oauthusagedata_pkey ON public.oauthusagedata USING btree (keyid)

Related Articles
public.vwoauthusagedata
Description See OauthUsageData: Oauth Usage by Client ID per Day Table Definition CREATE VIEW vwoauthusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, oauthusagedata.organizationid, ...
public.vwsubuserusagedata
Description View containing usage data for sub-users, including HTTP status code counts Table Definition CREATE VIEW vwsubuserusagedata AS ( SELECT oauthusagedata.clientid, oauthusagedata.rowdate, oauthusagedata.clientname, ...
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...
public.participantattributesdynamic
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...
public.convvoicetopicdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true participant varchar(50) true ...