Creating Import Database Tables

The following tables are available in the Staging Database:

Stages (HPM_STG_STAGE)
POVs (HPM_STG_POV)
Drivers (HPM_STG_DRIVER)
Driver selections (HPM_STG_DRIVER_SELECTION)
Assignments (HPM_STG_ASSIGNMENT)
Assignment Rules (HPM_STG_ASGN_RULE_SELECTION)

Staging database scripts are available for MS SQL Server and Oracle Database. You can create a database and use the create_staging.sql script to create tables.

To create staging tables:

Create a database.
Locate create_staging.sql in the default location for your database type:
- EPM_ORACLE_HOME/products/Profitability/database/Common/MSSQLServer
- EPM_ORACLE_HOME/products/Profitability/database/Common/Oracle 2
Run create_staging.sql.