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 |