Share this page

# DSH_PREFERENCE_VALS

This table stores the portlet preferences values for the portlet preferences defined in the DSH_PORTLET_PREFERENCES table. There is no limit on the size of the text value that can be stored, but values larger than 4000 chars are saved in multiple rows.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DSH_PORTLET_PREFERENCES | PORTLET_PREFERENCE_ID | PORTLET_PREFERENCE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PORTLET_PREFERENCE_VALUE_ID | NOT NULLABLE | NUMBER | System identifier for the portlet preference value
VERSION | NOT NULLABLE | NUMBER | Row version information
PORTLET_PREFERENCE_ID | NOT NULLABLE | NUMBER | FK to the portlet preference for which this value is defined
VALUE | NULLABLE | VARCHAR2(4000) | Value of the portlet preference. When code meaning is saved, it is saved here as [code][meaning].
PREF_SEQUENCE | NOT NULLABLE | NUMBER | If a preference value for a given PORTLET_PREFERENCE_ID is too large to fit into a single row (with sequence = 0), extra rows will be created to record the value, each with an increasing PREF_SEQUENCE value.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
DSH_PREF_VALS_PK | UNIQUE |  | PORTLET_PREFERENCE_VALUE_ID
DSH_PRE_VAL_IX1 | NONUNIQUE |  | PORTLET_PREFERENCE_ID

## Sequences

This table uses no 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: