KNTA_PORTLET_TYPES

KNTA_USERS

USER_ID

CREATED_BY

KNTA_PORTLET_COLUMNS

PORTLET_COLUMN_SET_ID

DEFAULT_LAYOUT_SET_ID

KNTA_PERSONALIZATION_VALUES

PERSONALIZATION_VALUE_SET_ID

DEFAULT_PERSON_VALUE_SET_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

PORTLET_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

VALID_FROM_DATE

NOT NULL

DATE

Date and time when the portlet definition was changed that would have caused propagation.

PORTLET_TYPE_NAME

NOT NULL

VARCHAR2(80)

Name of the portlet

DESCRIPTION

NULLABLE

VARCHAR2(400)

Description of the portlet.

PORTLET_CATEGORY

NULLABLE

VARCHAR2(80)

User defined category for the portlet

PORTLET_URL

NOT NULL

VARCHAR2(200)

Relative URL location from the dashboard home for a portlet of this type

PORTLET_MAX_URL

NULLABLE

VARCHAR2(200)

Relative URL location from the dashboard home for the max page of a portlet of this type

PORTLET_FILTER_URL

NULLABLE

VARCHAR2(200)

Relative URL location from the dashboard home for the filter page of a portlet of this type

PORTLET_ARRANGE_DATA_URL

NULLABLE

VARCHAR2(200)

Relative URL location from the dashboard home for the arrange data page of a portlet of this type

PRODUCT_SCOPE_TYPE

NOT NULL

VARCHAR2(30)

Defines what product does this portlet belong to

EDITABLE_FLAG

NOT NULL

VARCHAR2(1)

A flag to indicate whether an instance of this portlet type is editable

MAXIMIZABLE_FLAG

NOT NULL

VARCHAR2(1)

A flag to indicate whether an instance of this portlet type is maximizable

SINGLE_INSTANCE_FLAG

NOT NULL

VARCHAR2(1)

A flag to indicate whether only one instance of the portlet type is allowed per user

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

A flat to indicate whether this portlet type is enabled to be instantiated

DISPLAY_CONFIGURABLE_FLAG

NOT NULL

VARCHAR2(1)

Internal field, defines if the portlet columns can be configured in portlet builder

FILTER_CONFIGURABLE_FLAG

NOT NULL

VARCHAR2(1)

Internal field, defines if the portlet filter fields be configured in portlet builder

RESTRICT_ACCESS_FLAG

NOT NULL

VARCHAR2(1)

If the value is Y, the portlet security checks are made.

FILTERABLE_FLAG

NOT NULL

VARCHAR2(1)

Internal field for backwards compatibility. Defines if the portlet data can be filtered.

REQUIRE_PERSONALIZATION_FLAG

NOT NULL

VARCHAR2(1)

Defines if the user should be forced to personalize the portlet (first time only) before viewing the data.

BASE_SELECT_CLAUSE

NULLABLE

CLOB

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

BASE_FROM_CLAUSE

NULLABLE

VARCHAR2(4000)

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

BASE_WHERE_CLAUSE

NULLABLE

CLOB

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

BASE_ORDER_BY_CLAUSE

NULLABLE

VARCHAR2(4000)

Default ORDER_BY clause of the query that is used to load the data for this portlet.

BASE_GROUP_BY_CLAUSE

NULLABLE

VARCHAR2(4000)

Default GROUP_BY clause of the query that is used to load the data for this portlet.

BASE_HAVING_CLAUSE

NULLABLE

VARCHAR2(4000)

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

DEFAULT_TITLE

NOT NULL

VARCHAR2(80)

Default title given to new instances of this portlet type

DEFAULT_WIDTH

NOT NULL

NUMBER

Default width, narrow or wide, of this portlet type

DEFAULT_MAX_ROWS

NULLABLE

NUMBER

Default maximum number of rows displayed in a portlet of this type

LAYOUT_TYPE_CODE

NOT NULL

VARCHAR2(30)

Layout type, table or form, of this portlet type

DEFAULT_LAYOUT_SET_ID

NULLABLE

NUMBER

ID of the default layout set, usually column set, for this portlet type

DEFAULT_PERSON_VALUE_SET_ID

NULLABLE

NUMBER

ID of the default personalization value set for this portlet type

CLASS_OF_DATA_CAPSULE

NOT NULL

VARCHAR2(200)

Java class of the capsule used by this portlet type

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)

SOURCE

NULLABLE

VARCHAR2(100)

For records that have been updated by an interface or migrator, provides additional information about the source of the external update.

TIMEOUT

NULLABLE

NUMBER

Time in seconds after which the portlet query will be timed out

PARAM_JSP_URL

NULLABLE

VARCHAR2(200)

Parameters that are passed to the Java Server Page URL for the portlet to be displayed properly

CONTROLLER_CLASS

NULLABLE

VARCHAR2(200)

Java controller class for the portlet

DRILL_DOWN_SELECT_CLAUSE

NULLABLE

VARCHAR2(2000)

SQL Select clause for drill down functionality for the portlet

LIMIT_RESULTS_FLAG

NOT NULL

VARCHAR2(1)

Flag that determines if the portlet has a limit on the number of results

PAGEABLE_FLAG

NOT NULL

VARCHAR2(1)

Flag that determines whether the portlet is able to maximize to a full page

DEFAULT_MAX_PAGE_MAX_ROWS

NULLABLE

NUMBER

Default maximum pages and maximum rows for the portlet

USE_BIND_VARIABLES_FLAG

NOT NULL

VARCHAR2(1)

If this flag is set to Yes, the portlet sql will use the bind variables. This makes the sql run faster, in most cases this should be set to Yes. There are cases in which this has to be set to No for the sql to work.

DATA_SOURCE_TYPE_CODE

NOT NULL

VARCHAR2(30)

the type of data source, usually SQL

KNTA_PORTLET_TYPES_U1

UNIQUE

1

PORTLET_TYPE_ID

KNTA_PORTLET_TYPES_U2

UNIQUE

1

PORTLET_TYPE_NAME

KNTA_PORTLET_TYPES_S

PORTLET_TYPE_ID