JDBC Driver for Bullhorn CRM

Build 20.0.7654

Tables

The driver models the data in Bullhorn CRM into a list of tables that can be queried using standard SQL statements.

Generally, querying Bullhorn CRM tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData JDBC Driver for Bullhorn CRM Tables

Name Description
ActivityGoal Create, update, delete and query data of 'ActivityGoal' entity in BullhornCRM system.
ActivityGoalConfiguration Create, update, delete and query data of 'ActivityGoalConfiguration' entity in BullhornCRM system.
ActivityGoalTarget Create, update, delete and query data of 'ActivityGoalTarget' entity in BullhornCRM system.
Appointment Create, update, delete and query data of 'Appointment' entity in BullhornCRM system.
AppointmentAttendee Create, update, delete and query data of 'AppointmentAttendee' entity in BullhornCRM system.
AppointmentEditHistory Create, update, delete and query data of 'AppointmentEditHistory' entity in BullhornCRM system.
AppointmentEditHistoryFieldChange Create, update, delete and query data of 'AppointmentEditHistoryFieldChange' entity in BullhornCRM system.
BillableChargeEditHistory Create, update, delete and query data of 'BillableChargeEditHistory' entity in BullhornCRM system.
BillableChargeEditHistoryFieldChange Create, update, delete and query data of 'BillableChargeEditHistoryFieldChange' entity in BullhornCRM system.
Branch Create, update, delete and query data of 'Branch' entity in BullhornCRM system.
BusinessSector Create, update, delete and query data of 'BusinessSector' entity in BullhornCRM system.
Candidate Create, update, delete and query data of 'Candidate' entity in BullhornCRM system.
CandidateCertification Create, update, delete and query data of 'CandidateCertification' entity in BullhornCRM system.
CandidateCertificationEditHistory Create, update, delete and query data of 'CandidateCertificationEditHistory' entity in BullhornCRM system.
CandidateCertificationEditHistoryFieldChange Create, update, delete and query data of 'CandidateCertificationEditHistoryFieldChange' entity in BullhornCRM system.
CandidateCertificationRequirement Create, update, delete and query data of 'CandidateCertificationRequirement' entity in BullhornCRM system.
CandidateCertificationRequirementEditHistory Create, update, delete and query data of 'CandidateCertificationRequirementEditHistory' entity in BullhornCRM system.
CandidateCertificationRequirementEditHistoryFieldChange Create, update, delete and query data of 'CandidateCertificationRequirementEditHistoryFieldChange' entity in BullhornCRM system.
CandidateEducation Create, update, delete and query data of 'CandidateEducation' entity in BullhornCRM system.
CandidateFileAttachment Create, update, delete and query data of 'CandidateFileAttachment' entity in BullhornCRM system.
CandidateHistory Create, update, delete and query data of 'CandidateHistory' entity in BullhornCRM system.
CandidateReference Create, update, delete and query data of 'CandidateReference' entity in BullhornCRM system.
CandidateReferenceQuestion Create, update, delete and query data of 'CandidateReferenceQuestion' entity in BullhornCRM system.
CandidateReferenceResponse Create, update, delete and query data of 'CandidateReferenceResponse' entity in BullhornCRM system.
CandidateSource Create, update, delete and query data of 'CandidateSource' entity in BullhornCRM system.
CandidateWorkHistory Create, update, delete and query data of 'CandidateWorkHistory' entity in BullhornCRM system.
Category Create, update, delete and query data of 'Category' entity in BullhornCRM system.
Certification Create, update, delete and query data of 'Certification' entity in BullhornCRM system.
CertificationGroup Create, update, delete and query data of 'CertificationGroup' entity in BullhornCRM system.
CertificationRequirement Create, update, delete and query data of 'CertificationRequirement' entity in BullhornCRM system.
ClientContact Create, update, delete and query data of 'ClientContact' entity in BullhornCRM system.
ClientContact1 Create, update, delete and query data of 'ClientContact1' entity in BullhornCRM system.
ClientContact2 Create, update, delete and query data of 'ClientContact2' entity in BullhornCRM system.
ClientContact3 Create, update, delete and query data of 'ClientContact3' entity in BullhornCRM system.
ClientContact4 Create, update, delete and query data of 'ClientContact4' entity in BullhornCRM system.
ClientContact5 Create, update, delete and query data of 'ClientContact5' entity in BullhornCRM system.
ClientContactFileAttachment Create, update, delete and query data of 'ClientContactFileAttachment' entity in BullhornCRM system.
ClientContactHistory Create, update, delete and query data of 'ClientContactHistory' entity in BullhornCRM system.
ClientCorporation Create, update, delete and query data of 'ClientCorporation' entity in BullhornCRM system.
ClientCorporation1 Create, update, delete and query data of 'ClientCorporation1' entity in BullhornCRM system.
ClientCorporation2 Create, update, delete and query data of 'ClientCorporation2' entity in BullhornCRM system.
ClientCorporation3 Create, update, delete and query data of 'ClientCorporation3' entity in BullhornCRM system.
ClientCorporation4 Create, update, delete and query data of 'ClientCorporation4' entity in BullhornCRM system.
ClientCorporation5 Create, update, delete and query data of 'ClientCorporation5' entity in BullhornCRM system.
ClientCorporationAppointment Create, update, delete and query data of 'ClientCorporationAppointment' entity in BullhornCRM system.
ClientCorporationCertification Create, update, delete and query data of 'ClientCorporationCertification' entity in BullhornCRM system.
ClientCorporationEditHistory Create, update, delete and query data of 'ClientCorporationEditHistory' entity in BullhornCRM system.
ClientCorporationEditHistoryFieldChange Create, update, delete and query data of 'ClientCorporationEditHistoryFieldChange' entity in BullhornCRM system.
ClientCorporationFileAttachment Create, update, delete and query data of 'ClientCorporationFileAttachment' entity in BullhornCRM system.
ClientCorporationHistory Create, update, delete and query data of 'ClientCorporationHistory' entity in BullhornCRM system.
ClientCorporationNote Create, update, delete and query data of 'ClientCorporationNote' entity in BullhornCRM system.
ClientCorporationTask Create, update, delete and query data of 'ClientCorporationTask' entity in BullhornCRM system.
CorporateUser Create, update, delete and query data of 'CorporateUser' entity in BullhornCRM system.
CorporationDepartment Create, update, delete and query data of 'CorporationDepartment' entity in BullhornCRM system.
Country Create, update, delete and query data of 'Country' entity in BullhornCRM system.
Department Create, update, delete and query data of 'Department' entity in BullhornCRM system.
EntityFieldTypeLookup Create, update, delete and query data of 'EntityFieldTypeLookup' entity in BullhornCRM system.
GoalTarget Create, update, delete and query data of 'GoalTarget' entity in BullhornCRM system.
HousingComplex Create, update, delete and query data of 'HousingComplex' entity in BullhornCRM system.
HousingComplexAmenity Create, update, delete and query data of 'HousingComplexAmenity' entity in BullhornCRM system.
HousingComplexFurnitureDelivery Create, update, delete and query data of 'HousingComplexFurnitureDelivery' entity in BullhornCRM system.
HousingComplexUnit Create, update, delete and query data of 'HousingComplexUnit' entity in BullhornCRM system.
HousingComplexUtilityAccount Create, update, delete and query data of 'HousingComplexUtilityAccount' entity in BullhornCRM system.
JobBoardPost Create, update, delete and query data of 'JobBoardPost' entity in BullhornCRM system.
JobOrder Create, update, delete and query data of 'JobOrder' entity in BullhornCRM system.
JobOrder1 Create, update, delete and query data of 'JobOrder1' entity in BullhornCRM system.
JobOrder2 Create, update, delete and query data of 'JobOrder2' entity in BullhornCRM system.
JobOrder3 Create, update, delete and query data of 'JobOrder3' entity in BullhornCRM system.
JobOrder4 Create, update, delete and query data of 'JobOrder4' entity in BullhornCRM system.
JobOrder5 Create, update, delete and query data of 'JobOrder5' entity in BullhornCRM system.
JobOrderEditHistory Create, update, delete and query data of 'JobOrderEditHistory' entity in BullhornCRM system.
JobOrderEditHistoryFieldChange Create, update, delete and query data of 'JobOrderEditHistoryFieldChange' entity in BullhornCRM system.
JobOrderFileAttachment Create, update, delete and query data of 'JobOrderFileAttachment' entity in BullhornCRM system.
JobOrderHistory Create, update, delete and query data of 'JobOrderHistory' entity in BullhornCRM system.
JobOrderTemplate Create, update, delete and query data of 'JobOrderTemplate' entity in BullhornCRM system.
JobSubmission Create, update, delete and query data of 'JobSubmission' entity in BullhornCRM system.
JobSubmissionCertificationRequirement Create, update, delete and query data of 'JobSubmissionCertificationRequirement' entity in BullhornCRM system.
JobSubmissionCertificationRequirementEditHistory Create, update, delete and query data of 'JobSubmissionCertificationRequirementEditHistory' entity in BullhornCRM system.
JobSubmissionCertificationRequirementEditHistoryFieldChange Create, update, delete and query data of 'JobSubmissionCertificationRequirementEditHistoryFieldChange' entity in BullhornCRM system.
JobSubmissionEditHistory Create, update, delete and query data of 'JobSubmissionEditHistory' entity in BullhornCRM system.
JobSubmissionEditHistoryFieldChange Create, update, delete and query data of 'JobSubmissionEditHistoryFieldChange' entity in BullhornCRM system.
JobSubmissionHistory Create, update, delete and query data of 'JobSubmissionHistory' entity in BullhornCRM system.
Location Create, update, delete and query data of 'Location' entity in BullhornCRM system.
LocationEditHistory Create, update, delete and query data of 'LocationEditHistory' entity in BullhornCRM system.
LocationEditHistoryFieldChange Create, update, delete and query data of 'LocationEditHistoryFieldChange' entity in BullhornCRM system.
LocationEffectiveDateChange Create, update, delete and query data of 'LocationEffectiveDateChange' entity in BullhornCRM system.
LocationVersion Create, update, delete and query data of 'LocationVersion' entity in BullhornCRM system.
Note Create, update, delete and query data of 'Note' entity in BullhornCRM system.
NoteEntity Create, update, delete and query data of 'NoteEntity' entity in BullhornCRM system.
OpportunityEditHistory Create, update, delete and query data of 'OpportunityEditHistory' entity in BullhornCRM system.
OpportunityEditHistoryFieldChange Create, update, delete and query data of 'OpportunityEditHistoryFieldChange' entity in BullhornCRM system.
OpportunityFileAttachment Create, update, delete and query data of 'OpportunityFileAttachment' entity in BullhornCRM system.
PayableChargeEditHistory Create, update, delete and query data of 'PayableChargeEditHistory' entity in BullhornCRM system.
PayableChargeEditHistoryFieldChange Create, update, delete and query data of 'PayableChargeEditHistoryFieldChange' entity in BullhornCRM system.
Person Create, update, delete and query data of 'Person' entity in BullhornCRM system.
Placement Create, update, delete and query data of 'Placement' entity in BullhornCRM system.
Placement1 Create, update, delete and query data of 'Placement1' entity in BullhornCRM system.
Placement2 Create, update, delete and query data of 'Placement2' entity in BullhornCRM system.
Placement3 Create, update, delete and query data of 'Placement3' entity in BullhornCRM system.
Placement4 Create, update, delete and query data of 'Placement4' entity in BullhornCRM system.
Placement5 Create, update, delete and query data of 'Placement5' entity in BullhornCRM system.
PlacementCertification Create, update, delete and query data of 'PlacementCertification' entity in BullhornCRM system.
PlacementCertificationEditHistory Create, update, delete and query data of 'PlacementCertificationEditHistory' entity in BullhornCRM system.
PlacementCertificationEditHistoryFieldChange Create, update, delete and query data of 'PlacementCertificationEditHistoryFieldChange' entity in BullhornCRM system.
PlacementChangeRequest Create, update, delete and query data of 'PlacementChangeRequest' entity in BullhornCRM system.
PlacementChangeRequestEditHistory Create, update, delete and query data of 'PlacementChangeRequestEditHistory' entity in BullhornCRM system.
PlacementChangeRequestEditHistoryFieldChange Create, update, delete and query data of 'PlacementChangeRequestEditHistoryFieldChange' entity in BullhornCRM system.
PlacementCommission Create, update, delete and query data of 'PlacementCommission' entity in BullhornCRM system.
PlacementCommissionEditHistory Create, update, delete and query data of 'PlacementCommissionEditHistory' entity in BullhornCRM system.
PlacementCommissionEditHistoryFieldChange Create, update, delete and query data of 'PlacementCommissionEditHistoryFieldChange' entity in BullhornCRM system.
PlacementEditHistory Create, update, delete and query data of 'PlacementEditHistory' entity in BullhornCRM system.
PlacementEditHistoryFieldChange Create, update, delete and query data of 'PlacementEditHistoryFieldChange' entity in BullhornCRM system.
PlacementFileAttachment Create, update, delete and query data of 'PlacementFileAttachment' entity in BullhornCRM system.
Report Create, update, delete and query data of 'Report' entity in BullhornCRM system.
SalesQuota Create, update, delete and query data of 'SalesQuota' entity in BullhornCRM system.
SalesTaxRateEditHistory Create, update, delete and query data of 'SalesTaxRateEditHistory' entity in BullhornCRM system.
SalesTaxRateEditHistoryFieldChange Create, update, delete and query data of 'SalesTaxRateEditHistoryFieldChange' entity in BullhornCRM system.
SalesTaxRateEffectiveDateChange Create, update, delete and query data of 'SalesTaxRateEffectiveDateChange' entity in BullhornCRM system.
Sendout Create, update, delete and query data of 'Sendout' entity in BullhornCRM system.
Shift Create, update, delete and query data of 'Shift' entity in BullhornCRM system.
Skill Create, update, delete and query data of 'Skill' entity in BullhornCRM system.
Specialty Create, update, delete and query data of 'Specialty' entity in BullhornCRM system.
State Create, update, delete and query data of 'State' entity in BullhornCRM system.
Task Create, update, delete and query data of 'Task' entity in BullhornCRM system.
TaskEditHistory Create, update, delete and query data of 'TaskEditHistory' entity in BullhornCRM system.
TaskEditHistoryFieldChange Create, update, delete and query data of 'TaskEditHistoryFieldChange' entity in BullhornCRM system.
Tearsheet Create, update, delete and query data of 'Tearsheet' entity in BullhornCRM system.
TearsheetMember Create, update, delete and query data of 'TearsheetMember' entity in BullhornCRM system.
TearsheetRecipient Create, update, delete and query data of 'TearsheetRecipient' entity in BullhornCRM system.
TimeUnit Create, update, delete and query data of 'TimeUnit' entity in BullhornCRM system.
UserEditHistory Create, update, delete and query data of 'UserEditHistory' entity in BullhornCRM system.
UserEditHistoryFieldChange Create, update, delete and query data of 'UserEditHistoryFieldChange' entity in BullhornCRM system.
UserHousingComplexUnit Create, update, delete and query data of 'UserHousingComplexUnit' entity in BullhornCRM system.
UserPulseCallLog Create, update, delete and query data of 'UserPulseCallLog' entity in BullhornCRM system.
UserPulseCallLogContact Create, update, delete and query data of 'UserPulseCallLogContact' entity in BullhornCRM system.
UserType Create, update, delete and query data of 'UserType' entity in BullhornCRM system.
WorkersCompensation Create, update, delete and query data of 'WorkersCompensation' entity in BullhornCRM system.
WorkersCompensationRate Create, update, delete and query data of 'WorkersCompensationRate' entity in BullhornCRM system.
ZipCodeGis Create, update, delete and query data of 'ZipCodeGis' entity in BullhornCRM system.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654