Stores the trending analysis data for surveys.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dsdbname | nvarchar(64) | not null | Data Source Database name as entered on the Admin UI for generating the Data Source entry |
| iproduct | nvarchar(64) | not null | Data Source ID - Used in Asset Intelligence, and Service intelligence for determining which type of URL to expect based on the product integrated. |
| dsserver | nvarchar(64) | not null | Data Source Server Name of the Record Entry |
| dsschema | nvarchar(64) | not null | Data source product schema (i.e., Unicenter Asset Management r4) |
| dsuser | nvarchar(64) | not null | Data source login ID (not required) |
| dspwd | nvarchar(64) | not null | Data source password (not required) |
| dsengine | nvarchar(64) | not null | Data source database engine (i.e., "SQL Server") |
| laction | nvarchar(32) | not null | Last action code (i.e., "ADDED", "MODIFIED") |
| lactdate | date | not null | Last Action Date for this record |
| createdate | date | not null | Creation date for this record entry. |
| dssourceid | integer | with null | Data Source ID - Used in Asset Intelligence |
| dssourceuuid | byte(16) | with null | The Data Source uuid that is used as the records FK |
| dsport | nvarchar(16) | not null | The database port to be used for accessing the datasource database. (EI - Default for Embedded Ingres, II - Default for OpenSource ingres, etc...) |
Product Name: Unicenter Asset Intelligence
Table Type: Table