Specification of the attributes that a report profile can have.
A specification gives the attribute names, default value, whether it is a selection list or input field, the order of the fields etc.
The attributes are divided into sections, i.e. one for line-chart, one for layout
| Column Name | Column Datatype | Column Null Option | Column Comment |
| report_profile_id | integer | not null | Unique identity of the report profile |
| attribute_name | varchar(50) | not null | Attribute name |
| section | varchar(50) | not null | The section to which the attribute applies |
| default_value | nvarchar(255) | with null | The default value for the attribute |
| label | nvarchar(255) | with null | The attribute label |
| label_bundle_key | varchar(50) | with null | The bundle key for the label. Used if label is null to create i18n labels. |
| help | nvarchar(255) | with null | Help text |
| help_bundle_key | varchar(50) | with null | Bundle key for the help text. Used if help is null to create i18n help texts |
| type | varchar(50) | with null | The attribute type, for GUI
- check - Boolean checkbox - entry - User is allowed to enter data - hidden - Not shown to the user at all - label - A simple label. Not for editing - select - The user is presented with a selection list with the values from usm_report_profile_spec_values. - text - Text field |
| tab_order | integer | with null | The ordering of the fields. Lowest tab order is presented first. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| report_profile_id attribute_name section |
usm_report_profile_spec_values | attribute_name report_profile_id section |