KNTA_EXCEPTIONS

This table stores Exceptions for projects, tasks and rollup exceptions. Whenever an exception Rule is violated an Exception is raised by the Exception Engine and it is stored in this table. (In future this will be used by Requests, Packages and Package lines also.)

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_EXCEPTION_RULES_NLS	EXCEPTION_RULE_ID	EXCEPTION_RULE_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_ENTITIES_NLS	ENTITY_ID	SOURCE_ENTITY_ID
PM_PROJECTS	PROJECT_ID	SOURCE_ID

Column Descriptions

Column Name	Null?	Data Type	Description
EXCEPTION_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
EXCEPTION_RULE_ID	NOT NULL	NUMBER	Exception rule identifier
SOURCE_ENTITY_ID	NOT NULL	NUMBER	Source type identifier, could be an entity identifier of a project, task, request, package or package line
SOURCE_ID	NOT NULL	NUMBER	Source identifier, could be an identifier of a project, task, request, package or package line
EXCEPTION_MESSAGE	NULLABLE	VARCHAR2(2000)	Exception message text
VIOLATION	NULLABLE	VARCHAR2(250)	Violation attribute

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_EXCEPTIONS_N1	NONUNIQUE	1	SOURCE_ENTITY_ID
KNTA_EXCEPTIONS_N1	NONUNIQUE	2	SOURCE_ID
KNTA_EXCEPTIONS_N2	NONUNIQUE	1	EXCEPTION_RULE_ID
KNTA_EXCEPTIONS_N3	NONUNIQUE	1	EXCEPTION_ID

Sequences

Sequence Name	Sequence Type
KNTA_EXCEPTIONS_S	EXCEPTION_ID