Clarity

  • 1.  Project Tasks - Associated Risks/Issues

    Posted Mar 25, 2019 01:49 AM

    I am trying to figure out the DB table(s) where I can fetch to identify associated risks/issues for a project task. Any references on this would be helpful.

     

    Thanks,

    Praneeth



  • 2.  Re: Project Tasks - Associated Risks/Issues
    Best Answer

    Posted Mar 25, 2019 05:23 AM

    The relationship is in ITL_OBJECT_ASSOCIATIONS

    (has a link to the RISK and to the TASK in it)

     

    ERD is here ; https://docops.ca.com/ca-ppm/15-6/en/reference/ca-ppm-entity-relationship-diagrams-erd#CAPPMEntityRelationshipDiagrams(E… 

    Schema description can be found (downloaded from) here ; CA PPM Advanced Reporting and Database Schema Index - CA Technologies