CData Python Connector for Bullhorn CRM

Build 25.0.9539

JobOrder

Represents job order records that define open positions submitted by client corporations. This table supports end-to-end recruiting workflows by storing requirements, compensation details, and status information that drive candidate submission and placement activities.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the job-order record in Bullhorn CRM. This value supports workflow routing, reporting, and job-management automation that rely on stable references to job-order data.

Ofopenings Int False

Indicates the total number of openings that are associated with the job order. This value supports forecasting, fulfillment planning, and candidate-sourcing strategies.

AddressAddress String False

Captures the primary street address that is associated with the job location. This value supports geographic searching, mapping workflows, and candidate-placement logistics.

AddressCity String False

Indicates the city that is associated with the job location. This value supports location-based filtering and contributes to regional job-matching accuracy.

AddressCountry Int False

Represents the Id of the country that is associated with the job location. This value supports standardized geographic classification and ensures compatibility with integrations that rely on country-level metadata.

AddressStateorProvince String False

Indicates the state or provincial region that is associated with the job location. This value supports territory-based reporting and improves accuracy in geographic job searches.

AddressZip String False

Captures the ZIP code that is associated with the job location. This value supports precise geographic targeting, postal validation, and proximity-based candidate searching.

AllowClienttoEditJob Bool False

Returns a value of 'true' if the client is permitted to edit the job order through client-facing interfaces. It returns a value of 'false' if editing capabilities are restricted to internal users only.

Benefits String False

Captures the narrative description of benefits that are associated with the job order. This information supports candidate engagement and helps recruiters communicate total compensation offerings.

BillRateCategory Int False

Represents the Id of the bill-rate category that is associated with the job order. This value supports rate configuration, billing calculations, and client-specific pricing structures.

BonusPackage String False

Captures the description of any bonus package that is associated with the job opportunity. This value supports compensation discussions and helps recruiters highlight incentive-based offerings.

Branch String False

Captures the name or code of the branch that is responsible for the job order. This value supports organizational alignment and contributes to branch-level reporting and management workflows.

BranchID Int False

Represents the Id of the branch that is responsible for the job order. This value supports workflow routing, ownership tracking, and territory-based analytics.

CertificationRequirements String False

Captures the list or description of certifications that are required for the job order. This value supports qualification screening and ensures that recruiters evaluate candidate eligibility accurately.

ClientBillRate String False

Indicates the client bill rate that is associated with the job order. This value supports financial modeling, negotiation, and margin analysis workflows.

ClientCompanyId Int False

Represents the Id of the client corporation that is associated with the job order. This value supports client-level grouping, reporting, and organizational mapping.

ClientCostCenter String False

Captures the cost-center value that is associated with the job order. This value supports internal accounting, budgeting workflows, and financial tracking.

ContactId Int False

Represents the Id of the client contact who is associated with the job order. This value supports communication workflows and ensures that client interactions are linked to the correct individual.

DateAdded Datetime False

Indicates the date and time when the job-order record is created in Bullhorn CRM. This value supports lifecycle tracking, reporting, and audit-compliance workflows.

DateClosed Datetime False

Indicates the date when the job order is formally closed. This value supports lifecycle analysis and ensures that closed roles are excluded from active job searches.

DateLastExported Datetime False

Indicates the date when the job order is last exported to an external system. This value supports synchronization workflows and helps maintain consistency across external job-board integrations.

DateLastPublished Datetime False

Indicates the date when the job order is most recently published. This value supports posting workflows and assists users in monitoring job-visibility timelines.

DegreeRequirements String False

Captures the degree-related requirements that are associated with the job order. This value supports candidate qualification screening and enhances compliance with client-specified criteria.

EducationRequirements String False

Captures the educational requirements that are associated with the job order. This value supports recruiter evaluation and ensures accurate candidate matching.

EmploymentType String False

Indicates the employment-type classification that is associated with the job order, such as contract or permanent. This value supports filtering, reporting, and job-search categorization.

ExternalID String False

Captures the external system Id that is associated with the job order. This value supports synchronization across integrated platforms and ensures that external postings map to the correct internal record.

HourlyCommitment Double False

Indicates the expected hourly commitment that is associated with the job order. This value supports scheduling, planning, and workload assessment.

HoursofOperation String False

Captures the hours of operation that are associated with the job opportunity. This value supports candidate screening and aligns expectations regarding work schedules.

Interviewrequired Bool False

Returns a value of 'true' if the job order requires that candidates complete an interview. It returns a value of 'false' if no interview is required for placement.

JobDescription String False

Captures the full job-description text for the job order. This value supports candidate engagement and provides the essential responsibilities and expectations that define the role.

JobDuration Double False

Indicates the expected duration of the job assignment. This value supports forecasting, planning, and candidate-availability evaluation.

JobTitle String False

Captures the job title that is associated with the job order. This value supports search operations, candidate engagement, and display formatting across job boards.

Keywords String False

Captures the keywords that are associated with the job order for search optimization. This value supports candidate-matching algorithms and improves job-search relevance.

LastUpdated Datetime False

Indicates the date and time when the job-order record is most recently updated. This value supports audit tracking and helps users understand when critical job details are modified.

LocationId Int False

Represents the Id of the location record that is associated with the job order. This value supports geographic mapping and ensures accurate location-based reporting and search filtering.

LocationRequirements String False

Captures the location requirements that are associated with the job order. This value supports candidate screening by clarifying geographic expectations such as proximity or onsite presence.

MarkUp Double False

Indicates the markup percentage that is associated with the job order. This value supports financial modeling and contributes to profitability and rate-structure calculations.

MinimumExperience Int False

Indicates the minimum years of experience that are required for the job order. This value supports candidate qualification filtering and ensures alignment with client expectations.

NumberofEmployees Bool False

Returns a value of 'true' if the job order involves consideration of the employer's number of employees for compliance or classification purposes. It returns a value of 'false' if employee-count criteria do not apply to the job order.

OpenClosed Bool False

Returns a value of 'true' if the job order is classified as open. It returns a value of 'false' if the job order is classified as closed.

OptionsPackage String False

Captures descriptive information about the options or incentive package that is associated with the job order. This value supports compensation discussions and enhances candidate engagement.

OwnerId Int False

Represents the Id of the user who owns or manages the job order. This value supports accountability, routing, and visibility workflows in Bullhorn CRM.

PayRate String False

Captures the primary pay-rate information that is associated with the job order. This value supports compensation modeling and helps recruiters communicate rate expectations.

PayRate2 String False

Captures the secondary pay-rate information for the job order. This value supports scenarios that require an additional pay tier or alternate compensation structure.

Permfee Double False

Indicates the permanent-placement fee that is associated with the job order. This value supports financial planning and enables accurate revenue forecasting.

PremiumJobBoards String False

Captures the list of premium job boards where the job order may be posted. This value supports multi-board posting workflows and enhances visibility across higher-tier platforms.

Priority Int False

Indicates the priority level that is associated with the job order. This value supports workflow routing, candidate-sourcing urgency, and reporting based on priority weighting.

PublicCategory Int False

Represents the Id of the public job category that is associated with the job order. This value supports job-board classification and enhances search visibility.

PublishedCategoryId Int False

Represents the Id of the published category that is linked to the job order. This value supports external posting workflows and ensures that published listings align with the correct category.

PublishedContactInfoId Int False

Represents the Id of the contact-information record that is associated with the published job posting. This value supports public-facing communication and ensures that inquiries are directed appropriately.

PublishedDescription String False

Captures the publicly visible description that is associated with the job order. This value supports candidate engagement and external job-board presentation.

PublishedZipCode String False

Captures the published ZIP code for the job order. This value supports geographic targeting, distribution rules, and filtering on external job boards.

PublishtoCorporateWeb Int False

Indicates whether the job order is published to the corporate website. This value supports visibility rules and helps control distribution across online channels.

ReasonClosed String False

Captures the reason why the job order is closed. This value supports operational analysis, trend reporting, and process review.

ReportingtoContactId Int False

Represents the Id of the client contact to whom the placed candidate will report. This value supports candidate matching and ensures correct organizational alignment.

ReportingtoOther String False

Captures descriptive information about another reporting contact that is associated with the job order. This value supports candidate screening and clarifies reporting structure.

Salary String False

Captures the base-salary information that is associated with the job order. This value supports compensation communication and candidate-fit evaluation.

ScheduledEnd Datetime False

Indicates the scheduled end date for the job assignment. This value supports planning, forecasting, and coordination of contract timelines.

ShiftId Int False

Represents the Id of the shift that is associated with the job order. This value supports scheduling workflows and ensures correct shift alignment during placement.

Source String False

Captures the origin source of the job order. This value supports reporting, analytics, and workflow routing based on job-source channels.

StartDate Datetime False

Indicates the start date that is associated with the job assignment. This value supports onboarding planning and alignment with candidate availability.

Status String False

Indicates the current status of the job order. This value supports lifecycle management and determines whether the order appears in active, closed, or other workflow queues.

Tax Double False

Indicates the tax amount or percentage that is associated with the job order. This value supports financial calculations and compliance-based workflows.

TaxPreference String False

Captures the tax-preference classification that is associated with the job order. This value supports compliance evaluation and ensures alignment with client-defined hiring requirements.

TravelRequirements String False

Captures any travel-related requirements that are associated with the job order. This value supports candidate screening and clarifies expectations for travel frequency or necessity.

UsersAssigned String False

Captures the list of users who are assigned to the job order. This value supports collaboration, workflow routing, and accountability tracking within recruiting teams.

VisaSponsorshipProvided Bool False

Returns a value of 'true' if the job order includes visa sponsorship. It returns a value of 'false' if no sponsorship is available for the role.

Willrelocate Int False

Indicates the relocation preference or relocation-support level associated with the job order. This value supports candidate matching and helps recruiters evaluate suitability for relocation scenarios.

WillRelocateBoolean Bool False

Returns a value of 'true' if the job order supports candidate relocation. It returns a value of 'false' if relocation support is not offered.

WorkersCompCodeId Int False

Represents the Id of the workers' compensation code that is associated with the job order. This value supports compliance tracking and cost-modeling workflows.

IsDeleted Bool False

Returns a value of 'true' if the job-order record is marked as deleted in Bullhorn CRM. It returns a value of 'false' if the record remains active and available for search, reporting, or downstream workflows.

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