public.subuserlicensedata
Description
Per-user license assignments from Genesys Cloud. Tracks which
licenses are assigned to each user including Copilot license status.
Columns
| keyid |
varchar(255) |
|
false |
|
|
Unique identifier:
{userId}{licenseId}{assignmentDateYYYYMMDD} |
| userid |
varchar(50) |
|
false |
|
|
Genesys Cloud user GUID |
| username |
varchar(255) |
|
true |
|
|
User display name from license response |
| email |
varchar(255) |
|
true |
|
|
User email address |
| licenseid |
varchar(100) |
|
true |
|
|
Genesys Cloud license GUID |
| licensename |
varchar(100) |
|
true |
|
|
License display name (e.g., CX1, Copilot) |
| licensetype |
varchar(100) |
|
true |
|
|
License type category |
| licenseassignmentdate |
timestamp without time zone |
|
true |
|
|
Date the license was assigned to the user |
| licenseremovaldate |
timestamp without time zone |
|
true |
|
|
Date the license was removed (NULL if still active) |
| licenseactive |
boolean |
|
true |
|
|
Whether the license is currently active |
| copilotlicense |
boolean |
|
true |
|
|
TRUE if this is a Copilot license (detected by name/type containing
Copilot) |
| divisionid |
varchar(50) |
|
true |
|
|
Genesys Cloud division GUID |
| updated |
timestamp without time zone |
|
true |
|
|
Timestamp when this record was last synced |
Constraints
| subuserlicensedata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| subuserlicensedata_pkey |
CREATE UNIQUE INDEX subuserlicensedata_pkey ON
public.subuserlicensedata USING btree (keyid) |
|
| subuserlicensedata_userid_idx |
CREATE INDEX subuserlicensedata_userid_idx ON
public.subuserlicensedata USING btree (userid) |
Index for user-based license lookups |
| subuserlicensedata_copilot_idx |
CREATE INDEX subuserlicensedata_copilot_idx ON
public.subuserlicensedata USING btree (copilotlicense,
licenseactive) |
Composite index for Copilot license queries |
| subuserlicensedata_licensetype_idx |
CREATE INDEX subuserlicensedata_licensetype_idx ON
public.subuserlicensedata USING btree (licensetype) |
Index for license type filtering |
| subuserlicensedata_active_idx |
CREATE INDEX subuserlicensedata_active_idx ON
public.subuserlicensedata USING btree (licenseactive) |
Index for active license filtering |
Related Articles
public.vwcopilotlicensedusers
Description Users with active Copilot licenses Table Definition CREATE VIEW vwcopilotlicensedusers AS ( SELECT l.userid, l.username, l.email, l.licenseid, l.licensename, l.licensetype, l.licenseassignmentdate, l.divisionid, l.updated, ud.name AS ...
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, ...
public.vwlicensecountsbytype
Description Aggregate license counts by license type Table Definition CREATE VIEW vwlicensecountsbytype AS ( SELECT l.licensename, l.licensetype, count(DISTINCT l.userid) AS totalusers, sum( CASE WHEN (l.licenseactive = true) THEN 1 ELSE 0 END) AS ...
public.evalquestiondata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...
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 ...