Information for the defined profile is stored here
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique ID |
| name | nvarchar(64) | with null | Descriptive name |
| match | varchar(64) | with null | Wildcard for matching text filenames (not used for now) |
| table_name | varchar(32) | with null | event_XXX/temp_XXX table name |
| file_type | integer | with null | Input file type: 0=reference file, 1=metric file |
| file_format | integer | with null | Input file format: 0=csv, 1=fix length, 2=database table import, 3=advanced database import |
| separator | nvarchar(4) | with null | Input file data separator |
| status | integer | with null | 0=ready (simple), 1=pending, 2=ready (complex), 3=inactive |
| load_type | integer | with null | 0=add, 1=delete then add, 2=synchronize |
| key_cols | varchar(64) | with null | key column numbers in reference table |
| domain | varchar(50) | with null | Domain |
| user_id | nvarchar(100) | with null | User who create the table |
| filter | varchar(1024) | with null | content filter, i.e. sql query or line number range and etc. |
| src_table | varchar(64) | with null | The source table name (for database import only) |
| source_id | varchar(32) | with null | Handle to icdb |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | usm_mr_import | table_id |
| id | usm_mr_ifile | table_id |
| id | usm_mr_ifield | table_id |