The Staff_Target_Range table holds ranges of dates where different Staff targets (budgets) are effective. This table defines the date range and the target hours for each day of the week within this range. These ranges are specific to a staff and are coupled to a firm year. Unlike tables defined in the past which would only store either [ending_date] or [upper_date_exclusive] this table redundantly stores both of these as well as [lower_date_inclusive] for the performance benefits and defines [upper_date_exclusive] as the value the other two are validated against. |
staff_target_range_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Manufactured primary key for this table. |
staff_KEY | int | NOT NULL | Links this record to a particular staff. |
lower_date_inclusive | smalldatetime | NOT NULL | REDUNDANT: For performance we store the date that this range becomes effective. It can be computed from [upper_date_exclusive] and [firm_date_KEY]. |
ending_date | smalldatetime | NOT NULL | REDUNDANT: For backwards compatibility and ease of display on reports and screens, this is 24 hours prior to the [upper_date_exclusive]. |
upper_date_exclusive | smalldatetime | NOT NULL | This is the important date - this is the date that the next range begins and therefore where this ends. |
billable_percent | decimal (7, 6) | NOT NULL | The billable target hours are calculated from the target hours specified * this percentage. |
billable_amount | decimal (17, 2) | NOT NULL | If [billable_amount_is_overridden] is TRUE, this is the total billable amount to be spread across all target billable hours for the date range. |
billable_amount_is_overridden | bit | NOT NULL | When TRUE, indicates that the value of [billable_amount] is used, otherwise a rate is computed from an associated [Staff_Target_Range_Rate] record. |
billing_rate_type_KEY | int | | Links to a Billing_Rate_Type record. The staff must have this rate used for the entire time the range is applicable. |
target_hours_sunday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_monday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_tuesday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_wednesday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_thursday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_friday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_saturday | decimal (4, 2) | NOT NULL | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |