Data model: wide_schedule

Description

wide_schedule data model is best used together with wide_labor. It helps see what schedules are set for employees and compare it to the actual labor metrics.

Revel Data Connector users using this data model can answer questions like:

  • What are the employee's work schedules?
  • What are the shifts for a specific employee and how it changed over time?
  • Verify if shifts are set properly in multiple locations at the same time.
  • What is the projected employee wage?
  • What are the schedules for a specific role?
  • etc.

Data Objects

Column nameData typeModeDescriptionExample
schedule_idintRequiredUnique identifier of a schedule entry123
schedule_created_attimestampRequiredSchedule creation date and time in UTC format2021-03-08 19:24:57
schedule_updated_attimestampRequiredSchedule updated date and time in UTC format2022-05-09 13:24:22
shift_begin_timetimestampRequiredDate and time when a shift starts in UTC format2022-05-12 16:24:45
shift_end_timetimestampRequiredDate and time when a shift ends in UTC format2022-05-17 15:33:23
role_wagenumericRequiredWage for the role124.33
break_typevarcharN/AThe type of break associated to the timesheet entry. Possible values:
  • Auto Break
  • Paid Break
  • Unpaid Break
  • N/A
Auto break
time_schedule_stagevarcharRequiredThe stage of a time schedule flow. Possible values:
  • Created
  • Emailed
  • Approved
  • Rejected
  • Unknown
Approved
exempt_salariedboolRequiredIndicates if an employee receives a set salary instead of an hourly wageTrue
schedule_time_diff_in_secfloat8RequiredTime between shift_begin_time and shift_end_time in seconds12800
establishment_idint4RequiredEstablishment unique Key.1
establishment_namevarcharRequiredEstablishment NameCompany-1
establishment_cityvarcharRequiredEstablishment City.Atlanta
establishment_statevarchar'N/A'Establishment State.GA
establishment_countryvarcharRequiredEstablishment CountryUS
company_namevarcharRequiredCompany nameCompany
company_urlvarcharRequiredCompany url addresscompany.revelup.com
establishment_latitudefloat8NullableEstablishment Latitude34.6843294
establishment_longitudefloat8NullableEstablishment Longitude-86.4109566
establishment_post_codevarcharRequiredEstablishment Post Code30314
is_establishment_activeboolRequiredIdentification if establishment is active, e.g. TRUE or FALSETRUE
timezonevarcharRequiredThe configured timezone of the establishmentUS/Eastern
establishment_divisionvarchar'N/A'Establishment division. If establishment does not belong to a division, then value is N/A.Division - 1
establishment_sub_divisionvarchar'N/A'Establishment sub-division. If establishment does not belong to a sub-division, then value is N/A.Sub-division - 1
schedule_rule_idintRequiredSchedule unique key123
regular_valuefloat8RequiredNumber of hours, including paid breaks, an employee must work per day before switching to overtime rate.8.0
overtime_valuefloat8RequiredNumber of overtime hours, including paid breaks, an employee must work per day before switching to doubletime rate.4.0
doubletime_valuefloat8RequiredMaximum number of doubtime hours.4.0
overtime_ratefloat8RequiredOvertime rate for the schedule entry.1.5
double_ratefloat8RequiredDouble rate for the timesheet entry.2.0
regular_week_hoursfloat8RequiredNumber of hours, including paid breaks, that an employee must work per week before switching to a higher pay rate.40.0
start_dayintRequiredFirst day of a workweek, from 0 (Monday) to 6 (Sunday).4
day_start_timevarcharRequiredTime of day that a workday begins.03:00:00
is_manual_paid_breakboolRequiredSpecifies if employees may declare when they are going on a paid break manually, e.g. TRUE or FALSE.FALSE
auto_work_time_for_paid_breakvarcharNullableThe amount of time an employee must work to earn a paid break.07:30:00
auto_paid_break_durationvarcharNullableThe length of paid break that the employee earns after having worked enough time to qualify for a paid break.00:20:00
is_seventh_day_rule_enabledboolRequiredSpecifies if 7th Day Consecutive Overtime rule is enabled, e.g. TRUE or FALSE.FALSE
created_by_employee_first_namevarchar'N/A'First name of employee who created the schedule.John
created_by_employee_last_namevarchar'N/A'Last name of employee who created the schedule.Doe
created_by_employee_is_activeboolNullableIdentification of whether employee is active.TRUE
last_updated_by_employee_first_namevarchar'N/A'First name of employee who created the schedule.John
last_updated_by_employee_last_namevarchar'N/A'Last name of employee who created the schedule.Doe
last_updated_by_employee_is_activeboolNullableIdentification of whether employee is active.TRUE
employee_first_namevarcharRequiredFirst name of employee.John
employee_last_namevarcharRequiredLast name of employee.Doe
employee_is_activeboolRequiredIdentification of whether employee is active.TRUE
role_namevarcharRequiredEmployee role.Bartender
is_employee_role_activeboolRequiredIdentification of whether employee role is active.TRUE