Contains data describing what system role an application user has been assigned.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
FROMROLESYNC
|
bit
|
false
|
|
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
SECURITYMODECODE
|
tinyint
|
false
|
|
0=All records, 1=Records with no site assigned, 2=Records with one of these sites assigned, 3=Records within a branch
|
|
CONSTITUENTSECURITYMODECODE
|
tinyint
|
false
|
|
0=All records, 1=Records with no security group assigned, 2=Records with one of these security groups
|
|
SECURITYMODE
|
nvarchar(40) (Computed)
|
true
|
|
Provides a translation for the 'SECURITYMODECODE' field.
|
|
CONSTITUENTSECURITYMODE
|
nvarchar(41) (Computed)
|
true
|
|
Provides a translation for the 'CONSTITUENTSECURITYMODECODE' field.
|
|
ACCOUNTINGELEMENTSECURITYMODECODE
|
tinyint
|
false
|
|
0=All records, 1=Allow use of records in selected groups, 2=Restrict use of records in selected groups
|
|
ACCOUNTINGELEMENTSECURITYMODE
|
nvarchar(42) (Computed)
|
true
|
|
Provides a translation for the 'ACCOUNTINGELEMENTSECURITYMODECODE' field.
|
