The USERINFO table stores information entered on the user profile tabs in the Administrator. One record is created for each user. This table corresponds to the User entity in the Entity Model.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USERID (PK) |
STANDARDID (12) |
NOT NULL |
USERINFO_USERID_PK (CA) |
(One) to (Many) |
<any table>.CREATEUSER
|
|
(One) to (Many) |
<any table>.MODIFYUSER |
||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
TITLE |
varchar(32) |
NULLS |
|
|
|
|
USERNAME |
varchar(64) |
NULLS |
USERINFO_USERNAME (IE) |
|
|
|
REGION |
varchar(32) |
NULLS |
|
|
|
|
DIVISION |
varchar(32) |
NULLS |
|
|
|
|
DEPARTMENT |
varchar(32) |
NULLS |
|
|
|
|
|
varchar(128) |
NULLS |
|
|
|
|
PHONE |
varchar(32) |
NULLS |
|
|
|
|
DIRECT |
varchar(32) |
NULLS |
|
|
|
|
HOME |
varchar(32) |
NULLS |
|
|
|
|
FAX |
varchar(32) |
NULLS |
|
|
|
|
MOBILE |
varchar(32) |
NULLS |
|
|
|
|
PINNUMBER |
varchar(32) |
NULLS |
|
|
|
|
PAGERTERM |
varchar(32) |
NULLS |
|
|
|
|
ADDRESSID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
HOMEADDRESSID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ALTADDRESSID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
LASTNAME |
varchar(32) |
NULLS |
|
|
|
|
FIRSTNAME |
varchar(32) |
NULLS |
|
|
|
|
MIDDLENAME |
varchar(32) |
NULLS |
|
|
|
|
PREFIX |
varchar(16) |
NULLS |
|
|
|
|
SUFFIX |
varchar(16) |
NULLS |
|
|
|
|
ACCOUNTINGUSERID |
varchar(512) |
NULLS |
|
|
|
|
AVAILABLE |
char(1) |
NULLS |
|
|
|
|
DEFAULTADDKNOWLEDGE |
char(1) |
NULLS |
|
|
|
|
DEFECTNOTIFY |
char(1) |
NULLS |
|
|
|
|
TICKETNOTIFY |
char(1) |
NULLS |
|
|
|
|
PAGERMESSAGELENGTH |
float(8) |
NULLS |
|
|
|
|
USERCOMPANY |
varchar(128) |
NULLS |
|
|
|
|
TIMEZONE |
varchar(64) |
NULLS |
|
|
|
|
WINDOWSSID |
varchar(255) |
NULLS |
|
|
|
|
USEWINDOWSAUTH |
char(1) |
NULLS |
|
|
|
|
SPEEDSEARCHAPPROVAL |
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) |
|
| ERPEXTID | nvarchar |
NULLS |
|||
| ERPVARIATIONID | nvarchar |
NULLS |
|||
| ERPLOGICALID | nvarchar |
NULLS |
|||
| ERPUNIQUEID | nvarchar |
NULLS |