SSIS Components for Microsoft Dynamics GP

Build 24.0.9062

ApplicantPreviousEmployers

Return a list of: ApplicantPreviousEmployers

Columns

Name Type Description
ExtensionsExtensionAggregate String
AddressExtensionsExtensionAggregate String
AddressCity String
AddressLine1 String
AddressLine2 String
AddressLine3 String
AddressPostalCode String
AddressState String
AddressCountryRegion String
AddressFaxCountryCode String
AddressFaxExtension String
AddressFax String
AddressPhone1CountryCode String
AddressPhone1Extension String
AddressPhone1 String
AddressPhone2CountryCode String
AddressPhone2Extension String
AddressPhone2 String
AddressPhone3CountryCode String
AddressPhone3Extension String
AddressPhone3 String
AgeCode String
ApplicantId Int
ApplicationColorColorCode String
ApplicationColorColorName String
ApplicationStatus String
ApplicationsAggregate String
CompanyCode String
DateApplied Datetime
DepartmentId String
DivisionId String
Ethnicity String
FirstName String
Gender String
HRRequisistionId String
InterviewsAggregate String
IsDisabled Bool
IsDisabledVeteran Bool
IsOtherVeteran Bool
IsReplyLetterSent Bool
IsVeteran Bool
IsVietnamEraVeteran Bool
IsWillRelocate Bool
LastModifiedBy String
LastModifiedDate Datetime
LastName String
Location String
MiddleName String
PositionId String
PreviousEmployersExtensionsExtensionAggregate String
PreviousEmployersApplicantWorkHistoryKeyApplicantSequenceKeyApplicantId [KEY] Int
PreviousEmployersApplicantWorkHistoryKeyApplicantSequenceKeySequenceId [KEY] Int
PreviousEmployersApplicantWorkHistoryId [KEY] String
PreviousEmployersCompensationPeriod String
PreviousEmployersDeleteOnUpdate Bool
PreviousEmployersEndDate Datetime
PreviousEmployersLastModifiedBy String
PreviousEmployersLastModifiedDate Datetime
PreviousEmployersNotes String
PreviousEmployersPositionId String
PreviousEmployersStartDate Datetime
PreviousEmployersWage Decimal
PreviousEmployersYearsOfExperience Int
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsAggregate String
SequenceId Int
SkillsAggregate String
TaxIdentifier String
TestsAggregate String

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