KNTA_PORTLET_TYPE_COLUMNS

This table stores the list of available visible columns for each portlet type.

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_PORTLET_TYPES

PORTLET_TYPE_ID

PORTLET_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PORTLET_TYPE_COLUMN_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

DESCRIPTION

NULLABLE

VARCHAR2(1000)

Description for the purpose of this column

DB_COLUMN

NOT NULL

VARCHAR2(1000)

Database column name of this column

COLUMN_TYPE

NOT NULL

VARCHAR2(30)

Defines type of data fetched in the column (for example, numeric, string, date, and so on)

PORTLET_TYPE_ID

NOT NULL

NUMBER

ID of the portlet type to which this column belongs

PROMPT

NOT NULL

VARCHAR2(100)

Displayed prompt for this column

MAXIMIZED_PROMPT

NOT NULL

VARCHAR2(200)

Displayed prompt for this column in the maximized view

PIXEL_WIDTH

NULLABLE

NUMBER

Internal field to calculate the pixels from the character width

CHARACTER_WIDTH

NULLABLE

NUMBER

Number of characters that the user wants to display in this column

HYPERLINK_FLAG

NOT NULL

VARCHAR2(1)

A flag to indicate whether the data in this column should be hyperlinked

HYPERLINK_TYPE_CODE

NULLABLE

VARCHAR2(30)

Type of the hyperlink

HYPERLINK_FILTER_COLUMNS

NULLABLE

VARCHAR2(400)

Currently unused

HYPERLINK_ENTITY_ID_COLUMN

NULLABLE

VARCHAR2(30)

Identifier used to navigate to the hyperlink

CUSTOM_HYPERLINK

NULLABLE

VARCHAR2(1000)

Custom hyperlink defined by user

MANDATORY_FLAG

NOT NULL

VARCHAR2(1)

A flag to indicate whether this column is required in a portlet of the portlet type

TRUNCATE_FLAG

NOT NULL

VARCHAR2(1)

A flag to indicate if the data in this column should be truncated

TRUNCATE_LENGTH

NULLABLE

NUMBER

If TRUNCATE_FLAG is "Y", this value determines the length at which the data should be truncated

COLUMN_ALIAS

NOT NULL

VARCHAR2(30)

Unique alias for the column

TOOL_TIP_FLAG

NOT NULL

VARCHAR2(1)

Defines if the column has tool-tip

TOOL_TIP_COLUMN

NULLABLE

VARCHAR2(30)

Defines what to display if the column has the tool-tip

ALLOW_USER_SORT_BY_FLAG

NOT NULL

VARCHAR2(1)

Defines if the end-user can define the sort by in the filter page

DISPLAYABLE_FLAG

NOT NULL

VARCHAR2(1)

Defines if the column is displayed in the portlet

DEFAULT_ORDER_BY_FLAG

NOT NULL

VARCHAR2(1)

Defines if this column is the default order by value in the filter page

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.

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_PORTLET_TYPE_COLUMNS_N1

NONUNIQUE

1

PORTLET_TYPE_ID

KNTA_PORTLET_TYPE_COLUMNS_U1

UNIQUE

1

PORTLET_TYPE_COLUMN_ID

Sequences

Sequence Name

Sequence Type

KNTA_PORTLET_TYPE_COLUMNS_S

PORTLET_TYPE_COLUMN_ID