Name in AssignmentPro: Assignment Derived Calculations
Name in Database: vwEQ_ASSIGNMENT_DERIVED_CALCULATIONS
Description inc. recommended uses and limitations: Useful for user reports backing widgets
Tables used in the view:
ASSIGNMENT
ASSIGNMENT_DESTINATION
AUTH_STAGE_ASSIGNMENT
AUTHORIZATION
CLASSIFICATION
COUNTRY
EMPLOYEE
Fields contained in the view:
Hyperlinks
Assignment Compensation
Assignment
Employee
Relocation Tax Assistance
Different Date Formats: DD-MMM-YY, DDMMYYY and MMDDYYYY
Current Date
Assignment Effective Date
Assignment Scheduled/Extension Date
Concatenated text fields
Employee First Last Name
Employee Last First Name
Home - Host
Home Location (City, Country)
Host Location (City, Country)
Departure Location (City, State/Province)
Destination Location (City, State/Province)
Calculated fields
Days Until Benefits End Date
Countries displayed as ISO Codes
Assignment Home Country - 2 & 3 ISO char
Assignment Host Country - 2 & 3 ISO char
Employee Primary Citizenship - 2 ISO char
Employee Secondary Citizenship - 2 ISO char
State Province displayed as Code
Home State Province
Host State Province
Click here for details on how to create a user report to return all fields for a given name in the database.
Things to Note
The Destination Location for Remote Work field will show the Destination location from the first ASSIGNMENT_DESTINATION record
For remote workers and business travelers, the From and To locations are derived from the assignment table, not the destination table. Therefore, these fields may be empty in the results.