Description
Staff availability information. The data grain is day of week for each staff within a business.
Columns
| Column Name | Description |
|---|---|
business_id |
Unique identifier for the business |
staff_availability_key |
Surrogate key integer for staff availability within a business (will be unique on this table) |
staff_employment_history_key |
Surrogate key integer for staff within a business |
day_of_week |
Name of the day of the week in the form of Monday, Tuesday, etc. |
day_of_week_short |
Short, 3 letter, name of the day of the week in the form of Mon, Tue, etc. |
day_of_week_number |
Day of the week in integer format, where 1 is the first day of the week (Sunday) and ends on 7 (Saturday) |
day_of_week_number_iso |
Day of the week in integer format, where 1 is the first day of the week (Monday) and ends on 7 (Sunday) |
start_time_key |
Surrogate key for the time when the staff is available to begin working on that day of the week (a surrogate key to the dim_time table; -1 indicates that the staff has not logged in) |
end_time_key |
Surrogate key for the time when the staff is no longer available to work on that day of the week (a surrogate key to the dim_time table; -1 indicates that the staff has not logged in) |
start_time |
Time when the staff is available to begin working on that day of the week |
end_time |
Time when the staff is no longer available to work on that day of the week |