The USERINFO table stores information entered on the user profile tabs in the Administrator. One record is created for each user.
| 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) |