14.1 sp611_rpt_jeopardy_conditions

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.