UserAgreementConsents
The agreement consents of the user.
View-Specific Information
SELECT
Reading data from this entity requires Read User Consent/agreements:read:userConsent permission.We recommend using the built-in Identity Data Admin role.
To execute SELECT statements on this entity, the UserId column must be specified in the criteria as shown in the examples below:
SELECT * FROM Administrators.UserAgreementConsents WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae';
SELECT * FROM Administrators.UserAgreementConsents WHERE UserId IN ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '4cbf5435-6c39-49f9-8c8f-cee7c1cd8a6b');
The server uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.
- UserId supports the following operators: =, IN.
All other filters are processed client-side within the server.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The agreement consent identifier (UUID). | |
| UserId | String | Users.Id | The identifier (UUID) of the user who consented to the agreement. |
| Status | String | The consent status of the agreement. Possible values are 'PENDING', 'ACCEPTED', 'REVOKED', 'EXPIRED', and 'AGREEMENT_DISABLED'. | |
| LastConsentGivenAt | Datetime | The time at which the user consented to the agreement. | |
| LastConsentExpiresAt | Datetime | The time at which the agreement consent expires. | |
| AgreementId | String | Agreements.Id | The identifier (UUID) of the agreement associated with this agreement consent. |
| AgreementName | String | The name of the agreement associated with this agreement consent. | |
| AgreementDescription | String | The description of the agreement associated with this agreement consent. | |
| AgreementLanguageId | String | The identifier (UUID) of the agreement language associated with this agreement consent. | |
| AgreementLanguageName | String | The name of the agreement language associated with this agreement consent. | |
| AgreementLanguageRevisionId | String | The identifier (UUID) of the agreement language revision associated with this agreement consent. |