KNTA_PORTLET_TYPES_BACKUP

This table stores backup copy of portlet_types.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

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, currently SQL

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.