Table: dbo.Client_Billing_Item_Rate_Adjustment
The table used to store rate adjustments related to a client billing item.
Columns
NameTypeConstraintsDescription
client_billing_item_rate_adjustment_KEYint (4)NOT NULLPrimary key for the Client_Billing_Item_Rate_Adjustment table.
client_billing_item_KEYint (4)NOT NULLForeign key into the Client_Billing_Item table.
begin_datesmalldatetime (4)Date this rate adjustment becomes active.
end_datesmalldatetime (4)Date this rate adjustment becomes inactive.
adjustment_ratedecimal (5, 4)NOT NULLAdjustment rate to be applied to the client billing item during date range. Positive for a premium, negitive for a discount.
Primary key
NameColumnsDescription
PK_Client_Billing_Item_Rate_Adjustmentclient_billing_item_rate_adjustment_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Billing_Item_Rate_Adjustment__Client_Billing_Item__client_billing_item_KEYclient_billing_item_KEYClient_Billing_Item (client_billing_item_KEY)

Schema diagram