Retrieve employee assigment info from flow process BI Report

Summary:

Retrieve employee assigment info from flow process

Content (required):

Hi everyone,

I have a requirement which is to obtain information from employees with a BI report when they execute a flow process.

The test process I am using returns 1961 rows I have the following query:

The person_id count is correct, but when I try to fetch information from the assignment the count changes, this is the query:

WITH ARCHIVE

   AS (SELECT prd.person_id,

        PA.effective_date

     FROM  fusion.pay_payroll_rel_actions RA,

        fusion.pay_payroll_actions PA,

        fusion.pay_requests PR,

        fusion.pay_flow_instances FI,