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 |
