ODBC Driver for Bullhorn CRM

Build 25.0.9539

Opportunity

Represents sales opportunity records that track potential revenue-generating engagements with clients or prospects. This table supports business development workflows by storing opportunity stages, activities, and forecasting information.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) of the Opportunity table. This value distinguishes each Opportunity record so Bullhorn CRM can track sales prospects and related workflow activity.

Ofopenings Int False

Captures the number of openings that is associated with the Opportunity record. This value assists staffing teams in determining capacity and managing fulfillment progress.

ActualCloseDate Datetime False

Specifies the actual close date that is recorded for the Opportunity record. This timestamp enables accurate sales-cycle analysis and supports comparison between projected and actual closing behavior.

AddressAddress String False

Captures the primary street address that is associated with the Opportunity record. This information supports location-based search, client engagement planning, and geographic reporting.

AddressCity String False

Specifies the city that is associated with the Opportunity record. This field contributes to regional analysis and helps determine market-specific factors.

AddressCountry Int False

Indicates the Id of the country that is linked to the Opportunity record. This relationship ensures that regional rules and localization settings are applied correctly.

AddressStateorProvince String False

Captures the state or province that is associated with the Opportunity record. This value supports jurisdictional reporting and helps refine geographic segmentation.

AddressZip String False

Stores the ZIP or postal code that is associated with the Opportunity record. This information enables accurate regional filtering, tax assessments, and geographic analytics.

AllowClienttoEditJob Bool False

Returns a value of 'true' when the client organization is permitted to edit related job details for the Opportunity record. It returns a value of 'false' when client editing is restricted.

Benefits String False

Captures the benefits information that is associated with the Opportunity record. This narrative helps define compensation expectations and supports accurate job-package representation.

BillRateCategory Int False

Indicates the Id of the bill rate category that is applied to the Opportunity record. This value supports billing structure determination and downstream financial calculations.

BonusPackage String False

Stores the bonus package details that are connected to the Opportunity record. This information helps characterize compensation structures for internal review and client proposals.

BranchCode String False

Captures the branch code that is associated with the Opportunity record. This value supports organizational reporting, territory assignments, and workflow routing.

BusinessSectorId Int False

Indicates the Id of the business sector that is associated with the Opportunity record. This classification supports industry segmentation and strategic reporting.

ClientCompanyId Int False

Specifies the Id of the client company that is linked to the Opportunity record. This relationship identifies which customer organization is pursuing the engagement.

ContactId Int False

Identifies the Id of the client contact that is associated with the Opportunity record. This linkage supports communication workflows and relationship management.

DateAdded Datetime False

Indicates the datetime when the Opportunity record is created. This timestamp supports audit accuracy and chronological tracking of potential sales activity.

DegreeRequirements String False

Captures the degree requirements that are associated with the Opportunity record. This information helps recruiters evaluate candidate eligibility and align educational expectations.

EducationRequirements String False

Specifies the education requirements that apply to the Opportunity record. This field supports qualification screening and compliance-driven review.

ExternalID String False

Stores an external system Id that is associated with the Opportunity record. This information supports integrations, data imports, and synchronization across platforms.

ExpectedFee Double False

Represents the projected fee amount that is expected for the Opportunity record. This value supports revenue forecasting, pipeline valuation, and commission planning.

ExpectedPayRate Double False

Specifies the anticipated pay rate that is associated with the Opportunity record. This information assists with budgeting, compensation modeling, and internal rate approvals.

LastUpdated Datetime False

Captures the datetime when the Opportunity record is last modified. This value helps users identify recent changes and monitor lifecycle activity.

LocationRequirements String False

Describes the location requirements that apply to the Opportunity record. This narrative provides information that may influence candidate sourcing or job-site considerations.

MarkUp Double False

Represents the markup percentage that is associated with the Opportunity record. This calculation contributes to pricing structures and profitability assessments.

MinimumExperience Int False

Specifies the minimum required experience that applies to the Opportunity record. This value helps ensure appropriate candidate qualification and screening.

OpenClosed Bool False

Returns a value of 'true' when the Opportunity record is marked as open. It returns a value of 'false' when the Opportunity record is marked as closed.

OptionsPackage String False

Stores the options package information that is associated with the Opportunity record. This field outlines supplemental compensation details that may influence candidate engagement.

OwnerId Int False

Identifies the Id of the user who owns the Opportunity record. This assignment drives pipeline accountability and workflow distribution.

PayRate String False

Captures the pay rate information that is associated with the Opportunity record. This value supports compensation planning and candidate evaluation.

Priority Int False

Specifies the priority level that is assigned to the Opportunity record. This ranking helps determine workflow urgency and supports task allocation.

PublicCategory Int False

Indicates the category Id that is applied to the Opportunity record for public-facing listings. This value ensures correct classification for external visibility.

PublishedDescription String False

Stores the public description that is associated with the Opportunity record. This content is used for candidate engagement and job board visibility.

PublishedZipCode String False

Captures the public ZIP code that is associated with the Opportunity record. This information supports geographic search filters and ensures accuracy in external postings.

ReasonClosed String False

Describes the reason why the Opportunity record is marked as closed. This information supports performance analysis and helps refine future engagement strategies.

Salary String False

Captures the salary information that is associated with the Opportunity record. This field helps define compensation expectations and supports comparison with market conditions.

ShiftId Int False

Specifies the Id of the shift that is associated with the Opportunity record. This linkage supports scheduling expectations and candidate availability assessments.

Source String False

Indicates the origin source that is associated with the Opportunity record. This information helps track lead acquisition and channel effectiveness.

Tax Double False

Represents the tax-related value that is associated with the Opportunity record. This field supports financial modeling and billing configuration.

TaxPreference String False

Captures the tax preference information that applies to the Opportunity record. This value assists with billing setup and compliance-driven tax handling.

WillRelocate Bool False

Returns a value of 'true' when relocation is acceptable for the Opportunity record. It returns a value of 'false' when relocation is not permitted or not applicable.

IsDeleted Bool False

Returns a value of 'true' when the Opportunity record is marked as deleted. It returns a value of 'false' when the Opportunity record remains active in Bullhorn CRM.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539