Excel Add-In for Bullhorn CRM

Build 25.0.9539

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.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) for the Placement4 record. This value serves as the primary reference that is used throughout Bullhorn CRM workflows to track, update, and relate the Placement4 entry to associated records.

Changesapproved Int False

Captures the number of changes that are approved for the Placement4 record. This value participates in workflow tracking that is used to determine whether pending modifications can proceed.

Changeswaitingapproval Int False

Captures the number of changes that are waiting for approval for the Placement4 record. This value supports review and approval processes that are managed by Bullhorn CRM to ensure proper authorization.

Expiringcredentials Int False

Represents the number of credentials that are expiring for the Placement4 record. This value enables compliance monitoring that is needed for assignment continuation and client requirements.

Incompleterequirements Int False

Represents the number of requirements that are incomplete for the Placement4 record. This value informs validation processes that are used before confirming or extending the placement.

ApprovingClientContactId Int False

Specifies the Id of the client contact that is approving the Placement4 record. This value links the placement to the approving contact record that is stored in the ClientContact table.

BackupApprovingClientContactId Int False

Specifies the Id of the backup client contact that is assigned to approve the Placement4 record. This value provides redundancy that is used when the primary approving contact is unavailable.

BillingContactId Int False

Specifies the Id of the billing contact that is associated with the Placement4 record. This value links the placement to the contact that is responsible for billing coordination and invoice management.

BillingFrequency String False

Indicates the billing frequency that is applied to the Placement4 record. This value drives invoicing schedules that are enforced through Bullhorn CRM's financial workflows.

BillRate Double False

Specifies the bill rate that applies to the Placement4 record. This value participates in compensation, billing, and margin calculations that occur during invoice generation.

BonusPackage String False

Represents the bonus package that is associated with the Placement4 record. This value contributes to compensation configuration that is used in payroll and client billing operations.

BranchID Int False

Specifies the Id of the branch that is assigned to the Placement4 record. This value ties the placement to the organizational unit that is responsible for managing related activities.

CandidateId Int False

Specifies the Id of the candidate that is associated with the Placement4 record. This value establishes the relationship that is used to manage candidate placement status and work history.

CanEnterTime Bool False

Returns a value of 'true' when the candidate can enter time for the Placement4 record. It returns a value of 'false' when time entry is not permitted based on system controls or placement configuration.

ClientCompanyId Int False

Specifies the Id of the client company that is associated with the Placement4 record. This value links the placement to the organization that is receiving staffing services.

Comments String False

Captures comments that relate to the Placement4 record. This information supports communication and historical tracking within Bullhorn CRM workflows.

ContactId Int False

Specifies the Id of the primary contact that is associated with the Placement4 record. This value identifies the contact who serves as the main point of communication for the placement.

CostCenter String False

Represents the cost center that is associated with the Placement4 record. This value supports internal accounting alignment that is used for financial reporting and cost tracking.

DateAdded Datetime False

Indicates the date and time when the Placement4 record is added to the system. This value supports auditing, reporting, and chronological sequencing for placement activity.

DateLastModified Datetime False

Indicates the date and time when the Placement4 record is last modified. This value provides traceability that is used to track updates within Bullhorn CRM.

DaysGuaranteed Int False

Specifies the number of guaranteed days that apply to the Placement4 record. This value supports contractual compliance and billing logic that governs guarantees.

DaysproRated Int False

Specifies the number of prorated days that apply to the Placement4 record. This value influences billing adjustments and compensation calculations that are based on time worked.

EffectiveDate Datetime False

Indicates the effective date for the Placement4 record. This value determines when placement terms begin and influences downstream payroll and billing processes.

EffectivedateClient Datetime False

Indicates the client-defined effective date for the Placement4 record. This value reflects the client's internal scheduling requirements that affect engagement timing.

EmployeeType String False

Specifies the employee type that is assigned to the Placement4 record. This value affects payroll processing, tax configuration, and classification-based workflows.

Employment String False

Represents the employment classification for the Placement4 record. This value drives internal and regulatory logic that is used to determine placement status and compliance requirements.

HoursofOperation String False

Captures the hours of operation that relate to the Placement4 record. This information informs scheduling, availability checks, and time-entry validation.

HoursPerDay Double False

Specifies the number of hours per day that apply to the Placement4 record. This value contributes to time-entry expectations and billing calculations.

HousingManager Int False

Specifies the Id of the housing manager that is associated with the Placement4 record. This value identifies the person responsible for overseeing housing logistics when applicable.

HousingStatus String False

Indicates the housing status that is associated with the Placement4 record. This value supports operational tracking for placements that involve temporary housing arrangements.

InvoiceGrouping String False

Specifies the invoice grouping configuration that is assigned to the Placement4 record. This value informs the structure of generated invoices during financial processing.

JobId Int False

Specifies the Id of the job that is associated with the Placement4 record. This value links the placement to the originating job order for reporting and workflow alignment.

JobDuration Double False

Represents the job duration that is associated with the Placement4 record. This value supports planning and scheduling functions that are used to manage the assignment timeline.

LastApprovedPlacementChangeRequestId Int False

Specifies the Id of the most recent placement change request that is approved for the Placement4 record. This value contributes to change tracking and historical audit workflows.

LocationId Int False

Specifies the Id of the location that is associated with the Placement4 record. This value connects the placement to the site where work activities occur.

MarkUp Double False

Specifies the markup value that is applied to the Placement4 record. This value contributes to margin calculations that occur during billing and reporting processes.

MigrateGUID String False

Represents the globally unique migration Id that is associated with the Placement4 record. This value supports data migration tracking that is used to reconcile imported records.

OptionsPackage String False

Represents the options package that is linked to the Placement4 record. This value supports compensation, benefits, or incentive configurations that are maintained through Bullhorn CRM.

OtherHourlyFee Double False

Specifies the additional hourly fee that is associated with the Placement4 record. This value influences billing totals and cost calculations for hours worked.

OtherHourlyFeeComments String False

Captures comments that relate to the additional hourly fee for the Placement4 record. This information supports auditability and communication for billing adjustments.

OtmarkUp Double False

Specifies the overtime markup value that is applied to the Placement4 record. This value contributes to overtime rate calculations for payroll and invoice generation.

OverTimebillrate Double False

Specifies the overtime bill rate that is associated with the Placement4 record. This value drives invoicing and financial processing for overtime hours.

OverTimepayrate Double False

Specifies the overtime pay rate that is associated with the Placement4 record. This value supports payroll processing that is aligned with overtime rules.

OvertimeExemption Int False

Indicates whether the Placement4 record is marked for an overtime exemption. This value informs payroll logic that is used to determine whether overtime rules apply.

OwnerId Int False

Specifies the Id of the owner that is assigned to the Placement4 record. This value identifies the internal user who is responsible for managing and updating the placement.

PayRate String False

Specifies the pay rate that is associated with the Placement4 record. This value establishes compensation terms that influence payroll and billing workflows.

PayUnit String False

Indicates the pay unit that applies to the Placement4 record. This value determines how compensation is measured for payroll and financial processes.

Placementfee Double False

Specifies the placement fee that is associated with the Placement4 record. This value contributes to financial calculations that are used for client invoicing and revenue reporting.

PlacementfeeFlat Double False

Specifies the flat placement fee that is associated with the Placement4 record. This value supports fixed-fee billing arrangements that are configured for the placement.

ProjectCodeList String False

Captures the list of project codes that are linked to the Placement4 record. This information supports cost allocation and internal project tracking.

QuitJob Bool False

Returns a value of 'true' when the candidate quits the job that is associated with the Placement4 record. It returns a value of 'false' when the job separation does not meet the system's quit criteria.

RateEntryType Bool False

Returns a value of 'true' when the rate entry type for the Placement4 record requires a structured entry format. It returns a value of 'false' when rate information follows standard input behavior.

RecruitingmanagercommissionoverRide Double False

Specifies the recruiting manager commission override that is associated with the Placement4 record. This value influences commission calculations that relate to recruiting activities.

ReferralFee String False

Represents the referral fee that is associated with the Placement4 record. This value supports internal incentive tracking and client billing rules that involve referral arrangements.

ReferralFeeType String False

Indicates the referral fee type that is associated with the Placement4 record. This value determines how referral-related compensation is processed during financial workflows.

ReportedMargin Double False

Represents the reported margin that is associated with the Placement4 record. This value supports profitability analysis that is performed within Bullhorn CRM reporting.

Reportingto String False

Specifies the reporting relationship that is associated with the Placement4 record. This value identifies the person or role to whom the candidate reports during the assignment.

Salary String False

Specifies the salary amount that is associated with the Placement4 record. This value establishes fixed compensation terms that influence payroll and financial calculations.

SalesmanagercommissionoverRide Double False

Specifies the sales manager commission override that is associated with the Placement4 record. This value adjusts commission calculations that apply to sales activities.

ScheduledEnd Datetime False

Indicates the scheduled end date for the Placement4 record. This value supports workflow timing, extension management, and forecasting activities.

ShiftId Int False

Specifies the Id of the shift that is associated with the Placement4 record. This value ties the placement to scheduling parameters that define work hours and shift structures.

StartDate Datetime False

Indicates the start date for the Placement4 record. This value determines when assignment activities begin and influences payroll and billing cycles.

StatementContactId Int False

Specifies the Id of the statement contact that is associated with the Placement4 record. This value identifies the contact who receives statements or financial documents for the placement.

Status String False

Indicates the status of the Placement4 record. This value controls workflow transitions and determines which placement actions are available within Bullhorn CRM.

SubmissionId Int False

Specifies the Id of the submission that is associated with the Placement4 record. This value links the placement to the originating candidate submission within the hiring workflow.

TaxRate Double False

Specifies the tax rate that is applied to the Placement4 record. This value influences payroll withholding and cost calculations.

TaxState String False

Indicates the tax state that is associated with the Placement4 record. This value informs tax configuration rules that apply to payroll processing.

TerminationReason String False

Captures the termination reason that is associated with the Placement4 record. This information supports compliance tracking and end-of-assignment reporting.

UmbrellaCompanyId Int False

Specifies the Id of the umbrella company that is associated with the Placement4 record. This value is used when the placement is managed through an intermediary organization.

WorkersCompCodeId Int False

Specifies the Id of the workers' compensation code that is associated with the Placement4 record. This value supports regulatory compliance and insurance categorization.

WorkWeekBegin Int False

Indicates the day on which the work week begins for the Placement4 record. This value influences payroll cycle processing and time-entry validation.

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