sp154_confirmation_timebands
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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. |