Power BI Connector for Bullhorn CRM

Build 25.0.9539

JobOrder1

Represents an alternate schema variation for job order records. This table supports extended or legacy implementations by providing supplemental attributes that expand how job details are modeled within Bullhorn CRM.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the JobOrder1 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 JobOrder1 record. This value supports forecasting, fulfillment planning, and candidate-sourcing workflows.

AddressAddress String False

Captures the primary street address that is associated with the job location. This value supports geographic searching, mapping, 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 accurate regional job matching.

AddressCountry Int False

Represents the Id of the country that is associated with the job location. This value supports standardized geographic classification and integration workflows that rely on country 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 geographic search accuracy.

AddressZip String False

Captures the ZIP code that is associated with the job location. This value supports postal validation, precise geographic filtering, 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.

Benefits String False

Captures the narrative description of benefits that are associated with the job. This value supports candidate engagement and helps recruiters present 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 highlights 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 branch-level reporting.

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

CertificationRequirements String False

Captures the certification requirements that are associated with the job order. This value supports qualification screening and ensures recruiter alignment with client requirements.

ClientBillRate String False

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

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 job-assignment workflows.

ClientCostCenter String False

Captures the cost-center information 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 tied to the correct individual.

DateAdded Datetime False

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

DateClosed Datetime False

Indicates the date when the JobOrder1 record is formally closed. This value supports job-lifecycle analysis and prevents closed roles from appearing in active searches.

DateLastExported Datetime False

Indicates the date when the job order is last exported to an external system. This value supports integration monitoring and ensures synchronization across external job boards.

DateLastPublished Datetime False

Indicates the date when the job order is most recently published. This value supports visibility tracking across distribution channels.

DegreeRequirements String False

Captures the degree requirements that are associated with the job order. This value supports candidate qualification screening and ensures alignment with client expectations.

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 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 expectation setting and candidate-scheduling alignment.

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 the role does not require an interview for placement.

JobDescription String False

Captures the full job-description text for the JobOrder1 record. This value supports candidate engagement and provides essential context for role responsibilities.

JobDuration Double False

Indicates the expected duration of the job assignment. This value supports forecasting, contract 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 job-board display formatting.

Keywords String False

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

LastUpdated Datetime False

Indicates the date and time when the JobOrder1 record is most recently updated. This value supports audit tracking and helps users understand when 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 filtering and reporting based on job location.

LocationRequirements String False

Captures the location requirements that are associated with the job order. This value supports candidate screening by clarifying geographic expectations or constraints tied to the role.

MarkUp Double False

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

MinimumExperience Int False

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

NumberofEmployees Bool False

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

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 candidate-engagement workflows.

OwnerId Int False

Represents the Id of the user who owns or manages the job order. This value supports accountability, workflow routing, and team-based reporting.

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 that is associated with the job order. This value supports scenarios that require additional rate tiers or alternate compensation structures.

Permfee Double False

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

PremiumJobBoards String False

Captures the list of premium job boards that are associated with the job order. This value supports multi-board distribution workflows and enhances posting visibility.

Priority Int False

Indicates the priority level that is associated with the job order. This value supports workflow routing, candidate-sourcing urgency, and visibility rules within job pipelines.

PublicCategory Int False

Represents the Id of the public-facing job category that is associated with the job order. This value supports job-board classification and helps determine posting visibility.

PublishedCategoryId Int False

Represents the Id of the published job category that is linked to the job order. This value supports external-posting alignment and ensures accurate category usage across job boards.

PublishedContactInfoId Int False

Represents the Id of the contact-information record that is associated with the published version of the job order. This value supports public-facing communication and directs inquiries appropriately.

PublishedDescription String False

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

PublishedZipCode String False

Captures the published ZIP code that is associated with the job order. This value supports geographic filtering, distribution targeting, and job-board search relevance.

PublishtoCorporateWeb Int False

Indicates whether the job order is published to the corporate website. This value supports posting visibility rules and determines distribution across organizational web channels.

ReasonClosed String False

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

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 alignment with client organizational structure.

ReportingtoOther String False

Captures descriptive information about any additional reporting contact that is associated with the job order. This value supports candidate screening and clarifies role reporting expectations.

Salary String False

Captures the base-salary information that is associated with the job order. This value supports compensation discussion and candidate suitability analysis.

ScheduledEnd Datetime False

Indicates the scheduled end date for the job assignment. This value supports timeline coordination, forecasting, and contract-management workflows.

ShiftId Int False

Represents the Id of the shift that is associated with the job order. This value supports scheduling alignment and ensures that candidate assignments match shift requirements.

Source String False

Captures the originating source of the job order. This value supports reporting, analytics, and workflow routing based on job-creation 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, workflow routing, and reporting across job pipelines.

Tax Double False

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

TaxPreference String False

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

TravelRequirements String False

Captures the travel requirements that are associated with the job order. This value supports candidate evaluation and clarifies expectations related to travel frequency or necessity.

UsersAssigned String False

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

VisaSponsorshipProvided Bool False

Returns a value of 'true' if the job order provides visa sponsorship. It returns a value of 'false' if 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 recruiters assess relocation compatibility.

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

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