This table holds financial data derived from the UAPM tables within the MDB for use with Service Intelligence algorithms.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| uuid | byte(16) | not null | This is the unique identifier for the financial prop record |
| data_source | varchar(256) | not null | This is the reference to the datasource record in ud_datasource_list |
| type | nvarchar(100) | with null | This is a normalized type for the financial record. This is resolved by reviewing the UAPM records, and following the relationships back to their type label. |
| last_update_date | date | with null | Last date/time that this record was updated/inserted |
| label | nvarchar(100) | with null | Common label used as a description for the record entry |
| actual_cost | money | with null | A standard actual cost used for comparison within the application |
| desired_cost | money | with null | An internal or desired cost modifier used for comparison within the application |
| industry_cost | money | with null | A standard published industry cost modifier used for comparison within the application |
Product Name: Unicenter Service Intelligence
Table Type: Table