SSIS Components for Workday

Build 24.0.9062

StudentsImmigrationEventsDependentImmigrationData

Reads /dependentImmigrationData entries from the StudentsImmigrationEvents table.

Workday Resource Information

Retrieves an immigration event for the specified student ID.

Secured by: External Student Site System Access, Set Up: Student Sites, Student Data: Immigration

Scope: Academic Foundation, Student Core

Columns

Name Type Description
Id [KEY] String Id of the instance
StudentsImmigrationEvents_Id [KEY] String The Workday ID of the StudentsImmigrationEvents that contains this.
Students_Id [KEY] String The Workday ID of the Students that owns this.
CountryOfBirth_Descriptor String Supported for: SELECT. A description of the instance
CountryOfBirth_Href String Supported for: SELECT. A link to the instance
CountryOfBirth_Id String Supported for: SELECT. wid / id / reference id
CountryOfCitizenship_Descriptor String Supported for: SELECT. A description of the instance
CountryOfCitizenship_Href String Supported for: SELECT. A link to the instance
CountryOfCitizenship_Id String Supported for: SELECT. wid / id / reference id
DateOfBirth Datetime Supported for: SELECT. The student dependent’s date of birth.
Descriptor String Supported for: SELECT. A preview of the instance
FirstName String Supported for: SELECT. The first name of the student’s dependent.
ImmigrationStatus_Descriptor String Supported for: SELECT. A description of the instance
ImmigrationStatus_Href String Supported for: SELECT. A link to the instance
ImmigrationStatus_Id String Supported for: SELECT. wid / id / reference id
LastName String Supported for: SELECT. The last name of the student’s dependent.
MiddleName String Supported for: SELECT. The middle name of the student’s dependent.
RelationshipToStudent_Descriptor String Supported for: SELECT. A description of the instance
RelationshipToStudent_Href String Supported for: SELECT. A link to the instance
RelationshipToStudent_Id String Supported for: SELECT. wid / id / reference id
SevisExpirationDate Datetime Supported for: SELECT. The expiration date of the SEVIS ID for the student’s dependent.
SevisId String Supported for: SELECT. The SEVIS ID of the student’s dependent.
SevisIssueDate Datetime Supported for: SELECT. The issue date of the SEVIS ID for the student’s dependent.
Institution_Prompt String No description available.
Status_Prompt String No description available.
AcademicLevel_Prompt String Only used when a Students_Id filter is not provided. Accepts multiple inputs. No description available.
AcademicUnit_Prompt String Only used when a Students_Id filter is not provided. Accepts multiple inputs. Derived Academic Units.
ActiveOnly_Prompt Bool Only used when a Students_Id filter is not provided. Only return active students.
ProgramOfStudy_Prompt String Only used when a Students_Id filter is not provided. Accepts multiple inputs. For students who haven't matriculated, the program of study they either applied to or have been admitted to. For matriculated students, the primary program of study from their reporting record.
Search_Prompt String Only used when a Students_Id filter is not provided. A fuzzy search string that matches student IDs and names. Example: search=bri%20book returns the student Brian Booker.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062