Map IFS Database Columns to XML Tags

Explanation

When a recruitment vendor sends an xml file with information about recruits, the file can hold a lot of information, e.g., address, citizenship, date of birth etc. This activity is used to match information from the xml file to IFS Database columns storing that information.

Example:
If information about recruit's last name is stored in the XML file under a tag: <lastname>, this tag has to be mapped to IFS Database column LAST_NAME.

Prerequisites

In order to perform this activity, you should know the XML structure of the file the external recruitment vendor uses as well as IFS Database Columns.

System Effects

As a result of this activity, an IFS Applications will be configured to store information from external xml file in specific database columns.

Window

File Based Recruitment Integration

Related Window Descriptions

File Based Recruitment Integration

Procedure

  1. Open the File Based Recruitment Integration window and find the relevant recruitment vendor.
  2. Open the Mapping tab. in the table, you will see all database columns to which you can map tags from the xml.
  3. Find the IFS database column that stores information given to you in the file (e.g. if xml has middle name is stored using a <midname> tag, you should look for the MIDDLE_NAME tag).
  4. In the XML Tag field, enter the relevant XML tag (following example given in point 3, you should enter midname)
    Note: Some columns have to be mapped if integration is to work. Such columns are marked with the mandatory check box.
  5. Once all tags have been mapped, save your changes.