Defines a data object for a report.
Data object is responsible for fetching the data from the data source.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| report_data_id | varchar(128) | not null | Unique identifier for the report data object. The unique identifier is assigned when the report data is saved. |
| name | nvarchar(128) | with null | Human readable name of the data object |
| status | integer | with null | Indicates whether the data object is active or inactive. If status is 1, the data object is active and if status is 0, the data object is inactive |
| type | nvarchar(20) | with null | Indicates the source of data |
| description | nvarchar(128) | with null | Detailed description of the purpose of the data object |
| db_id | varchar(50) | with null | Handle to the usm_db table |
| comment | nvarchar(256) | with null | Stores the comment entered when data object is created |
| time_stamp | date | with null | The time when the data object is created |
| pre_actions | varchar(1024) | with null | Actions that have to be taken after the data is fetched from data source |
| query_string | nvarchar(4096) | with null | The query which indicates which data should be fetched from data source |
| post_actions | varchar(1024) | with null | Actions that have to be taken after the data is fetched from data source. |
| page_functions | varchar(64) | with null | Functions applied to each page of the report |
| report_functions | varchar(64) | with null | Functions applied to the entire report |
| fields | nvarchar(4096) | with null | Specific fields to be selected when fetching data |
| data1 | nvarchar(64) | with null | External integration/additional data |
| data2 | nvarchar(64) | with null | External integration/additional data |
| delimiter | nvarchar(20) | with null | Seperates values of fields in the data |
| class | varchar(64) | with null | Class to which this data object belongs to |
| report_variable_string | long varchar | with null | Specifies the variables for this report |
| folder | nvarchar(64) | with null | Folder into which the data object is stored |
| owner | nvarchar(128) | with null | User who created the data object |
| reg_join_query_string | varchar(1024) | with null | Select query if the data object type is registry join |
| pvt_row_fields | nvarchar(4096) | with null | Row fields that are selected for pivoting |
| pvt_column_fields | nvarchar(64) | with null | Column fields by which data is grouped while pivoting |
| pvt_data_fields | nvarchar(64) | with null | Actual data values that are aggregated for the pivoted data |
| pvt_aggregate_fields | nvarchar(64) | with null | Values of data after aggregation |
| dblock_type | integer | with null | Type of locking method when executing the database queries. |
| pvt_totals | integer | with null | Specifies how the pivoted totals are displayed |
| pvt_aggregate_type | integer | with null | Specifies how aggregation should be done |
| pvt_data | nvarchar(64) | with null | Stores the pivoted data |
| pvt_empty_cell_value | nvarchar(64) | with null | Specifies the value to be taken if cell is empty |
| pvt_error_value | nvarchar(64) | with null | Specifies the value to be taken if cell value is error |
| pvt_orig_fields | nvarchar(4096) | with null | Original values of data before any pivoting |
| pvt_sort_order | nvarchar(64) | with null | Specifies how sorting should be done |
| bucket_no | integer | with null | Specifies the number of buckets in the data |
| bucket_size | integer | with null | Specifies the size of each bucket |
| pvt_col_sort_order | nvarchar(64) | with null | Specifies how column sort should be done |
| get_variables_page | nvarchar(1024) | with null | Handle to the page displaying the variables of the data object |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| report_data_id | usm_billing_group | report_data_id |
| report_data_id | usm_link_report_variable_data | report_data_id |
| report_data_id | usm_report_dataview | report_data_id |