Graduate Record Examinations (GRE)

Delivered Transaction Code: SAD_GRE

Modify the delivered transaction as follows:

  • Update the data update rule with one defined by your institution based on your constituent data update policies.

  • Search/Match Setup: Update the search parameter, search result codes and update rules based on your institution’s needs.

File Parser Field Conversion Definition Template: SAD_GRE

Conversion examples have been delivered for the following fields:

  • ACAD CAREER based on incoming Department Code value.

  • ACAD_PROG based on incoming Department Code value.

  • ACAD PLAN based on incoming Intended Graduate Major Field value.

  • GENDER based on incoming Gender value.

Each of these conversions may need to be modified based upon your internal values. Either create a new field conversion definition or copy the delivered definition and modify as needed.

Context Definition Template: SAD_GRE

Review the delivered template and determine if any records need to be added. Modify this delivered version. It will be used on the File Mapping Definition component. Create a copy before doing so to keep an original version. If you choose to use a copy of a delivered context definition and reference the copied version in your file mapping definition, the system forces you to redefine the file layout and file mapping setup.

File Mapping Definition Template: SAD_GRE_TESTPROSPECT

This file mapping definition can be used to create prospects, populate test scores and supporting data such as academic interests. You will need to make changes to this delivered template to reflect institution defined default values. Before doing so, make a copy of the delivered template.

File Definition Tab:

Important:

Leave the context definition as SAD_GRE. If you change this, all the file layout and mapping setup will disappear.

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the GRE layout you are using.

Mapping Tab:

The default values for the following fields will need to be reviewed and probably modified depending upon your institution’s business practices:

  • SCC_STG_NAMES.NAME_TYPE

  • SCC_STG_ADDR.ADDRESS_TYPE

  • SCC_STG_EMAIL.E_ADDR_TYPE

  • SCC_STG_PHONE.PHONE TYPE

  • SCC_STG_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_ID – Twenty-one rows

  • SCC_STG_TESTCMP.TEST_COMPONENT – Twenty-one rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Twenty-one rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Seven rows

  • SAD_PRS_CAR_STG.INSTITUTION

  • SAD_PRS_CAR_STG.RECRUITING_STATUS

  • SAD_PRS_CAR_STG.ADM_REFRL_SRCE

  • SAD_PRS_PRG_STG.INSTITUTION

  • SAD_PRS_PRG_STG.RECRUITING_STATUS

  • SAD_PRS_PLN_STG.INSTITUTION

  • SCC_STG_ADMINT.LS_DATA_SOURCE

Calculated Fields: The following calculated fields have been delivered for GRE:

  • SCC_STG_NAMES.LAST_NAME_SRCH - Removes all special characters and puts the field into upper case.

  • SCC_STG_NAMES.FIRST_NAME_SRCH - Removes all special characters and puts the field into upper case.

  • SCC_STG_TESTCMP.SCORE - Twenty one rows. Formats the incoming score.

    • Verbal Reasoning Score: If Test Code is 02 and Score Type is V, then Scaled Score should be populated.

    • Quantitative Reasoning Score: If Test Code is 02 and Score Type is Q, then Scaled Score should be populated.

    • New Verbal Reasoning Score: If Test Code is 03 and Score Type is V, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is V, then Estimated Current Score should be populated.

    • New Quantitative Reasoning Score: If Test Code is 03 and Score Type is Q, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is Q, then Estimated Current Score should be populated.

    • Analytical Writing Score: If Test Code is 02 or 03 and Score Type is W, then Scaled Score should be populated.

    • Biochemistry, Cell, Molecular Biology Score: If Test Code is 22 and Score Type is S, then Scaled Score should be populated.

    • Biochemistry Subscore: If Test Code is 22 and Score Type is 1, then Scaled Score should be populated.

    • Cell Biology Subscore: If Test Code is 22 and Score Type is 2, then Scaled Score should be populated.

    • Molecular Bio & Genetics Subscore: If Test Code is 22 and Score Type is 3, then Scaled Score should be populated.

    • Biology Score: If Test Code is 24 and Score Type is S, then Scaled Score should be populated.

    • Cellular & Molecular Bio Subscore: If Test Code is 24 and Score Type is 1, then Scaled Score should be populated.

    • Organismal Biology Subscore: If Test Code is 24 and Score Type is 2, then Scaled Score should be populated.

    • Ecology & Evolution Subscore: If Test Code is 24 and Score Type is 3, then Scaled Score should be populated.

    • Chemistry Score: If Test Code is 27 and Score Type is S, then Scaled Score should be populated.

    • Computer Science Score: If Test Code is 29 and Score Type is S, then Scaled Score should be populated.

    • Literature in English Score: If Test Code is 64 and Score Type is S, then Scaled Score should be populated.

    • Mathematics Score: If Test Code is 68 and Score Type is S, then Scaled Score should be populated.

    • Physics Score: If Test Code is 77 and Score Type is S, then Scaled Score should be populated .

    • Psychology Score: If Test Code is 81 and Score Type is S, then Scaled Score should be populated.

    • Experimental Psychology Subscore: If Test Code is 81 and Score Type is 1, then Scaled Score should be populated.

    • Social Psychology Subscore: If Test Code is 81 and Score Type is 2, then Scaled Score should be populated.

  • SCC_STG_TESTCMP.PERCENTILE - Twenty One rows. Formats the incoming percentile.

    • Verbal Reasoning Percentage: If Test Code is 02 and Score Type is V, then Percentage Rank should be populated.

    • Quantitative Reasoning Percentage: If Test Code is 02 and Score Type is Q, then Percentage Rank should be populated.

    • New Verbal Reasoning Percentage: If Test Code is 03 and Score Type is V, then Percentage Rank should be populated.

    • New Quantitative Reasoning Percentage: If Test Code is 03 and Score Type is Q, then Percentage Rank should be populated.

    • Analytical Writing Percentage: If Test Code is 02 or 03 and Score Type is W, then Percentage Rank should be populated.

    • Biochemistry, Cell, Molecular Biology Percentage: If Test Code is 22 and Score Type is S, then Percentage Rank should be populated.

    • Biochemistry Percentage: If Test Code is 22 and Score Type is 1, then Percentage Rank should be populated.

    • Cell Biology Percentage: If Test Code is 22 and Score Type is 2, then Percentage Rank should be populated.

    • Molecular Bio & Genetics Percentage: If Test Code is 22 and Score Type is 3, then Percentage Rank should be populated.

    • Biology Percentage: If Test Code is 24 and Score Type is S, then Percentage Rank should be populated.

    • Cellular & Molecular Bio Percentage: If Test Code is 24 and Score Type is 1, then Percentage Rank should be populated.

    • Organismal Biology Percentage: If Test Code is 24 and Score Type is 2, then Percentage Rank should be populated.

    • Ecology & Evolution Percentage: If Test Code is 24 and Score Type is 3, then Percentage Rank should be populated.

    • Chemistry Percentage: If Test Code is 27 and Score Type is S, then Percentage Rank should be populated.

    • Computer Science Percentage: If Test Code is 29 and Score Type is S, then Percentage Rank should be populated.

    • Literature in English Percentage: If Test Code is 64 and Score Type is S, then Percentage Rank should be populated.

    • Mathematics Percentage: If Test Code is 68 and Score Type is S, then Percentage Rank should be populated.

    • Physics Percentage: If Test Code is 77 and Score Type is S, then Percentage Rank should be populated.

    • Psychology Percentage: If Test Code is 81 and Score Type is S, then Percentage Rank should be populated.

    • Experimental Psychology Percentage: If Test Code is 81 and Score Type is 1, then Percentage Rank should be populated.

    • Social Psychology Percentage: If Test Code is 81 and Score Type is 2, then Percentage Rank should be populated.

  • SAD_PRS_CAR_STG.ADM_RECR_CTR - Derives the Recruiting Center based on the incoming Institution, Career, Program, and Plan.

File Mapping Definition Template: SAD_GRE_TESTRESULTS

This file mapping definition can be used to post GRE test scores. You will need to make changes to this delivered template to reflect institution defined default values. Before doing so, make a copy of the delivered template.

File Definition Tab:

Important:

Leave the context definition as SAD_GRE. If you change this, all the file layout and mapping setup will disappear.

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the GRE layout you are using.

Mapping Tab:

The default values for the following fields will need to be reviewed and probably modified depending upon your institution’s business practices:

  • SCC_STG_NAMES.NAME_TYPE

  • SCC_STG_ADDR.ADDRESS_TYPE

  • SCC_STG_EMAIL.E_ADDR_TYPE

  • SCC_STG_PHONE.PHONE TYPE

  • SCC_STG_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_ID – Twenty-one rows

  • SCC_STG_TESTCMP.TEST_COMPONENT – Twenty-one rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Twenty-one rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Seven rows

Calculated Fields: The following calculated fields have been delivered for GRE:

  • SCC_STG_NAMES.LAST_NAME_SRCH - Removes all special characters and puts the field into upper case.

  • SCC_STG_NAMES.FIRST_NAME_SRCH - Removes all special characters and puts the field into upper case.

  • SCC_STG_TESTCMP.SCORE - Twenty one rows. Formats the incoming score.

    • Verbal Reasoning Score: If Test Code is 02 and Score Type is V, then Scaled Score should be populated.

    • Quantitative Reasoning Score: If Test Code is 02 and Score Type is Q, then Scaled Score should be populated.

    • New Verbal Reasoning Score: If Test Code is 03 and Score Type is V, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is V, then Estimated Current Score should be populated.

    • New Quantitative Reasoning Score: If Test Code is 03 and Score Type is V, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is Q, then Estimated Current Score should be populated.

    • Analytical Writing Score: If Test Code is 02 or 03 and Score Type is W, then Scaled Score should be populated.

    • Biochemistry, Cell, Molecular Biology Score: If Test Code is 22 and Score Type is S, then Scaled Score should be populated.

    • Biochemistry Subscore: If Test Code is 22 and Score Type is 1, then Scaled Score should be populated.

    • Cell Biology Subscore: If Test Code is 22 and Score Type is 2, then Scaled Score should be populated.

    • Molecular Bio & Genetics Subscore: If Test Code is 22 and Score Type is 3, then Scaled Score should be populated.

    • Biology Score: If Test Code is 24 and Score Type is S, then Scaled Score should be populated.

    • Cellular & Molecular Bio Subscore: If Test Code is 24 and Score Type is 1, then Scaled Score should be populated.

    • Organismal Biology Subscore: If Test Code is 24 and Score Type is 2, then Scaled Score should be populated.

    • Ecology & Evolution Subscore: If Test Code is 24 and Score Type is 3, then Scaled Score should be populated.

    • Chemistry Score: If Test Code is 27 and Score Type is S, then Scaled Score should be populated.

    • Computer Science Score: If Test Code is 29 and Score Type is S, then Scaled Score should be populated.

    • Literature in English Score: If Test Code is 64 and Score Type is S, then Scaled Score should be populated.

    • Mathematics Score: If Test Code is 68 and Score Type is S, then Scaled Score should be populated.

    • Physics Score: If Test Code is 77 and Score Type is S, then Scaled Score should be populated.

    • Psychology Score: If Test Code is 81 and Score Type is S, then Scaled Score should be populated.

    • Experimental Psychology Subscore: If Test Code is 81 and Score Type is 1, then Scaled Score should be populated.

    • Social Psychology Subscore: If Test Code is 81 and Score Type is 2, then Scaled Score should be populated.

  • SCC_STG_TESTCMP.PERCENTILE - Twenty one rows. Formats the incoming percentile.

    • Verbal Reasoning Percentage: If Test Code is 02 and Score Type is V, then Percentage Rank should be populated.

    • Quantitative Reasoning Percentage: If Test Code is 02 and Score Type is Q, then Percentage Rank should be populated.

    • New Verbal Reasoning Percentage: If Test Code is 03 and Score Type is V, then Percentage Rank should be populated.

    • New Quantitative Reasoning Percentage: If Test Code is 03 and Score Type is Q, then Percentage Rank should be populated.

    • Analytical Writing Percentage: If Test Code is 02 or 03 and Score Type is W, then Percentage Rank should be populated.

    • Biochemistry, Cell, Molecular Biology Percentage: If Test Code is 22 and Score Type is S, then Percentage Rank should be populated.

    • Biochemistry Percentage: If Test Code is 22 and Score Type is 1, then Percentage Rank should be populated.

    • Cell Biology Percentage: If Test Code is 22 and Score Type is 2, then Percentage Rank should be populated.

    • Molecular Bio & Genetics Percentage: If Test Code is 22 and Score Type is 3, then Percentage Rank should be populated.

    • Biology Percentage: If Test Code is 24 and Score Type is S, then Percentage Rank should be populated.

    • Cellular & Molecular Bio Percentage: If Test Code is 24 and Score Type is 1, then Percentage Rank should be populated.

    • Organismal Biology Percentage: If Test Code is 24 and Score Type is 2, then Percentage Rank should be populated.

    • Ecology & Evolution Percentage: If Test Code is 24 and Score Type is 3, then Percentage Rank should be populated.

    • Chemistry Percentage: If Test Code is 27 and Score Type is S, then Percentage Rank should be populated.

    • Computer Science Percentage: If Test Code is 29 and Score Type is S, then Percentage Rank should be populated.

    • Literature in English Percentage: If Test Code is 64 and Score Type is S, then Percentage Rank should be populated.

    • Mathematics Percentage: If Test Code is 68 and Score Type is S, then Percentage Rank should be populated.

    • Physics Percentage: If Test Code is 77 and Score Type is S, then Percentage Rank should be populated.

    • Psychology Percentage: If Test Code is 81 and Score Type is S, then Percentage Rank should be populated.

    • Experimental Psychology Percentage: If Test Code is 81 and Score Type is 1, then Percentage Rank should be populated.

    • Social Psychology Percentage: If Test Code is 81 and Score Type is 2, then Percentage Rank should be populated.

Common Attribute Framework:

The following sample common attributes have been delivered for the incoming field indicated. These attributes should be associated with the SAD_TESTDT record context:

  • GRE_LAST4_SSN - Social Security Number – Last 4 Digits

  • GRE_REG_NBR - Registration Number

  • GRE_TEST_NAME - Test Name

  • GRE_EXAM_SEQ_NO - Examinee Sequence No.

  • GRE_REC_SRL_NBR - Record Serial Number

  • GRE_CYCLE_NO - Cycle Number

  • GRE_PROC_DT - Process Date

Set up additional common attributes for other fields that have not been mapped on the File Mapping Definition component. Add each new attribute to the SAD_TESTDT record context. In addition to creating the common attribute and adding them to the record context, you will need to add rows for each common attribute on the File Mapping Definition component. Additional fields that were not mapped include:

  • Institution Name

  • Department Name

  • Country

  • Test Code

To complete the setup for the delivered common attributes, see: