The Job Functions are stored in the JRJOBFUNCTIONS table. Primary key is the Job Function name. Job Functions can be added by adding a new row to this table.
The structure of the table:
Column name |
Data type |
Description |
|---|---|---|
jobfunction |
(N)VARCHAR(50) |
Name of the Job Function |
description |
(N)VARCHAR(1000) |
Description of the Job Function |
substitution |
INTEGER |
Flag substitution allowed 1: Substitutes can be set for this Job Function 0: No substitutes can be set for this Job Function |
use_for_assign_request |
INTEGER |
Not used |
ldap_group |
(N)VARCHAR(50) |
Name of the linked LDAP group |
ldap_id |
INTEGER |
ID of the linked LDAP directory configuration |
synchronize |
INTEGER |
Flag Synchronization 1: The users will be synchronized with a LDAP Job Function 0: No synchronization |
errormsg |
(N)VARCHAR(255) |
Error message of the synchronization |
transparent |
INTEGER |
Flag transparency 1: The Job Function is marked for transparency 0: No transparency |
substitute_required |
INTEGER |
Flag substitute required 1: A substitute has to be selected for this Job Function 0: No substitute required |
jobrouter_administration |
INTEGER |
Flag automatic/manual creation 1: Not automatically created/managed 0: Created/managed automatically by JobServer |
modify_date |
DATETIME |
Modify date |
modified_by |
(N)VARCHAR(50) |
Modified by |
create_date |
DATETIME |
Create date |
created_by |
(N)VARCHAR(50) |
Created by |
