Process Action Items in Database

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Need to create a report on process action items and their status, what would be the tables to use?

Environment

All Supported Clarity Releases

Resolution

Use the below tables to include in your report, from Clarity transactional database: 

• BPM_RUN_STEPS
• BPM_RUN_STEP_ACTION_RESULTS
• BPM_RUN_PROCESSES
• BPM_RUN_ASSIGNEES
• BPM_RUN_ASSIGNEE_NOTES
• CAL_ACTION_ITEMS
• CAL_ACTION_ITEM_ASSIGNEES