Visa/Work Permits User Report View

Name in AssignmentPro: Visa/Work Permits User Report (View)

Name in Database: vwEQ_IMMIGRATION_USER_REPORT

Description inc. recommended uses and limitations: This view allows user reports to access all data associated with a Case record, including up to 10 Dependents and up to 10 Detail records. The “Equus – Immigration Details” User Report Type was updated to rely on this view.

Tables used in the view:

ASSIGNMENT
ASSIGNMENT_CASE
ASSIGNMENT_CASE_ASSIGNMENT_DEPENDENT
ASSIGNMENT_CASE_EMPLOYEE
ASSIGNMENT_CASE_SPOUSE_DOMESTIC_PARTNER
ASSIGNMENT_DEPENDENT
ASSIGNMENT_VISA
ASSIGNMENT_VISA_RULE
EMPLOYEE
SPOUSE_DOMESTIC_PARTNER
​

Fields contained in the view:

Click here for details on how to create a user report to return all fields for a given name in the database.