Table: Staff_Target_Range_Rate
The Staff_Target_Range_Rate table holds which billing rate is used to calculate the target billing amount for rate-based ranges. Not all target ranges are based on staff rate tables making this rate optional so it is stored in this table seperately from the Staff_Target_Range table.
NOTE: primary key is non-standard, standard key column is a unique constraint for performance issues.
Columns
NameTypeConstraintsDescription
staff_target_range_rate_KEYintNOT NULLManufactured primary key for this table for backwards compatibility. Currently must be the same value as [staff_target_range_KEY].
staff_target_range_KEYintNOT NULLLinks this record to the Staff_Target_Range record it is for.
billing_rate_type_KEYintNOT NULLLinks to a Billing_Rate_Type record. The staff of the Staff_Target_Range must have this rate used for the entire time the range is applicable.
Primary key
NameColumnsDescription
PK_Staff_Target_Range_Rate$staff_target_range_KEYstaff_target_range_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Target_Range_Rate__staff_target_range_rate_KEYstaff_target_range_rate_KEYBackward compatible table key must be unique (instead of being a primary key as it normally is.)
Indexes
NameColumnsDescription
IX_Staff_Target_Range_Rate$billing_rate_type_KEYbilling_rate_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Target_Range_Rate__Billing_Rate_Type__billing_rate_type_KEYbilling_rate_type_KEYBilling_Rate_Type
FK_Staff_Target_Range_Rate__Staff_Target_Range__staff_target_range_KEYstaff_target_range_KEYStaff_Target_Range

Schema diagram