Defines a data view for a report. The dataview displays the data retrieved from data object in customizable chart or table format.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| report_dataview_id | varchar(128) | not null | Unique identifier for the report dataview. This is created when the dataview is saved |
| description | nvarchar(128) | with null | Describes the purpose of the data view |
| report_data_id | varchar(128) | not null | Handle to the data object to which this dataview is associated |
| comment | nvarchar(256) | with null | Stores comments entered by the user when dataview is created |
| type | nvarchar(20) | with null | Specifies the type of the dataview |
| time_stamp | date | with null | Specifies the time when dataview is created |
| status | integer | with null | Specifies the status of dataview: active or inactive |
| legend | nvarchar(64) | with null | Specifies the legend to be displayed on the chart |
| report_style_chart | long varchar | with null | Chart settings to be applied if dataview contains chart |
| report_style_table | long varchar | with null | Table settings to be applied if dataview contains table |
| bucket_size | integer | with null | Specifies the number of rows to be displayed in each bucket |
| data1 | nvarchar(64) | with null | External integration/additional data |
| data2 | nvarchar(256) | with null | External integration/additional data |
| column_rules | long varchar | with null | Operations to be performed on each and individual column of data |
| dataview_type | integer | with null | Specifies the type of dataview |
| dataobject_string | varchar(64) | with null | Specifies settings for the data object associated with the dataview |
| external_cmd | nvarchar(64) | with null | Store the command for external process invocation |
| external_file_name | nvarchar(256) | with null | Store the file name for external process invocation |
| external_params | nvarchar(256) | with null | Store the parameter for external process invocation |
| external_format | nvarchar(64) | with null | Store the format for external process invocation |
| external_cleanup | integer | with null | Specify whether external cleanup is to performed |
| delimiter | nvarchar(20) | with null | Delimiter separating values of data |
| refresh_time | integer | with null | Specifies how often dataview should be refreshed |
| print_settings | varchar(256) | with null | Specifies settings for printing the dataview |
| folder | nvarchar(64) | with null | Specifies folder in which dataview is saved |
| owner | nvarchar(128) | with null | Specifies user who created the dataview |
| get_variables_page | nvarchar(1024) | with null | Handle to the page to get variables for the associated data object |
| pre_actions | nvarchar(256) | with null | Specifies actions to be performed before loading the dataview |
| post_actions | nvarchar(256) | with null | Specifies actions to be performed after loading the dataview |
| bucket_no | integer | with null | Specifies the number of the page of dataview being displayed |
| path | nvarchar(256) | with null | Specifies path for storing offline report |
| file_name | nvarchar(256) | with null | Specifies filename for storing offline report |
| guinode_id | varchar(64) | with null | Specifies handle to the guinode for displaying the report |
| metering_string | varchar(256) | with null | Specifies paramter for customizing the metering reports |
| name | nvarchar(128) | with null | Specifies Human readable name for the dataview |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| report_dataview_id | usm_report_dataview_field | report_dataview_id |
| report_dataview_id | usm_report_layout_obj_list | report_dataview_id |