Name in AssignmentPro: Latest Passports by Assignment (view)
Name in Database: vwEQ_LATEST_PASSPORTS_BY_ASSIGNMENT
Description inc. recommended uses and limitations: This view pulls the most recent passport record details. If multiple records exist for an Employee, Spouse/Domestic Partner or Dependent, the view will pull the record with the greatest expiration date. If multiple records exist with the same expiration date, the view will pull the latest record created.
Tables used in the view:
ASSIGNMENT
COUNTRY
EMPLOYEE
EMPLOYEE_PASSPORT
EQ_STD_DEPENDENTS_PASSPORTS_GET
SPOUSE_DOMESTIC_PARTNER
SPOUSE_DOMESTIC_PARTNER_PASSPORT
ASSIGNMENT_DEPENDENT
ASSIGNMENT_DEPENDENT_PASSPORT
ASSIGNMENT_VISA
CLASSIFICATION
TAX_SOCIAL_INSURANCE
Fields contained in the view:
General Fields
Assignment ID
Employee Passport Fields
Employee Passport Expiration Date
Employee Passport First Name
Employee Passport Issue City
Employee Passport Issue Country
Employee Passport Issue Date
Employee Passport Last Name
Employee Passport Middle Name
Employee Passport Number
Spouse Domestic Partner Passport fields
Spouse Domestic Partner Passport Expiration Date
Spouse Domestic Partner Passport First Name
Spouse Domestic Partner Passport Issue City
Spouse Domestic Partner Passport Issue Country
Spouse Domestic Partner Passport Issue Date
Spouse Domestic Partner Passport Last Name
Spouse Domestic Partner Passport Middle Name
Spouse Domestic Partner Passport Number
Child Passport Fields
Child Passport Expiration Date (1-10)
Child Passport First Name (1-10)
Child Passport Issue City (1-10)
Child Passport Issue Country (1-10)
Child Passport Issue Date (1-10)
Child Passport Last Name (1-10)
Child Passport Middle Name (1-10)
Child Passport Number (1-10)
Click here for details on how to create a user report to return all fields for a given name in the database.