sp611_rpt_jeopardy_conditions
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table provides a list of Jeopardy conditions along with descriptive text and a sort order. This is used in the Analytics reporting module to allow users to select jeopardy condition to report against.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| name | varchar(40) | Â |  |
| description | varchar(40) | Â | |
| jeopardy_warning | number(38) | Â | |
| code | number(38) | Â | |
| sort_order | number(38) | Â |  |
| display_priority | number(38) | Â | |
Keys
primary key (name)
Column Descriptions
| Field | Description |
|---|---|
| name | Identifier for this jeopardy condition. |
| description | Textual description of this condition, displayed to the user in the Analytics reports pages. |
| jeopardy_warning | This indicates if this is either a jeopardy_warning (1) or a jeopardy_warning2 (2). |
| code | Jeopardy condition code. N.B. These codes are defined in FS020 (Jeopardy States). |
| sort_order | The order the descriptions are displayed in the Analytics reports pages. |
| display_priority | For jobs which have multiple jeopardy warnings this indicates which priority is displayed. |