Name in AssignmentPro: Comp Worksheet with Batch Payroll Reporting Detail (view)
Description: The Comp Worksheet With Batch Payroll Reporting Details (view) allows users to use the REPORT_BATCH_ID to find all of the compensation worksheets that are part of the Comp Worksheet To Pay Register Reconciliation (View). This will allow users to research Comp. Worksheet amounts in case two pay periods of data are aggregated or in the scenario where the users have Effective and Retro Compensation Worksheets in the same pay period.
The view allows users to research all of the Compensation Worksheets included so they can further review differences between comp worksheets and the pay register.
Recommended use: Once a report is run using the Comp Worksheet To Pay Register Reconciliation (View) if the user needs more detail on the Compensation Worksheets they should use the REPORT_BATCH_ID and this view to determine what Compensation Worksheets are aggregated together.
Tables used in the view:
ASSIGNMENT
POLICY
EMPLOYEE
COMPANY
PRIMARY_PAYROLL_SYSTEM
SECONDARY_PAYROLL_SYSTEM
ACCOUNT
PR
CW
DIFFERENCE
REPORT_BATCH
COMP_WORKSHEET
Fields contained in the view:
Assignment ID
Assignment Type
Assignment Policy Name
Employee ID
Employee Name
Assignment Company ID
Assignment Company Name
Assignment Primary Payroll System ID
Assignment Primary Payroll System Name
Assignment Primary Payroll System External Name
Assignment Primary Payroll System Country
Assignment Primary Payroll System Currency
Assignment Secondary Payroll System ID
Assignment Secondary Payroll System Name
Assignment Secondary Payroll System External Name
Assignment Secondary Payroll System Country
Assignment Secondary Payroll System Currency
Account ID
Account Number
Account Description
Comp Worksheet Amount
Comp Worksheet Currency
Report Batch Id
Report Batch Calendar ID
Report Batch Pay Date
Report Batch Begin Date
Report Batch End Date
Comp Worksheet ID
Comp Worksheet Calendar ID
Comp Worksheet Begin Date
Comp Worksheet End Date
Comp Worksheet Pay Date
Comp Worksheet Type
Comp Worksheet Version
Comp Worksheet Line Item Name
Comp Worksheet Line Item ID
ID
Create By
Create Date
Last Update By
Last Update Date
Click here for details on how to create a user report to return all fields for a given name in the database.