Name in AssignmentPro: Assignment Dependents (view)
Name in Database: vwEQ_ASSIGNMENT_DEPENDENTS
Description inc. recommended uses and limitations: Returns the first 10 dependent records (Child 1 - Child 10) in one row
Tables used in the view:
ASSIGNMENT_DEPENDENT
ASSIGNMENT_DEPENDENT_CF
ASSIGNMENT_DEPENDENT_PASSPORT
CLASSIFICATION
COUNTRY
SCHOOL
Fields contained in the view:
Dependent details
Dependent ID
Dependent Names: First, Middle, Last and Former
Relationship
Gender
Status
Birth Date
Country of Birth - Name and 3 char ISO
Primary Citizenship Country - Name and 3 char ISO
Secondary Citizenship Country - Name and 3 char ISO
Years of Age
National ID Number
Included in Cost of Living
School Information
Type
Id
Name
Expenses paid to
Grade
Special Needs
Special Needs Details
Passport Information
Dependent Names: First, Middle, Last and Former
Number
Issue City
Issue Date
Expiration Date
Dependent level custom fields
Date, Text, Number, Money and Currency
Click here for details on how to create a user report to return all fields for a given name in the database.