SSIS Components for Microsoft Dynamics GP

Build 24.0.9060

ApplicantInterviews

Return a list of: ApplicantInterviews

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
InterviewsExtensionsExtensionAggregate String
InterviewsApplicantInterviewKeyApplicantId [KEY] Int
InterviewsApplicantInterviewKeyApplyDateId [KEY] Datetime
InterviewsApplicantInterviewKeyInterviewTypeId [KEY] String
InterviewsCompanyCode String
InterviewsDeleteOnUpdate Bool
InterviewsDepartmentId String
InterviewsDivisionId String
InterviewsEffectiveDate Datetime
InterviewsInterviewItemsAggregate String
InterviewsInterviewTypeCode Int
InterviewsNotes String
InterviewsPositionId String
InterviewsReviewRange Int
InterviewsReviewRating Decimal
InterviewsTotalWeight Int
InterviewsWeightedScore Int
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
PreviousEmployersAggregate String
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.9060