Table Apm_Project_Stakeholders

Entity

Entity: Projects.Agile.ProjectStakeholders

Contains the stakeholders associated with projects and their project-management characteristics. Entity: Apm_Project_Stakeholders (Introduced in version 27.1.1.54)

Owner Tables Hierarchy

Apm_Projects

Summary

Name	Type	Description
Attitude	`tinyint` Allowed: `1`, `2`, `3`, `4`, `5`	Indicates the stakeholder’s current attitude toward the project.
Influence_Level	`tinyint` Allowed: `1`, `2`, `3`	Indicates the stakeholder’s ability to influence project decisions, execution or outcomes.
Interest_Level	`tinyint` Allowed: `1`, `2`, `3`	Indicates how strongly the stakeholder is interested in or affected by the project outcomes.
Is_Active	`bit`	Indicates whether the stakeholder is currently relevant to the project.
Notes	`nvarchar(max)`	Additional information or comments.
Project_Area_Id	`uniqueidentifier`	The project area for which the party is identified as a stakeholder. When not specified, the party is a stakeholder for the entire project.
Project_Id	`uniqueidentifier`	The project for which the party is identified as a stakeholder.
Project_Stakeholder_Id	`uniqueidentifier` `PK`
Row_Version	`timestamp`
Stakeholder_Party_Id	`uniqueidentifier`	The person or organization that is a stakeholder in the project.
Stakeholder_Role_Id	`uniqueidentifier`	The role of the stakeholder in the project or in the specified project area.

Columns

Attitude

Indicates the stakeholder’s current attitude toward the project.

Property	Value
Allowed Values	`1`, `2`, `3`, `4`, `5`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	7
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	tinyint (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Attitude - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Influence_Level

Indicates the stakeholder’s ability to influence project decisions, execution or outcomes.

Property	Value
Allowed Values	`1`, `2`, `3`
Auto Complete	no
Data Filter	no
Default Value	2
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	tinyint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Influence_Level - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Interest_Level

Indicates how strongly the stakeholder is interested in or affected by the project outcomes.

Property	Value
Allowed Values	`1`, `2`, `3`
Auto Complete	no
Data Filter	no
Default Value	2
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	tinyint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Interest_Level - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Is_Active

Indicates whether the stakeholder is currently relevant to the project.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	True
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	9
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Is_Active - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Notes

Additional information or comments.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2147483647
Order	8
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(max) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Notes - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Like	None	no	no

Project_Area_Id

The project area for which the party is identified as a stakeholder. When not specified, the party is a stakeholder for the entire project.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Apm_Project_Areas
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Project_Area_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Project_Id

The project for which the party is identified as a stakeholder.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	1
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Apm_Projects
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Project_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Project_Stakeholder_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Project_Stakeholder_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
GreaterThanOrLessThan	None	no	yes

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	10
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Stakeholder_Party_Id

The person or organization that is a stakeholder in the project.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Parties
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Stakeholder_Party_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Stakeholder_Role_Id

The role of the stakeholder in the project or in the specified project area.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Apm_Stakeholder_Roles
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Stakeholder_Role_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Table of Contents