POQ_QUAL_AREA_OUTCOMES

POQ_QUAL_AREA_OUTCOMES stores the outcomes that are included on the qualification area.

Details

• Schema: FUSION

• Object owner: POQ

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
POQ_QUAL_AREA_OUTCOMES_PK	QUAL_AREA_OUTCOME_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
QUAL_AREA_OUTCOME_ID	NUMBER		18	Yes	Internal system identifier for a qualification area outcome.
OBJECT_VERSION_ID	NUMBER		9	Yes	Column is obsolete. Used to implement optimistic locking.	Obsolete
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
QUAL_AREA_ID	NUMBER		18	Yes	Internal system identifier for a qualification area.
OUTCOME_NAME	VARCHAR2	80		Yes	Outcome name or identifier entered by the user.
DISPLAY_SEQUENCE	NUMBER		9	Yes	Specifies the order in which the outcomes should be displayed for this specific qualification area.
FROM_SCORE	NUMBER				Specifies the outcome from score value when scoring is enabled.
TO_SCORE	NUMBER				Specifies the outcome to score value when scoring is enabled.
KNOCKOUT_OUTCOME_FLAG	VARCHAR2	1			Specifies the outcome is set as the knockout outcome.
NOTIFICATION_FLAG	VARCHAR2	1			Specifies whether a notification needs to be sent to the qualification owner when a qualification is evaluated with this outcome.
ACTIVE_FLAG	VARCHAR2	1		Yes	Indicates whether the outcome is active or not.
INCLUDE_IN_SEARCH_FLAG	VARCHAR2	1			Column is obsolete. Indicates whether the outcome should be include in the search or not.	Obsolete
READ_ONLY_FLAG	VARCHAR2	1			Column is obsolete. Indicates whether the outcome name can be edited or not.	Obsolete
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POQ_QUAL_AREA_OUTCOMES	poq_qual_areas_b	QUAL_AREA_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POQ_QUAL_AREA_OUTCOMES_PK	Unique	Default	QUAL_AREA_OUTCOME_ID
POQ_QUAL_AREA_OUTCOMES_U1	Unique	Default	QUAL_AREA_ID, DISPLAY_SEQUENCE, ACTIVE_FLAG
POQ_QUAL_AREA_OUTCOMES_U2	Unique	Default	QUAL_AREA_ID, UPPER("OUTCOME_NAME")