Contains predefined picklist values for fields across different Salesforce objects.

View-Specific Information

SELECT

TableName should be specified in the WHERE clause. RecordTypeId may also be specified along TableName to only retrieve data for a specific record type.

SELECT * FROM PickListValues WHERE TableName = 'Account'

SELECT * FROM PickListValues WHERE TableName = 'Account' AND RecordTypeId = '0121W000000cq9EDAL'

Columns

Name	Type	References	Description
ID [KEY]	String		A unique identifier for the picklist value, formatted as ColumnName|Picklist_Value.
TableName	String		The name of the Salesforce object (table) associated with the picklist. Required when retrieving picklist data.
ColumnName	String		The name of the column that the picklist is associated with. Optionally used to filter results to a specific column.
PickList_Value	String		The internal value stored in Salesforce for this picklist entry.
PickList_Label	String		The user-friendly label displayed in the Salesforce UI for the picklist value.
PickList_IsActive	Boolean		Indicates whether the picklist value is currently active and available for selection.
PickList_IsDefault	Boolean		Indicates whether this picklist value is set as the default for its associated column.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
RecordTypeId	String		Optional identifier for the record type. Use this to return picklist values specific to a particular record type.