Cmdlets for Bullhorn CRM

Build 25.0.9539

Tables

The cmdlet models the data in Bullhorn CRM as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cmdlets PowerShell Module for Bullhorn CRM Tables

Name Description
ActivityGoal Represents the collection of activity goals that define measurable performance expectations for users in Bullhorn CRM. This table supports reporting and analytics by providing goal definitions that are evaluated against actual activity metrics over time.
ActivityGoalConfiguration Captures the configuration settings that control how activity goals function within Bullhorn CRM. This table supports administrative workflows by defining system rules, thresholds, and behavior for goal tracking.
ActivityGoalTarget Represents the target values that are associated with specific activity goals. This table enables performance monitoring by linking goal definitions to measurable outcomes that are evaluated during activity reporting.
Appointment Represents 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.
AppointmentAttendee Captures the attendees who are associated with appointments in Bullhorn CRM. This table enhances scheduling workflows by specifying participant relationships and supporting collaboration and visibility across user teams.
AppointmentEditHistory Tracks the historical changes that are applied to appointment records. This table supports auditing and compliance by preserving a chronological record of updates that provide context for user actions and appointment lifecycle events.
AppointmentEditHistoryFieldChange Represents the individual field-level modifications that are associated with appointment edit history entries. This table supports detailed auditing by documenting which values are changed, when the changes occur, and how those changes affect appointment workflows.
BillableChargeEditHistory Tracks the historical updates that are applied to billable charge records in Bullhorn CRM. This table supports financial accuracy and auditability by maintaining a record of modifications across billing workflows.
BillableChargeEditHistoryFieldChange Represents the change to an individual field that appears in the edit history for a billable charge. This table enhances billing transparency by documenting value changes, adjustment reasons, and their effects on financial reporting.
Branch Represents organizational branches that define physical or operational locations within a company. This table supports segmentation and reporting by enabling users to group records by geographic region or internal business structure.
BusinessSector Represents the business sectors that classify industries or market segments. This table supports strategic reporting and candidate or client categorization by standardizing sector definitions across the Bullhorn CRM system.
Candidate Represents 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.
CandidateCertification Captures the certifications that are associated with candidates, including credentials, expiration dates, and verification details. This table supports compliance-driven workflows by enabling recruiters to validate and track required qualifications.
CandidateCertificationEditHistory Tracks historical updates that are applied to candidate certification records. This table supports audit and compliance requirements by documenting when certification details are changed and how those changes affect qualification status.
CandidateCertificationEditHistoryFieldChange Represents field-level changes that occur within certification edit history records. This table provides granular auditing capabilities by identifying which specific values are updated during certification lifecycle management.
CandidateCertificationRequirement Represents the certification requirements that must be met for roles, job submissions, or placements. This table supports staffing workflows by ensuring candidates meet mandatory qualifications before advancing through hiring stages.
CandidateCertificationRequirementEditHistory Tracks the historical changes that are applied to certification requirement records. This table supports compliance tracking by documenting modifications that can affect job qualifications or hiring workflows.
CandidateCertificationRequirementEditHistoryFieldChange Represents field-specific updates that occur within certification requirement edit history entries. This table supports granular auditing by identifying the values that are modified and the context for each change.
CandidateEducation Captures educational background details that are associated with candidate records. This table supports qualification evaluation by storing information that influences matching, vetting, and job submission processes.
CandidateFileAttachment Represents the files that are attached to candidate records, such as resumes, certifications, or documentation. This table supports document management workflows by enabling users to store, retrieve, and audit attachments that are linked to candidate profiles.
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.
CandidateReference Captures professional or personal references that are associated with candidate records. This table supports vetting workflows by storing reference details that recruiters use to validate candidate credibility and work history.
CandidateReferenceQuestion Represents the questions that are used during candidate reference checks. This table supports standardized evaluation by defining consistent prompts that measure candidate performance or behavior.
CandidateReferenceResponse Captures the responses that are provided by references during candidate evaluations. This table supports decision-making workflows by storing structured feedback that informs suitability assessments.
CandidateSource Represents the sources from which candidate records originate (for example, job boards, referrals, or internal submissions). This table supports reporting and performance tracking by enabling users to analyze sourcing effectiveness.
CandidateWorkHistory Captures past employment details that are associated with candidate profiles. This table supports qualification assessments by storing work experience that influences matching, vetting, and placement workflows.
Category Represents 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.
Certification Represents the certifications that users or candidates hold, including credential details or validity information. This table supports compliance and qualification tracking by defining the certifications that influence placement readiness.
CertificationGroup Represents groups of related certifications that are organized for compliance or workflow purposes. This table supports structured qualification management by grouping certifications that apply to similar roles or requirements.
CertificationRequirement Represents the certification requirements that must be met for specific roles, job submissions, or hiring stages. This table supports compliance enforcement by ensuring that required credentials are validated during placement workflows.
ClientContact Represents 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.
ClientContact1 Represents an alternative contact record structure for individuals who are associated with client corporations. This table supports legacy or variant data models by maintaining additional contact attributes that extend customer relationship workflows.
ClientContact2 Represents a supplemental contact configuration for individuals who are linked to client corporations. This table supports enhanced customer relationship management (CRM) processes by enabling the system to store additional relational or demographic details.
ClientContact3 Represents another variant of client contact records that support extended data structures within Bullhorn CRM. This table supports workflows that rely on specialized contact attributes for segmentation or engagement tracking.
ClientContact4 Represents a client contact record format that is designed for alternative or extended use cases. This table supports specialized customer relationship management (CRM) needs by providing additional schema options for storing client-related information.
ClientContact5 Represents an additional client contact table that stores alternative or system-specific contact attributes. This table supports complex customer relationship management (CRM) implementations by providing flexible structures for managing client relationships.
ClientContactFileAttachment Captures files (for example, contracts, forms, or communication documents) that are attached to client contact records. This table supports documentation workflows by enabling users to store, retrieve, and audit contact-related attachments.
ClientContactHistory Tracks historical changes that are applied to client contact records. This table supports auditing and visibility by documenting lifecycle updates that provide context for outreach, communication, or account management.
ClientCorporation Represents 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.
ClientCorporation1 Represents a variant structure for storing client corporation details. This table supports extended or legacy schema requirements by providing additional attributes that supplement core client data.
ClientCorporation2 Represents an additional schema variant for client corporation information. This table supports specialized workflows by enabling the system to store expanded organizational attributes that influence reporting or segmentation.
ClientCorporation3 Represents another alternate client corporation structure that supports extended customer relationship management (CRM) data needs. This table enhances customization by providing additional fields that organizations use for tailored reporting and analysis.
ClientCorporation4 Represents a client corporation table that supports unique or specialized implementations of the Bullhorn CRM data model. This table supports extended workflow scenarios by storing attributes not present in the core corporation record.
ClientCorporation5 Represents an additional client corporation variant that is used to support flexible data modeling in Bullhorn CRM. This table enhances reporting and workflow customization by storing extended company-level information.
ClientCorporationAppointment Captures appointments that are associated with client corporations. This table supports account management workflows by linking scheduled interactions to corporate entities for tracking engagement activity.
ClientCorporationCertification Represents certifications (for example, compliance or contract-related credentials) that are associated with client corporations. This table supports regulatory workflows by ensuring that required certifications remain tracked and visible.
ClientCorporationEditHistory Tracks historical changes that are applied to client corporation records. This table supports transparency and auditability by maintaining detailed logs of updates that affect organizational information.
ClientCorporationEditHistoryFieldChange Represents the update to an individual field that is recorded when a client corporation record is changed. This table supports granular auditing by identifying specific value changes and their effects on corporate data.
ClientCorporationFileAttachment Captures file attachments, including documents such as contracts, proposals, or compliance materials, that are associated with client corporation records. This table supports documentation workflows by enabling users to store and manage corporate files.
ClientCorporationHistory Captures lifecycle and historical events that relate to client corporation records. This table supports long-term analysis and relationship tracking by recording changes that influence account development.
ClientCorporationNote Represents notes that users create for client corporations. This table supports communication and account management workflows by storing contextual information that informs future interactions or follow-up actions.
ClientCorporationTask Represents tasks that are associated with client corporation records. This table supports activity planning and workflow management by enabling users to track to-do items, deadlines, and follow-up actions for client accounts.
CorporateUser Represents 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.
CorporationDepartment Represents departments that are associated with client corporations. This table supports organizational structuring by enabling users to segment corporate records for reporting, workflow routing, and relationship management.
Country Represents standardized country definitions that support address, localization, and regional reporting needs. This table enhances data consistency by ensuring that geographic values remain uniform across candidate, client, and job records.
Department Represents internal departments within a corporate organization. This table supports role-based workflows by organizing users, tasks, and activity metrics according to departmental structure.
EntityFieldTypeLookup Represents lookup values that define the data types that are assigned to entity fields across Bullhorn CRM. This table supports schema interpretation by helping the system determine validation rules, data formats, and field behaviors.
GoalTarget Represents the target values that are assigned to performance goals across Bullhorn CRM. This table supports performance monitoring by defining measurable outcomes that users compare against actual activity results during reporting.
HousingComplex Represents housing complexes that are available for candidate or contractor placement. This table supports housing coordination workflows by storing location details that affect onboarding, relocation, and assignment planning.
HousingComplexAmenity Represents amenities (for example, utilities or facility features) that are associated with housing complexes. This table supports housing suitability assessments by enabling users to determine whether a complex meets specific placement requirements.
HousingComplexFurnitureDelivery Represents furniture delivery records that are associated with housing complexes. This table supports logistical coordination by tracking delivery details that influence move-in preparation and candidate placement readiness.
HousingComplexUnit Represents individual housing units within a housing complex. This table supports placement assignments by storing unit-level characteristics that recruiters and coordinators use when securing accommodations.
HousingComplexUtilityAccount Represents utility accounts that are associated with units in a housing complex. This table supports operational and financial tracking by capturing account information that affects billing, setup, and service coordination.
JobBoardPost Represents job board posting records that define how job orders are published externally. This table supports recruiting and outreach workflows by storing posting metadata that influences job visibility, distribution, and application flow.
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.
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.
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.
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.
JobOrder4 Represents a job order variant that supports additional data modeling requirements. This table enhances customization by allowing recruiters and administrators to store specialized job attributes that affect workflow routing and reporting.
JobOrder5 Represents a fifth variant of job order data that is used in specialized customer relationship management (CRM) implementations. This table supports configuration flexibility by providing extra fields that capture unique job-related information.
JobOrderEditHistory Tracks historical changes that are applied to job order records. This table supports auditing and transparency by documenting lifecycle updates that affect job requirements, status changes, or recruiter actions.
JobOrderEditHistoryFieldChange Represents the field-level updates that occur within job order edit history entries. This table supports granular review by identifying individual value changes that influence reporting and compliance tracking.
JobOrderFileAttachment Captures files (for example, job descriptions, compliance forms, or client documentation) that are attached to job order records. This table supports document management by enabling users to store, retrieve, and audit job-related attachments.
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.
JobOrderTemplate Represents job order templates that define reusable configurations for creating new job orders. This table supports efficiency and consistency by enabling users to prepopulate common job attributes that streamline the job creation process.
JobSubmission Represents 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.
JobSubmissionCertificationRequirement Represents certification requirements that apply to specific job submissions. This table supports compliance and qualification workflows by ensuring that candidates meet role-specific certification expectations before progressing.
JobSubmissionCertificationRequirementEditHistory Tracks the historical updates that are applied to job submission certification requirements. This table supports audit and compliance visibility by documenting changes that influence candidate qualification status.
JobSubmissionCertificationRequirementEditHistoryFieldChange Represents field-level modifications that occur within job submission certification requirement edit history entries. This table supports granular auditing by identifying specific values that are changed and their impact on compliance assessments.
JobSubmissionEditHistory Tracks historical changes that are applied to job submission records. This table supports transparency and evaluation by preserving a chronological record of updates that affect candidate submission progress.
JobSubmissionEditHistoryFieldChange Represents individual field-level updates that occur within job submission edit history entries. This table supports detailed auditing by identifying which values are modified and how those changes influence submission workflows.
JobSubmissionHistory Captures lifecycle and historical events that relate to job submission records. This table supports long-term reporting and workflow analysis by tracking candidate movement across submission 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.
LocationEditHistory Tracks historical updates that are applied to location records. This table supports auditing and record accuracy by documenting changes that affect operational or geographic information.
LocationEditHistoryFieldChange Captures field-level changes that appear within location edit history records. This table supports granular auditing by identifying the specific values that are updated and their significance in location management.
LocationEffectiveDateChange Captures effective date changes that apply to Location records. This table supports time-based accuracy by storing date transitions that influence location validity, assignment rules, or billing periods.
LocationVersion Stores versioned snapshots of Location records. This table supports historical tracking and analysis by preserving earlier states that provide context for location-related decisions.
Note Represents 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.
NoteEntity Represents the relationships between notes and the entities they reference. This table supports cross-entity visibility by linking notes to records such as candidates, jobs, or client contacts for context and retrieval.
Opportunity Represents 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.
OpportunityEditHistory Tracks historical updates that are applied to Opportunity records. This table supports sales accountability by documenting lifecycle changes that affect forecasting, pipeline management, and revenue analysis.
OpportunityEditHistoryFieldChange Captures the change to an individual field that is recorded when an opportunity record is updated. This table supports granular pipeline auditing by identifying precise updates that influence opportunity progress.
OpportunityFileAttachment Captures files that are attached to opportunity records, including proposals, contracts, or supporting documents. This table supports sales documentation workflows by enabling users to store and access materials that support opportunity advancement.
PayableChargeEditHistory Tracks historical updates that are applied to payable charge records. This table supports financial integrity by recording changes that impact billing, cost allocations, and reconciliation workflows.
PayableChargeEditHistoryFieldChange Captures the change to an individual field that is recorded when a payable charge is updated. This table supports detailed financial auditing by identifying the specific modifications that influence payable reporting and accounting accuracy.
Person Represents person records that store profile attributes for individuals involved in Bullhorn CRM workflows. This table supports entity linking and profile management by centralizing information that can be reused across candidates, client contacts, and other record types.
Placement Represents 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.
Placement1 Stores an alternative structure for placement data that is used in extended or legacy configurations. This table supports workflow flexibility by providing additional fields that tailor placement tracking to specialized business requirements.
Placement2 Stores a supplemental placement schema for environments that require extended placement attributes. This table supports advanced reporting and workflow logic by capturing data elements that extend the core placement model.
Placement3 Stores a placement record variation used for custom or specialized implementations. This table enhances operational flexibility by accommodating additional placement attributes that influence internal processes.
Placement4 Stores an extended placement schema variation that supports specialized staffing workflows. This table strengthens customization by supplementing standard placement details with organization-specific attributes.
Placement5 Stores a fifth placement variant that supports flexible or legacy deployment scenarios. This table supports tailored workflow needs by capturing placement-related data that extends beyond the core model.
PlacementCertification Represents certifications that are associated with candidate placements. This table supports compliance and contract requirements by ensuring that placements remain aligned with required credentials throughout their lifecycle.
PlacementCertificationEditHistory Tracks historical updates that are applied to placement certification records. This table supports compliance visibility by documenting changes that affect whether a placement satisfies required credential standards.
PlacementCertificationEditHistoryFieldChange Captures the change to an individual certification field that is recorded when a placement certification is updated. This table supports granular compliance auditing by identifying specific value modifications that influence placement eligibility and regulatory requirements.
PlacementChangeRequest Represents change requests that apply to placement records, including adjustments to dates, rates, or assignment details. This table supports approval workflows by tracking proposed modifications that require review before updates can be applied.
PlacementChangeRequestEditHistory Tracks historical updates that are applied to placement change request records. This table supports transparency by documenting the evolution of change requests and their impact on placement management.
PlacementChangeRequestEditHistoryFieldChange Captures the change to an individual field that is recorded when a placement change request is updated. This table supports detailed auditing by identifying specific modifications that influence proposed placement adjustments and their approval outcomes.
PlacementCommission Represents 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.
PlacementCommissionEditHistory Tracks the historical updates that are applied to placement commission records. This table supports financial auditing by documenting modifications that affect commission calculations and payout reporting.
PlacementCommissionEditHistoryFieldChange Captures the change to an individual field that is recorded when a placement commission is updated. This table supports granular financial oversight by identifying specific commission value modifications and the context for each change.
PlacementEditHistory Tracks historical updates that are applied to placement records. This table supports compliance, payroll, and client reporting by documenting lifecycle changes that affect assignment details and employment status.
PlacementEditHistoryFieldChange Captures field-level modifications that occur within placement edit history entries. This table supports detailed auditing by identifying individual value changes that influence payroll, billing, or contractual obligations.
PlacementFileAttachment Captures the files that are attached to placement records, including contracts, onboarding documents, and compliance materials. This table supports documentation workflows by enabling users to store, retrieve, and audit placement-related files.
PlacementRateCard Defines the rate card configurations that set pay and bill rate structures for placements. This table supports financial accuracy by standardizing compensation arrangements that guide invoicing, payroll, and profitability analysis.
PlacementRateCardLine Stores the individual line items that belong to placement rate cards. This table supports rate management by capturing detailed compensation components that influence billing rules and payroll calculations.
PlacementRateCardLineGroup Organizes groups of related rate card lines that structure complex compensation models. This table supports financial modeling by grouping rate components that apply to specific roles, departments, or contract types.
PrimaryEntityToAssociatedEntityAssociations Represents the relationships between a primary entity and its associated entity, including the identifier (Id) values that link related records. This table supports relational integrity by storing associations that define how records interact across the Bullhorn CRM data model.
Report Stores report definitions that contain configuration details for generating analytics within Bullhorn CRM. This table supports business intelligence by enabling users to create, manage, and execute structured reports for operational insights.
SalesQuota Represents sales quota assignments that define performance targets for users or teams. This table supports sales management by storing goal values that influence tracking, forecasting, and incentive programs.
SalesTaxRateEditHistory Tracks historical updates that are applied to sales tax rate records. This table supports financial compliance by documenting changes that affect tax calculations and regulatory reporting.
SalesTaxRateEditHistoryFieldChange Captures the change to an individual field that is recorded when a sales tax rate is updated. This table supports financial auditing and accuracy by identifying specific tax rate value modifications and evaluating their impact on billing and compliance.
SalesTaxRateEffectiveDateChange Captures effective date changes that apply to sales tax rate records. This table supports time-based financial accuracy by storing information that determines when tax rates become active or expire.
Sendout Represents Sendout records that document when candidate profiles are submitted to client contacts for review. This table supports recruiter-client collaboration by tracking which candidates are forwarded, when they are sent, and how clients respond.
Shift Represents Shift records that define work schedule segments for placements or assignments. This table supports timekeeping, scheduling, and billing workflows by storing shift parameters that influence payroll and operational planning.
Skill Represents 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.
Specialty Represents specialty categories that further define candidate expertise or job requirements. This table supports refined talent matching by allowing recruiters to apply more specific classification criteria.
State Represents state or provincial geographic definitions that are used in addresses and regional reporting. This table supports data consistency by standardizing location attributes across candidate, client, and job records.
Task Represents 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.
TaskEditHistory Tracks historical updates that are applied to task records. This table supports accountability and workflow transparency by preserving a record of changes that affect task status, ownership, or scheduling.
TaskEditHistoryFieldChange Captures the change to an individual field that is recorded when a task is updated. This table supports granular auditing by identifying specific value modifications and explaining how those changes influence workflow progress.
Tearsheet Represents tearsheets, which are curated lists of candidates or contacts used for marketing, sourcing, or outreach campaigns. This table supports targeted communication by organizing groups of records that recruiters engage during coordinated outreach.
TearsheetMember Represents the individual members that belong to a tearsheet list. This table supports list management by storing associations between tearsheets and the candidates or contacts they include.
TearsheetRecipient Represents the intended recipients of tearsheet-related communications. This table supports outreach workflows by tracking which individuals should receive marketing or informational messages associated with a tearsheet.
TimeUnit Represents standardized time units that are used across billing, payroll, and scheduling workflows. This table supports consistent time calculations by defining units such as hours, days, or weeks for operational processes.
UserEditHistory Tracks historical updates that are applied to user records. This table supports administrative oversight by documenting changes that affect system access, user roles, or personal information.
UserEditHistoryFieldChange Captures the change to an individual field that is recorded when a user record is updated. This table supports granular administrative auditing by identifying updates that affect user configuration or permissions.
UserHousingComplexUnit Stores the associations between users and housing complex units. This table supports operational workflows by tracking user assignments or responsibilities that relate to housing management activities.
UserPulseCallLog Captures call log entries that are generated by the UserPulse feature in Bullhorn CRM. This table supports performance analytics and relationship tracking by storing details about user-initiated calls.
UserPulseCallLogContact Stores the contacts that are linked to UserPulse call log entries. This table supports outreach analysis by connecting call activity to specific client or candidate interactions.
UserType Represents user type definitions that categorize system users by their roles or access levels. This table supports permission management by assigning role-based capabilities across the Bullhorn CRM system.
WorkersCompensation Represents 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.
WorkersCompensationRate Stores rate information that is associated with workers' compensation classifications. This table supports accurate financial calculations by capturing rate values that are used in payroll, invoicing, and cost analysis.
ZipCodeGis Represents geographic information system (GIS) data that is associated with ZIP codes. This table supports location-based analysis by storing spatial attributes that influence routing, territory planning, and regional reporting.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539