Per-user license assignments from Genesys Cloud. Tracks which licenses are assigned to each user including Copilot license status.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| 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 | |||
| 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 |
| Name | Type | Definition |
|---|---|---|
| subuserlicensedata_pkey | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition | Comment |
|---|---|---|
| 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 |