Defines the set of statuses that can be assigned to Status attributes, supporting status-driven workflows. Only available when Edition is set to CustomerService, FieldService, Marketing, ProjectOperations, or Sales.

View-Specific Information

SELECT

The driver uses the Microsoft Dynamics 365 API to process WHERE clause conditions built with the following column and operators. The rest of the filter is executed client-side within the driver.

• TableName supports the = and IN operators.

For example, the following queries are processed server-side:

SELECT * FROM StatusAttributeOptions WHERE TableName = 'teams'

SELECT * FROM StatusAttributeOptions WHERE TableName IN ('accounts', 'teams')

To query this view, you must include a value for the TableName filter.

Columns

Name	Type	Description
ColumnName	String	The name of the column in the table where the status option is defined.
Color	String	The color code associated with the status option, typically used for visual representation in user interfaces.
ExternalValue	String	An external system value mapped to this status option, if applicable.
HasChanged	String	Indicates whether the status option has been modified since its creation or last update.
IsManaged	Boolean	Specifies if the status option is managed (part of a managed solution).
Label_LocalizedLabels	String	Localized labels for the status option in various supported languages.
Label_UserLocalizedLabel_HasChanged	String	Indicates if the user-customized label for the status option has been modified.
Label_UserLocalizedLabel_IsManaged	Boolean	Specifies if the user-customized label for the status option is managed (part of a managed solution).
Label_UserLocalizedLabel_Label	String	The user-customized label text for the status option.
Label_UserLocalizedLabel_LanguageCode	Integer	The language code corresponding to the user-customized label.
Label_UserLocalizedLabel_MetadataId	String	The unique identifier for the metadata associated with the user-customized label.
Description_LocalizedLabels	String	Localized descriptions for the status option in various supported languages.
Description_UserLocalizedLabel	String	The user-customized description for the status option, providing additional context or details.
MetadataId	String	The unique identifier for the metadata associated with the status option.
ParentValues	String	Specifies the parent values for hierarchical status options, if applicable.
State	Integer	The statecode value that this status option belongs to, indicating which state this status reason is valid for.
Value	Integer	The integer value associated with this status option, used for storage and retrieval.
TableName	String	The name of the table where this status option is defined.