Table of Contents
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. County__c > Region__c). |
| 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. |
DependentLabel | 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). |
