sp228_fixed_reasons
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table provides a standard descriptive text string for jobs that have been "fixed" with a specific reason code.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| description | varchar2(30)Â | Â | Â  Â |
| fixed_reason_no | number |  |  |
| is_active | number | Â | Â |
| sequence_no | number | Â | Â |
KeysÂ
primary key (fixed_reason_no)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| fixed_reason_no  | ServiceOptimizer reason number. |
| description | The description of this reason. |
| sequence_no | Internal index. |
| is_active | Is this reason in use. |