Maybe this will help you maybe not
The ERD in the old tech ref is
The timeentry notes are processed further like this
IMP_TRANSACTIONIMPORT
NOTES VARCHAR : NULL Any notes for the transaction.
PPA_TRANSCONTROL
NOTES VARCHAR : NULL Any comments by the user who entered the transaction.
PPA_WIP
NOTES VARCHAR : NULL Any comments by the user who entered the transaction.
I do not know where the PPM and DWH ERD's are now and do not have the access to search for them. The closest I can get is
Search Results - CA PPM - 15.6.1 - CA Technologies Documentation
(That is a link)
PMO Reports: PPM Schema
The PPM Schema report displays the columns of tables and views in the schema. The report includes the column data types, nulls constraints and comments. The report is grouped by the database table or view. The following image displays the PPM Schema report with table
PMO Reports: Data Warehouse Schema
The Data Warehouse Schema report displays the columns of tables and views in the Data Warehouse (DWH) schema. The report includes … the Data Warehouse Schema report with columns and comments. data_warehouse_schema.png Report Prerequisites Verify that you have completed
Original Message:
Sent: 06-26-2019 03:32 AM
From: Pia Jeppesen
Subject: Timesheet Notes and Transaction Notes
Hi all,
I'm trying to find documentation of where the timesheets notes can be seen on transactions, and also what transaction notes are supposed to contain, can anyone assist or direct me to any documentation on it?
We are trying to use JasperSoft reporting to extract only posted transaction, however the notes put on the timesheets are also needed, why I now have to figure out the connections.
/Pia