The substitutes are stored in the JRREPRESENTATION table. The primary key consists of the user name, Job Function and user name of the substitute. Substitute definitions can be added by adding a new row to this table.
The structure of the table:
Column name |
Data type |
Description |
|---|---|---|
username |
(N)VARCHAR(50) |
User name |
jobfunction |
(N)VARCHAR(50) |
Name of the Job Function substituted for. If it is a personal substitution, the entry is in the #username# format. |
representative |
(N)VARCHAR(50) |
Username of the substitute |
status |
INTEGER |
Status of the entry. 1 if the substitution is active, 0 if not. |
