Jenzabar Campus Portal Features Help Hub

Working with Hidden Data Mappings

You can map and unmap hidden data as well as change existing mappings for a hidden data item.

Note

Employment Position Management forms: When an Employment Position Management employment application form is created, two hidden data elements are added to the form. Do not modify or delete these two hidden data elements as they are needed when an employment application is submitted in order for the form data to be properly mapped to the database.

Map Hidden Data

If a hidden data item is currently unmapped and you want to map it, use the following procedure.

  1. Open the form for editing.

  2. Scroll to the Hidden Data section at the bottom of the form and click the Not mapped link for the hidden data item you wish to map.

    not_mapped.jpg

  3. The Mapping: Choose a Table screen is displayed. This page contains a table that shows all the available tables to which you can map hidden data within this feature. While there is an "Actual Name" value included for each table, some of the tables listed may actually be logical tables that represent more than one physical table in the J1 database.

  4. Select the table to which you want to map this hidden data item by clicking the display name, which will produce one of the following results:

    1. If no questions in this form are currently mapped to this table, the system displays the Mapping: Set up Mapping screen, which lists details about the columns available for mapping. In this case, continue to Step 5.

    2. If any questions in this form are already mapped to this table, the system displays the Mapping: Choose a Row screen, which summarizes the row or rows that the current mapping dictates for the selected mapping table. In this case, do one of the following:

      1. If you want to map your hidden data using one of the rows being displayed:

        1. Click that row.

        2. The Mapping: Set up Mapping screen is displayed. It lists details about the columns available for mapping and shows how the columns are already mapped.

        3. Continue to Step 5.

      2. If you want to create a new row:

        1. Click Create a new row for this data.

        2. The Mapping: Set up Mapping screen is displayed. It lists details about the columns available for mapping.

        3. Continue to Step 5.

      Tip

      Some J1 Desktop model tables can accommodate only one row. You will not see errors when actually adding extra rows; however, when you try to validate the form, you will be unsuccessful. Therefore, before creating a new row for a model table, make sure that the table can accommodate it.

  5. Use the Mapped Value drop-down menu to match the hidden data item to the appropriate column.

    1. Each column available for mapping is displayed under the Field Name heading.

    2. Locate the appropriate column.

    3. In the corresponding Mapped Value column, use the drop-down menu to choose the hidden data item you are mapping.

  6. Click Save.

Modify Hidden Data Mapping

If a hidden data item is currently mapped but you want to change its mapping, use the following procedure.

  1. Open the form for editing.

  2. Scroll down to the Hidden Data section, which is at the bottom of the screen.

  3. Locate the hidden data item whose mapping you want to modify.

  4. Click the Mapped link.

    mapped.jpg

  5. The Mapping: Set up Mapping screen is displayed. This screen shows how the hidden data item you selected is mapped. It also shows all other mappings that currently exist for the table and row to which this particular hidden data item is mapped.

    1. If you want to keep the hidden data item mapped to the current table and row but to a different column, complete the following steps:

      1. Set the Mapped Value drop-down menu to 'No Change/Default Value' for the mapping column currently associated with the selected hidden data item.

      2. Continue to Step 6.

    2. If you want to keep the hidden data item mapped to the current table but want to change the mapping to a different row that has already been defined, complete the following steps:

      1. Click Change Row. The Mapping: Choose a Row screen is displayed.

      2. Click the name of the row you want to use.

      3. Continue to Step 6.

    3. If you want to keep the hidden data item mapped to the current table but want the mapping to be part of a new row that you define now, complete the following steps:

      1. Click Change Row. The Mapping: Choose a Row screen is displayed.

      2. Click Create a new row for this data. The Mapping: Set up Mapping screen is displayed.

      3. Continue to Step 6.

    4. If you want to map the hidden data item to a different table, complete the following steps:

      1. Click Change Table.

      2. The Mapping: Choose a Table screen is displayed. This screen contains a table that shows all the available tables to which you can map within this feature. While there is an "Actual Name" included for each table, some of the tables listed may actually be logical tables that represent more than one physical table.

      3. Select the table to which you want to map this hidden data item by clicking the display name, which results in one of the following:

        1. If no questions are currently mapped to this table, the Mapping: Set up Mapping screen is displayed. It lists details about the columns available for mapping. See "Mapping: Set up Mapping Screen" topic for more details about this screen. In this case, continue to Step 6.

        2. If any questions are already mapped to this table, the Mapping: Choose a Row screen is displayed. It lists the row or rows that the current mapping dictates. In this case, click the name of the row that you want to use or click Create a new row for this data. In this case, continue to Step 6.

    Tip

    Some J1 Desktop model tables can accommodate only one row. You will not see errors when adding extra rows; however, when you try to validate the form, you will be unsuccessful. Therefore, before creating a new row for a model table, make sure that the table can accommodate it.

  6. Use the Mapped Value drop-down menu to match the hidden data item to the appropriate column.

    1. Each column available for mapping is displayed under the Field Name heading.

    2. Locate the appropriate column.

    3. In the corresponding Mapped Value column, use the drop-down menu to choose the hidden data item you are mapping.

  7. Click Save.

Delete Hidden Data Mapping

If you want to delete a hidden data item's mapping, use the following procedure.

  1. Open the form for editing.

  2. Scroll down to the Hidden Data section, which is at the bottom of the screen.

  3. Locate the hidden data item whose mapping you want to modify, and click the Mapped link.

    mapped.jpg

  4. The Mapping: Set up Mapping screen is displayed. It shows how the hidden data item you selected is mapped and all other mappings that currently exist for the table and row to which this particular hidden data item is mapped.

    1. If the hidden data item you are deleting is the only item that is mapped to this table or if you want to remove all currently defined mappings for this table and row, complete the following steps:

      1. Click Remove All Mappings at the bottom of the screen.

      2. Confirm that you wish to remove all of the mappings for the table and row.

      3. Upon confirmation, you return to the Form Builder: Name of your form screen.

    2. If you wish to remove the hidden data item's mapping and leave all of the other mappings for this table and row as is, complete the following steps:

      1. Locate the column to which this hidden data item is mapped.

      2. In the Mapped Value column, set the drop-down menu to No Change/Default Value.

      3. Click Save. You will be returned to the Form Builder: Name of your form screen.

        Note

        This option does not work if you are removing the last question from a mapping table. You must use the previous option or the next option in this case.

    3. If you want to remove the mapping only for the selected hidden data item, complete the following steps:

      1. Click the Remove Mapping link at the top of the screen in the Hidden Data line.

      2. Confirm the deletion of the mapping for the hidden data item.

      3. Upon confirmation, the Mapping: Choose a Table screen appears, where you can select another table for the hidden data item's mapping.

        1. If you wish to leave the hidden data item unmapped, click on the Back to Main link at the bottom of the screen.

        2. If you want to associate the hidden data item with another mapping column, click on the name of the table, and continue with the mapping.