Operational Data Store Schema Reference

Back Next

DX_ODS_USER_ACCESS Table

The DX_ODS_USER_ACCESS table contains information about

B2B Data Exchange

users and the access level to events that the Dashboard panels display in the Operation Console.

The following table describes the columns and data types of the DX_ODS_USER_ACCESS table:

Column Name	data type	Description
USER_ID*	NUMBERPS(19,0), NOT NULL	Unique identifier for the Operation Console user that can view specific information from the operational data store in Dashboard panels. The identifier is generated and does not represent the login name for the user.
ACCESS_ID*	NUMBERPS(19,0), NOT NULL	Unique identifier for the Operation Console access role.
* Primary key.