This is the central table via which the personnel data import interface is implemented. It is used to import personnel data from external systems into the portal's internal "Personnel list" table. Which columns are imported is set in the "Configuration IF_SPALTE_T" table. The following columns are usually imported, for example: Last name, first name, department, title, e-mail, company, cost center, personnel ID, telephone, fax, cell phone.
identification
Information on the identification of the data record is stored in this info area.
| Property | Description |
| PERSONAL ID (technical column name) | Import of the employee's personnel number. |
| SURNAME (technical column name) | Import of the employee's surname. |
| FIRST NAME (technical column name) | Import of the employee's first name. |
| FSysID (technical column name) | Import the primary key of the system from which you are importing into the FM portal. |
| Personnel number | Import of the employee's CPID. |
| Person | Unique identifier of the person to be imported. This number is used for reliable identification and assignment of the person in the system and is essential for correct data import. |
Data
The fields in this info area are only imported if they are defined for import in the "
| Property | Description |
| TELEPHONE (technical column name) | Import the landline number where the employee can be reached during the day. |
| REMARK (technical column name) | Import of the comment on the employee. |
| Cost center 2 | Assignment to the primary key of the portal-internal table "Cost center" to define a second cost center via which the employee's services are billed. |
| Company | Assignment to the primary key of the portal-internal "Company" table to define the company in which the employee works. Import the name of the company for which the employee works. |
| TITLE (technical column name) | Import of the title held by the employee. |
| Exit date | Import of the date on which the cooperation with the employee was terminated. |
| Cost center | Assignment to the primary key of the portal-internal table "Cost center" to determine the cost center via which the employee's services are billed. |
| SOCIAL INSURANCE NUMBER (technical column name) | Import of the employee's social security number. |
| ANREDE (technical column name) | Import of the employee's salutation. |
| Person Type Code | Import of the employee's personnel type. |
| Mobile phone | Import of the mobile phone number via which the employee can be reached during the day. |
| TELEFAX (technical column name) | Import the fax number where the employee can be reached during the day. |
| INACTIVE (technical column name) | Import of information as to whether the employee is currently inactive. |
| DATE OF BIRTH (technical column name) | Import of the employee's date of birth. |
| Department | Assignment to the primary key of the portal-internal table "Departments" to define the department in which the employee works. |
| Department (long) | Import of additional information on the department in which the employee works. |
| Entry date | Import of the date on which the collaboration with the employee began. |
| USERNAME (technical column name) | Import of the employee's user name. |
| EMAIL (technical column name) | Import of the employee's e-mail address. |
| Zip code private | Import of the postal code of the city in which the employee lives. |
| Place private | Import of the name of the place where the employee lives. |
| Private road | Import the street and house number where the employee lives. |
| Location code | Import of the name of the location where the employee works. |
| FUNCTION (technical column name) | FUNCTION (technical column name) |
| PERSONAL FUNCTION (technical column name) | PERSONAL FUNCTION (technical column name) |
| Private phone | Import of the employee's private landline number. |
Unpublished
This info area is invisible and cannot be switched on. Columns in this info area are also invisible, but can be shown in lists if they are not explicitly configured as "visible = false" and "enabled = false".
| Property | Description |
| ANREDE1 (technical column name) | ⚠️ This property will be removed in one of the next releases. Please do not use it anymore.
Import of the employee's salutation. |
| ROOM (technical column name) | ROOM (technical column name) |
