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