HP ALM Database Reference
td.USER_SETTINGS Table

Description

User settings in a web client. This table is not in use with the standard ALM client. See the COMMON_SETTINGS table.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key USET_IDThe record ID.int4  
 USET_SCOPE_TYPE

The scope of the setting: one of APPLICATION , MODULE or a custom scope applicable to an ALM extension.

If the scope is APPLICATION, the setting applies to the application globally.

varchar240  
 USET_SCOPE_ID

If the USET_SCOPE_TYPE is not APPLICATION, the name of the scope the setting applies to.

For example, if the scope type is MODULE and USET_APPLICATION_TYPE is ALM, the scope ID is the name of an ALM module. For example, DEFECTS or REQUIREMENTS.

If the USET_SCOPE_TYPE is APPLICATION, the USET_SCOPE_ID value is "default".

varchar240  
 USET_OWNERThe user name of the user to whom the setting or definition applies.varchar240  
 USET_KEY

A value generated from the tree of classes required to use this value.

The value may be encoded.

varchar512  
 USET_VALUEThe value of the setting.varchar16 
 USET_APPLICATION_TYPEThe name of the web application that uses the setting. For example, APM.varchar40 

See Also