Table Prd_Workgroups

Entity

Entity: Production.Resources.Workgroups

Production workgroups. Entity: Prd_Workgroups

Summary

Name	Type	Description
Active	bit	Indicates whether the current workgroup is active.
Cost_Currency	nvarchar(3)	Not used.
Full_Path	nvarchar(254)	The full path to the current node, represented with slash ('/') as leading, trailing and separator character. Example: '/rootnode/subnode/'.
Id	uniqueidentifier PK	Unique workgroup auto-generated Id
Notes	nvarchar(254)	User notes for the workgroup
Parent	nvarchar(255)	Path-like parent workgroup name
Row_Version	timestamp
Workgroup_Name	nvarchar(64)	Name of the workgroup

Columns

Active

Indicates whether the current workgroup is active.

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	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	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Active - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	True	no	no

Cost_Currency

Not used.

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	3
Order	4
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(3) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Full_Path

The full path to the current node, represented with slash ('/') as leading, trailing and separator character. Example: '/rootnode/subnode/'.

Property	Value
Auto Complete	no
Data Filter	no
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	3
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(254) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Full_Path - Supported Filters

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

Id

Unique workgroup auto-generated 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

Id - Supported Filters

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

Notes

User notes for the workgroup

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
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	nvarchar(254) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Parent

Path-like parent workgroup name

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

Parent - Supported Filters

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

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	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	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Workgroup_Name

Name of the workgroup

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	64
Order	2
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(64)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Workgroup_Name - Supported Filters

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