Stores information about a group.
Columns
| Column Name
| Definition |
|---|
NAME_UPCASE |
- Function:
- The name of the group
in all uppercase letters.
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- No
- Primary Key:
- Yes
- Foreign Key:
- No
|
CREATED_BY |
- Function:
- The user who created the group.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
CREATED_DATE |
- Function:
- The date the group was created.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
DESCRIPTION |
- Function:
- A free text description for the group.
- Data Type:
- nvarchar
- Size:
- 2048
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
ENABLED |
- Function:
- Indicates whether the group is enabled.
- Values:
-
- Yes - The group is enabled.
- No - The group is disabled.
- Data Type:
- varchar
- Size:
- 3
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
LAST_MODIFIED_BY |
- Function:
- The user who last updated,
or modified, the group.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
LAST_MODIFIED_DATE |
- Function:
- The date the group was last modified.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
NAME |
- Function:
- The name of the group.
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
RESPONSIBLE_USER |
- Function:
- The user who is the group lead.
The group lead cannot be removed until the group is removed or a new group lead is assigned.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
SOURCE |
- Function:
- This column is not in use.
- Values:
- Null
- Data Type:
- nvarchar
- Size:
- 128
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
Relationships
| Table Name | Relationship |
|---|
| WF_GROUP_MEMBERS | 1:n |
| WF_REG_USERS | 1:1 |
