Graduate Management Admission Test (GMAT)

Delivered Transaction Code: SAD_GMAT

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_GMAT

Conversion examples have been delivered for the following fields:

  • Admit Term based on incoming Graduation Date values.

  • Gender based on incoming Gender values.

  • STATE/PROVINCE based on incoming Country Of Residence and State/Province values. Used with a delivered calculated field.

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.

Note:

Not all State/Province Codes have been mapped. See the rows populated for the following provinces in Pakistan: PAKICT (Islamabad Capital Territory), PAKNWF (North West Frontier), PAKPUN (Punjab) and PAKSIN (Sindh) and enter an internal values for these states.

Context Definition Template: SAD_GMAT

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_GMAT_TESTPROSPECT

This file mapping definition can be used to create prospects in addition to populating 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_GMAT. 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 GMAT layout you are using. Modify default values on the Date Day column for the fields:

  • Administration Date

  • Administration Date2

  • Administration Date3

  • Graduation Date

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 – Fifteen rows

  • SCC_STG_TESTCMP.TEST_COMPONENT – Fifteen rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Fifteen rows

  • SCC_STG_TESTDT.TEST_ID – Three rows

  • SAD_STG_TST_CAF.TEST_ID – Eight rows

  • SCC_STG_STD_CAR.ACAD_CAREER

  • SAD_PRS_CAR_STG.ACAD_CAREER

  • SAD_PRS_CAR_STG.INSTITUTION

  • SAD_PRS_CAR_STG.RECRUITING_STATUS

  • SAD_PRS_CAR_STG.ADM_REFRL_SRCE

  • SAD_PRS_PRG_STG.ACAD_CAREER

  • SAD_PRS_PRG_STG.INSTITUTION

  • SAD_PRS_PRG_STG.ACAD_PROG

  • SAD_PRS_PRG_STG.RECRUITING_STATUS

  • SAD_PRS_PLN_STG.ACAD_CAREER

  • SAD_PRS_PLN_STG.INSTITUTION

  • SAD_PRS_PLN_STG.ACAD_PROG

  • SAD_PRS_PLN_STG.ACAD_PLAN

  • SAD_STG_PRS_CAF.ACAD_CAREER – Three rows.

  • SAD_STG_PRS_CAF.INSTITUTION – Three rows.

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

  • 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_ADDR.STATE - Concatenates the incoming values for the Country of Residence and State/Province/County fields and compares them to the field conversion definition for STATE/PROVINCE to determine the value to populate.

  • SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for the Verbal Converted Score, Quantitative Converted Score, Total Converted Score, Analytical Writing Converted Score and Integrated Reasoning Converted Score (depending on the application class ID populated). If the incoming value is ++ or +++ or ~~~, population of the row is skipped.

  • SCC_STG_TESTCMP.PERCENTILE - Looks at the incoming percentile value for the Verbal Percentage Below, Quantitative Percentage Below, Total Score Percentage Below, Analytical Writing Percentage Below or Integrated Reasoning Percentage (depending on the application class ID populated). If the incoming value is ++ or ~~, population of the field is skipped.

  • SAD_PRS_CAR_STG.ADM_RECR_CTR - Looks at the prospect setup you have defined to determine recruiting center. If you don’t set up the Prospect Setup page, you will need to change this to a default recruiting center.

  • SAD_PRS_CAR_STG.LAST_SCH_ATTEND - Uses the incoming value from Attending Institution Code to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ATP_CODE.

File Mapping Definition Template: SAD_GMAT_TESTRESULTS

This file mapping definition can be used to post GMAT 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_GMAT. 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 GMAT layout you are using. Modify default values on the Date Day column for the fields:

  • Administration Date

  • Administration Date2

  • Administration Date3

  • Graduation Date

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 – Fifteen rows

  • SCC_STG_TESTCMP.TEST_COMPONENT – Fifteen rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Fifteen rows

  • SCC_STG_TESTDT.TEST_ID – Three rows

  • SAD_STG_TST_CAF.TEST_ID – Eleven rows

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

  • 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_ADDR.STATE - Concatenates the incoming values for the Country of Residence and State/Province/County fields and compares them to the field conversion definition for STATE/PROVINCE to determine the value to populate.

  • SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for the Verbal Converted Score, Quantitative Converted Score, Total Converted Score, Analytical Writing Converted Score and Integrated Reasoning Converted Score (depending on the application class ID populated). If the incoming value is ++ or +++ or ~~~, population of the row is skipped.

  • SCC_STG_TESTCMP.PERCENTILE - Looks at the incoming percentile value for the Verbal Percentage Below, Quantitative Percentage Below, Total Score Percentage Below, Analytical Writing Percentage Below or Integrated Reasoning Percentage (depending on the application class ID populated). If the incoming value is ++ or ~~, population of the field is skipped.

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:

  • GMAT_DT_SCORE - Date Scores Published to Program.

  • GMAT_EDU_LVL - Education Level.

  • GMAT_ID_NBR - GMAT ID Number.

  • GMAT_IN_GRD_STUDY - Intended Graduate Study.

  • GMAT_IRR_CD - Irregularity Code.

  • GMAT_PROG_CD - GMAT Program Code.

  • GMAT_REG_NBR - Registration/Appt Number.

  • GMAT_UGRD_MJCD - Undergraduate Major Code.

  • GMAT_UGRD_PTAVG - Undergraduate Grade Point Average.

These attributes should be associate with the ADM_PRSPCT_CAR Record Context:

  • GMAT_EDU_LVL - Education Level.

  • GMAT_UGRD_MJCD - Undergraduate Major Code.

  • GMAT_UGRD_PTAVG - Undergraduate Grade Point Average.

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