Power BI Connector for Bullhorn CRM

Build 25.0.9539

JobOrder3

Represents another schema variant that stores extended job order values for specialized business needs. This table supports workflow flexibility by enabling organizations to maintain custom job attributes beyond the core model.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the JobOrder3 record in Bullhorn CRM. This value supports cross-referencing, workflow routing, and reporting processes that rely on stable job-order identifiers.

Ofopenings Int False

Indicates the total number of openings that are associated with the job order. This value supports forecasting, resource allocation, and fulfillment planning.

AdditionalskillsKeywords String False

Captures additional skills or keyword terms that are associated with the job order. This value supports enhanced search matching and assists recruiters with identifying qualified candidates more efficiently.

AddressAddress String False

Captures the primary street address that is associated with the job location. This value supports candidate search filtering, mapping tools, and geographic categorization.

AddressCity String False

Indicates the city that is associated with the job location. This value supports location-based reporting and ensures accurate filtering during candidate matching.

AddressCountry Int False

Represents the Id of the country that is associated with the job location. This value supports standardized geographic classification, system integrations, and country-based reporting.

AddressStateorProvince String False

Indicates the state or provincial region that is associated with the job location. This value supports territory-based assignments and improves regional filtering for candidate searches.

AddresszipPostalcode String False

Captures the ZIP or postal code that is associated with the job location. This value supports routing accuracy, location matching, and search-radius filtering.

AllowClienttoEditJob Bool False

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

Benefits String False

Captures the benefits information that is associated with the job order. This value supports candidate engagement and ensures that compensation packages are clearly communicated.

BillRateCategory Int False

Represents the Id of the bill-rate category that is associated with the job order. This value supports pricing configuration, billing workflows, and financial modeling.

BonusPackage String False

Captures descriptive information about the bonus package that is associated with the job order. This value supports candidate attraction and assists recruiters in presenting incentive components.

Branch String False

Captures the name or code of the branch that is responsible for the job order. This value supports organizational alignment, routing rules, and branch-level analytics.

BranchID Int False

Represents the Id of the branch that is associated with the job order. This value supports ownership assignment, reporting segmentation, and workflow distribution.

CertificationRequirements String False

Captures the certification requirements that are associated with the job order. This value supports qualification screening and ensures compliance with client-defined standards.

ClientBillRate String False

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

ClientCompanyId Int False

Represents the Id of the client company that is associated with the job order. This value supports client-based grouping, reporting, and account-management activities.

ClientCostCenter String False

Captures the client cost-center information that is associated with the job order. This value supports internal accounting, departmental chargeback 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 routing and ensures interactions are linked to the correct client representative.

DateAdded Datetime False

Indicates the date and time when the JobOrder3 record is created in Bullhorn CRM. This value supports audit trails, lifecycle monitoring, and time-based reporting.

DateClosed Datetime False

Indicates the date when the job order is closed. This value supports lifecycle management and prevents inactive orders from appearing in active job pipelines.

DateLastExported Datetime False

Indicates the date when the job order is most recently exported to an external system. This value supports integration tracking and confirms synchronization across connected platforms.

DateLastPublished Datetime False

Indicates the date when the job order is most recently published. This value supports job-board visibility tracking, refresh timing, and communication planning.

DegreeRequirements String False

Captures the degree requirements that are associated with the job order. This value supports qualification checks and ensures alignment with client needs.

EducationRequirements String False

Captures the educational requirements that are associated with the job order. This value supports accurate candidate screening and strengthens compliance with role standards.

Employment String False

Captures the employment classification that is associated with the job order. This value supports classification-based search filters, reporting, and job-type segmentation.

ExternalID String False

Captures the external system Id that is associated with the job order. This value supports mapping, synchronization, and validation across external job-posting or applicant-tracking systems.

HourlyCommitment Double False

Indicates the expected hourly commitment that is associated with the job order. This value supports scheduling, workforce planning, and candidate-availability assessments.

HoursofOperation String False

Captures the hours of operation that are associated with the job role or worksite. This value supports expectation setting and ensures candidate availability aligns with job requirements.

Interviewrequired Bool False

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

JobBoardList String False

Captures the list of job boards that are associated with the job order. This value supports posting distribution, visibility management, and multi-platform job-advertising workflows.

JobBoardPublishing Int False

Indicates the publishing status that is associated with the job order for external job boards. This value supports posting configuration, visibility control, and distribution tracking.

JobDescription String False

Captures the detailed job-description text for the JobOrder3 record. This value supports candidate engagement, job-board presentation, and compliance with job-posting requirements.

JobDuration Double False

Indicates the expected duration of the job assignment. This value supports workforce forecasting, scheduling accuracy, and contract-planning activities.

JobTitle String False

Captures the job title that is associated with the job order. This value supports search optimization, candidate attraction, and posting consistency across job boards.

LastUpdated Datetime False

Indicates the date and time when the JobOrder3 record is most recently updated. This value supports audit visibility and helps users track modifications to job details.

LocationId Int False

Represents the Id of the location record that is associated with the job order. This value supports geographic filtering, workflow routing, and location-based reporting.

LocationRequirements String False

Captures the location requirements that are associated with the job order. This value supports candidate screening and clarifies geographic expectations or restrictions for the role.

MarkUp Double False

Indicates the markup percentage that is associated with the job order. This value supports pricing analysis, profitability modeling, and financial planning.

MinimumExperience Int False

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

NumberofEmployees Bool False

Returns a value of 'true' if employee-count criteria are relevant to the job order for compliance or analysis. It returns a value of 'false' if employee-count considerations do not apply.

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 the description of any options or incentive package that is associated with the job order. This value supports compensation communication and enhances candidate-engagement workflows.

OwnerId Int False

Represents the Id of the user who owns or manages the JobOrder3 record. This value supports accountability, collaboration, and task-routing workflows.

PayRate String False

Captures the primary pay-rate information that is associated with the job order. This value supports compensation modeling and informs rate-based decision making.

PayRate2 String False

Captures secondary pay-rate information that is associated with the job order. This value supports alternate rate structures or multi-tiered compensation arrangements.

Permfee Double False

Indicates the permanent-placement fee that is associated with the job order. This value supports revenue calculations, contract planning, and client negotiation.

Priority Int False

Indicates the priority level that is assigned to the job order. This value supports workflow triage, recruiter workload management, and urgency-based task routing.

PublicCategory Int False

Represents the Id of the public-facing job category that is associated with the JobOrder3 record. This value supports job-board categorization and enhances posting discoverability.

PublishedCategoryId Int False

Represents the Id of the published job category that is linked to the job order. This value supports posting consistency and ensures proper classification across external platforms.

PublishedContactInfoId Int False

Represents the Id of the contact-information record that is associated with the published job order. This value supports public inquiries and ensures that applicants receive accurate routing details.

PublishedDescription String False

Captures the publicly visible description that is associated with the job order. This value supports candidate engagement and ensures clear, readable role communication across job boards.

PublishedZipCode String False

Captures the published ZIP code that is associated with the job posting. This value supports location-based search filtering, job-board targeting, and regional analytics.

ReasonClosed String False

Captures the reason the job order is closed. This value supports historical analysis, operational reporting, and trend evaluation.

ReportingtoContactId Int False

Represents the Id of the client contact to whom the placed candidate will report. This value supports organizational-context communication and ensures clear reporting structure.

ReportingtoOther String False

Captures descriptive information about alternative reporting relationships that are associated with the job order. This value supports candidate screening and clarifies nonstandard reporting lines.

Salary String False

Captures the salary information that is associated with the job order. This value supports compensation transparency and strengthens recruiter–candidate communication.

ScheduledEnd Datetime False

Indicates the scheduled end date for the job assignment. This value supports contract lifespan tracking, forecasting, and scheduling workflows.

ShiftId Int False

Represents the Id of the shift that is associated with the job order. This value supports workforce alignment and ensures placement compatibility with shift requirements.

Source String False

Captures the originating source of the job order. This value supports analytics, workflow routing, and visibility into job-generation channels.

StartDate Datetime False

Indicates the start date that is associated with the job order. This value supports onboarding coordination, timeline management, and role scheduling.

Status String False

Indicates the current status of the JobOrder3 record. This value supports job-pipeline management, reporting, and search filtering.

Tax Double False

Indicates the tax amount or percentage that is associated with the job order. This value supports compliance tracking and contributes to financial planning.

TaxPreference String False

Captures the tax-preference setting that is associated with the job order. This value supports regulatory compliance and ensures accurate financial configuration.

TravelRequirements String False

Captures the travel requirements that are associated with the job order. This value supports candidate qualification and clarifies expectations regarding travel obligations.

UsersAssigned String False

Captures the list of users who are assigned to the job order. This value supports shared workload management, role delegation, and team-based recruiting workflows.

VisaSponsorshipProvided Bool False

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

Willrelocate Int False

Indicates the relocation-support level or preference that is associated with the job order. This value supports candidate screening and helps assess suitability for relocation-dependent roles.

WillRelocateBoolean Bool False

Returns a value of 'true' if the job order supports candidate relocation. It returns a value of 'false' if relocation assistance 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 evaluation and contributes to cost-modeling processes.

IsDeleted Bool False

Returns a value of 'true' if the JobOrder3 record is marked as deleted in Bullhorn CRM. It returns a value of 'false' if the record remains active and available for reporting, searching, and workflow operations.

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