KNTA_PRODUCTS

This table stores information about which products are available in PPM Center. New products will each have their own entry. The PRODUCT VECTOR is a bit flag that shares a name space with KNTA_ACCESS_GRANTS.ACCESS_GRANT_VECTOR. It is important that these not be changed.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
PRODUCT_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
PRODUCT_NAME	NOT NULL	VARCHAR2(80)
PRODUCT_KEY	NOT NULL	NUMBER
TEMP_NUM_LICENSE	NULLABLE	NUMBER
TEMP_EXPIRATION_DATE	NULLABLE	DATE
PRODUCT_DESCRIPTION	NULLABLE	VARCHAR2(200)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_PRODUCTS_U1	UNIQUE	1	PRODUCT_ID
SYS_C005198741	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.