This table is used to evaluate and control the import of personnel data. For each import run in which stored procedures are executed in the database, the changes made there are written to this "import log". This makes it possible to evaluate, for example, whether all data records could be imported without errors. It also shows which data records have been deleted or need to be deleted because they no longer exist in the external system. Note: Settings for whether to import, update and delete are made for each table in the "System configuration".
identification
Information on the identification of the data record is stored in this info area.
| Property | Description |
| Name of the log table | Displays the name of the target table. |
| Name of the log column | Displays the name of the column that was imported. |
Data
Information on what the personnel data import interface has done with individual data records.
| Property | Description |
| Log severity | Displays the severity of the error. "0" is displayed if no error has occurred. |
| Log error | Indicates whether an error occurred during import. |
| Log process | Display of the process that imported the data. This is normally a stored procedure. |
| Log message | Display of the import message (e.g. "this entry has been inserted from the periodic import" when a new data record has been successfully imported). If an error has occurred, the error message is displayed here. |
| Log step | Display of the type of action performed. This can be "insert" for an import, "update" for an update or "delete" for a deletion process. |
| Log type | Display of the type of action performed. These can be: "commit" for a successful execution, "failure" for an incorrect execution, "intend" for no changes made to the target table because the action is not activated in the system configuration for this table (e.g. a data record would have to be deleted because it no longer exists in the external system. In the system configuration, however, it is set that the interface for the personnel data import should not delete any data records in this table. The log then reads: "intend" for the "delete" step). |
| Char of the log data record | Display of the textual value of the data record, if available. This is normally the content of the "Code" column. |
| Log data record (technical column name) | Display of the primary key of the data record. |
| Table | Display of the UID of the target table, if available. |
