Table: dbo.Client_Billing_Item_Rate_Adjustment
The table used to store rate adjustments related to a client billing item.
Columns
Name | Type | Constraints | Description
client_billing_item_rate_adjustment_KEY | int (4) | NOT NULL | Primary key for the Client_Billing_Item_Rate_Adjustment table.
client_billing_item_KEY | int (4) | NOT NULL | Foreign key into the Client_Billing_Item table.
begin_date | smalldatetime (4) |  | Date this rate adjustment becomes active.
end_date | smalldatetime (4) |  | Date this rate adjustment becomes inactive.
adjustment_rate | decimal (5, 4) | NOT NULL | Adjustment rate to be applied to the client billing item during date range. Positive for a premium, negitive for a discount.

Primary key
Name | Columns | Description
PK_Client_Billing_Item_Rate_Adjustment | client_billing_item_rate_adjustment_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Billing_Item_Rate_Adjustment__Client_Billing_Item__client_billing_item_KEY | client_billing_item_KEY | Client_Billing_Item (client_billing_item_KEY) |