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. |