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