resource_working_hours_v1

Resource working hours are the designated time periods when a resource is available to perform work or provide services. Each row represents working hours during a shift in a specific day of the week.

Column	Data type	Description
id	VARCHAR(32)	The unique identifier of the resource working hour entry.
resource_name	VARCHAR(100)	The full name of the resource for which the working hours are recorded.
resource_deleted_at	TIMESTAMP_TZ(9)	The timestamp with time zone offset of when the resource was deleted.
day_name	VARCHAR(9)	The name of the day of the week for which the working hours are specified.
day_name_abbreviation	VARCHAR(3)	3-letter abbreviated name of the day for which the working hours are specified.
day_of_week	NUMBER(1)	A numerical representation of the day of the week (ISO 8601 weekday number from 1 - Monday through 7 - Sunday) for which the working hours are specified.
start_time	TIME(9)	The time at which the resource's work shift or availability begins.
finish_time	TIME(9)	The time at which the resource's work shift or availability ends.
resource_time_zone	VARCHAR(60)	The timezone of the resource.
_resource_id	NUMBER(38,0)	The identifier of the resource associated with the working hours.
_last_sync_at	TIMESTAMP_TZ(9)	The timestamp with time zone offset of when the record was last refreshed.