Recent Articles
CSI - Customer Hosted Deployment Requirements
Overview Document Purpose: This document outlines the infrastructure and configuration requirements for deploying the CSI (Genesys Cloud Data Adapter) platform in a customer-hosted environment. The platform synchronises Genesys Cloud operational and ...
public.vwplanninggroupbusinessunit
Description Convenience view joining planning groups to their business units Table Definition CREATE VIEW vwplanninggroupbusinessunit AS ( SELECT pg.id AS planninggroupid, pg.name AS planninggroupname, pg.businessunitid AS ...
public.vwoauthusagedetaileddata
Description Table Definition CREATE VIEW vwoauthusagedetaileddata AS ( SELECT oauthusagedetaileddata.clientid, oauthusagedetaileddata.rowdate, oauthusagedetaileddata.clientname, oauthusagedetaileddata.organizationid, oauthusagedetaileddata.userid, ...
public.oauthusagedetaileddata
Description Detailed OAuth usage by client, endpoint and HTTP method per day Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false Primary Key clientid varchar(50) true OAuth Client GUID rowdate timestamp without time ...
public.vwsubuserlicensedata
Description Subscription user license data with user details Table Definition CREATE VIEW vwsubuserlicensedata AS ( SELECT l.keyid, l.userid, l.username AS licensedusername, l.email AS licensedemail, l.licenseid, l.licensename, l.licensetype, ...