SSIS Components for Bullhorn CRM

Build 25.0.9539

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.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Identifies the unique identifier (Id) for the Placement2 record. This value establishes the primary reference used in financial processing, placement management, and system integrations.

Changesapproved Int False

Captures the number of approved placement changes that is recorded in the Placement2 record. This value supports audit tracking and reflects completed modifications.

Changeswaitingapproval Int False

Captures the number of placement changes that is waiting for approval in the Placement2 record. This value supports workflow routing and pending-action monitoring.

Expiringcredentials Int False

Records the count of credentials that are nearing expiration for the Placement2 record. This value assists compliance tracking and proactive renewal processes.

Incompleterequirements Int False

Captures the number of incomplete requirements that is associated with the Placement2 record. This value supports onboarding management and prevents incomplete placements from progressing.

ApprovingClientContactId Int False

Identifies the approving client contact Id that is associated with the Placement2 record. This value designates the client contact responsible for authorizing changes or confirming placement details.

BackupApprovingClientContactId Int False

Identifies the backup approving client contact Id that is linked to the Placement2 record. This value supports secondary approval routing when the primary approver is unavailable.

BillingContactId Int False

Identifies the billing contact Id that is associated with the Placement2 record. This value determines who receives billing inquiries and financial communications related to the placement.

BillingFrequency String False

Specifies the billing frequency that is applied to the Placement2 record. This value determines the cadence of invoice generation and revenue recognition.

BillRate Double False

Captures the bill rate that is assigned to the Placement2 record. This value determines the hourly or periodic amount invoiced to the client.

BonusPackage String False

Describes the bonus package that is associated with the Placement2 record. This information supports compensation planning and defines additional benefits offered as part of the placement.

BranchID Int False

Identifies the branch Id that is connected to the Placement2 record. This value establishes regional or organizational ownership for reporting and operational workflows.

CandidateId Int False

Identifies the candidate Id that is associated with the Placement2 record. This value links the placement to the worker fulfilling the assignment.

CanEnterTime Bool False

Returns a value of 'true' when the Placement2 record allows the candidate to enter time. It returns a value of 'false' when time entry is restricted or managed externally.

ClientCompanyId Int False

Identifies the client company Id that is associated with the Placement2 record. This value links the placement to the company receiving services.

Comments String False

Records comments that are stored in the Placement2 record. This information supports internal communication and documents placement-specific notes.

ContactId Int False

Identifies the contact Id that is linked to the Placement2 record. This value identifies the primary client contact responsible for coordination or communication.

CostCenter String False

Specifies the cost center that is assigned to the Placement2 record. This value supports financial allocation and internal accounting processes.

DateAdded Datetime False

Captures the date the Placement2 record is added to the system. This value supports historical tracking and time-based reporting.

DateLastModified Datetime False

Captures the date the Placement2 record is last modified. This value supports audit history, data governance, and change monitoring.

DaysGuaranteed Int False

Specifies the number of guaranteed days that is associated with the Placement2 record. This value supports financial commitments and contractual terms of service.

DaysproRated Int False

Captures the number of prorated days that is calculated for the Placement2 record. This value supports billing adjustments and partial-period compensation.

EffectiveDate Datetime False

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

EffectivedateClient Datetime False

Captures the effective date that is recorded for the client in the Placement2 record. This value supports client-specific scheduling and contract enforcement.

EmployeeType String False

Specifies the employee type that is assigned to the Placement2 record. This value identifies the worker classification used for payroll, billing, and compliance.

Employment String False

Describes the employment designation that is associated with the Placement2 record. This value supports categorization of the work arrangement for reporting and contractual alignment.

HoursofOperation String False

Captures the hours of operation that are recorded in the Placement2 record. This information supports scheduling expectations and timekeeping controls.

HoursPerDay Double False

Specifies the number of hours per day that is defined for the Placement2 record. This value supports payroll calculations and work-schedule management.

HousingManager Int False

Identifies the housing manager Id that is associated with the Placement2 record. This value supports coordination of housing services when lodging is required for the assignment.

HousingStatus String False

Specifies the housing status that is assigned to the Placement2 record. This value supports operational planning and determines whether housing resources are active, pending, or not applicable.

InvoiceGrouping String False

Specifies the invoice grouping method that is applied to the Placement2 record. This value determines how billable items are combined during invoice generation.

JobId Int False

Identifies the job Id that is associated with the Placement2 record. This value links the placement to its originating job order.

JobDuration Double False

Captures the job duration that is determined for the Placement2 record. This value supports schedule planning, forecasting, and assignment management.

LastApprovedPlacementChangeRequestId Int False

Identifies the last approved placement change request Id that is linked to the Placement2 record. This value supports audit tracking and connects the record to its most recent approved modification.

LocationId Int False

Identifies the location Id that is associated with the Placement2 record. This value determines the worksite location used for scheduling, compliance, and client reporting.

MarkUp Double False

Captures the markup percentage that is applied to the Placement2 record. This value supports billing calculations and determines the rate differential between pay and bill amounts.

MigrateGUID String False

Captures the globally unique migration Id that is assigned to the Placement2 record. This value supports data migration integrity and ensures consistent record tracking across environments.

OptionsPackage String False

Specifies the options package that is associated with the Placement2 record. This information supports compensation structuring and defines optional components included in the placement terms.

OtherHourlyFee Double False

Captures the additional hourly fee that is applied to the Placement2 record. This value supports premium billing arrangements or supplemental charges.

OtherHourlyFeeComments String False

Records comments about the additional hourly fee that is associated with the Placement2 record. This information provides context for billing adjustments and internal approvals.

OtmarkUp Double False

Captures the overtime markup percentage that is applied to the Placement2 record. This value supports payroll and billing calculations for overtime hours.

OverTimebillrate Double False

Specifies the overtime bill rate that is assigned to the Placement2 record. This value determines the rate invoiced to the client for overtime work.

OverTimepayrate Double False

Specifies the overtime pay rate that is assigned to the Placement2 record. This value determines the rate paid to the candidate for verified overtime hours.

OvertimeExemption Int False

Identifies the overtime exemption classification that is associated with the Placement2 record. This value supports compliance tracking and determines how overtime rules apply under labor regulations.

OwnerId Int False

Identifies the owner Id that is assigned to the Placement2 record. This value designates the user responsible for managing the placement lifecycle and overseeing related activities.

PayRate String False

Specifies the pay rate that is assigned to the Placement2 record. This value determines compensation calculations and supports payroll processing.

PayUnit String False

Specifies the pay unit that is applied to the Placement2 record. This value defines the measurement basis used for payroll, billing, and reporting.

Placementfee Double False

Captures the placement fee that is assessed for the Placement2 record. This value supports revenue calculations and contract enforcement.

PlacementfeeFlat Double False

Captures the flat placement fee that is associated with the Placement2 record. This value represents a fixed charge used in contract-based or non-percentage fee models.

ProjectCodeList String False

Specifies the project code list that is associated with the Placement2 record. This value supports internal accounting, cost allocation, and multi-project reporting.

QuitJob Bool False

Returns a value of 'true' when the Placement2 record indicates that the candidate quit the job. It returns a value of 'false' when the candidate did not separate from the assignment voluntarily.

RateEntryType Bool False

Returns a value of 'true' when the Placement2 record uses a rate entry type that triggers alternate processing rules. It returns a value of 'false' when standard rate entry behavior applies.

RecruitingmanagercommissionoverRide Double False

Captures the recruiting manager commission override amount that is associated with the Placement2 record. This value supports incentive tracking and commission calculations.

ReferralFee String False

Specifies the referral fee arrangement that is associated with the Placement2 record. This value supports financial agreements and identifies whether referral compensation is applicable.

ReferralFeeType String False

Specifies the referral fee type that is assigned to the Placement2 record. This value determines how referral payments are classified during revenue processing.

ReportedMargin Double False

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

Reportingto String False

Identifies the reporting-to contact that is associated with the Placement2 record. This value determines the supervisory contact responsible for oversight and timecard approvals.

Salary String False

Specifies the salary value that is assigned to the Placement2 record. This value supports compensation modeling and applies when the placement uses a salaried pay structure.

SalesmanagercommissionoverRide Double False

Captures the sales manager commission override that is associated with the Placement2 record. This value supports commission tracking and revenue allocation.

ScheduledEnd Datetime False

Specifies the scheduled end date that is assigned to the Placement2 record. This value determines when the placement is expected to conclude for scheduling and forecasting.

ShiftId Int False

Identifies the shift Id that is associated with the Placement2 record. This value determines the assigned work shift used for scheduling, timekeeping, and payroll calculations.

StartDate Datetime False

Specifies the start date that is recorded for the Placement2 record. This value determines when the candidate begins the assignment and triggers pay, billing, and scheduling workflows.

StatementContactId Int False

Identifies the statement contact Id that is associated with the Placement2 record. This value determines where client statements and billing summaries are directed.

Status String False

Specifies the status that is assigned to the Placement2 record. This value indicates the placement's current state within operational, financial, and workflow processes.

SubmissionId Int False

Identifies the submission Id that is linked to the Placement2 record. This value connects the placement back to the originating job submission that advanced to hire.

TaxRate Double False

Specifies the tax rate that is applied to the Placement2 record. This value supports taxation calculations and financial compliance.

TaxState String False

Identifies the tax state that is associated with the Placement2 record. This value determines the jurisdiction used for tax calculations and regulatory reporting.

TerminationReason String False

Specifies the termination reason that is recorded for the Placement2 record. This information documents the cause of assignment conclusion for compliance and internal review.

UmbrellaCompanyId Int False

Identifies the umbrella company Id that is associated with the Placement2 record. This value supports employer-of-record arrangements and determines which entity manages payroll and compliance.

WorkersCompCodeId Int False

Identifies the workers' compensation code Id that is assigned to the Placement2 record. This value determines the insurance classification used for risk assessment and payroll processing.

WorkWeekBegin Int False

Specifies the workweek start day that is defined for the Placement2 record. This value determines how weekly time, overtime, and payroll periods are calculated.

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