Name in AssignmentPro: Employee Assignments 1 line per Employee (view)
Name in Database: vwEQ_EMPLOYEE_ASSIGNMENTS
Description inc. recommended uses and limitations: returns the first 10 assignments for an employee as one row.
Tables used in the view:
EMPLOYEE
EQ_STD_EMPLOYEE_ASSIGNMENTS_GET
Fields contained in the view:
Employee Fields
Employee ID
Number Of Assignments
Assignment Fields
Assignment Actual End Date
Assignment Effective Date
Assignment From City
Assignment From Company Segment Level 1
Assignment From Company Segment Level 2
Assignment From Country
Assignment From Country Code
Assignment From Salary Grade
Assignment From Title
Assignment ID
Assignment Inactive
Assignment Number
Assignment Phase
Assignment Relocation Policy
Assignment Scheduled End Date
Assignment Start Date
Assignment To City
Assignment To Company Segment Level 1
Assignment To Company Segment Level 2
Assignment To Country
Assignment To Country Code
Assignment To Salary Grade
Assignment To Title
Assignment Type
These fields are available for each Assignment, 1-10.
Click here for details on how to create a user report to return all fields for a given name in the database.