1. Administrator's Guide
  2. Working with Detailed Profitability
  3. Model Data Schema for Detailed Profitability
  4. Model Data Schema Table Structural Requirements

Model Data Schema Table Structural Requirements

To register a table from the Model Data Schema for use in a Detailed Profitability application, you must meet some requirements.

  • Database object names: Must be in upper case characters, and may include digits 0-9, and characters "_" and "$". Lower case and other special characters are not supported. If you have existing database object names using lower case or special characters, you can create views to rename table, view, and column names using allowable identifiers and then register the views instead of their underlying tables.

  • Destination Stage tables only: Must have a numeric column named "WORKING" (in upper case characters).

  • Destination Stage tables only: Must have a primary key constraint defined on it to enforce the uniqueness of the table.