Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Modifying column definitions to use the TIMESTAMP data type in an Oracle database

Updated on June 20, 2022

This content applies only to Pega Cloud environments

If you have an Oracle database and you use materialized interaction history summaries, modify the column definitions for DateTime properties to use the TIMESTAMP data type.

TIMESTAMP columns provide high-precision time to track customer responses by milliseconds. To store records with greater precision and to avoid duplicate data issues that might occur when you use DATE data type columns, convert the DateTime properties to make them map to TIMESTAMP columns.

Examples of DateTime properties include the following properties in the PR_DATA_IH_FACTinteraction history table:

  • pxOutcomeTime
  • pxDecisionTime
Pega Customer Decision Hub Update Guide
The Oracle database administrator performs this task.
  1. Connect to the Pega Platform database.
  2. Modify the column definition for a DateTime property by running the following ALTER script on the database:
    ALTER TABLE <Schema_Name>.<Table_Name> MODIFY <Column_Name> TIMESTAMP
    where:<Schema_Name> is the name of the schema that contains the table.<Table_Name> is the name of the table that you want to modify.<Column_Name> is the name of the column whose definition you want to modify.
    Note: For the columns where you modify the column definition, check if the columns are used for table partitioning.
    For example:

    To update the column definition for the pxOutcomeTime property in the PR_DATA_IH_FACT table, run the following script:


    To update the column definition for the pxDecisionTime property in the PR_DATA_IH_FACT, run the following script:

    Result: This change does not affect existing records.
  3. Save the underlying Data-Decision-IH-Fact Database Table rule.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us