JDBC Driver for Bullhorn CRM

Build 25.0.9539

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.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the Placement1 record. This value uniquely distinguishes the Placement1 record within Bullhorn CRM and is used throughout financial, payroll, and workflow processes.

Changesapproved Int False

Captures the number of changes that are approved for the Placement1 record. This value supports audit reporting and provides visibility into placement modifications that have progressed through approval workflows.

Changeswaitingapproval Int False

Captures the number of changes that are waiting for approval for the Placement1 record. This value helps track pending updates and supports operational oversight of approval queues.

Expiringcredentials Int False

Indicates the number of credentials that are nearing expiration for the Placement1 record. This information supports compliance workflows that monitor expiring documents and certifications.

Incompleterequirements Int False

Identifies the count of incomplete requirements that are associated with the Placement1 record. This value supports onboarding and compliance processes that verify all placement prerequisites.

ApprovingClientContactId Int False

Specifies the client contact identifier (Id) that is designated as the approver for the Placement1 record. This reference supports approval routing and tracks the responsible decision-maker.

BackupApprovingClientContactId Int False

Identifies the backup client contact Id that is assigned to the Placement1 record. This value provides redundancy in approval workflows when the primary approver is unavailable.

BillingContactId Int False

Captures the billing contact Id that is associated with the Placement1 record. This reference ensures that invoices and billing communications reach the correct client representative.

BillingFrequency String False

Describes the billing frequency that is configured for the Placement1 record. This value influences invoice generation schedules and aligns billing cycles with client agreements.

BillRate Double False

Captures the bill rate that is assigned to the Placement1 record. This value drives invoicing, revenue calculations, and financial reporting for the assignment.

BonusPackage String False

Describes the bonus package that is associated with the Placement1 record. This value supports compensation modeling and details additional incentives included in the employment arrangement.

BranchID Int False

Identifies the branch Id that is linked to the Placement1 record. This reference supports segmentation, reporting, and organizational routing within Bullhorn CRM.

CandidateId Int False

Specifies the candidate Id that is associated with the Placement1 record. This value establishes the relationship between the placement and the individual performing the work.

CanEnterTime Bool False

Returns a value of 'true' when the Placement1 record allows the candidate to enter time. It returns a value of 'false' when system configuration prevents time entry for the placement.

ClientCompanyId Int False

Identifies the client company Id that is associated with the Placement1 record. This reference aligns the placement with the company that receives the services.

Comments String False

Captures comments that are recorded for the Placement1 record. This information supports internal documentation and communication related to placement activity.

ContactId Int False

Specifies the contact Id that is associated with the Placement1 record. This value identifies the client-side contact who participates in managing or overseeing the placement.

CostCenter String False

Captures the cost center that is assigned to the Placement1 record. This value supports accounting allocation and ensures labor charges map to the appropriate financial category.

DateAdded Datetime False

Records the date that is associated with when the Placement1 record is added. This value provides historical context and supports reporting related to placement creation timing.

DateLastModified Datetime False

Captures the date that is associated with the last modification of the Placement1 record. This value supports audit tracking and identifies when the most recent update occurred.

DaysGuaranteed Int False

Specifies the number of guaranteed days that are associated with the Placement1 record. This information supports contractual obligations and drives billing or compensation rules.

DaysproRated Int False

Captures the number of pro-rated days that are calculated for the Placement1 record. This value influences prorated billing and compensation processes.

EffectiveDate Datetime False

Specifies the effective date that is assigned to the Placement1 record. This value determines when placement terms become active within payroll and billing workflows.

EffectivedateClient Datetime False

Identifies the effective date on the client side that is associated with the Placement1 record. This value ensures alignment between internal placement timing and client-recognized start dates.

EmployeeType String False

Captures the employee type that is assigned to the Placement1 record. This value supports classification of the worker within payroll, reporting, and compliance workflows.

EmploymentType String False

Specifies the employment type that is associated with the Placement1 record. This value determines how the placement is categorized across payroll, reporting, and assignment management.

HoursofOperation String False

Captures the hours of operation that are associated with the Placement1 record. This value supports scheduling, timekeeping expectations, and client operational alignment.

HoursPerDay Double False

Specifies the number of hours per day that are expected for the Placement1 record. This value supports timekeeping, payroll calculations, and compliance monitoring.

HousingManager Int False

Identifies the housing manager Id that is associated with the Placement1 record. This reference supports housing oversight when placements involve employer-provided accommodations.

HousingStatus String False

Captures the housing status that is associated with the Placement1 record. This information supports operational tracking and indicates placement-related housing arrangements.

InvoiceGrouping String False

Specifies the invoice grouping category that is applied to the Placement1 record. This value influences how charges are consolidated and presented in client invoices.

JobId Int False

Identifies the job Id that is linked to the Placement1 record. This reference maintains the relationship between the placement and the originating job order.

JobDuration Double False

Captures the job duration that is associated with the Placement1 record. This value supports forecasting, billing, and scheduling decisions.

LastApprovedPlacementChangeRequestId Int False

Identifies the change request Id that is associated with the most recently approved placement change for the Placement1 record. This value supports audit trails and tracking of historical changes.

LocationId Int False

Identifies the location Id that is associated with the Placement1 record. This value links the placement to the worksite or client location used for payroll, scheduling, and reporting.

MarkUp Double False

Captures the markup percentage that is assigned to the Placement1 record. This value contributes to revenue calculations and determines the margin that is applied to billable hours.

MigrateGUID String False

Represents the globally unique migration Id for the Placement1 record. This value supports data migration, synchronization, and system reconciliation activities.

OptionsPackage String False

Describes the options package that is associated with the Placement1 record. This information outlines additional benefits or configurable components included in the placement arrangement.

OtherHourlyFee Double False

Captures the additional hourly fee that is associated with the Placement1 record. This value supports supplemental billing structures beyond standard rates.

OtherHourlyFeeComments String False

Records comments that describe the purpose or application of the additional hourly fee for the Placement1 record. This information supports internal documentation of billing exceptions and special conditions.

OtmarkUp Double False

Captures the overtime markup rate that is applied to the Placement1 record. This value influences overtime billing and ensures that enhanced rates follow client agreements.

OverTimebillrate Double False

Specifies the overtime bill rate that is associated with the Placement1 record. This value determines the invoiced amount for overtime hours.

OverTimepayrate Double False

Captures the overtime pay rate that is assigned to the Placement1 record. This value affects payroll processing for overtime work.

OvertimeExemption Int False

Indicates the overtime exemption status that is associated with the Placement1 record. This value supports compliance rules that determine whether overtime regulations apply.

OwnerId Int False

Identifies the owner Id that is assigned to the Placement1 record. This value designates the user responsible for managing the placement.

PayRate String False

Captures the pay rate that is assigned to the Placement1 record. This value determines the compensation that is provided to the candidate for regular hours worked.

PayUnit String False

Specifies the pay unit that is associated with the Placement1 record. This value defines the pay structure used for compensation calculations.

Placementfee Double False

Captures the placement fee that is assigned to the Placement1 record. This value supports billing and revenue processes related to direct hire or permanent placement arrangements.

PlacementfeeFlat Double False

Specifies the flat placement fee that is associated with the Placement1 record. This value represents a fixed fee amount used in permanent placement billing.

ProjectCodeList String False

Captures the list of project codes that is associated with the Placement1 record. This value supports financial allocation, cost tracking, and client-specific reporting.

QuitJob Bool False

Returns a value of 'true' when the Placement1 record indicates that the candidate quit the job. It returns a value of 'false' when the placement remains active or ends for another reason.

RateEntryType Bool False

Returns a value of 'true' when the Placement1 record uses an alternate rate entry type. It returns a value of 'false' when the placement follows the standard rate entry method.

RecruitingmanagercommissionoverRide Double False

Captures the commission override amount for the recruiting manager that is associated with the Placement1 record. This value supports commission calculations and revenue allocation.

ReferralFee String False

Records the referral fee that is associated with the Placement1 record. This value supports billing processes when referrals influence compensation or invoicing.

ReferralFeeType String False

Specifies the referral fee type that is associated with the Placement1 record. This value determines how referral charges are categorized and processed.

ReportedMargin Double False

Captures the reported margin that is calculated for the Placement1 record. This value supports profitability analysis and financial reporting.

Reportingto String False

Describes the reporting-to designation that is assigned to the Placement1 record. This information identifies the supervisor or client contact associated with the placement.

Salary String False

Captures the salary amount that is assigned to the Placement1 record. This value supports compensation modeling and payroll workflows for salaried placements.

SalesmanagercommissionoverRide Double False

Captures the commission override amount for the sales manager that is associated with the Placement1 record. This value supports compensation tracking and commission reconciliation.

ScheduledEnd Datetime False

Specifies the scheduled end date that is associated with the Placement1 record. This value helps determine assignment duration and supports forecasting and transition planning.

ShiftId Int False

Identifies the shift Id that is linked to the Placement1 record. This value supports scheduling, timekeeping expectations, and labor category alignment.

StartDate Datetime False

Captures the start date that is associated with the Placement1 record. This value determines when the placement begins and supports payroll, billing, and onboarding workflows.

StatementContactId Int False

Identifies the statement contact Id that is associated with the Placement1 record. This value determines who receives financial statements and billing summaries.

Status String False

Specifies the placement status that is assigned to the Placement1 record. This value reflects the current state of the placement within operational workflows.

SubmissionId Int False

Identifies the submission Id that links the Placement1 record to its originating job submission. This value preserves the relationship between stages of the recruiting lifecycle.

Tax Double False

Captures the tax amount or tax rate that is associated with the Placement1 record. This value supports payroll taxation and billing calculations based on jurisdictional rules.

TaxState String False

Specifies the tax state that is associated with the Placement1 record. This value determines state-specific taxation rules that apply to the placement.

TerminationReason String False

Captures the termination reason that is recorded for the Placement1 record. This value supports offboarding, reporting, and compliance documentation.

UmbrellaCompanyId Int False

Identifies the umbrella company Id that is linked to the Placement1 record. This value supports payroll and billing when the worker operates through an umbrella organization.

WorkersCompCodeId Int False

Specifies the workers' compensation code Id that is associated with the Placement1 record. This value determines workers' compensation classification and influences insurance cost calculations.

WorkWeekBegin Int False

Captures the workweek start day that is defined for the Placement1 record. This value supports timekeeping, overtime calculations, and payroll processing.

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