usm_mr_ifile

The information for the Imported data file or the external database where the data is fetched from

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique ID
domain varchar(50) with null Domain of user who uploaded file
status integer with null 0=uploading, 1=uploaded, 2=checking, 3=error, 4=validated, 5=remove, 6=removing, 7=deleted, 8=incomplete, 9=warning, 10=imported, 11=re-import, 12=archive, 13=archiving, 14=archived
upload_date date not null Time when file is uploaded
process_date date with null Time when file is imported
user_id nvarchar(100) with null User who uploaded the file
proc_id varchar(64) with null Importer engine ID (for future use)
server_file nvarchar(256) with null File name on server
client_file nvarchar(256) with null Original file name
user_text nvarchar(128) with null Additional comments by user
err_code integer with null error code
err_text nvarchar(256) with null Error details
source_id varchar(32) with null icdb id
filter nvarchar(512) with null Content filter on indivdual upload level
table_id integer with null Point to mr_itable

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
id usm_mr_ierror ref_id
id usm_mr_ivalue id
id usm_mr_iref id


Copyright © 2006 CA. All rights reserved.