Share this page

# DSH_BUILDER_DEF_PREFS

This table stores all the preferences of the portlet.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DSH_PORTLET_DEFS | PORTLET_DEF_ID | PORTLET_DEF_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
BUILDER_PORTLET_DEF_PREF_ID | NOT NULL | NUMBER(19,0) | ID of the table
VERSION | NOT NULL | NUMBER(10,0) | Version
NAME | NOT NULL | VARCHAR2(200 BYTE) | Name of the preference
TYPE | NOT NULL | VARCHAR2(30 BYTE) | Type of the preference
PROMPT | NOT NULL | VARCHAR2(200 BYTE) | Prompt of the preference
DEFAULT_VALUE | NULL | VARCHAR2(4000 BYTE) | Default value
DISPLAY_OPTION | NOT NULL | VARCHAR2(32 BYTE) | Display option of the preference, can be one of the followings: requiredEditablePref, editablePref, nonEditablePref, and hiddenPref
PORTLET_DEF_ID | NOT NULL | NUMBER(19,0) | The ID of table DSH_PORTLET_DEFS
LAYOUT_ROW | NOT NULL | NUMBER(10,0) | Row position in layout
LAYOUT_COLUMN | NOT NULL | NUMBER(10,0) | Column position in layout
LAYOUT_WIDTH | NOT NULL | NUMBER(10,0) | Width of the layout
DEFINITION_LANGUAGE | NOT NULL | VARCHAR2(40 BYTE) | Definition language
UUID | NOT NULL | VARCHAR2(255 BYTE) | System-generated identifier (UUID)
ADVANCED_DEF_PROPERTY | NULL | VARCHAR2(20 CHAR) | Advanced default property, can be one of the followings: NONE, USER_INFO and ENTITY_INFO

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
DSH_BLD_DEF_IX1 | NONUNIQUE | 1 | PORTLET_DEF_ID
DSH_BLD_DEF_IX2 | NONUNIQUE | 1 | UUID
DSH_BUILD_PR_PK | UNIQUE | 1 | BUILDER_PORTLET_DEF_PREF_ID

## Sequences

This table does not have any sequences.

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: