This table contains data that is specific to group constituents.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
GROUPTYPECODE
|
tinyint
|
false
|
|
Indicates the type of group. A group type of Custom indicates that GROUPTYPEID will point to a custom group type record in the GROUPTYPE table.
|
|
STARTDATE
|
datetime
|
true
|
|
The date of the group's inception
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
DESCRIPTION
|
nvarchar(300)
|
false
|
|
Provides a user-friendly description of the purpose of a group.
|
|
GROUPTYPE
|
nvarchar(9) (Computed)
|
true
|
|
Provides a translation for the 'GROUPTYPECODE' field.
|
