SSIS Components for Microsoft Dynamics GP

Build 24.0.9062

Applicant

Return a list of: Applicant

Columns

Name Type ReadOnly Description
ExtensionsExtensionAggregate String False

AddressExtensionsExtensionAggregate String False

AddressCity String False

AddressLine1 String False

AddressLine2 String False

AddressLine3 String False

AddressPostalCode String False

AddressState String False

AddressCountryRegion String False

AddressFaxCountryCode String False

AddressFaxExtension String False

AddressFax String False

AddressPhone1CountryCode String False

AddressPhone1Extension String False

AddressPhone1 String False

AddressPhone2CountryCode String False

AddressPhone2Extension String False

AddressPhone2 String False

AddressPhone3CountryCode String False

AddressPhone3Extension String False

AddressPhone3 String False

AgeCode String False

ApplicantId [KEY] Int False

ApplicationColorColorCode String False

ApplicationColorColorName String False

ApplicationStatus String False

ApplicationsAggregate String False

CompanyCode String False

DateApplied Datetime False

DepartmentId String False

DivisionId String False

Ethnicity String False

FirstName String False

Gender String False

HRRequisistionId String False

InterviewsAggregate String False

IsDisabled Bool False

IsDisabledVeteran Bool False

IsOtherVeteran Bool False

IsReplyLetterSent Bool False

IsVeteran Bool False

IsVietnamEraVeteran Bool False

IsWillRelocate Bool False

LastModifiedBy String False

LastModifiedDate Datetime False

LastName String False

Location String False

MiddleName String False

PositionId String False

PreviousEmployersAggregate String False

ReferenceInformationSource String False

ReferenceInformationSourceDescription String False

ReferencesAggregate String False

RejectionInformationComment String False

RejectionInformationReason String False

SchoolsAggregate String False

SequenceId Int False

SkillsAggregate String False

TaxIdentifier String False

TestsAggregate String False

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PagingColumn String

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