Name in AssignmentPro: ASSIGNMENT COMP & PAYROLL INFO
Name in Database: vwEQ_ASSIGNMENT_COMPENSATION_PAYROLL_INFORMATION
Description inc. recommended uses and limitations: This view can be used to easily report on some commonly used compensation and payroll values (e.g. Assignment Payroll Systems, Salaries, Bonuses and Family Sizes) without the need for custom SQL field logic.
The view lists the "current" and "previous" values for salary, bonus and family size; however these should be used with care as "current" is the value with the highest effective date and "previous" is the value with the second highest effective date, irrespective of whether that date is in the future or not.
Tables used in the view:
ASSIGNMENT
ASSIGNMENT_COMPENSATION_BONUS
ASSIGNMENT_COMPENSATION_SALARY
ASSIGNMENT_FAMILY_SIZE
EMPLOYEE
PAYROLL_SYSTEM
Fields contained in the view:
Current Date (Current Server Data and Timestamp)
Employee Name (Last Name, First Name)
Assignment Id
Effective Date (Assignment/Relocation Effective Date)
Payroll System Fields:
Asgn Home Payroll System
Asgn Home Payroll System External Name
Asgn Host Payroll System
Asgn Host Payroll System External Name
Asgn Primary Payroll System
Asgn Primary Payroll System External Name
Asgn Secondary Payroll System
Asgn Secondary Payroll System External Name
Asgn Home Payroll System Pay Periods Per Year
Asgn Host Payroll System Pay Periods Per Year
Asgn Primary Payroll System Pay Periods Per Year
Asgn Secondary Payroll System Pay Periods Per Year
Assignment Compensation Salary Fields:
Current Annual Base Pay Amount
Current Annual Base Pay Currency
Current Annual Salary For Calculations Amount
Current Annual Salary For Calculations Currency
Current Reason For Increase
Current Base Bay Effective Date
Current Annual Base Pay (2 dec)
Current Annual Base Pay Plus Curr
Previous Annual Base Pay Amount
Previous Annual Base Pay Currency
Previous Annual Salary For Calculations Amount
Previous Annual Salary For Calculations Currency
Previous Reason For Increase
Previous Base Pay Effective Date
Previous Annual Base Pay (2 dec)
Previous Annual Base Pay Plus Curr
Assignment Compensation Bonus Fields:
Current Bonus Amount
Current Bonus Amount Currency
Current Bonus Paid Date
Current Bonus Type
Previous Bonus Amount
Previous Bonus Amount Currency
Previous Bonus Paid Date
Previous Bonus Type
Assignment Family Size Fields:
Current Family Size Effective Date
Current Home Family Size
Current Host Family Size
Previous Family Size Effective Date
Previous Home Family Size
Previous Host Family Size
Click here for details on how to create a user report to return all fields for a given name in the database.