14.1 sp159_dependency_cost_category
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Cost weightings for different categories of time dependency. When a dependent job is placed within an earliest/latest time window the cost weighting is applied to the time difference between the target time for the dependent job and the actual time at which it is placed.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| category | number(6) |  | |
| category_name | varchar2(10) | | |
| weighting | number(9) | | |
| description | varchar2(80) |  | |
| field_id | varchar2(100) | |
Keys
primary_key(category)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| category | The cost weighting category. |
| category_name | The name of the category. |
| weighting | The weighting value. |
| description | Deprecated - a description of the category. |
| field_id | Key to language translation in sp900 for description. |