Test Scores Tab (Review Internet Submission Window)

If the Submission Type is Admissions Inquiry - New (320), Admissions Application - New (330), Student Request (530), or Transcript (580)this tab may be displayed even if no data is submitted for the TEST_SCORES mapping table. If available, the Test Scores and User Defined subtabs on the Test Scores tab contain the same information as the Test Scores window/tabs used throughout J1 Desktop and is used to review any test scores information that is included in a submission that needs to be saved to the TEST_SCORES table in the J1 database.

·       Submitted Test Score rows are displayed below the existing Test Score rows in the same grid. A sunburst icon () is displayed beside the new Test Score rows so that they can be quickly identified.

·       Each submitted row for the TEST_SCORES mapping table can have from 1 to 10 individual test element codes and scores. Each test element code and its corresponding score are displayed on the Edit Test Scores window as a new TEST_ELEMENT row. You can edit the test dates and test score details for these rows when the submission type is Transcript (580).

·       Data submitted for the DTE_TAKEN, REQUESTED_SCORES_BE_SENT, and TST_CDE columns on the TEST_SCORES logical mapping table are displayed in this tab.

·       Submitted test scores from Admissions Inquiry - New (320), Admissions Application - New (330), or Student Request (530) are always marked as SELF_REPORTED since the candidate/student submitted the data. Submitted test scored from Transcript (580) are not marked as SELF_REPORTED.

·       Submitted rows can be deleted from this window if you determine that the information is a duplication of an existing TEST_SCORES row.

·       When you save submitted test score and test element information that is displayed on this tab, the information is saved to the TEST_SCORES and TEST_SCORES_DETAIL tables.

If only Hidden Data/Custom Text is submitted for a table/row combination (i.e., Table, Row # but no score information), the data for that row is ignored.

Tests that have been marked as Self-Reported will not be included in the Highest Test Score or AD Requirements calculations.

If a test that has been submitted on a transcript is not yet defined in J1 Desktop, you must open the Test Scores Definition and Edit Test Elements windows and define the test and test elements (including PESC values) before you can process the imported test scores.

Right-Click Options

Columns and Mappings

Test Scores

In previous versions, the TEST_SCORES.SELF_REPORTED column was always set to 'Y' for submitted test scores. The column was made available for mapping, therefore the Review Internet Submissions window will no longer set the value for the SELF_REPORTED column. Any Form Builder 2.0 forms that request test score information must be reviewed and the SELF_REPORTED flag set accordingly (most likely as Custom Text, but a variety of alteratives are available).

When configuring mappings to the TEST_SCORES mapping table in the campus portal (JICS) form, you must ensure that the TST_ELEM_CDE's entered are appropriate for the entered TEST_CDE on the same mapping row.

Columns and Mappings for Test Scores

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
Test	TEST_SCORES	TST_CDE	Y	TEST_SCORES	TST_CDE
	TEST_SCORES	TST_SEQ	N
Description	TEST_DEFINITION	TST_DESC	N
Total Composite Score	TEST_SCORES	TOTAL_COMPOS_SCORE	Y	TEST_SCORES	TOTAL_COMPOS_SCORE
Date Taken	TEST_SCORES	DTE_TAKEN	Y	TEST_SCORES	DTE_TAKEN
Self-Reported	TEST_SCORES	SELF_REPORTED	Y	TEST_SCORES	SELF_REPORTED
Test Report Type	TEST_SCORES	TEST_REPORT_TYPE	Y	TEST_SCORES	TEST_REPORT_TYPE
Test Location Type	TEST_SCORES	TestLocationTypeDefinitionAppID	Y	TEST_SCORES	TEST_LOCATION_TYPE
Requested Scores	TEST_SCORES	REQUESTED_SCORES_BE_SENT	Y	TEST_SCORES	REQUESTED_SCORES_BE_SENT

 

If you have mapped the TOTAL_COMPOS_SCORE mapping column to your form, the Review Internet Submissions window will use any submitted value from the submitted element scores rather than calculating the total score. Therefore, if the submitter incorrectly enters the total score value, there will probably be a discrepancy between the total score and the combined element score.

 

Test Elements

Each submitted test can have 1-10 defined test elements, each consisting of an element code and a score. Test elements are saved when you save the test.

Columns and Mappings for Test Elements

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
Test	TEST_SCORES	TST_CDE	Y	TEST_SCORES	TST_CDE
	TEST_SCORES	TST_SEQ	N
Description	TEST_DEFINITION	TST_DESC	N
Total Composite Score	TEST_SCORES	TOTAL_COMPOS_SCORE	N
Date Taken	TEST_SCORES	DTE_TAKEN	Y	TEST_SCORES	DTE_TAKEN
Test Element	TEST_SCORES_DETAIL	TST_ELEM	Y	TEST_SCORES	TEST_ELEM_CDE_1 through TEST_ELEM_CDE_10
Test Element Description	TEST_ELEMENT_DEF	TST_ELEM_DESC	N
Test Score	TEST_SCORES_DETAIL	TST_SCORE	Y	TEST_SCORES	TEST_ELEM_SCORE_1 through TEST_ELEM_SCORE_10
Percentile	TEST_SCORES_DETAIL	TST_PERCENTILE	Y	TEST_SCORES	TEST_ELEM_PERCENT_1 through TEST_ELEM_PERCENT_10

Related Topics

Review Internet Submission Window

Test Scores Window

Common Functionality for Grid Windows

Edit Test Scores window

Edit Test Elements