Skip to main content
Mitratech Success Center

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)

  • Was this article helpful?