International English Language Testing System (IELTS)

Delivered Transaction Code: SAD_IELTS

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:

Not needed

Context Definition Template: SAD_IELTS

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_IELTS_TESTRESULTS

This file mapping definition can be used to post IELTS 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_IELTS. If you change this, all the file layout and mapping setup will disappear.

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 IELTS 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_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_COMPONENT – Five rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Five rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Six rows

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

  • 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 - Looks at the incoming score value for ListeningTestScore, ReadingTestScore, WritingTestScore, SpeakingTestScore or OverallScore (depending on the application class ID populated). If the incoming value is 0 or -1, population of the row is skipped.

Common Attribute Framework:

The following sample common attributes have been delivered for the incoming field indicated:

  • IELTS_DOWNLOADID for DownloadID

  • IELTS_PARTNO for PartNo

  • IELTS_CENTRENUMBER for CentreNumber

  • IELTS_CANDIDATENUMBR for CandidateNumber

  • IELTS_CANDIDATEID for CandidateID

  • IELTS_TRFNUMBER for TRFNumber

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:

  • StartDate

  • EndDate

To complete the setup for the delivered common attributes, see Setting Up Filtering for Common Attributes.