Name in AssignmentPro: Comp Worksheet To Pay Register Reconciliation (View)
Name in Database: vwEQ_COMPWORKSHEET_TO_PAYREGISTER_RECONCILIATION
Description inc. recommended uses and limitations: The view allows users to compare the Compensation Worksheet (CW) and Pay Registers (PR) amounts along with the CW and PR currencies to determine variances or differences between the values. This can be used with Assignment, Assignment Derived, and other non-financial tables
Limitations:
Compensation Worksheets must be linked to payroll reporting to be included in the View reporting results
View was created with unique joins that allow users to compare Comp Worksheet & Pay Register amounts. View should not be joined in the User Report Type with other financial like the Compensation Worksheet or Pay Register tables. View already has the necessary fields from these tables to perform a reconciliation between Comp Worksheet & Pay Registers.
View can be used with Assignment, Assignment Derived, and other non-financial tables
Tables used in the view:
ASSIGNMENT
POLICY
EMPLOYEE
COMPANY
PRIMARY_PAYROLL_SYSTEM
SECONDARY_PAYROLL_SYSTEM
ACCOUNT
PR
CW
DIFFERENCE
REPORT_BATCH
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
Pay Register Calendar Id
Pay Register Payroll System Name
Pay RegisterPay Date
Pay_Register Begin Date
Pay Register End Date
Pay Register Id
Pay Register Amount
Pay Register Currency
Pay Register Status
Pay Register Primary Wage Code
Pay Register Secondary Wage Code
Comp Worksheet Amount
Comp Worksheet Currency
Difference
Pay Register Batch Id
Pay Register Batch Calendar Id
Pay Register Batch Pay Date
Pay Register Batch Begin Date
Pay Register Batch End Date
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.
Important Fields Details
Pay Register Amount
Caters the correct pay register amount
When imported to primary payroll system, use the primary payroll amount
When imported to secondary payroll system, use the secondary payroll amount
Pay Register Currency
Caters the correct pay register currency
When imported to primary payroll system, use the primary payroll currency
When imported to secondary payroll system, use the secondary payroll currency
Compensation Worksheet Amount - CW_AMOUNT
Caters the correct comp worksheet amount
When imported to primary payroll system, use the primary amount from the compensation worksheet
When imported to secondary payroll system, use the secondary amount from the compensation worksheet
Compensation Worksheet Currency - CW_CURRENCY
Caters the correct comp worksheet currency
When imported to primary payroll system, use the primary currency from the compensation worksheet
When imported to secondary payroll system, use the secondary currency from the compensation worksheet
Comp Worksheet amount was to 'Sum Then Round ' the amount
Pay Register Payroll System Name - PR_PAYROLL_SYSTEM_NAME
Use Pay Register Calendar Id to get the name of the payroll system (PAYROLL_SYSTEM!NAME) so users can determine which payroll paid the pay register
Difference
The column ' Difference' will show the calculated difference between the Comp Worksheet & Pay Register amounts. Note, the difference column discards 0.01 variance.