JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

ApplicantSchools

Return a list of: ApplicantSchools

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
PreviousEmployersAggregate String
ReferenceInformationSource String
ReferenceInformationSourceDescription String
ReferencesAggregate String
RejectionInformationComment String
RejectionInformationReason String
SchoolsExtensionsExtensionAggregate String
SchoolsApplicantEducationKeyApplicantId [KEY] Int
SchoolsApplicantEducationKeySequenceId [KEY] Int
SchoolsDegree String
SchoolsDeleteOnUpdate Bool
SchoolsGPABase String
SchoolsGradePointAverage String
SchoolsLastModifiedBy String
SchoolsLastModifiedDate Datetime
SchoolsMajor String
SchoolsNotes String
SchoolsSchool String
SchoolsYearGraduated 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462