Share this page
KNTA_SAVED_SEARCH_TYPES
This table stores one record for each saved search type supported by PPM Center. This table stores the details of which JSP pages should be used for getting the parameters for the search and displaying the search results.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_ENTITIES_NLS |
ENTITY_ID |
ENTITY_ID |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
SAVED_SEARCH_TYPE_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 |
|
ENTITY_ID |
NOT NULL |
NUMBER |
ID of the entity being searched for |
|
SEARCH_JSP |
NOT NULL |
VARCHAR2(200) |
URL for the search page jsp |
|
RESULT_JSP |
NOT NULL |
VARCHAR2(200) |
URL for the result page jsp |
|
SEARCH_TYPE_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the search type |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KNTA_SAVED_SEARCH_TYPES_U1 |
UNIQUE |
1 |
SAVED_SEARCH_TYPE_ID |
Sequences
This table uses no sequences.
