The mpi_relxtsk table stored relationship task information.

Expanded name
Relationship types
Table category
This runtime data table stores information about relationships that have an associated task. Tasks are created when relationships compare above specified thresholds.
Not applicable.
Table 1. mpi_relxtsk Attribute Descriptions
Attribute Description
caudrecno Creation of this particular record, from mpi_audhead
maudrecno Last time the record value was modified, from mpi_audhead
tskrecno Relationship task record number; assigned from mpi_seqgen
tsktypeno Identifies the task type, from mpi_tsktype
tskstatno Task workflow status, from mpi_tskstat.
usrrecno Unique user ID number from mpi_usrhead
reltypeno Numeric value from the relationship type
side Indicates which side of the relationship link that the associated entrecno applies; supports searching for relationship links by entrecno
recno Record number

mpi_relxtsk SQL:

create table mpi_relxtsk
caudrecno  bigint    	NOT NULL,
maudrecno  bigint    	NOT NULL,
tskrecno   bigint    	NOT NULL,
tsktypeno  smallint  	NOT NULL,
tskstatno  smallint  	NOT NULL,
usrrecno   smallint  	NOT NULL,
reltypeno  int		NOT NULL,
side       nchar(1)	NOT NULL
recno      bigint	NOT NULL 
CREATE UNIQUE INDEX  mpi_relxtsk0 ON mpi_relxtsk (tsktypeno,reltypeno,recno,tskrecno)
CREATE UNIQUE INDEX  mpi_relxtsk1 ON mpi_relxtsk (recno,tskstatno)