To facilitate the introduction of Multi-period Payroll functionality in this release, a new intermediary database table has been added to store data that ties payees to their respective pay periods. The introduction of the intermediary table means that any reports that rely on a join between the pre-existing rar.GrossWageBatch and rar.GrossWageBatchPayee tables will be affected. Because of that, the following statement can be used to correct the existing joins within report queries: -- None MPP linking rar.GrossWageBatch to rar.GrossWageBatchPayee SELECT * FROM rar.GrossWageBatch b JOIN rar.GrossWageBatchPayee p ON b.GrossWageBatch_id = p.GrossWageBatch_id -- None MPP linking rar.GrossWageBatch to rar.GrossWageBatchPayee_History SELECT * FROM rar.GrossWageBatch b JOIN rar.GrossWageBatchPayee_History p ON b.GrossWageBatch_id = p.GrossWageBatch_id ------------------------------------------------------------------------------- -- MPP linking rar.GrossWageBatch to rar.GrossWageBatchPayee --**** NOTE : GrossWageBatch_id column in the rar.GrossWageBatchPayee table will be dropped SELECT * FROM rar.GrossWageBatch b JOIN rar.GrossWageBatchPeriods d ON b.GrossWageBatch_id = d.GrossWageBatchId JOIN rar.GrossWageBatchPayee p ON d.GrossWageBatchPeriodId = p.GrossWageBatchPeriodId -- MPP linking rar.GrossWageBatch to rar.GrossWageBatchPayee_History --**** NOTE : GrossWageBatch_id column in the rar.GrossWageBatchPayee_History table will be dropped SELECT * FROM rar.GrossWageBatch b JOIN rar.GrossWageBatchPeriods d ON b.GrossWageBatch_id = d.GrossWageBatchId JOIN rar.GrossWageBatchPayee_History p ON d.GrossWageBatchPeriodId = p.GrossWageBatchPeriodId Note that this will ensure that data can be retrieved by the report query but depending on the context of a report, further changes may be required to the report query based on the database schema changes that have been made in this release. |