How to determine the date a transactions was created

book

Article ID: 143171

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

I am looking for a way either in the Clarity app, or via a query to determine the actual date a transaction was created/entered in the system. 

Environment

Release : All Supported Releases

Component : CA PPM APPLICATION

Resolution

  1. Query that can be used: select * From PPA_Transcontrol
  2. Field from table that shows the date it was created "Entrydate"

Additional Information

See: Clarity PPM Advanced Reporting and Database Schema Index for more details on help in finding table and field definitions

See KB 21999 - for more information on transactions and when they move to the PPA_Transcontrol table

See KB 141061 - How to search for known Clarity PPM Issues using Self Service