How to determine the date a transactions was created

Products

• 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