sp155_confirmation_types
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
Sets of job attribute modifications that can be used to alter a job's existing attributes on the Gantt's Call Confirm dialog.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| description | varchar2(30)Â | Â | Â  |
| earliest_adjustment | number(4)Â | Â | Â |
| latest_adjustment | number(4) | Â | Â |
| earliest_rounding | number(2) | Â | Â |
| is_emp_mandatory | number(1) | Â | Â |
| importance_value_use | number(1) | Â | Â |
| importance_value | number(1) | Â | Â |
| priority_value_use | number(1) | Â | Â |
| priority_value | number(2) | Â | Â |
| field_id | varchar2(100) | Â | Â |
Keys
Column Descriptions
| Field | Description |
|---|---|
| description | Depreciated - Unique description  |
| earliest_adjustment | Number of minutes added to the job's ETA to form the job's proposed new access/ appointment earliest time. If 0, defaults to the job's current access/appointment earliest time. Should be <= 0.  |
| latest_adjustment | Number of minutes added to the job's proposed new access/appointment earliest time to form the job's proposed new access/ appointment latest time. If 0, defaults to the job's current access/appointment latest time.Should be >= 0. |
| earliest_rounding | When the earliest adjustment is subtracted from the ETA, the resulting time is rounded up to the nearest multiple of earliest_rounding minutes. The direction of rounding depends on the sign of earliest_rounding. A negative sign means round down. A positive sign means round up. Zero means no rounding. |
| is_emp_mandatory | Indicates whether the job's employee requirements should be updated to set the employee currently set to this job mandatory (replacing any existing employee for this). 0 = no modification is made.1 = the employee will be made mandatory. |
| importance_value_use | Indicates how importance_value is applied. 0 = no change is made. 1 = importance_value is applied as a decrement. 2 = importance_value is applied as an increment. 3 = importance value is applied as a replacement. |
| importance_value | Job importance value for application as specified by importance_value_use. |
| priority_value_use | Indicates how priority value is applied. 0 = no change is made. 1 = priority_value is applied as a decrement. 2 = priority_value is applied as an increment. 3 = priority_value is applied as a replacement. |
| priority_value | Job priority value for application as specified by priority_value_use. |
| field_id | Key to language translation for description. |