System Table Definitions
System tables support the record security features of Data Warehouse. Normally your report will not query these tables directly, but will instead call database functions that use these tables. For more information, see Security and User Access.
Other tables that are related to security and are also related to a particular object type are grouped with the object type's tables. For example, the descriptions of WH_ACCOUNT_GROUP_ACCESS and WH_ACCCOUNT_USER_ACCESS can be found with the other Account tables, in the Account section.
The system tables include:
- WH_GROUP
- WH_GROUP_FUNCTIONAL_ACCESS
- WH_GROUP_MEMBER
- WH_SYSTEM
- WH_USER
- WH_USER_FUNCTIONAL_ACCESS
WH_GROUP
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
|
GROUP_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Group Name |
|
GROUP_UNIQUE_KEY |
VARCHAR2(50) |
VARCHAR(50) |
Group Unique Key |
|
DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Description |
|
VERSION |
NUMBER |
INT |
Version Number |
|
CREATED_ON |
DATE |
DATETIME |
Created On |
|
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
|
CREATED_BY_USER_PK |
NUMBER |
INT |
Created by User Primary Key |
|
MODIFIED_BY_USER_PK |
NUMBER |
INT |
Modified by User Primary Key |
WH_GROUP_FUNCTIONAL_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
|
FUNCTIONAL_OPERATION_IID |
NUMBER |
INT |
Functional Operation Identifier |
|
VERSION |
NUMBER |
INT |
Version Number |
|
APPLICATION_ID |
NUMBER |
INT |
Application Identifier |
|
CATEGORY_ID |
NUMBER |
INT |
Category Identifier |
|
OBJECT_ENTITY_CODE |
VARCHAR2(10) |
VARCHAR(10) |
Object Entity Code |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
Object Unique Code |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
Object is Embedded |
WH_GROUP_MEMBER
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
|
GROUP_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Group Name |
|
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
|
USER_NAME |
VARCHAR2(50) |
VARCHAR(50) |
User Name |
|
VERSION |
NUMBER |
INT |
Version Number |
WH_GROUP_GROUP_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
GROUP$_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
| ALLOW_DENY_IID | CHAR(1) | CHAR(1) | Allow Deny IID |
| IS_DELETE | NUMBER | INT | Is Deleted |
| IS_MANUAL | NUMBER | INT | Is Manual |
| IS_PERM | NUMBER | INT | Is Permanent |
| IS_READ | NUMBER | INT | Is Read |
| IS_UPDATE | NUMBER | INT | Is Updated |
|
VERSION |
NUMBER |
INT |
Version Number |
WH_GROUP_USER_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
GROUP$_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
|
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
| ALLOW_DENY_IID | CHAR(1) | CHAR(1) | Allow Deny IID |
| IS_DELETE | NUMBER | INT | Is Deleted |
| IS_MANUAL | NUMBER | INT | Is Manual |
| IS_PERM | NUMBER | INT | Is Permanent |
| IS_READ | NUMBER | INT | Is Read |
| IS_UPDATE | NUMBER | INT | Is Updated |
|
VERSION |
NUMBER |
INT |
Version Number |
WH_SYSTEM
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
SYSTEM_PRIMARY_KEY |
NUMBER |
INT |
System Primary Key |
|
CREATED_ON |
DATE |
DATETIME |
Created On |
|
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
|
VERSION |
NUMBER |
INT |
Version Number |
|
CREATED_BY_USER_PK |
NUMBER |
INT |
Created by User Primary Key |
|
MODIFIED_BY_USER_PK |
NUMBER |
INT |
Modified by User Primary Key |
|
WEBIPASSWORD |
VARCHAR2(250) |
VARCHAR(250) |
Web Password |
WH_SYSTEM_LOOKUP_ITEMS
| Column Name | Oracle Data Type | MSSQL Data Type | Friendly Name Column |
| ITEM_PRIMARY_KEY | NUMBER | INT | Item Primary Key |
| TABLE_UNIQUE_CODE | VARCHAR2(4) | VARCHAR(4) | Table Unique Code |
| ITEM_TREE_POSITION | VARCHAR2(250) | VARCHAR(250) | Item Tree Position |
| ITEM_IS_ACTIVE | VARCHAR2(10) | VARCHAR(10) | Item is Active |
| ITEM_NAME | VARCHAR2(4000) | VARCHAR(4000) | Item Name |
| LOCALE | VARCHAR2(5) | VARCHAR(5) | Locale |
| ITEM_NAME_FULL | VARCHAR2(4000) | VARCHAR(4000) | Item Name Full |
| ITEM_DISPLAY_ORDER | NUMBER | INT | Item Display Order |
| ITEM_PARENT_PRIMARY_KEY | NUMBER | INT | Item Parent Primary Key |
| ITEM_LEVEL_01 | VARCHAR2(4000) | VARCHAR(4000) | Item level 01 |
| ITEM_LEVEL_02 | VARCHAR2(4000) | VARCHAR(4000) | Item level 02 |
| ITEM_LEVEL_03 | VARCHAR2(4000) | VARCHAR(4000) | Item level 03 |
| ITEM_LEVEL_04 | VARCHAR2(4000) | VARCHAR(4000) | Item level 04 |
| ITEM_LEVEL_05 | VARCHAR2(4000) | VARCHAR(4000) | Item level 05 |
| ITEM_LEVEL_06 | VARCHAR2(4000) | VARCHAR(4000) | Item level 06 |
| ITEM_LEVEL_07 | VARCHAR2(4000) | VARCHAR(4000) | Item level 07 |
| ITEM_LEVEL_08 | VARCHAR2(4000) | VARCHAR(4000) | Item level 08 |
| ITEM_LEVEL_09 | VARCHAR2(4000) | VARCHAR(4000) | Item level 09 |
| ITEM_LEVEL_10 | VARCHAR2(4000) | VARCHAR(4000) | Item level 10 |
| OVERALL_DISPLAY_ORDER | VARCHAR2(250) | VARCHAR(250) | Overall Display Order |
WH_SYSTEM_LOOKUP_ITEMS_TEMP
| Column Name | Oracle Data Type | MSSQL Data Type | Friendly Name Column |
| ITEM_PRIMARY_KEY | NUMBER | INT | Item Primary Key |
| LOCALE | VARCHAR2(5) | VARCHAR(5) | Locale |
| TABLE_UNIQUE_CODE | VARCHAR2(4) | VARCHAR(4) | Table Unique Code |
| ITEM_DISPLAY_ORDER | NUMBER | INT | Item Display Order |
| ITEM_TREE_POSITION | VARCHAR2(250 CHAR) | VARCHAR(250) | Item Tree Position |
| ITEM_IS_ACTIVE | VARCHAR2(10 CHAR) | VARCHAR(10) | Item is Active |
| ITEM_PARENT_PRIMARY_KEY | NUMBER | INT | Item Parent Primary Key |
| ITEM_NAME | VARCHAR2(4000 CHAR) | VARCHAR(4000) | Item Name |
| ITEM_PK_C | VARCHAR2(20 CHAR) | VARCHAR(20) | Item Primary Key |
| ITEM_PARENT_PK_C | VARCHAR2(20 CHAR) | VARCHAR(20) | Item Parent Primary Key |
WH_USER
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
|
USER_NAME |
VARCHAR2(50) |
VARCHAR(50) |
User Name |
|
CONTACT_PRIMARY_KEY |
NUMBER |
INT |
Contact Primary Key |
|
CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Contact Type |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Contact First Name |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Contact Middle Name |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Contact Name |
|
USER_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
User Type |
|
IS_USER_ACTIVE |
VARCHAR2(5) |
VARCHAR(5) |
Is User Active |
|
IS_USER_LOCKED |
VARCHAR2(5) |
VARCHAR(5) |
Is User Locked |
|
DEFAULT_GROUP_PRIMARY_KEY |
NUMBER |
INT |
Default Group Primary Key |
|
DEFAULT_GROUP_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Default Group Name |
|
DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Description |
|
VERSION |
NUMBER |
INT |
Version Number |
|
WEBI_USERNAME |
VARCHAR2(250) |
VARCHAR(250) |
Web UserName |
|
CREATED_ON |
DATE |
DATETIME |
Created On |
|
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
|
CREATED_BY_USER_PK |
NUMBER |
INT |
Created by User Primary Key |
|
MODIFIED_BY_USER_PK |
NUMBER |
INT |
Modified by User Primary Key |
| LAST_LOGIN_ON | DATE | DATETIME | Last Login On |
| ACCOUNT_EXPIRES_ON | DATE | DATETIME | Account Expires On |
| AUTH_TYPE | VARCHAR2(10) | VARCHAR(10) | Aunthorization Type |
| NUMBER_OF_FAILED_ATTEMPTS | NUMBER | INT | Number of Failed Attempts |
| USER_PASSWORD_SAVED_DATE | DATE | DATETIME | User Password Saved Date |
| LAST_FAILED_ATTEMPT_ON | DATE | DATETIME | Last Failed Attempt On |
| BYPASS_SEARCH_LIMITS | VARCHAR2(5) | VARCHAR(5) | Bypass Search Limits |
| ACCOUNT_ACTIVE | VARCHAR2(5) | VARCHAR(5) | Account Active |
| IS_CHANGE_PWD_NEXT_LOGIN | VARCHAR2(5) | VARCHAR(5) | Is Change Password Next Login |
| LDAP_STATUS | VARCHAR2(75) | VARCHAR2(75) | LDAP Status |
WH_USER_FUNCTIONAL_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
|
FUNCTIONAL_OPERATION_IID |
NUMBER |
INT |
Functional Operation Id |
|
VERSION |
NUMBER |
INT |
Versio Number |
|
APPLICATION_ID |
NUMBER |
INT |
Application Identifier |
|
CATEGORY_ID |
NUMBER |
INT |
Cateory Identifier |
|
OBJECT_ENTITY_CODE |
VARCHAR2(10) |
VARCHAR(10) |
Object Entity Code |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
Object Unique Code |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
Object is Embedded |
WH_USER_GROUP_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
USER$_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
| ALLOW_DENY_IID | CHAR(1) | CHAR(1) | Allow Deny IID |
| IS_DELETE | NUMBER | INT | Is Delete |
| IS_MANUAL | NUMBER | INT | Is Manual |
| IS_PERM | NUMBER | INT | Is Perm |
| IS_READ | NUMBER | INT | Is Read |
| IS_UPDATE | NUMBER | INT | Is Update |
|
VERSION |
NUMBER |
INT |
Version Number |
WH_USER_USER_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
USER$_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
|
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
| ALLOW_DENY_IID | CHAR(1) | CHAR(1) | Allow Deny IID |
| IS_DELETE | NUMBER | INT | Is Delete |
| IS_MANUAL | NUMBER | INT | Is Manual |
| IS_PERM | NUMBER | INT | Is Perm |
| IS_READ | NUMBER | INT | Is Read |
| IS_UPDATE | NUMBER | INT | Is Update |
|
VERSION |
NUMBER |
INT |
Version Number |