The USERPROFILE table stores information that has been entered on the Employee and Custom tabs for a user profile. This table is a child table to the USERINFO table.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USERID (PK)(FK) |
STANDARDID(12) |
NOT NULL |
USERPROFILE_USERID_PK (CA) |
(One) to (One) |
|
|
ASSETID |
STANDARDID(12) |
NULLS |
|
|
|
|
ASSETDESC |
varchar(64) |
NULLS |
|
|
|
|
HIREDATE |
datetime(8) |
NULLS |
|
|
|
|
BIRTHDATE |
datetime(8) |
NULLS |
|
|
|
|
SPOUSE |
varchar(64) |
NULLS |
|
|
|
|
SSN |
STANDARDID(12) |
NULLS |
|
|
|
|
EMPLOYEENUMBER |
STANDARDID(12) |
NULLS |
|
|
|
|
USERDATE1 |
datetime(8) |
NULLS |
|
|
|
|
USERDATE2 |
datetime(8) |
NULLS |
|
|
|
|
USERDATE3 |
datetime(8) |
NULLS |
|
|
|
|
USERDATE4 |
datetime(8) |
NULLS |
|
|
|
|
USERDATE5 |
datetime(8) |
NULLS |
|
|
|
|
USERTEXT1 |
varchar(255) |
NULLS |
|
|
|
|
USERTEXT2 |
varchar(255) |
NULLS |
|
|
|
|
USERTEXT3 |
varchar(255) |
NULLS |
|
|
|
|
USERTEXT4 |
varchar(255) |
NULLS |
|
|
|
|
USERTEXT5 |
varchar(255) |
NULLS |
|
|
|
|
USERNUM1 |
real(4) |
NULLS |
|
|
|
|
USERNUM2 |
real(4) |
NULLS |
|
|
|
|
USERNUM3 |
real(4) |
NULLS |
|
|
|
|
USERNUM4 |
real(4) |
NULLS |
|
|
|
|
USERNUM5 |
real(4) |
NULLS |
|
|
|
|
NOTES |
TEXTBLOB(16) |
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) |