Custom Data Tab (Review Submitted FERPA Permissions Window)

If available, this tab is used to review any information that is included in a submission that is mapped to any customer-defined tables. The Custom Data tab is available if the Submission Type is FERPA Permissions AND if there are submission data mapped to customer-defined tables for the current submission. A sunburst icon (

) is displayed beside the "Custom Data" label on the tab.

The tab consists of a grid displaying all submitted columns (Question Text, Mapped Table Name, Mapped Column Name, and Submission Value) that are mapped to customer-defined tables. There is no comparison of values in existing tables to the submitted values since J1 Desktop does not know how to process data mapped to custom tables because the key is unknown for the custom tables being updated; therefore, you must determine how to use the submitted data to update the custom tables. However, a stored procedure template is provided to process the data according to your wishes/needs.

Buttons

Clicking this button runs the CUST_TABLES$UPD_SUBMITTED_PERM stored procedure. This stored procedure by default retrieves the data from the SUBMISSION_RESPONSE_V and uses only mapped columns from custom tables for the SUBMISSION_ID.

If the stored procedure was not run successfully, an error message is displayed and the Run Stored Procedure button is still enabled and the sunburst icon is still displayed.

If the stored procedure was run successfully, the Run Stored Procedure button is not available and the sunburst icon is removed.

Clicking this button displays an InfoMaker report. It displays column headers and the data for custom mappings so that it mimics the format of the Custom Data tab. Also, you are able to print this report.