| uid |
INTEGER |
|
| userid |
VARCHAR(128) |
User name |
| passwd |
VARCHAR(128) |
User's password |
| description |
VARCHAR(120) |
Description of user |
| admin |
SMALLINT |
User type and authority |
| last_update |
BIGINT (Db2®, SQL Server), INT (Oracle) |
Date password last set |
| pid |
INTEGER |
Default printer identifier |
| acct_info |
VARCHAR(60) |
User-defined accounting information |
| name |
VARCHAR(60) |
User's name |
| company |
VARCHAR(60) |
User's organization |
| title |
VARCHAR(60) |
User's title |
| addr1 |
VARCHAR(60) |
User's address |
| addr2 |
VARCHAR(60) |
User's address |
| addr3 |
VARCHAR(60) |
User's address |
| addr4 |
VARCHAR(60) |
User's address |
| dept |
VARCHAR(60) |
User's department |
| building |
VARCHAR(60) |
User's building or location |
| room |
VARCHAR(60) |
User's office or room |
| phone |
VARCHAR(32) |
User's phone number |
| fax |
VARCHAR(32) |
User's fax number |
| cover_page |
VARCHAR(60) |
Default fax cover page |
| time_out |
BIGINT (Db2, SQL Server), INT (Oracle) |
User's inactivity timeout value |
| email |
VARCHAR(254) |
User's e-mail address |
| upd_userid |
VARCHAR(128) |
Userid of last user to update user |
| upd_date |
BIGINT (Db2, SQL Server), INT (Oracle) |
Date and time user was last
updated (in old style) |
| passwd_exp |
INTEGER |
Password expiration |
| uclass |
VARCHAR(1) |
Printer class value |
| banner |
VARCHAR(1) |
Printer banner |
| dest |
VARCHAR(8) |
Printer dest value |
| node |
VARCHAR(8) |
The system name |
| writer |
VARCHAR(8) |
Printer writer value |
| pagedef |
VARCHAR(8) |
Printer PageDef |
| formdef |
VARCHAR(8) |
Printer FormDef |
| forms |
VARCHAR(8) |
Printer Forms |
| routing |
VARCHAR(24) |
Printer routing field |
| misc390 |
VARCHAR(254) |
Reserved for future use |
| upd_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Date and time user was last
updated |
| failed_logins |
INTEGER |
Number of failed logins |
| last_login_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Date and time user logged into Content
Manager OnDemand |
| last_pw_chng_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Date and time user changed
the password |
| prev_pwd2 |
VARCHAR(128) |
Password previous to current
password |
| prev_pwd3 |
VARCHAR(128) |
Password previous to prev_pwd2 |
| prev_pwd4 |
VARCHAR(128) |
Password previous to prev_pwd3 |
| prev_pwd5 |
VARCHAR(128) |
Password previous to prev_pwd4 |
| prev_pwd6 |
VARCHAR(128) |
Password previous to prev_pwd5 |
| prev_pwd7 |
VARCHAR(128) |
Password previous to prev_pwd6 |
| prev_pwd8 |
VARCHAR(128) |
Password previous to prev_pwd7 |
| prev_pwd9 |
VARCHAR(128) |
Password previous to prev_pwd8 |
| prev_pwd10 |
VARCHAR(128) |
Password previous to prev_pwd9 |
| lockout_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Date and time user was locked
out of OnDemand |
| last_action_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Date and time user performed
the most recent action |