The provider models entities in the Bullhorn CRM API as an easy-to-use SQL database, using tables, views, stored procedures, and system tables. These tables, views, and stored procedures are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Bullhorn CRM account.

Note: The provider exposes saved searches as views that follow the naming convention SavedSearch_<name of saved search>. See SavedSearch_My_saved_search for an example.

The following table includes a list of common tables and views:

Table	Description
Appointment	Provides appointment records that track scheduled interactions between users, candidates, and clients. This table supports workflow management by enabling users to organize meetings, synchronize schedules, and review engagement histories.
Candidate	Specifies candidate records that store personal, professional, and placement-related information within Bullhorn CRM. This table supports recruiting workflows by enabling searching, matching, tracking, and qualification management.
CandidateHistory	Captures historical changes that are associated with candidate records. This table supports auditing, reporting, and workflow tracking by recording lifecycle updates that provide context for candidate progression.
Category	Specifies categories that classify records across Bullhorn CRM (for example, skills, specialties, or organizational groupings). This table supports filtering, searching, and reporting by standardizing classification values."
ClientContact	Stores contact records for individuals who are associated with client corporations. This table supports client relationship management by storing communication details that enable users to coordinate outreach and track engagement history.
ClientCorporation	Stores client corporation records that store company-level information for organizations that engage with the recruiting process. This table supports sales, account management, and placement workflows by serving as the core entity for client relationships.
CorporateUser	Stores system user accounts that belong to a corporate organization within Bullhorn CRM. This table supports authentication, permission management, and activity tracking by storing details about internal or external users who access the system.
Department	Lists internal departments within a corporate organization. This table supports role-based workflows by organizing users, tasks, and activity metrics according to departmental structure.
EntityFiles	Specifies the set of files that are attached to entities within Bullhorn CRM. This view supports document management workflows by allowing users to identify, access, and review attachments that relate to records such as candidates, job orders, or client contacts.
JobOrder	Stores 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.
JobOrderHistory	Captures lifecycle and historical events that relate to job order records. This table supports long-term analysis by tracking changes that influence recruiting metrics, client activity, and job order progression.
JobSubmission	Stores job submission records that link candidates to job orders during the recruiting lifecycle. This table supports placement workflows by tracking submission status, recruiter actions, and candidate progress across hiring stages.
Location	Represents physical or organizational locations that are associated with corporate or client entities. This table supports operational workflows by storing address, region, and location attributes that influence assignment, billing, and reporting.
Note	Captures user-created notes that store freeform or structured commentary that is associated with Bullhorn CRM entities. This table supports communication, documentation, and relationship management by capturing contextual information that informs future actions.
Opportunity	Stores sales opportunity records that track potential revenue-generating engagements with clients or prospects. This table supports business development workflows by storing opportunity stages, activities, and forecasting information.
Placement	Stores placement records that define confirmed assignments of candidates to job orders. This table supports billing, payroll, and lifecycle management by storing placement details such as assignment dates, rates, and status changes.
PlacementCommission	Stores commission records that are associated with candidate placements. This table supports financial tracking by storing commission amounts, allocation details, and the relationships between recruiters, sales representatives, and finalized placement activity.
Skill	Specifies standardized skills that classify candidate qualifications or job requirements. This table supports searching, matching, and reporting by ensuring that skills remain consistent across recruiting workflows.
Task	Stores task records that track actionable items assigned to users or teams. This table supports workflow management by documenting to-do items, deadlines, and follow-up activities across customer Bullhorn CRM processes.
WorkersCompensation	Provides workers' compensation classifications that apply to placements or job orders. This table supports compliance and risk management by defining coverage categories that influence insurance costs and regulatory reporting.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including retrieving and deleting event messages as well as managing authentication tokens.