Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: