JobOrder2
Represents a supplemental structure for job order data used in specialized implementations. This table supports customized workflows by storing additional fields that influence job filtering, matching, and reporting.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) for the JobOrder2 record in Bullhorn CRM. This value supports job-management workflows, audit tracking, and cross-referencing across related job-order entities. |
| 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. |
| AdditionalKeywords | String | False |
Captures additional keywords that are associated with the job order. This value supports enhanced search optimization and improves matching accuracy for candidate queries. |
| AddressAddress | String | False |
Captures the primary street address that is associated with the job location. This value supports geographic filtering, mapping functions, and proximity-based candidate searches. |
| AddressCity | String | False |
Indicates the city that is associated with the job location. This value supports regional reporting and contributes to accurate geographic categorization. |
| AddressCountry | Int | False |
Represents the Id of the country that is associated with the job location. This value supports standardized geographic classification and ensures consistency across integrated systems. |
| AddressState | String | False |
Indicates the state or provincial region that is associated with the job location. This value supports territory-based reporting and improves region-specific filtering. |
| AddressZip | String | False |
Captures the ZIP code that is associated with the job location. This value supports postal validation, search precision, and location-based filtering. |
| AllowClienttoEditJob | Bool | False |
Returns a value of 'true' if the client is permitted to edit the job order through designated client-facing interfaces. It returns a value of 'false' if editing permissions are restricted to internal users. |
| Benefits | String | False |
Captures the benefits information that is associated with the job opportunity. This value supports candidate-engagement workflows by presenting supplemental compensation details. |
| BillRateCategory | Int | False |
Represents the Id of the bill-rate category that is associated with the job order. This value supports financial modeling, pricing configuration, and client-specific billing structures. |
| BonusPackage | String | False |
Captures the bonus-package information that is associated with the job order. This value supports compensation planning and helps recruiters communicate incentive 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. |
| BranchID | Int | False |
Represents the Id of the branch that is responsible for the job order. This value supports workflow routing, ownership assignment, and region-based analytics. |
| CertificationRequirements | String | False |
Captures the certification requirements that are associated with the job order. This value supports candidate qualification screening and ensures compliance with client-mandated credentials. |
| ClientBillRate | String | False |
Indicates the bill rate that is associated with the client for this job order. This value supports financial evaluation and informs margin analysis and rate negotiations. |
| ClientCompanyId | Int | False |
Represents the Id of the client company that is associated with the job order. This value supports client-level reporting, relationship tracking, and job-order grouping. |
| ClientCostCenter | String | False |
Captures the client cost-center information that is associated with the job order. This value supports internal accounting workflows and contributes to project-to-department mapping. |
| ContactId | Int | False |
Represents the Id of the primary client contact who is associated with the job order. This value supports relationship management and ensures accurate communication routing. |
| DateAdded | Datetime | False |
Indicates the date and time when the JobOrder2 record is created in Bullhorn CRM. This value supports audit compliance, lifecycle tracking, and reporting. |
| DateClosed | Datetime | False |
Indicates the date when the job order is formally closed. This value supports lifecycle management and prevents closed jobs from appearing in active candidate searches. |
| DateLastExported | Datetime | False |
Indicates the date when the job order is most recently exported to an external system. This value supports integration tracking and ensures synchronization with third-party platforms. |
| DateLastPublished | Datetime | False |
Indicates the date when the job order is most recently published. This value supports visibility monitoring across distribution channels and helps teams manage posting refresh cycles. |
| DegreeRequirements | String | False |
Captures the degree requirements that are associated with the job order. This value supports qualification filtering and helps recruiters evaluate candidate suitability. |
| EducationRequirements | String | False |
Captures the educational requirements that are associated with the job order. This value supports screening workflows and helps ensure role-alignment during candidate evaluation. |
| Employment | String | False |
Captures the employment classification that is associated with the job order. This value supports searching, reporting, and categorization within job pipelines. |
| ExternalID | String | False |
Captures the external system Id that is associated with the job order. This value supports platform synchronization and ensures correct mapping between internal and external job records. |
| HourlyCommitment | Double | False |
Indicates the expected hourly commitment that is associated with the job order. This value supports scheduling accuracy, workforce planning, and candidate-availability matching. |
| HoursofOperation | String | False |
Captures the hours of operation that are associated with the job opportunity. This value supports expectation setting and ensures candidate alignment with role scheduling. |
| Interviewrequired | Bool | False |
Returns a value of 'true' if candidates are required to complete an interview for the job order. It returns a value of 'false' if an interview is not required for placement consideration. |
| JobBoardList | String | False |
Captures the list of job boards that are associated with the job order. This value supports distribution management and helps teams monitor posting visibility across platforms. |
| JobBoardPublishing | Int | False |
Indicates the job-board publishing status that is associated with the job order. This value supports posting workflows and determines where the job is distributed externally. |
| JobDescription | String | False |
Captures the full job-description text for the JobOrder2 record. This value supports recruiter communication, candidate engagement, and job-board display formatting. |
| JobDuration | Double | False |
Indicates the expected duration of the job assignment. This value supports contract planning, forecasting, and evaluation of candidate availability. |
| JobTitle | String | False |
Captures the job title that is associated with the JobOrder2 record. This value supports search relevance, candidate engagement, and job-board display accuracy. |
| LastUpdated | Datetime | False |
Indicates the date and time when the JobOrder2 record is most recently updated. This value supports audit tracking and helps teams monitor changes to job details. |
| LocationId | Int | False |
Represents the Id of the location record that is associated with the job order. This value supports geographic assignment, filtering, and reporting across job regions. |
| LocationRequirements | String | False |
Captures the location requirements that are associated with the job order. This value supports recruiter screening and clarifies any geographic constraints that affect candidate eligibility. |
| MarkUp | Double | False |
Indicates the markup percentage that is associated with the job order. This value supports pricing analysis, margin calculations, and financial planning. |
| MinimumExperience | Int | False |
Indicates the minimum years of experience that are required for the job order. This value supports candidate qualification assessment and ensures alignment with client 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 information is 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 information about the options or incentive package that is associated with the job order. This value supports candidate-engagement workflows and compensation presentation. |
| OwnerId | Int | False |
Represents the Id of the user who owns or manages the job order. This value supports assignment clarity, workflow routing, and accountability tracking. |
| PayRate | String | False |
Captures the primary pay-rate information that is associated with the job order. This value supports compensation modeling and provides clarity during candidate discussions. |
| PayRate2 | String | False |
Captures the secondary pay-rate information that is associated with the job order. This value supports roles that require multiple rate structures or alternative compensation tiers. |
| Permfee | Double | False |
Indicates the permanent-placement fee that is associated with the job order. This value supports financial forecasting and contributes to compensation planning. |
| Priority | Int | False |
Indicates the priority level that is associated with the job order. This value supports workflow triage, resource allocation, and urgency-based reporting. |
| 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 ensures accurate posting structure. |
| PublishedCategoryId | Int | False |
Represents the Id of the category that is used when the job order is published externally. This value supports posting accuracy and categorization across distribution channels. |
| PublishedContactInfoId | Int | False |
Represents the Id of the published-contact-information record that is associated with the job order. This value supports public inquiries, routing, and candidate communication. |
| PublishedDescription | String | False |
Captures the publicly visible job description that is associated with the JobOrder2 record. This value supports candidate attraction and ensures clarity during job-board display. |
| PublishedZipCode | String | False |
Captures the published ZIP code that is associated with the job order. This value supports geographic filtering, posting distribution, and search optimization. |
| ReasonClosed | String | False |
Captures the reason why the job order is closed. This value supports operational reporting, lifecycle analysis, and historical review. |
| ReportingtoContactId | Int | False |
Represents the Id of the client contact to whom the candidate will report. This value supports role clarity and ensures accurate organizational alignment. |
| ReportingtoOther | String | False |
Captures descriptive information about any additional reporting party that is associated with the job order. This value supports candidate screening and organizational-context communication. |
| Salary | String | False |
Captures the salary information that is associated with the job order. This value supports compensation evaluation, transparency, and candidate-matching workflows. |
| ScheduledEnd | Datetime | False |
Indicates the scheduled end date for the job assignment. This value supports contract management, project planning, and forecasting of role duration. |
| ShiftId | Int | False |
Represents the Id of the shift that is associated with the job order. This value supports scheduling accuracy and ensures alignment between candidate availability and role requirements. |
| Source | String | False |
Captures the originating source of the job order. This value supports lead tracking, workflow routing, and analytics related to job creation. |
| StartDate | Datetime | False |
Indicates the start date that is associated with the job assignment. This value supports onboarding coordination and synchronization with candidate availability. |
| Status | String | False |
Indicates the current status of the job order. This value supports workflow management, search filtering, and job-pipeline reporting. |
| 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 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 or regulatory requirements. |
| TravelRequirements | String | False |
Captures the travel requirements that are associated with the job order. This value supports candidate evaluation and clarifies expectations regarding travel obligations. |
| UsersAssigned | String | False |
Captures the list of users who are assigned to the job order. This value supports collaboration, task delegation, and visibility across recruiting teams. |
| 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 suitability evaluations and relocation-related screening. |
| 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 workflows and cost-modeling processes. |
| IsDeleted | Bool | False |
Returns a value of 'true' if the JobOrder2 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 execution. |