Thanks Craig - I've posted a feature request, to include the job assignment ID numbers in the appraisal status report. If this is addressed this will solve one issue for the client.
The bigger issue is that all job assignment data, i.e. every manager, job titles etc, is returned against each appraisal for the users with 2+ job assignments (all in the one row of data), causing difficulty reporting against appraisal completion for a specific job assignment.
Thanks
Duncan