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