SSIS Components for Bullhorn CRM

Build 25.0.9539

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.

Columns

Name Type ReadOnly Description
id [KEY] Int False

Represents the unique identifier (Id) for the PlacementRateCard record. This value provides the primary reference that Bullhorn CRM uses to manage rate card configurations that apply to placements.

DateAdded Datetime False

Indicates the date and time when the PlacementRateCard record is added to the system. This value supports audit tracking and helps sequence updates across multiple rate card versions.

DateLastModified Datetime False

Indicates the date and time when the PlacementRateCard record is last modified. This value provides visibility into changes that affect rate card accuracy and payroll or billing alignment.

EffectiveDate Date False

Specifies the effective date for the PlacementRateCard record. This value determines when the rate card becomes active for payroll, invoicing, and financial calculations.

EffectiveEndDate Date False

Specifies the effective end date for the PlacementRateCard record. This value defines when the rate card expires and supports version control for placement-rate management.

IsDeleted Bool False

Returns a value of 'true' when the PlacementRateCard record is marked as deleted. It returns a value of 'false' when the rate card remains active and available in Bullhorn CRM.

OwnerId Int False

Specifies the Id of the owner that is associated with the PlacementRateCard record. This value identifies the user responsible for managing or updating the rate card configuration.

PlacementId Int False

Specifies the Id of the placement that is associated with the PlacementRateCard record. This value links the rate card to the placement whose billing and pay rules it defines.

PlacementRateCardVersion Int False

Represents the version number of the PlacementRateCard record. This value supports version tracking and helps Bullhorn CRM determine which rate card rules apply at a given time.

RootExternalID String False

Represents the root external Id that is associated with the PlacementRateCard record. This value supports integration with external systems that synchronize placement rate card data.

RootMigrateGUID String False

Represents the globally unique migration Id that is associated with the PlacementRateCard record. This value supports migration workflows that reconcile imported rate card records.

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