Please enable JavaScript to view this site.

Administration manual

Navigation: Tech Doc > Description of the JobRouter database > Database structure > Store organization data

Process owners

Scroll Prev Top Next More

The process owners are stored in the JRUSERPROCESS table. The primary key consists of the process name and the user name. Process owners can be added by adding a new row to this table.

The structure of the table:

Column name

Data type

Description

processname

(N)VARCHAR(50)

Process name

username

(N)VARCHAR(50)

User name or Job Function name

close_step

INTEGER

Currently not used

abort_step

INTEGER

Aborting steps:

1: User can abort steps

0: User cannot abort steps

delete_step

INTEGER

Deleting steps:

1: User can delete steps

1: User cannot delete steps

assign_step

INTEGER

Assigning steps:

1: User can assign steps

0: User cannot assign steps

reactivate_step

INTEGER

Reactivating steps:

1. User can reactivate steps

0: User cannot reactivate steps

email_info

INTEGER

Currently not used

change_escalation

INTEGER

Changing escalation:

1: User can change the escalation time of steps and instances

0: User cannot change the escalation time of steps and instances

export_incident

INTEGER

Exporting instances:

1: User can export instances

0: User cannot export instances

edit_process_info

INTEGER

Editing process info:

1: User can edit process info

0: User cannot edit process info

design_process

INTEGER

Designing process

1: User can edit the process

0: User cannot edit the process

configure_process

INTEGER

Currently not used

reimport_archived_incident

INTEGER

Importing instances from the archive:

1: User can import instances from the archive

0: User cannot import instances from the archive

 

Please note: Importing instances from an archive is only possible when the JobShift module is licensed.

modify_date

DATETIME

Modify date

modified_by

(N)VARCHAR(50)

Modified by

create_date

DATETIME

Create date

created_by

(N)VARCHAR(50)

Created by