rs_users
The following table lists the columns for the rs_users view. The equivalent jcs_users view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| ID | NUMBER | The unique id of a Redwood user |
| VERSION | NUMBER | The version number of a Redwood user |
| DESCRIPTION | VARCHAR2 | The description of a Redwood user |
| COMMENT_TEXT | VARCHAR2 | Comment describing the Redwood user |
| USERNAME | VARCHAR2 | Username (must be known in Oracle as well) |
| CREATION_DATE | TIMESTAMP WITH TIME ZONE | Time of creationThe timezone is specified as an Olson name. |
| LASTMODIFICATION | TIMESTAMP WITH TIME ZONE | Time of last modificationThe timezone is specified as an Olson name. |
| ORACLE_TYPE | VARCHAR2 | Whether this is an Oracle USER or ROLE (null if it is not known) |
| EMAIL_ACCOUNT | VARCHAR2 | E-mail account |
| DEFAULT_PRINTER_NAME | VARCHAR2 | Default printer |
| ACCOUNTID | VARCHAR2 | Oracle username |
| ADDRESS | VARCHAR2 | E-mail account |
| FIRSTNAME | VARCHAR2 | First name of this user |
| LASTNAME | VARCHAR2 | Last name of this user |
| COMPANY | VARCHAR2 | Company where this user is employed |
| PHONE | VARCHAR2 | Phone number of this user |
| FAX | VARCHAR2 | Fax number of this user |
| ADDRESS1 | VARCHAR2 | First address line of this user |
| ADDRESS2 | VARCHAR2 | Second address line of this user |
| CITY | VARCHAR2 | City where this user is living |
| COUNTRY | VARCHAR2 | Country where this user is living |
| STATE | VARCHAR2 | State where this user is living |
| ZIP | VARCHAR2 | ZIP code of this user |
| BRANCH | VARCHAR2 | Branch for this user |
| DEPARTMENT | VARCHAR2 | Department for this user |
| NETWORKPRINTER | VARCHAR2 | Default printer |
| PRINTOPTIONS | VARCHAR2 | Printer options |
| ALLOWATTACHMENTS | VARCHAR2 | Is this user allowed to attach files to email |
| ALLOWEMAIL | VARCHAR2 | Is this user allowed to use email |
| WELCOMESCREENINFORMATION | VARCHAR2 | Information shown on the welcome screen |
| DISABLED | VARCHAR2 | Is this user disabled |
note
VERSION: Version is not increased with one anymore after changing the object.
note
ORACLE_TYPE: Although the column is called Oracle type, it does not mean an Oracle user does exist with this name.
plsqlTopic
onsiteTopic