The USERSECURITY table stores information that has been entered on the General and Security tabs of a user profile. This table contains information for a user's access level, whether a user can create new teams, add or remove team members, Administrative roles assigned to user, and other details associated with security and general functions of Infor CRM.
The USERSECURITY table corresponds to the USER entity in the entity model.
| Field | Datatype (Length) | Allow Nulls | Indexes | Values | Relationship | Related Table and Field |
|---|---|---|---|---|---|---|
|
USERID (PK) (FK) |
STANDARDID(12) |
NOT NULL |
USERSECURITY_USERID_PK (CA) |
|
(One) to (Many) |
|
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (One) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (One) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (One) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
USERCODE |
varchar(30) |
NULLS |
USERSECURITY_USERCODE (IE) |
|
|
|
|
TYPE |
BOOLEAN(1) |
NULLS |
USERSECURITY_TYPE (IE) |
User Types: |
|
|
|
ACCESSLEVEL |
varchar(20) |
NULLS |
|
|
|
|
|
CLIENTLOGPTR |
STANDARDID(12) |
NULLS |
|
|
|
|
|
HOSTLOGPTR |
STANDARDID(12) |
NULLS |
|
|
|
|
|
LOGTHRESHOLD |
smallint(2) |
NULLS |
|
|
|
|
|
MANAGERID (FK) |
STANDARDID(12) |
NULLS |
|
|
(Many) to (One) |
USERSECURITY.USERID |
|
DEFAULTSECCODEID (FK) |
STANDARDID(12) |
NOT NULL |
USERSECURITY_DEFAULTSECCODEID (IE) |
|
(Many) to (One)* limited to 1:1 by application |
|
|
(One) to (One) |
||||||
|
ADDMEMBERS |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
DELMEMBERS |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
CREATETEAMS |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
ISMANAGER |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
FUNCTIONS |
varchar(255) |
NULLS |
|
|
|
|
|
ENABLED |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
PRIVATEACCOUNTID(FK) |
STANDARDID(12) |
NULLS |
|
|
(Many) to (One) |
USERSECURITY.USERID |
|
PRIMARYSITE (FK) |
STANDARDID(12) |
NULLS |
USERSECURITY_PRIMARYSITE (IE) |
|
(Many) to (One) |
|
|
LASTRNFILE |
int(4) |
NULLS |
|
|
|
|
|
LASTSENDDATE |
datetime(8) |
NULLS |
|
|
|
|
|
SECURITY |
DATABLOB |
NULLS |
|
|
|
|
|
USERPW |
varchar(128) |
NULLS |
|
|
|
|
|
SUPPORTUSER |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
ADMINROLE |
STANDARDID(12) |
NULLS |
|
|
|
|
|
USERTEMPLATE |
varchar(30) |
NULLS |
|
|
|
|
|
ISWEBADMIN |
char(1) |
NULLS |
|
|
|
|
|
CUSTOMERSERVICEUSER |
char(1) |
NULLS |
|
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
PWCHANGEDATE |
datetime(8) |
NULLS |
|
|
|
|
|
LOGINATTEMPTS |
smallint |
NULLS |
|
|
|
|
|
FAILEDATTEMPTDATE |
datetime(8) |
NULLS |
|
|
|
|
| PASSWORDRESETTOKEN | varchar(32) | NULLS | ||||
| TOKENEXPIRATION | datetime(8) | NULLS | ||||
|
FEDERATEDIDENTITY |
nvarchar(128) |
NULLS |
||||
|
ERPEXTID |
nvarchar(100) |
NULLS | ||||
|
ERPVARIATIONID |
nvarchar(22) |
NULLS | ||||
|
ERPLGICALID |
nvarchar(255) |
NULLS | ||||
|
ERPUNIQUEID |
nvarchar(377) |
NULLS | ||||
|
SYNCSTATUS |
nvarchar(64) |
NULLS | ||||
|
ERPSTATUS |
nvarchar(64) |
NULLS | ||||
|
ERPDISTINGUISHEDNAME |
nvarchar(256) |
NULLS |