---
title: Metadata Picklist by Dependency
description: "Table of Contents - [Dependent Picklist Metadata (from the Metadata API)](#dependent-picklist-metadata-from-the-metadata-api) - [Parameters](#parameters) - [Example of Use - All](#example-of-use--all) - [Example of Use - Single](#example-of-use--single) - [ss_SysPicklistDep table](#sssyspicklistdep-table) ## **Dependent Picklist Metadata (from the Metadata API)** Pull dependent Picklist mappings…"
url: "https://sql-sales.com/docs/metadata-picklist-by-dependency/"
updated: "2026-08-31"
category: Metadata
---

# Metadata Picklist by Dependency

Table of Contents

- [Dependent Picklist Metadata (from the Metadata API)](#dependent-picklist-metadata-from-the-metadata-api)
- [Parameters](#parameters)
- [Example of Use - All](#example-of-use--all)
- [Example of Use - Single](#example-of-use--single)
- [ss_SysPicklistDep table](#sssyspicklistdep-table)

## **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). |