14.1 sp116_break_specifications
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This defines a break pattern of up to 5 breaks that may be assigned to a shift.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| break_spec_id | number(9) |  | |
| break_num | number(4) | | |
| break_start | number(4) | | |
| break_end | number(4) | | |
| break_duration | number(4) | | |
| break_name | varchar(20) | | |
| field_id | varchar2(100) | |
Keys
unique (break_spec_id,break_name) unique (break_spec_id,break_num)
foreign key (field_id) references sp900_language_translation (field_id)
Column Descriptions
| Field | Description |
|---|---|
| break_spec_id | Identifier for this specification (references SP115 & SP128) |
| break_num | reserved (default 1) |
| break_start | a number of minutes from midnight representing the earliest start time for the break (using the operative's timezone) |
| break_end | a number of minutes from midnight representing the latest start time for the break (using the operative's timezone) |
| break_duration | The break duration ( in minutes) |
| break_name | Name of the break |
| field_id | key to language translations for break_name |