Review Unifier Database Table Structure

Before building your SQL statement, review the Unifier database table structure.

You can find the Unifier database table name in two ways:

  1. Using Entity Reference (ER) Views
    1. Sign in to Unifier as a Company Administrator and go to the Company tab (Company Workspace), ensure that you are in Administration mode > Data Structure Setup > ER Views.
    2. Open Business Processes View.
    3. Use your browser search function and search for a BP you want to report against (for example, Invoices).
    4. The name of the table appears under the BP Name, in blue (for example, UNIFIER_UI. The word "unifier" is the prefix and common to all BP tables. The UI is the ID of the Invoices BP).
  2. Using BP IDs
    1. Sign in to Unifier as a Company Administrator and go to the Company tab (Company Workspace), ensure that you are in Administration mode > uDesigner > Business Processes.
    2. Locate the BPs that you want to use in the report and find the IDs (first column).
    3. Add your deployment prefix and add an underscore ( _ ) to get the table name (for example, UNIFIER_UI).

      Note: To access the Line Items of a BP, add _LINEITEM to the table name (for example, UNIFIER_UI_LINEITEM).

The following lists the column names:

Related Topics

Creating a Custom Report in Primavera Unifier

Download and Install BI Publisher Desktop for Microsoft Office

Connect to Unifier Database

Writing Your First Statement

Adding Line Items

Creating a New Custom Report

Building Report Template

Creating a Report with Line Items

Advanced BI Publisher Functions

Search Parameters and Additional Parameters



Legal Notices
Copyright © 2016, 2018, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, March 28, 2018