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