Share this page
ALM Project 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 Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | USET_ID | The record ID. | int | 4 | |||
| 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. | varchar | 240 | ||||
| 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". | varchar | 240 | ||||
| USET_OWNER | The user name of the user to whom the setting or definition applies. | varchar | 240 | ||||
| USET_KEY | A value generated from the tree of classes required to use this value. The value may be encoded. | varchar | 512 | ||||
| USET_VALUE | The value of the setting. | varchar | 16 |  | |||
| USET_APPLICATION_TYPE | The name of the web application that uses the setting. For example, APM. | varchar | 40 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| USET_APPLICATION_TYPE_IDX | |||
| USET_IDX | |||
| USET_PRIMARYKEY | | |
See Also
Related Objects
