usm_mr_isystem

It holds the information for the data process operational key - last processing ID

Column Name Column Datatype Column Null Option Column Comment
id integer not null ID for the system, currently it should be just 0
domain varchar(50) with null Domain for the Data mediation system (not used yet), cross domains are not supported
status integer with null Status for the data mediation system.0=load files only, 1=import only, 2=aggregation, 3=finish!, 4=aggregation error, 5=waiting for billing to finish, 6=aggregating, 7=profiles pending, 8=profile error
status_date date with null Date/time when status changed
start_date date with null Metric start date/time
end_date date with null Metric end date/time
min_date date with null Min metric time stamp
max_date date with null Max metric time stamp
agg_mode integer with null Aggregation mode: 0=use min/max_date, 1=use start/end_date
interval varchar(16) with null Metric report interval
off_date integer with null Start day of month
etable_id integer with null Last event table name ID
file_id integer with null Last mr_ifile ID
table_id integer with null Last mr_itable ID
ftype_id integer with null Last mr_iftype ID
import_id integer with null Last mr_import ID
group_id integer with null Last group ID
proc_id integer with null Last process ID (for future use)
ebulk_id integer with null Last event table bulk_id
rbulk_id integer with null Last mr_result table bulk_id
last_agg_id integer with null Last processed bulk_id
file_path nvarchar(256) with null Upload file path (root)

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.