CSO_USER_INFORMATION
This table contains the properties of individual users.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_USER_INFORMATION_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ACTIVE | VARCHAR2 | 1 | Yes | A flag indicating if the user is active or has been locked out after 3 invalid login attempts. |
| ALIAS | VARCHAR2 | 100 | This is the user alias field for this record. | |
| BAN_UNTIL_DATE | TIMESTAMP | This is the date until this user will be banned. | ||
| BAN_USER | NUMBER | Flag that indicates this user has been banned. | ||
| DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
| DATE_MODIFIED | TIMESTAMP | Yes | This is the date that the record was modified. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| DEFAULT_SUB_SITE_ID | VARCHAR2 | 32 | This is the default View for a user. | |
| VARCHAR2 | 100 | The user's email address which must be unique within a repository. | ||
| FIRST_NAME | VARCHAR2 | 100 | This is the user's first name for this record. | |
| IS_DEFAULT_ADMINISTRATOR | VARCHAR2 | 1 | Flag indicating if the user is a default administrator for the repository. | |
| LAST_NAME | VARCHAR2 | 100 | This is the user's last name fo rthis record. | |
| LOCALE_ID | VARCHAR2 | 32 | The locale associated with the current record. | |
| LOGIN | VARCHAR2 | 100 | Yes | The unique user ID for the user in the repository. |
| LOOKUP_CODE_ID | VARCHAR2 | 32 | Deprecated. Reference to LOOKUP_CODE table. Contains the user preference for format of eMails sent. Valid values are AOL, HTML, and plain text. | |
| OWNER_SITE_ID | VARCHAR2 | 32 | Yes | This is the GUID for the repository or view the user belongs to |
| PDIT_CHALLENGE | VARCHAR2 | 100 | This is the PDIT challenge. | |
| PDIT_CHALLENGE_HINT | VARCHAR2 | 100 | This has been deprecated from the schema. | |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| RECEIVE_PERFORM | CHAR | 1 | Flag indicating if user should receive email notifications for tasks they can perform | |
| RECEIVE_ASSIGNED | CHAR | 1 | Flag indicating if user should receive email notifications for tasks they have been assigned. | |
| REPUTATION_POINTS | NUMBER | Reputation Points for this user. | ||
| SHOW_EMAIL | NUMBER | Flag to show or not email in web apps. | ||
| SHOW_NAME | NUMBER | Flag to show or not name in web apps. | ||
| SUBSCRIBE_ON_TOPIC_CREATION | CHAR | 1 | Flag indicating if InfoManager should auto-subscribe the user to the topics he creates. | |
| SUBSCRIBE_ON_TOPIC_REPLY | CHAR | 1 | Flag indicating if InfoManager should auto-subscribe the user to the topics he replies to | |
| ADMIN_USER | CHAR | 1 | Flag indicating if user is a Management Console user. | |
| USER_LEVEL | VARCHAR2 | 32 | This is the GUID for the reputation model the user belongs to | |
| USER_IMAGE | VARCHAR2 | 100 | Image name used for the user's avatar. | |
| SUBSCRIPTION_SCHEDULE | NUMBER | The subscription schedule this user is on. | ||
| REPORTING_USER_GROUP_ID | VARCHAR2 | 32 | The Reporting Group for a user. | |
| URL_TOKEN | VARCHAR2 | 32 | Time sensitive GUID used by URLs specific to the user. | |
| URL_TOKEN_EXPIRATION | TIMESTAMP | This is the expiration time for URLTOKEn. | ||
| LAST_CHANGED_PDIT_CHALLENGE | TIMESTAMP | Yes | Will record the date when the PDIT challenge was changed. | |
| EXTERNAL_ID | NUMBER | This is the comment for the column EXTERNAL_ID. | ||
| EXTERNAL_TYPE | VARCHAR2 | 100 | This is the comment for the column EXTERNAL_TYPE. | |
| TYPE_LOOKUP_CODE_ID | VARCHAR2 | 32 | With the introduction of integration users, we want a strongly typed column (lookup code ID) do determine which type the user is (console, web, or integration). | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_USER_INFORMATION | cso_site | DEFAULT_SUB_SITE_ID |
| CSO_USER_INFORMATION | cso_locale | LOCALE_ID |
| CSO_USER_INFORMATION | cso_lookup_code | LOOKUP_CODE_ID |
| CSO_USER_INFORMATION | cso_site | OWNER_SITE_ID |
| CSO_USER_INFORMATION | cso_tag | REPORTING_USER_GROUP_ID |
| CSO_USER_INFORMATION | cso_lookup_code | TYPE_LOOKUP_CODE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_USER_INFORMATION_N2 | Non Unique | Default | LOGIN |
| CSO_USER_INFORMATION_N3 | Non Unique | Default | LOCALE_ID |
| CSO_USER_INFORMATION_N4 | Non Unique | Default | LOOKUP_CODE_ID |
| CSO_USER_INFORMATION_N5 | Non Unique | Default | DEFAULT_SUB_SITE_ID |
| CSO_USER_INFORMATION_N6 | Non Unique | Default | REPORTING_USER_GROUP_ID |
| CSO_USER_INFORMATION_N7 | Non Unique | Default | ACTIVE, ADMIN_USER |
| CSO_USER_INFORMATION_N8 | Non Unique | Default | TYPE_LOOKUP_CODE_ID |
| CSO_USER_INFORMATION_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_USER_INFORMATION_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |
| CSO_USER_INFORMATION_UK1 | Unique | Default | OWNER_SITE_ID, LOGIN, EXTERNAL_TYPE, ORA_SEED_SET1 |
| CSO_USER_INFORMATION_UK11 | Unique | Default | OWNER_SITE_ID, LOGIN, EXTERNAL_TYPE, ORA_SEED_SET2 |
| CSO_USER_INFORMATION_UK2 | Unique | Default | LOWER("LOGIN"), EXTERNAL_TYPE, OWNER_SITE_ID, ORA_SEED_SET1 |
| CSO_USER_INFORMATION_UK21 | Unique | Default | LOWER("LOGIN"), EXTERNAL_TYPE, OWNER_SITE_ID, ORA_SEED_SET2 |