These messages are specific to the Review Internet Submission window.

When the User Defined Forms window is populated with submitted data and if the data submitted is for a user-defined column that exists in the database but does not display on the User Columns form, the following message is displayed: "There are submitted values for [Name|Address|Biograph] user-defined columns that are not currently displayed on the User Columns InfoMaker form. Please select the User Columns tab and click the Compare Data button to see these values."

When the User Defined Forms window is populated with submitted data and if the data submitted is for a user-defined column that exists in the database but does not display on the User Table form, the following message is displayed: "There are submitted values for [Name|Address|Biograph] user-defined columns that are not currently displayed on the User Table InfoMaker form. Please select the User Table tab and click the Compare Data button to see these values."

When the User Defined Forms window is populated with submitted data and if the data submitted is for a user-defined column that exists in the database but does not display on both the User Columns form and the User Table form, the following message is displayed: "There are submitted values for [Name|Address|Biograph] user-defined columns that are not currently displayed on the User Columns and the User Table InfoMaker forms. Please select the User Table tab and click the Compare Data button to see these values."

 

If the selected window/tab has columns on the master table, then a User Columns tab similar to the following example is displayed.

 

The User Columns tab displays a form with primary keys, which are read-only, and default standard user-defined columns and labels on the associated master table. For example, if you open this window from the Name Entity window, the associated table is NameMaster (Name Master).

These columns are provided by Jenzabar and cannot be edited or changed. The column label indicates the length and field type. The following table illustrates the meaning of various labels: 

1. 1. LABEL	Length	Type
      UDef 1 A 1	1	Alphanumeric
      UDef 1 A 2	1	Alphanumeric
      UDef 2 A 1	2	Alphanumeric
      UDef 2 A 2	2	Alphanumeric
      UDef 3 A 1	3	Alphanumeric
      UDef 3 A 2	3	Alphanumeric
      UDef 5 A 1	5	Alphanumeric
      UDef 5 A 2	5	Alphanumeric
      UDef 5 2 1	5.2	Numeric
      UDef 7 2 1	7.2	Numeric
      UDef 10 A 1	10	Alphanumeric
      UDef Date 1		Date (MM/DD/YYYY)
      UDef Date 2		Date (MM/DD/YYYY)
      UDef ID 1	9	Alphanumeric

 

If the selected window/tab has a related _UDF table, a User Table tab is displayed. The User Table tab allows you to define columns unique to your organization on the table listed on this tab. The only columns displayed on this tab by default are read-only primary key columns.

The following text will alert you to the user-defined (_UDF) table against which this form was created:  "This user customizable form was created against the XXX_XXX_UDF table."

By default, only System Administrators have security access to this tab.

This tab allows the System Administrator to rename the User Columns and User Table tabs and/or choose to hide or display the  tabs. Any changes to the controls on this tab are global changes saved to the UDEF_TABS_CONFIG table; in other words, these changes affect all users.

 

If your school added a new column to a UDF table or a new custom table and you want to make it available for mapping in Form Builder or FormFlow, you must perform the following steps:

• Access the Manage Mapping Tables window and select the updated table or add a new custom table. That window checks for new columns and adds them to the list.
• Access the Internet Submissions window and select each submission type that you want the columns to be available for and make the columns available.