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 |
|---|---|---|
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
|
GROUP_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
GROUP_UNIQUE_KEY |
VARCHAR2(50) |
VARCHAR(50) |
|
DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
|
VERSION |
NUMBER |
INT |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_ON |
DATE |
DATETIME |
|
CREATED_BY_USER_PK |
NUMBER |
INT |
|
MODIFIED_BY_USER_PK |
NUMBER |
INT |
WH_GROUP_FUNCTIONAL_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
|
FUNCTIONAL_OPERATION_IID |
NUMBER |
INT |
|
VERSION |
NUMBER |
INT |
|
APPLICATION_ID |
NUMBER |
INT |
|
CATEGORY_ID |
NUMBER |
INT |
|
OBJECT_ENTITY_CODE |
VARCHAR2(10) |
VARCHAR(10) |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
WH_GROUP_MEMBER
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
|
GROUP_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
USER_PRIMARY_KEY |
NUMBER |
INT |
|
USER_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
VERSION |
NUMBER |
INT |
WH_SYSTEM
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
SYSTEM_PRIMARY_KEY |
NUMBER |
INT |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_ON |
DATE |
DATETIME |
|
VERSION |
NUMBER |
INT |
|
CREATED_BY_USER_PK |
NUMBER |
INT |
|
MODIFIED_BY_USER_PK |
NUMBER |
INT |
|
WEBIPASSWORD |
VARCHAR2(250) |
VARCHAR(250) |
WH_USER
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
USER_PRIMARY_KEY |
NUMBER |
INT |
|
USER_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_PRIMARY_KEY |
NUMBER |
INT |
|
CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
USER_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
|
IS_USER_ACTIVE |
VARCHAR2(5) |
VARCHAR(5) |
|
IS_USER_LOCKED |
VARCHAR2(5) |
VARCHAR(5) |
|
DEFAULT_GROUP_PRIMARY_KEY |
NUMBER |
INT |
|
DEFAULT_GROUP_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
|
VERSION |
NUMBER |
INT |
|
WEBI_USERNAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_ON |
DATE |
DATETIME |
|
CREATED_BY_USER_PK |
NUMBER |
INT |
|
MODIFIED_BY_USER_PK |
NUMBER |
INT |
WH_USER_FUNCTIONAL_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
USER_PRIMARY_KEY |
NUMBER |
INT |
|
FUNCTIONAL_OPERATION_IID |
NUMBER |
INT |
|
VERSION |
NUMBER |
INT |
|
APPLICATION_ID |
NUMBER |
INT |
|
CATEGORY_ID |
NUMBER |
INT |
|
OBJECT_ENTITY_CODE |
VARCHAR2(10) |
VARCHAR(10) |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |