Description
Employee shift information
Columns
| Column Name | Type | Description |
|---|---|---|
schedule_start_time |
timestamp[ns]
|
The starting datetime of the schedule |
schedule_end_time |
timestamp[ns]
|
The ending datetime of the schedule |
is_latest_schedule |
string
|
Indicates whether the schedule is the latest; enumerated: 'Yes' or 'No', 'Yes') |
schedule_publish_status |
string
|
Status of the schedule publication; enumerated: 'Published' or 'Draft' |
employee |
string
|
The name of the employee being scheduled |
shift_placement_type |
string
|
The type of shift placement; enumerated: 'Class' or 'Location' |
location |
string
|
The location associated with the shift |
class |
string
|
The class associated with the shift |
position |
string
|
The employee position associated with the shift |
pay_type |
string
|
The type of pay associated with the shift; enumerated: 'Hourly' or 'Salary' |
pay_rate |
double
|
The pay rate for the employee position associated with the shift |
hourly_pay_rate |
double
|
The hourly pay rate for the employee position associated with the shift |
shift_date |
date32[day]
|
The date of the shift |
shift_start_time |
timestamp[ns]
|
The starting datetime of the shift |
shift_end_time |
timestamp[ns]
|
The ending datetime of the shift |
shift_duration |
decimal128(27, 6)
|
The duration of the shift in hours |
break_minutes |
int32
|
The duration of the shift break in minutes |
is_paid_break |
string
|
Indicates whether the break is paid; enumerated: 'Yes' or 'No' |
business_id |
string
|
Unique identifier for the business |
school_id |
string
|
Unique identifier for the school |
school |
string
|
The name of the school |
business |
string
|
The name of the business |
shift_id |
string
|
Unique identifier for the shift |
employee_id |
string
|
Unique identifier for the employee |
position_id |
string
|
Unique identifier for the employee position associated with the shift |
class_id |
string
|
Unique identifier for the class |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |