PlacementRateCardLine
Stores the individual line items that belong to placement rate cards. This table supports rate management by capturing detailed compensation components that influence billing rules and payroll calculations.
Table Specific Information
This table comes with the limitations below since it is exposed from its parent entity PlacementRateCardLineGroup endpoint.
- No more than a maximum of 15 PlacementRateCardLine records are returned for every parent PlacementRateCardLineGroup record. This means that if a parent PlacementRateCardLineGroup record contains more than 15 related PlacementRateCardLine records, ex. 17, only the top 15 related records are returned. This is due to Bullhorn CRM API limitations, as stated in the BullhornCRM API Reference Documentation.
- The ORDER BY clause is processed server side only for the parent identifier column PlacementRateCardLineGroupId, as in the example below.
For every other column or columns set, the ORDER BY clause is processed client side.
SELECT * FROM PlacementRateCardLine ORDER BY PlacementRateCardLineGroupId DESC
Columns
| Name | Type | ReadOnly | Description |
| id [KEY] | Int | False |
Represents the unique identifier (Id) for the PlacementRateCardLine record. This value provides the primary reference that Bullhorn CRM uses to track individual billing and pay rate entries within a placement rate card. |
| Alias | String | False |
Specifies the alias that is associated with the PlacementRateCardLine record. This value supports user-friendly identification of the rate line during payroll, billing, and configuration workflows. |
| BillCurrencyUnitId | Int | False |
Specifies the Id of the billing currency unit that is associated with the PlacementRateCardLine record. This value determines the currency context that applies to client billing for this rate line. |
| BillMultiplier | Decimal | False |
Represents the billing multiplier that is associated with the PlacementRateCardLine record. This value adjusts billing calculations when the rate line requires a multiplier for invoice generation. |
| BillRate | Decimal | False |
Specifies the bill rate that applies to the PlacementRateCardLine record. This value drives the calculation of client charges that are based on this rate line. |
| EarnCodeId | Int | False |
Specifies the Id of the earn code that is associated with the PlacementRateCardLine record. This value links the rate line to an earning classification that influences payroll processing. |
| MarkupPercent | Decimal | False |
Represents the markup percentage that is associated with the PlacementRateCardLine record. This value contributes to margin calculations and helps determine the bill rate from the pay rate. |
| MarkupValue | Decimal | False |
Represents the markup value that is associated with the PlacementRateCardLine record. This value provides a fixed markup amount that is applied during billing or margin computation. |
| PayCurrencyUnitId | Int | False |
Specifies the Id of the pay currency unit that is associated with the PlacementRateCardLine record. This value determines the currency that applies to compensation for this rate line. |
| PayMultiplier | Decimal | False |
Represents the pay multiplier that is associated with the PlacementRateCardLine record. This value adjusts payroll calculations when the rate line requires a multiplier for earnings determination. |
| PayRate | Decimal | False |
Specifies the pay rate that applies to the PlacementRateCardLine record. This value determines the compensation that is paid for hours or units associated with this rate line. |
| PlacementRateCardLineGroupId | Int | False |
Specifies the Id of the rate card line group that is associated with the PlacementRateCardLine record. This value organizes the rate line into a group that supports structured billing and pay configuration. |