Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 FROMROLESYNC bit   Default = 0
 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
 CONSTITUENTSECURITYMODECODE tinyint   Default = 0 0=All records, 1=Records with no security group assigned, 2=Records with one of these security groups
 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.
 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.
 ACCOUNTINGELEMENTSECURITYMODECODE tinyint   Default = 0 0=All records, 1=Allow use of records in selected groups, 2=Restrict use of records in selected groups
 ACCOUNTINGELEMENTSECURITYMODE nvarchar(42) (Computed) CASE [ACCOUNTINGELEMENTSECURITYMODECODE] WHEN 0 THEN N'All records' WHEN 1 THEN N'Allow use of records in selected groups' WHEN 2 THEN N'Restrict use of records in selected groups' END Provides a translation for the 'ACCOUNTINGELEMENTSECURITYMODECODE' field.

Foreign Key Field Type Null Notes Description
 SYSTEMROLEID uniqueidentifier   SYSTEMROLE.ID FK to SYSTEMROLE
 APPUSERID uniqueidentifier   APPUSER.ID FK to APPUSER
 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_SYSTEMROLEAPPUSER_APPUSERID APPUSERID      
 IX_SYSTEMROLEAPPUSER_BRANCHSITEID BRANCHSITEID      
 IX_SYSTEMROLEAPPUSER_DATEADDED DATEADDED    
 IX_SYSTEMROLEAPPUSER_DATECHANGED DATECHANGED      
 PK_SYSTEMROLEAPPUSER ID  
 UC_SYSTEMROLEAPPUSER_SYSTEMROLEID_APPUSERID APPUSERID, SYSTEMROLEID    
 UIX_SYSTEMROLEAPPUSER_SYSTEMROLEID_APPUSERID SYSTEMROLEID, APPUSERID    

Trigger Name Description
 TR_SYSTEMROLEAPPUSER_UPDATED
 TR_SYSTEMROLEAPPUSER_INSERTED
 TR_SYSTEMROLEAPPUSER_AUDIT_UPDATE
 TR_SYSTEMROLEAPPUSER_AUDIT_DELETE
 TR_SYSTEMROLEAPPUSER_AUDIT_ETLDELETEDID

Referenced by Field
 SITEPERMISSION SYSTEMROLEAPPUSERID
 SYSTEMROLEAPPUSERACCOUNTINGELEMENTSECURITY SYSTEMROLEAPPUSERID
 SYSTEMROLEAPPUSERCONSTITUENTSECURITY SYSTEMROLEAPPUSERID
 SYSTEMROLEAPPUSERSITE SYSTEMROLEAPPUSERID

Entity-Relationship diagram of this table