Dependent Picklist Metadata (from the Metadata API)
Pull dependent Picklist mappings by Record Type, including controlling field hierarchy, controlling values, dependent values, and internal dependency indexes, per Object or for a specified Object.
Results are loaded to table ss_SysPicklistDep
Parameters
Parameter | Purpose |
@ObjectName | Salesforce Object Name (for example Account). alternatively pass "All" to retrieve all Objects. |
@Env | SQL Sales Environment Name, see Setup |
@Special1 | Future use, not currently used |
@Special2 | Future use, not currently used |
Example of Use - All
exec ss_MetaPickDep 'DEMO', 'All'
Example of Use - Single
exec ss_MetaPickDep 'DEMO', 'Account'
ss_SysPicklistDep table
Column Name | Purpose |
ObjectName | The Salesforce object the picklist field belongs to (e.g. Account, Opportunity). |
RecordTypeId | Unique Salesforce ID of the Record Type the picklist values apply to. |
RecordTypeName | Name of the Record Type (e.g. Master, Customer, Partner). |
FieldName | API name of the picklist field |
ControllingField | Immediate controlling field (parent) if the picklist is dependent; NULL if not dependent. |
ControllingFields | Full hierarchy of controlling fields (from immediate parent upwards), shown as a chain (e.g. |
ControllerIndex | Internal index assigned to controlling field values, used by Salesforce to map dependencies. |
ControllingValue | Controlling picklist value that permits the dependent value. |
DependentValue | API value of the dependent picklist option. |
| Display label shown to users for the dependent picklist value. |
ValidFor | List of controlling value indexes that this picklist value is valid for (used to define dependency mappings). |
DependentActive | Whether the dependent picklist value is active (1 = active, 0 = inactive). |
DependentDefaultValue | Whether the dependent picklist value is the default (1 = default, 0 = not default). |