Table: Staff_Target_Range_Day
Holds the target working hours for each day of the week that applies during the date range in Staff_Target_Range. NOTE: primary key is non-standard, standard key column is a unique constraint for performance issues.
Columns
Name | Type | Constraints | Description
staff_target_range_day_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Manufactured key for this table.
staff_target_range_KEY | int | NOT NULL | Links this record to the Staff_Target_Range record is is for.
week_day | tinyint (3) | NOT NULL | This is the day of the week as a number between 1 and 7 where the week starts on Monday. Monday = 1, Tuesday = 2, ..., Saturday = 6, Sunday = 7. The expression to convert this value [based on @@DATEFIRST == 1] to the current @@DATEFIRST setting is: [week_day] = (((DATEPART(WEEKDAY, GETDATE()) - 1) + (@@DATEFIRST - 1)) % 7) + 1
target_hours | decimal (4, 2) |  | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00.

Primary key
Name | Columns | Description
PK_Staff_Target_Range_Day$staff_target_range_KEY$week_day | staff_target_range_KEY, week_day | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Target_Range_Day__staff_target_range_day_KEY | staff_target_range_day_KEY | Backward compatible table key must be unique (instead of being a primary key as it normally is.)

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Target_Range_Day__Staff_Target_Range__staff_target_range_KEY | staff_target_range_KEY | Staff_Target_Range |