Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
GROUPTYPECODE | tinyint | Default = 0 | 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 | The date of the group's inception | ||
DATEADDED | datetime | Default = getdate() | Indicates the date this record was added. | |
DATECHANGED | datetime | Default = getdate() | Indicates the date this record was last changed. | |
TS | timestamp | Timestamp. | ||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) | Numeric representation of the timestamp. | |
DESCRIPTION | nvarchar(300) | Default = '' | Provides a user-friendly description of the purpose of a group. | |
GROUPTYPE | nvarchar(9) (Computed) | CASE [GROUPTYPECODE] WHEN 0 THEN N'Household' WHEN 1 THEN N'Custom' END | Provides a translation for the 'GROUPTYPECODE' field. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
ID | uniqueidentifier | CONSTITUENT.LOCALID | Primary Key. | |
GROUPTYPEID | uniqueidentifier | GROUPTYPE.ID | Points to a custom group type definition in the GROUPTYPE table | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
NAMEFORMATFUNCTIONID | uniqueidentifier | NAMEFORMATFUNCTION.ID | The name format function which will be used to generate the household name if specified. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_GROUPDATA_DATEADDED | DATEADDED | |||
IX_GROUPDATA_DATECHANGED | DATECHANGED | |||
IX_GROUPDATA_ID | ID | |||
PK_GROUPDATA | ID |
Trigger Name | Description |
---|---|
TR_GROUPDATA_AUDIT_UPDATE | |
TR_GROUPDATA_AUDIT_DELETE | |
TR_GROUPDATA_MARKNONHOUSEHOLDASCONSTITUENT | |
TR_GROUPDATA_INSERT_HOUSEHOLD_UPDATE | |
TR_GROUPDATA_DELETE_HOUSEHOLD_UPDATE |
Referenced by | Field |
---|---|
GROUPGOAL | GROUPID |
TEAMEXTENSION | HOUSEHOLDID |