A user report can be used in the payroll reporting process to produce only accounting transactions that have changed since the last payroll period. The user report will require a user report type with the “vwEQ_PAYROLL_REPORT_COMP_PERIODS_DIFF_EXPORT_EXPANDED (view)” as its base table.

This user report type will include line items that exist on the current payroll, but did not exist at all on the previous payroll period. In addition, it will include assignments where line items do not exist for the current pay period, but did exist on the previous one. This will be useful for determining assignments that have started or ended in a pay period.

Ex.

The sample file above is a user report that could be automatically created through the payroll reporting process. This sample shows 3 assignees that have compensation worksheets for the current period.

Newhart did not have a previous compensation worksheet, so all of his transactions will be returned as “Added”.

Williams has the exact same amounts on his balance sheet as the previous balance sheet.

This is not the first worksheet for Wilson. Wilson’s salary changes this month, forcing all line items based on salary to change. Wilson also has a one-time payment for Spousal Assistance.

A similar user report can be used to produce differences for a single assignee at a time (as opposed to by batch as in the example above). The user report will require a user report type with the “vwEQ_COMP_WORKSHEET_TRANSACTION_CHANGES (view)” as its base table.

Note: A user report filter could be added to only show Added or Changed payment instructions.