ODBC Driver for Bullhorn CRM

Build 25.0.9539

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.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) that is assigned to the Placement table. This value establishes the primary reference that is used when linking a Placement record to related entities throughout Bullhorn CRM.

Changesapproved Int False

Indicates the number of approved changes that is associated with the Placement record. This value supports auditing and reconciliation processes that track modifications over time.

Changeswaitingapproval Int False

Identifies the number of pending changes that is awaiting approval for the Placement record. This value enables monitoring of outstanding updates that require review before becoming effective.

Expiringcredentials Int False

Tracks the number of credentials that is nearing expiration for the Placement record. This information assists compliance workflows that ensure all credentials remain current during the placement lifecycle.

Incompleterequirements Int False

Captures the number of outstanding requirements that is associated with the Placement record. This value supports operational processes that monitor onboarding, verification, and compliance tasks.

ApprovingClientContactId Int False

Specifies the client contact Id that is designated as the primary approver for the Placement record. This reference supports approval routing and communication workflows that involve the client's designated decision maker.

BackupApprovingClientContactId Int False

Specifies the client contact Id that is identified as the backup approver for the Placement record. This value provides redundancy for approval workflows when the primary approver is unavailable.

BillingContactId Int False

Specifies the contact Id that is assigned as the billing contact for the Placement record. This value supports billing coordination and ensures accurate communication with the appropriate financial representative.

BillingFrequency String False

Specifies the billing frequency that is configured for the Placement record. This value informs invoicing schedules and downstream financial processes.

BillRate Double False

Captures the bill rate that is associated with the Placement record. This value contributes to invoice generation, revenue calculations, and margin analysis.

BonusPackage String False

Describes the bonus package that is connected to the Placement record. This value supports compensation modeling and internal reporting that tracks placement-related incentives.

BranchID Int False

Identifies the branch Id that is associated with the Placement record. This reference enables regional reporting, assignment routing, and organizational hierarchy alignment.

CandidateId Int False

Specifies the candidate Id that is linked to the Placement record. This value forms the core relationship between the Placement record and the candidate who is assigned to the job.

CanEnterTime Bool False

Returns a value of 'true' when the Placement record allows the candidate to enter time. It returns a value of 'false' when the Placement record restricts time entry based on configuration or workflow conditions.

ClientContactId Int False

Specifies the client contact Id that is associated with the Placement record. This value identifies the client's representative who is responsible for communication and oversight during the placement.

Comments String False

Captures internal comments that are recorded for the Placement record. This information supports collaboration and provides historical context for operational and account-management activities.

CompanyId Int False

Specifies the company Id that is associated with the Placement record. This reference connects the placement to the hiring organization within Bullhorn CRM.

CostCenter String False

Specifies the cost center that is assigned to the Placement record. This value assists accounting and reporting workflows that allocate costs to the proper organizational unit.

DateAdded Datetime False

Records the datetime stamp that is applied when the Placement record is first created. This value supports historical tracking, auditing, and chronological filtering.

DateLastModified Datetime False

Captures the datetime stamp that is recorded when the Placement record is most recently updated. This information enables audit reconciliation and informs processes that depend on the latest data values.

DaysGuaranteed Int False

Indicates the number of guaranteed days that is defined for the Placement record. This value supports financial modeling and contract compliance monitoring.

DaysproRated Int False

Specifies the number of prorated days that is calculated for the Placement record. This value influences billing, compensation, and agreement-related calculations.

EffectiveDate Datetime False

Specifies the effective date that is assigned to the Placement record. This date determines when the placement becomes active for reporting, billing, and workflow operations.

EffectivedateClient Datetime False

Captures the client-specific effective date that is defined for the Placement record. This value supports client-driven scheduling, milestone tracking, and coordinated start-date alignment.

EmployeeType String False

Identifies the employee type that is associated with the Placement record. This classification informs payroll processes, benefits treatment, and compliance configuration.

EmploymentType String False

Specifies the employment type that is defined for the Placement record. This value drives eligibility rules, reporting groupings, and workflow routing.

HoursofOperation String False

Describes the hours of operation that is associated with the Placement record. This information supports scheduling, availability management, and operational planning.

HoursPerDay Double False

Captures the number of hours per day that is expected for the Placement record. This value supports timesheet validation, labor modeling, and scheduling processes.

HousingManager Int False

Specifies the user or contact Id that is designated as the housing manager for the Placement record. This reference supports housing coordination and logistical workflows.

HousingStatus String False

Indicates the housing status that is associated with the Placement record. This value enables tracking of housing arrangements as part of onboarding or ongoing assignment management.

InvoiceGrouping String False

Specifies the invoice grouping configuration that is applied to the Placement record. This value determines how related charges and transactions are organized during invoice generation.

JobDuration Double False

Captures the job duration that is associated with the Placement record. This value supports contract planning, forecasting, and compliance with job-length requirements.

JobId Int False

Specifies the job Id that is connected to the Placement record. This reference creates the relationship between the placement and the job order to which the candidate is assigned.

LastApprovedPlacementChangeRequestId Int False

Identifies the Id of the most recent placement change request that is approved for the Placement record. This reference supports audit trails and ensures visibility into approved modifications.

LocationId Int False

Specifies the location Id that is associated with the Placement record. This value links the placement to a defined worksite location for scheduling, billing, and reporting activities.

MarkUp Double False

Represents the markup amount that is applied to the placement's pay-to-bill calculation. This value supports margin analysis and downstream financial reporting.

MigrateGUID String False

Represents the globally unique migration Id that is associated with the Placement record. This value enables system synchronization and ensures continuity when records originate from external data sources.

OptionsPackage String False

Specifies the options package that is associated with the Placement record. This value is referenced during contract setup and may influence compensation or billing structures.

OtherHourlyFee Double False

Represents the additional hourly fee that is associated with the Placement record. This value contributes to total billable calculations and may affect profitability reporting.

OtherHourlyFeeComments String False

Specifies comments regarding the additional hourly fee that is associated with the Placement record. This value supports auditability and provides clarification for finance and payroll teams.

OtmarkUp Double False

Represents the overtime markup value that is applied to the Placement record. This value influences cost and bill calculations for hours that exceed standard thresholds.

OverTimebillrate Double False

Specifies the overtime bill rate that is associated with the Placement record. This value defines the billed amount for qualifying overtime hours in client invoicing.

OverTimepayrate Double False

Represents the overtime pay rate that is associated with the Placement record. This value is used during payroll processing to calculate earnings for overtime work.

OvertimeExemption Int False

Specifies the overtime-exemption value that is associated with the Placement record. This value informs compliance and determines how overtime rules apply during payroll and billing.

OwnerId Int False

Represents the owner identifier (Id) that is assigned to the Placement record. This value designates the responsible internal user for workflow, visibility, and reporting.

PayRate String False

Specifies the pay rate that is associated with the Placement record. This value feeds payroll calculations and may affect margin and compensation reporting.

PayUnit String False

Represents the pay-unit designation that is associated with the Placement record. This value determines the interval or unit on which payroll amounts are calculated.

Placementfee Double False

Represents the placement fee that is associated with the Placement record. This value influences revenue recognition and may be included in client invoicing.

PlacementfeeFlat Double False

Specifies the flat placement fee that is associated with the Placement record. This value overrides percentage-based fee logic when applicable.

ProjectCodeList String False

Specifies the project codes that are associated with the Placement record. This value enables categorization for billing, accounting, and project-level reporting.

QuitJob Bool False

Returns a value of 'true' if the placement is flagged as a quit. It returns a value of 'false' if the placement is not flagged as a quit.

RateEntryType Bool False

Returns a value of 'true' if the rate entry type that is associated with the Placement record is configured as user-entered. It returns a value of 'false' if the rate is derived or system-calculated.

RecruitingmanagercommissionoverRide Double False

Represents the recruiting-manager override commission that is associated with the Placement record. This value contributes to commission calculations used during payroll and financial reporting.

ReferralFee String False

Specifies the referral fee that is associated with the Placement record. This value supports revenue tracking and referral-program audits.

ReferralFeeType String False

Represents the referral-fee type that is associated with the Placement record. This value determines how referral fees are calculated or categorized within financial workflows.

ReportedMargin Double False

Specifies the reported margin that is associated with the Placement record. This value supports profitability evaluation and financial analytics.

Reportingto String False

Represents the reporting-to designation that is associated with the Placement record. This value provides the supervisory or client-contact context required for operational and payroll workflows.

Salary String False

Specifies the salary value that is associated with the Placement record. This value supports compensation determination for placements using salaried structures.

SalesmanagercommissionoverRide Double False

Represents the sales-manager override commission that is associated with the Placement record. This value contributes to commission distribution calculations used by finance teams.

ScheduledEnd Datetime False

Specifies the scheduled end date for the Placement record. This value informs contract management, forecasting, and expected termination workflows.

ShiftId Int False

Represents the shift identifier (Id) that is associated with the Placement record. This value defines the working schedule that applies to payroll and resource-planning processes.

StartDate Datetime False

Specifies the start date for the Placement record. This value initiates payroll eligibility, scheduling, and contract-tracking logic.

StatementContactId Int False

Represents the statement-contact Id that is associated with the Placement record. This value identifies the billing contact used during invoice-generation workflows.

Status String False

Specifies the status that is associated with the Placement record. This value drives workflow behavior, visibility rules, and eligibility for payroll and invoicing processes.

SubmissionId Int False

Represents the submission identifier (Id) that is associated with the Placement record. This value links the placement back to the originating job-submission workflow.

Tax Double False

Specifies the tax amount that is associated with the Placement record. This value is applied during payroll and invoicing calculations to meet compliance requirements.

TaxState String False

Represents the tax state that is associated with the Placement record. This value determines jurisdiction for payroll, tax withholding, and regulatory calculations.

TerminationReason String False

Specifies the termination reason that is associated with the Placement record. This value supports auditability, compliance reporting, and end-of-assignment workflows.

UmbrellaCompanyId Int False

Represents the umbrella-company Id that is associated with the Placement record. This value defines the third-party management or payroll provider responsible for processing the worker.

WorkersCompCodeId Int False

Specifies the workers-compensation code Id that is associated with the Placement record. This value determines insurance, compliance classification, and risk-management categorization.

WorkWeekBegin Int False

Represents the work-week starting day that is associated with the Placement record. This value determines how time entry, overtime calculations, and payroll weeks are aligned.

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