KNTA_PORTLETS

This table stores a row for each instance of a portlet type. This table stores both seeded rows for default portlets and dynamic rows on demand. The first time a user personalizes a page, edits a portlet on the page, or deletes a portlet from the page, the default rows of the page are duplicated for the user. After that, if the user deletes a portlet, the corresponding row will be deleted. The user will never be able to delete the seeded rows using the application.

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_PERSONALIZATION_VALUES

PERSONALIZATION_VALUE_SET_ID

PERSONALIZATION_VALUE_SET_ID

KNTA_PORTLET_COLUMNS

PORTLET_COLUMN_SET_ID

PORTLET_COLUMN_SET_ID

KNTA_PORTLET_TYPES

PORTLET_TYPE_ID

PORTLET_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PORTLET_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_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

PORTLET_TYPE_ID

NOT NULL

NUMBER

Portlet type of this portlet

USER_PAGE_TAB_ID

NOT NULL

NUMBER

Page and the tab that his portlet belongs to for a user

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Parameter set context ID for the filter fields

WIDTH

NOT NULL

NUMBER

Width of this portlet type (1 = narrow or 2 = wide)

TITLE

NOT NULL

VARCHAR2(80)

User-defined title of this portlet

SECTION

NOT NULL

NUMBER

Section number of the page (starting from 1) that this portlet sits on

ROW_IN_SECTION

NOT NULL

NUMBER

Row number in the section (starting from 1) that this portlet sits on

MAX_ROWS

NULLABLE

NUMBER

Maximum number of rows to be displayed. This will be part of the WHERE clause, but we have a separate column for it so that it can be easily changed by consultants, configurators, and so on, either in SQL*Plus or through a screen in a future release.

PERSONALIZATION_VALUE_SET_ID

NULLABLE

NUMBER

Identifies the set of personalization values for this portlet. See table KNTA_PERSONALIZATION_VALUES.

PERSON_VALUE_SET_CHANGED_FLAG

NOT NULL

VARCHAR2(1)

Whether this portlet has be personalized by the user

PORTLET_COLUMN_SET_ID

NULLABLE

NUMBER

If this portlet's type has the layout type "TABLE" this should reference the portlet_column_set_id from KNTA_PORTLET_COLUMNS.

PORTLET_COL_SET_CHANGED_FLAG

NULLABLE

VARCHAR2(1)

Whether the user has personalized the columns in the portlet

SELECT_CLAUSE

NULLABLE

CLOB

SELECT clause of the query that is used to load the data for this portlet

FROM_CLAUSE

NULLABLE

VARCHAR2(4000)

FROM clause of the query that is used to load the data for this portlet

WHERE_CLAUSE

NULLABLE

CLOB

WHERE clause of the query that is used to load the data for this portlet

ORDER_BY_CLAUSE

NULLABLE

VARCHAR2(4000)

ORDER BY clause of the query that is used to load the data for this portlet

GROUP_BY_CLAUSE

NULLABLE

VARCHAR2(4000)

GROUP BY clause of the query that is used to load the data for this portlet

HAVING_CLAUSE

NULLABLE

VARCHAR2(4000)

HAVING clause of the query that is used to load the data for this portlet

INVALID_FLAG

NULLABLE

VARCHAR2(1)

Flag that determines if the portlet is invalid

MAX_PAGE_MAX_ROWS

NULLABLE

NUMBER

Value that determines the maximum pages and maximum rows displayed by the portlet

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_PORTLETS_N1

NONUNIQUE

1

USER_PAGE_TAB_ID

KNTA_PORTLETS_N2

NONUNIQUE

1

PORTLET_TYPE_ID

KNTA_PORTLETS_U1

UNIQUE

1

PORTLET_ID

Sequences

Sequence Name

Sequence Type

KNTA_PORTLETS_S

PORTLET_ID