Clarity

 View Only
  • 1.  Timesheet Notes and Transaction Notes

    Posted Jun 26, 2019 03:46 AM

    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



  • 2.  RE: Timesheet Notes and Transaction Notes

    Posted Jun 26, 2019 07:13 AM
    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





  • 3.  RE: Timesheet Notes and Transaction Notes
    Best Answer

    Broadcom Employee
    Posted Jun 26, 2019 09:42 AM
    DWH ERD can be found here https://techdocs.broadcom.com/us/product-content/recommended-reading/product-related-technical-information/ca-ppm-advanced-reporting-and-database-schema-index.html?intcmp=searchresultclick&resultnum=1?intcmp=searchresultclick&resultnum=1

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 4.  RE: Timesheet Notes and Transaction Notes

    Broadcom Employee
    Posted Jun 26, 2019 09:46 AM
    Also in DWH you can use below 

    dwh_tme_entry
    dwh_tme_entry_ln
    dwh_tme_sheet
    dwh_tme_sheet_ln
    dwh_tme_sheet_note
    dwh_tme_entry_note
    dwh_tme_period

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 5.  RE: Timesheet Notes and Transaction Notes

    Posted Jun 26, 2019 12:32 PM
    If you do not have the required access for the ERD documentation it might be simpler to look at the database itself

    The timeentry DWH  tables that have note in their name have also note fields, the others not so much

    In addition the transaction table has a note field apparently corresponding to the PPA_WIP table in the PPM database



  • 6.  RE: Timesheet Notes and Transaction Notes

    Broadcom Employee
    Posted Jun 26, 2019 12:38 PM
    SAAS customers will not have direct access to database and cannot find tables also. Hence i shared the tabled details and the ERD site

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 7.  RE: Timesheet Notes and Transaction Notes

    Posted Jun 27, 2019 11:17 AM

    I see your point.

    To which version does the link which you provided go?
    Does the link work or does it go to ftp://ftp.ca.com which does not exist anymore
    Does it have
    dwh_tme_sheet_note
    dwh_tme_entry_note
    tables?
    I looked at the 15.3 version and could not find those tables.




  • 8.  RE: Timesheet Notes and Transaction Notes

    Posted Jul 02, 2019 03:32 AM

    Thank you all for the replies. We were looking for the field the timesheet notes were transferred to on the transaction, but from your replies I see that is not happening, so now we'll start looking at the joins needed to have the timesheets notes shown with the transactions in the reports.

    Thank you so much
    /Pia



    ------------------------------
    Pia Jeppesen
    Senior Specialist
    DSV A/S
    Denmark
    ------------------------------