Represents all or some of a scheduled assignment. Each block can be scheduled by day or for a particular time. There is nothing unique about a [Schedule_Entry] and it is up to the user interface to reduce the number of overlaps and adjacent entries, but it is possible for such entries to be created due to concurrency. |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
schedule_entry_KEY | int | NOT NULL | |
schedule_item_KEY | int | NOT NULL | Link to the schedule item of the assignment that is being scheduled (or at least partially scheduled) by this record. |
staff_KEY | int | NOT NULL | Link to the staff of the assignment that is being scheduled (or at least partially scheduled) by this record. |
schedule_entry_start_utc | datetime | NOT NULL | The starting date and time in UTC. |
schedule_entry_duration | int | NOT NULL | The duration of the schedule entry on the timeline in minutes. |
schedule_entry_scheduled | int | NOT NULL | The number of minutes this entry has actually been scheduled for. It can be any amount less than or equal to [schedule_entry_duration]. |
schedule_entry_start__time_zone_KEY | smallint (5) | NOT NULL | The time zone selected by the last person editing [schedule_entry_start_utc]. |
schedule_entry_end__time_zone_KEY | smallint (5) | NOT NULL | The time zone selected by the last person editing [schedule_entry_end_utc]. |
schedule_entry_end_utc | datetime | NOT NULL | COMPUTED: The ending date and time in UTC computed from [schedule_entry_start_utc] and [schedule_entry_duration]. |
calendar_category_KEY | int | | |