Seeking Best Practices for Designing a Payroll Costing Report for Voluntary Deduction Elements
We have a requirement to build a report that provides costing details for all employees, but only for a specific group of elements, namely voluntary deductions. To meet this need, I have developed a BI report that extracts run results and reconciles them with payroll actions and the related payroll tables. In other words, the report currently brings in costing information derived from run results, as shown in the attached file.
My question is whether this is the correct or most efficient approach to satisfy the requirement. Specifically, is it advisable to build this report directly from run results as I have done, or would it be a better practice to copy and modify the existing Payroll Costing Detail data model to align with this requirement?