Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 GROUPID varbinary The SID for this active directory group.
 LDAPQUERY nvarchar(4000)   Default = ''
 DISPLAYNAME nvarchar(255)   Default = ''
 SEARCHROOT nvarchar(1024)   Default = ''
 INCLUDESUBCONTAINERS bit   Default = 1 If true, will search through any subcontainers (groups) encountered.
 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.
 SECURITYMODECODE tinyint   Default = 0 0=All records, 1=Records with no site assigned, 2=Records with one of these sites assigned, 3=Records within a branch
 OVERWRITEEXISTINGSECURITY bit   Default = 0
 GROUPNAME nvarchar(128) (Computed) isnull(suser_sname([GROUPID]),isnull(DISPLAYNAME,'LDAP query')) The name of this active directory group.
 SECURITYMODE nvarchar(40) (Computed) CASE [SECURITYMODECODE] WHEN 0 THEN N'All records' WHEN 1 THEN N'Records with no site assigned' WHEN 2 THEN N'Records with one of these sites assigned' WHEN 3 THEN N'Records within a branch' END Provides a translation for the 'SECURITYMODECODE' field.
 CONSTITUENTSECURITYMODECODE tinyint   Default = 0 0=All records, 1=Records with no security group assigned, 2=Records with one of these security groups
 CONSTITUENTSECURITYMODE nvarchar(41) (Computed) CASE [CONSTITUENTSECURITYMODECODE] WHEN 0 THEN N'All records' WHEN 1 THEN N'Records with no security group assigned' WHEN 2 THEN N'Records with one of these security groups' END Provides a translation for the 'CONSTITUENTSECURITYMODECODE' field.

Foreign Key Field Type Null Notes Description
 SYSTEMROLEID uniqueidentifier   SYSTEMROLE.ID FK to SYSTEMROLE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BRANCHSITEID uniqueidentifier SITE.ID FK to SITE

Index Name Field(s) Unique Primary Clustered
 IX_SYSTEMROLEADGROUP_BRANCHSITEID BRANCHSITEID      
 IX_SYSTEMROLEADGROUP_DATEADDED DATEADDED    
 IX_SYSTEMROLEADGROUP_DATECHANGED DATECHANGED      
 PK_SYSTEMROLEADGROUP ID  
 UIX_SYSTEMROLEADGROUP_SYSTEMROLEID_DISPLAYNAME SYSTEMROLEID, DISPLAYNAME    

Trigger Name Description
 TR_SYSTEMROLEADGROUP_AUDIT_UPDATE
 TR_SYSTEMROLEADGROUP_AUDIT_DELETE

Referenced by Field
 SYSTEMROLEADGROUPCONSTITUENTSECURITY SYSTEMROLEADGROUPID
 SYSTEMROLEADGROUPSITE SYSTEMROLEADGROUPID

Entity-Relationship diagram of this table