StatusAttributeMetadata
Contains metadata for attributes of type Status, often used to track the lifecycle or current condition of an entity.
View-Specific Information
Select
Note that without filtering on TableName, the connector returns the results for the first table found.
The following examples show how to query the view for a specific table or list of tables:
SELECT * FROM StatusAttributeMetaData WHERE TableName='AccountLeads'
SELECT * FROM StatusAttributeMetaData WHERE TableName IN ('Account','AccountLead');
Columns
| Name | Type | References | Description |
| ColumnName [KEY] | String | The name of the column in the table where the status attribute is defined. | |
| MetadataId | String | The unique identifier for the metadata associated with this status attribute. | |
| OptionSet_Description_LocalizedLabels | String | Localized descriptions for the status options in various supported languages. | |
| OptionSet_Description_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized description label for the status options has been modified. | |
| OptionSet_Description_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized description label for the status options is managed (part of a managed solution). | |
| OptionSet_Description_UserLocalizedLabel_Label | String | The user-customized label text for the description of the status options. | |
| OptionSet_Description_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-customized description label. | |
| OptionSet_Description_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-customized description label. | |
| OptionSet_DisplayName_LocalizedLabels | String | Localized display names for the status options in various supported languages. | |
| OptionSet_DisplayName_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized display name label for the status options has been modified. | |
| OptionSet_DisplayName_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized display name label for the status options is managed (part of a managed solution). | |
| OptionSet_DisplayName_UserLocalizedLabel_Label | String | The user-customized label text for the display name of the status options. | |
| OptionSet_DisplayName_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-customized display name label. | |
| OptionSet_DisplayName_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-customized display name label. | |
| OptionSet_ExternalTypeName | String | The external type name associated with the status options, if applicable. | |
| OptionSet_HasChanged | String | Indicates whether the status option set has been modified since its creation or last update. | |
| OptionSet_IntroducedVersion | String | The version of the system in which the status option set was introduced. | |
| OptionSet_IsCustomizable_CanBeChanged | Boolean | Indicates whether the status option set can be customized by the user or administrators. | |
| OptionSet_IsCustomizable_ManagedPropertyLogicalName | String | The logical name of the managed property controlling the customizability of the status option set. | |
| OptionSet_IsCustomizable_Value | Boolean | Specifies if the status option set is customizable. | |
| OptionSet_IsCustomOptionSet | Boolean | Indicates whether the status option set is custom or part of a default configuration. | |
| OptionSet_IsGlobal | Boolean | Specifies if the status option set is global (shared across entities) or local (specific to one entity). | |
| OptionSet_IsManaged | Boolean | Indicates if the status option set is managed (part of a managed solution). | |
| OptionSet_MetadataId | String | The unique identifier for the metadata associated with the status option set. | |
| OptionSet_Name | String | The name of the status option set. | |
| OptionSet_OptionSetType | String | The type of the status option set (e.g., picklist, drop-down). | |
| OptionSet_ParentOptionSetName | String | The name of the parent option set, if this status option set is part of a hierarchy. | |
| TableName | String | The name of the table where this status attribute is defined. |