The populations in the environment.

Table-Specific Information

We recommend using the built-in Client Application Developer role to read and write data for this table.

SELECT

Reading data from this table requires Read Population/dir:read:population permission.

The connector uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.

• Id supports the following operators: =, IN.

All other filters are processed client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM Administrators.Populations WHERE Id = '8bfe1f41-8dd3-4847-94ab-14f9344d8a81';
SELECT * FROM Administrators.Populations WHERE Id IN ('8bfe1f41-8dd3-4847-94ab-14f9344d8a81', '0277e170-eedb-4b04-ae0a-4f4ba63477fa');

INSERT

Creating data in this table requires Create Population/dir:create:population permission.

Refer to the query example below:

INSERT INTO Administrators.Populations (Name, Description, IsDefault) VALUES ('Population 1', 'Population 1', false);

UPDATE

Updating data in this table requires Update Population/dir:update:population permission.

Refer to the query example below:

UPDATE Administrators.Populations SET Description = 'My Population' WHERE Id = '8bfe1f41-8dd3-4847-94ab-14f9344d8a81'

DELETE

Deleting data from this table requires Delete Population/dir:delete:population permission.

Refer to the query example below:

DELETE FROM Administrators.Populations WHERE Id = 'ea6a22d3-e616-4fc7-835b-e898f5e49a96'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The population identifier (UUID).
Name	String	False		The name of the population.
Description	String	False		The population's description.
PasswordPolicyId	String	False	PasswordPolicies.Id	The password policy identifier (UUID) that is used for this population. If 'null' or empty, the environment's default password policy is used instead.
UserCount	Integer	True		The number of users that belong to the population.
IsDefault	Boolean	False		Boolean value indicating whether the population is the default population for the environment. Only one population per environment can be the default.
EnvironmentId	String	True	Information.Environments.Id	The identifier (UUID) of the environment in which the population exists.
CreatedAt	Datetime	True		The time at which the population was created.
UpdatedAt	Datetime	True		The time at which the population was last updated.