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
Name | Type | Constraints | Description
staff_target_range_rate_KEY | int | NOT NULL | Manufactured primary key for this table for backwards compatibility. Currently must be the same value as [staff_target_range_KEY].
staff_target_range_KEY | int | NOT NULL | Links this record to the Staff_Target_Range record it is for.
billing_rate_type_KEY | int | NOT NULL | Links 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
Name | Columns | Description
PK_Staff_Target_Range_Rate$staff_target_range_KEY | staff_target_range_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Target_Range_Rate__staff_target_range_rate_KEY | staff_target_range_rate_KEY | Backward compatible table key must be unique (instead of being a primary key as it normally is.)
Indexes
Name | Columns | Description
IX_Staff_Target_Range_Rate$billing_rate_type_KEY | billing_rate_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Target_Range_Rate__Billing_Rate_Type__billing_rate_type_KEY | billing_rate_type_KEY | Billing_Rate_Type |
FK_Staff_Target_Range_Rate__Staff_Target_Range__staff_target_range_KEY | staff_target_range_KEY | Staff_Target_Range |