PROCESSFILE

Stores all the information related to the file process.

Column Descriptions:

Name	Type	Description
PROCESSFILE_ID	BIGINT NOT NULL	Generated primary key.
MEMBER_ID	BIGINT	The identifier of the user that uploaded the file.
PROPERTIES	VARCHAR (1000)	Some extra name value pairs such as the scheduler job identifier and host name.
STARTTIME	TIMESTAMP	The time the file upload process begins.
ENDTIME	TIMESTAMP	The time the file upload process ends.
STATUS	INTEGER	The status of the file upload. Valid values are as follows: 0 = New, 1 = Processing, 2 = Complete, 3 = Failed, 4 = Canceled.
PROCESSINFO	CLOB (1000000)	The processing information such as the summary report.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PROCESSFILE_ID	Primary Key
I0001311	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3601	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3603	PROCESSFILE_ID	FILEPROCREL	PROCESSFILE_ID	Cascade