The Process table stores information about Infor CRM processes assigned to Infor CRM contacts. Processes are created in Architect as plugins, and then released to users to assign to contacts. The stored information includes the process name, family, contact target ID and name, the status of the process, the start date, the date of the next action, if an activity is part of the process, has the process been suspended, the process node, date of the last action, the details that appear in the Summary tab, the process plugin ID the process is based on, and the ID of the user starting the process.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
PROCESSID (PK) |
STANDARDID(12) |
NOT NULL |
PROCESS_PROCESSID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
NAME |
varchar(64) |
NULLS |
|
|
|
|
FAMILY |
varchar(64) |
NULLS |
|
|
|
|
TARGETID (FK) |
STANDARDID(12) |
NOT NULL |
PROCESS_TARGETID (IE) |
(Many) to (One) |
|
|
TARGETNAME |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
int(4) |
NULLS |
|
|
|
|
STARTDATE |
datetime(8) |
NULLS |
|
|
|
|
NEXTACTION |
datetime(8) |
NULLS |
|
|
|
|
ACTIVITYID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
SUSPENDED |
BOOLEAN(1) |
NULLS |
|
|
|
|
USERID (FK) |
STANDARDID(12) |
NOT NULL |
|
(Many) to (One) |
|
|
NODE |
varchar(64) |
NULLS |
|
|
|
|
LASTACTION |
datetime(8) |
NULLS |
|
|
|
|
NEXTSUMMARY |
varchar(64) |
NULLS |
|
|
|
|
DATA |
Datablob(16) |
NULLS |
|
|
|
|
BASEDON (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
STARTERID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
BASETABLE |
varchar(64) |
NULLS |
|
|
|
|
BASETABLEID |
char(12) |
NULLS |
|
|
unknown |
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |