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 =
Cancelled. |
| 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 |