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