Review Submission Mapping Details Window

The Review Submission Mapping Details window opens when you click the Review Mapping Details button on the Internet Submissions window. The Review Mapping Details button is only available for any Form Builder 2 submissions type. You cannot add, insert, or delete rows on the Review Submission Mapping Details window.

This window is used to view the available database column mappings for the selected Internet submission type and its related detail. These tables and columns can be used to map form questions and answers to the J1 database when the form is submitted. If a database mapping table or column is not listed, it cannot be used for mapping when using Form Builder 2 to create this type of Internet submission. When the form is submitted with a candidate's/student's answers to the questions, it will be displayed on the Process Internet Submissions window, which then processes and maps the responses to the J1 database.

Jenzabar recommends that prior to creating forms in campus portal (JICS) that you ensure the properties for the columns of each J1 and custom table are as you want them. If you do not see a custom mapping table that you expect to see in the Available Tables drop-down list box, you may need to access the Assign Submission Types window and assign the appropriate submission type to the custom table.

Columns

The following columns are on this window:

This column is not editable, but it displays the description of the Internet Submission Type.

This drop-down is a listing of tables that are available to the campus portal (JICS) Form Builder designer to be used for mapping. Any custom tables that have been added to your database can be added to this list via the Manage Mapping Tables window.

Notes entered in this editable column are specific to the selected Submission Type and describe what the table is used for. This description is displayed to the user in campus portal (JICS) when viewing a list of the tables available for mapping to questions.

Data Mapping Grid

The mapping columns for the selected table are displayed in the Data Mapping grid. The available settings for each mapping column are Nullable, Default Value, and Is Available for Mapping?

Column Description

This column is not editable. It displays a list of columns associated with the selected table.

Nullable

The Nullable checkbox indicates whether or not the candidate/student filling in a question on a campus portal (JICS) form that is mapped to a table/column is required to fill in the question on the form. If the checkbox is selected, the candidate/student is not required to fill in the mapped question. If the checkbox is not selected, the question mapped to this table/column must be answered before the form can be submitted.

By default, columns in custom tables will allow a null value. Most of the columns for J1 tables are selected by default. However, some columns will be cleared and therefore required in campus portal (JICS). The columns with Nullable not selected by default are columns in the NAME_MASTER, ADDRESS_MASTER, BIOGRAPH_MASTER, TEST_SCORES, ORG_TRACKING, and CANDIDATE mapping tables that correspond to checkbox columns on windows in the J1 Desktop application. Also, the questions on the Sample Application and Sample Inquiry forms in campus portal (JICS) that correspond to these columns are defined as radio buttons with Yes/No options; therefore, many of the radio buttons on the Sample Application and Sample Inquiry forms are required entry. In the case of checkbox-type columns that exist in J1 Desktop, the default database value will be used when the submission is processed if the candidate/student does not specifically mark a required answer on the campus portal (JICS) form. If you do not want to use the default settings for the Nullable property for columns in J1 tables, these can be changed so that the columns are Nullable, which allows you to (1) create the question from scratch and map it to the now Nullable column or (2) import the questions from the Sample forms, remove the mapping to the column(s), save the changes, and then re-create the mappings.

If you change the Nullable property for a column that has already been mapped in one or more campus portal (JICS) forms, you must remove all mappings to the updated column and re-create them in order for the form(s) to recognize that a change has been made.

The campus portal (JICS) Candidate form designer can also mark a question as required on a form, even if it is marked as Nullable on this window.

The Select All checkbox is used to select all or clear all of the checkboxes in the Nullable column.

Default Value

Before using the table/column mappings in a campus portal (JICS) form, ensure that the Default Value is set as desired. This property is cached on the Web server the first time that the mapping table is selected; therefore, the changes to the property will not be recognized by campus portal (JICS) unless the cache is cleared. See the campus portal (JICS) document Candidate 2.0 Installation and Configuration Guide for more information about clearing the campus portal (JICS) cache.

The Default Value column specifies the default value that should be shown to the form designer if they choose to define a table/column mapping as a Custom Data type of question. When viewing the mapping columns for a particular mapping table in campus portal (JICS), the specified default value will be displayed in the text box that is shown to the right of the Mapped Value drop-down list box if the Custom Data option is selected in the Mapped Value column for a J1 mapping column with a Default Value defined. This default value can be changed when editing the form in campus portal (JICS). Once the Custom Data value is saved for the mapping column defined on the form, the specified Custom Data value will be used when the form is submitted. However, if the saved value is deleted from the form and the mapping table properties saved, it will again show the default value defined in J1 Desktop the next time the mapping table is opened.

The Default Value column can also specify a default value with which to pre-populate a question mapped to the specified column for the Relationship Management portlet's forms. You can enter in a static value, or you can define a question to use a variable that would be updated at the time the form is populated. The available variables are timestamp (returns the current date and time), current_date (returns the current date), and current_time (returns the current time). These values will only be pre-populated in a form's questions if the user is creating a new row of data (i.e., if they choose to add a new address or relationship row) or if the user is updating the SNAPSHOT data category and no row exists for the ID in the mapping table (i.e., if there is not currently a row in BIOGRAPH_MASTER for the ID).

To set this up for the mapping columns that will be used in the Relationship Management forms, there are two steps you need to follow (the order of these steps is not important, although both should be done before submitting forms):

1. In the form's question definition, select a column name from the Prepopulate drop-down list box (i.e., RELATION_TABLE.BEGIN_DTE_OF_REL).

2. On the Review Submission Mapping Details window inJ1 Desktop for the submission type, specify a static value or one of the available variable names in the Default Value column for the column selected for pre-population on the form (i.e., 'current_time').

Using the above examples, if the user is editing an existing relationship row, the form will be pre-populated with any existing BEGIN_DTE_OF_REL value on the selected RELATION_TABLE row. Also, if the user chooses to create a new relationship row, the question will instead be populated with the current date.

There are several columns on the new mapping tables that have been updated to contain a Default Value. These include ATTRIBUTE_TRANS.ATTRIB_BEGIN_DTE (uses the timestamp variable) and MAJOR_DONOR.CURRENT_STAGE_CODE (uses a text string of 'INIT'). Therefore, you may wish to check the contents of the Default Value column for the new mapping tables to see if you wish to leave the values as they are or if they should be changed.

Is Available for Mapping?

Before using the table/column mappings in a campus portal (JICS) form, ensure that the Is Available for Mapping? is set as desired. This property is cached on the Web server the first time that the mapping table is selected; therefore, the changes to the property will not be recognized by campus portal (JICS) unless the cache is cleared. See the campus portal (JICS) document Candidate 2.0 Installation and Configuration Guide for more information about clearing the campus portal (JICS) cache.

The Is Available for Mapping? column indicates whether or not a column should be displayed when the mapping table is selected for use on a campus portal (JICS) form. When the checkbox is selected for a column, the column will be shown in the list of available columns for the mapping table. If the checkbox is not selected, the column will not be displayed in the list for the mapping table. By default, all columns for both J1 tables and custom tables will have the Is Available for Mapping property selected. The campus portal (JICS) Candidate administrator can select this checkbox if a column is available for mapping.

The Select All checkbox is used to select all or clear all of the checkboxes in the Is Available for Mapping? column.

Buttons

Clicking the Save button updates rows in the AVAIL_FORM_TYPE_MAP_TABLE (MAP_TABLE_NOTES column) and the NULLABLE, DEFAULT_VALUE, and IS_AVAILABLE_FOR_MAPPING columns in the FORM_DATA_MAPPING table.

Clicking this button returns you to the Internet Submissions window with no changes saved.