Name in AssignmentPro: vwEQ_COMP_WORKSHEET_TRANSACTION_CHANGES
Name in Database: vwEQ_COMP_WORKSHEET_TRANSACTION_CHANGES
Description inc. recommended uses and limitations: This view has the ability to track changes made to a Compensation Worksheet. Note that this view is not joint to the Payroll System Calendar table and for that reason calculation period dates pulled from this table cannot be used in a Payroll Report as they will be incorrect or not relevant to that period for example.
Tables used in the view:
vwEQ_COMP_WORKSHEET_CURRENT_AND_PREVIOUS_EFFECTIVE_NON_RETRO
vwEQ_COMP_WORKSHEET_TRANSACTION_ID
Fields contained in the view:
Amount Change
Assignment Id
Change Type
Comp Worksheet Dictionary Id
Current and Previous Details
Account Id
Amount
Comp Worksheet Id
Comp Worksheet Line Item Id
Currency
Entry Comp Id
Entry Id
Payroll System Calendar Id
Transaction Type
Comp Worksheet Template Id
Click here for details on how to create a user report to return all fields for a given name in the database.