Description
Staff availability information. The data grain is day of week for each staff within a business.
Columns
| Column Name | Type | Description |
|---|---|---|
business_id |
string
|
Unique identifier for the business |
staff_availability_key |
int32
|
Surrogate key integer for staff availability within a business (will be unique on this table) |
staff_employment_history_key |
int32
|
Surrogate key integer for staff within a business |
day_of_week |
string
|
Name of the day of the week in the form of Monday, Tuesday, etc. |
day_of_week_short |
string
|
Short, 3 letter, name of the day of the week in the form of Mon, Tue, etc. |
day_of_week_number |
int32
|
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 |
int32
|
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 |
int32
|
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 |
int32
|
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 |
string
|
Time when the staff is available to begin working on that day of the week |
end_time |
string
|
Time when the staff is no longer available to work on that day of the week |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |