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.