KNTA_LOOKUPS

This table stores all of the static values used in validations for PPM Center products. Each row includes a code and a meaning for that code. PPM Center products track lookups by their code internally, and uses the meaning to display a meaningful message to the user.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_PARAMETER_SET_CONTEXTS	PARAMETER_SET_CONTEXT_ID	USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name	Null?	Data Type	Description
LOOKUP_TYPE	NOT NULL	VARCHAR2(150)	System-generated identifier
LOOKUP_CODE	NOT NULL	VARCHAR2(40)
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
ENTITY_LAST_UPDATE_DATE	NOT NULL	DATE	Date a record in the entity was last updated
SEQ	NOT NULL	NUMBER
MEANING	NOT NULL	VARCHAR2(150)
DESCRIPTION	NULLABLE	VARCHAR2(400)
DEFAULT_FLAG	NOT NULL	VARCHAR2(1)
USER_MAINTAINABLE_FLAG	NOT NULL	VARCHAR2(1)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
SOURCE_TYPE_CODE	NULLABLE	VARCHAR2(30)
SOURCE	NULLABLE	VARCHAR2(100)
USER_DATA_SET_CONTEXT_ID	NULLABLE	NUMBER	Parameter set context identifier for the user data fields
USER_DATA1-20	NULLABLE	VARCHAR2(200)	User data segment
VISIBLE_USER_DATA1-20	NULLABLE	VARCHAR2(200)	User data segment
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_LOOKUPS_U1	UNIQUE	1	LOOKUP_TYPE
KNTA_LOOKUPS_U1	UNIQUE	2	LOOKUP_CODE
SYS_C00108369140	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.