Skip to main content
LinkedIn
Copied!

Table of Contents

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

Version:

Only available versions of this content are shown in the dropdown

If you have an Oracle database, 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, map the DateTime properties to TIMESTAMP columns.

Examples of DateTime properties include the following properties in the PR_DATA_IH_FACT interaction history table:

  • pxOutcomeTime
  • pxDecisionTime

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.

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

    ALTER TABLE pegadata.PR_DATA_IH_FACT MODIFY pxOutcomeTime TIMESTAMP

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

    ALTER TABLE pegadata.PR_DATA_IH_FACT MODIFY pxDecisionTime TIMESTAMP
    This change does not affect existing records.
Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us