Test Of English as a Foreign Language (TOEFL)

Delivered Transaction Code: SAD_TOEFL

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_TOEFL

Conversion examples have been delivered for the following fields:

  • Gender based on incoming Gender values.

  • Language Code based on incoming Native Language Code values.

  • Academic Career based on incoming Department Code values.

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 Native Language Code values have been mapped. The following incoming language codes are not mapped: AKA (Akan), ALB (Albanian), ASM (Assamese), AZE (Azerbaijani), BAM (Bambara), BAK (Bashkir), BAQ (Basque), BEL (Belarusian), BEN (Bemba), BER (Berber), BIK (Bikol), BOS (Bosnian), CAT (Catalan), CEB (Cebuano), NYA (Chichewa (Nyanja)), CHV (Chuvash), DYU (Dyula), EFI (Efik), EST (Estonian), EWE (Ewe), FIJ (Fijian), FIN (Finnish), FUL (Fulah), GAA (Ga), GLA (Galician), LUG (Ganda), GEO(Georgian), GRN (Guarani), GUJ (Gujarati), GWI (Gwichin), HAU (Hausa), HIL (Hiligaynon), IBO (Igbo), ILO (Iloko), IPK (Inupiaq), JAV (Javanese), KAU (Kanuri), KAS (Kashmiri), KAZ (Kazakh), KHM (Khmer), KIK (Kikuyu), KIN (Kinyarwanda), KOS (Kosraean), KUR (Kurdish), KUS (Kusaiean), LIN (Lingala), LUA (Luba-Lulua), LUO (Luo), LTZ (Luzembourgish), MAC (Macedonian), MAD (Madurese), MLG (Malagasy), MAL (Malayalam), MLT (Maltese), MAN (Mandingo), MAR (Marathi), MAH (Marshallese), MEN (Mende), MIN (Minangkabau), MON (Mongolian), MOS (Mossi), NAU (Nauru), NEP (Nepali), ORI (Orlya), ORM (Oromo), PAU (Palauan), PON (Pohnpeian), PAN (Punjabi), PUS (Pushto), SMO (Samoan), SAT (Santali), SNA (Shona), SND (Sindhi), SIN (Sinhalese), SLO (Slovak), SLV (Slovenian), SOL (Somali), SUN (Sundanese), TGK (Tajik), TAT (Talar), TIB (Tibetan), TIR (Tigrinya), TON (Tonga), TUK (Turkmen), UIG (Uighar), UZB (Uzbek), WOL (Wolof), XHO (Xhosa), YAP (Yapese), YID (Yiddish), YOR (Yoruba), YPK (Yupik), ZHA (Zhuang), ZUL (Zulu).

Context Definition Template: SAD_TOEFL

Review the delivered template and determine if any records need to be added. Modify this delivered definition. 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_TOEFL_TESTRESULTS

This file mapping definition can be used to post TOEFL test scores only. 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_TOEFL. 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 TOEFL 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_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_COMPONENT – Ten rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Ten rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Ten rows

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

  • 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_NAMES.LAST_NAME, SCC_STG_NAMES.FIRST_NAME and SCC_STG_NAMES.MIDDLE_NAME - Parses the incoming value in Last (Family) Name in position 43 into LAST_NAME, FIRST_NAME and MIDDLE_NAME when the Test Type = P (PBT) in field position 556. If the Test Type is I (IBT), the name parts will appear in the three separate fields Last (Family) Name, First (Given) Name and Middle Name and will populate LAST_NAME, FIRST_NAME and MIDDLE_NAME from the three fields.

  • SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for IBT Listening, IBT Speaking, IBT Total Score, P/B Section I Score and Total Score (depending on the application class ID populated). If the incoming value is ** or ***, population of the row is skipped.

  • SCC_STG_ADDR.STATE - Validates the incoming country against the values in the country table. If the country exists, it then validates the incoming state-country combination against the state table. If the state-province is found, the state value is populated. If not, the field is left blank.

File Mapping Definition Template: SAD_TOEFL_TESTPROSPECT

This file mapping definition can be used to post TOEFL test scores and create a prospect record. 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: Modify context definition and conversion definition to those 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 TOEFL 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_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_COMPONENT – Ten rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Ten rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Ten rows

  • SAD_PRS_CAR_STG.INSTITUTION

  • SAD_PRS_CAR_STG.RECRUITING_STATUS

  • SAD_PRS_CAR_STG.ADM_REFRL_SRCE

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

  • 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_NAMES.LAST_NAME, SCC_STG_NAMES.FIRST_NAME and SCC_STG_NAMES.MIDDLE_NAME - Parses the incoming value in Last (Family) Name in position 43 into LAST_NAME, FIRST_NAME and MIDDLE_NAME when the Test Type = P (PBT) in field position 556. If the Test Type is I (IBT), the name parts will appear in the three separate fields Last (Family) Name, First (Given) Name and Middle Name and will populate LAST_NAME, FIRST_NAME and MIDDLE_NAME from the three fields.

  • SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for IBT Listening, IBT Speaking, IBT Total Score, P/B Section I Score and Total Score (depending on the application class ID populated). If the incoming value is ** or ***, population of the row 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.

  • SCC_STG_ADDR.STATE - Validates the incoming country against the values in the country table. If the country exists, it then validates the incoming state-country combination against the state table. If the state-province is found, the state value is populated. If not, the field is left blank.

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:

  • TOEFL_REG_NBR for Registration or Appointment Number

  • TOEFL_TESTCTR_CD for Test Center Code

  • TOEFL_LIST_IND for Listening Indicator

  • TOEFL_SPK_IND for Speaking Indicator

  • TOEFL_REASON_TKN for Reason for taking TOEFL

  • TOEFL_DEGREE for Degree

  • TOEFL_INTINFO_YEAR for Interpretive Info Year

  • TOEFL_NBR_TAKEN for Number of times taken

  • TOEFL_IBT_TESTCTR for IBT Test Center Code

  • TOEFL_TSTCTR_CNTRY for Test Center Country

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 Code

• Department Code

• Address Country Name

• Native Country Name

• Test Type

• No Resp/Off Topic

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