14.1 sp154_confirmation_timebands
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Pairs of Earliest & Latest combinations that can be used to override the defaults on the Gantt's Call Confirm dialog. The earliest and latest times are expressed as a number of minutes past midnight: but a value of 240 (say) always means "4 o'clock" even on a daylight saving changeover day.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| description | varchar2(30) |  | |
| earliest | number(4) | | |
| latest | number(4) | | |
| display_order | number(2) | | |
| field_id | varchar2(100) | |
Keys
foreign key (field_id) references sp900_language_translation (field_id)
Column Descriptions
| Field | Description |
|---|---|
| description | Depreciated - Unique description. |
| earliest | The earliest appointment time (for appointments) or access earliest time (for non-appointments) (number of minutes past midnight). It must be in the range 0 to +1440. The relevant day is defined by the ETA of the job. |
| latest | The latest appointment time (for appointments) or access latest time (for non-appointments) (number of minutes past midnight). It must be in the range 0 to +1440. The relevant day is defined by the ETA of the job. |
| display_order | Data is displayed in ascending order. |
| field_id | Key to language translations for description. |