Pearson Test of English (PTE)

Delivered Transaction Code: SAD_PTE

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_PTE

Conversion examples have been delivered for the following fields:

Academic Career based on incoming Program Receiving Scores values.
Academic Plan based on incoming Program Receiving Scores values.
Academic Program based on incoming Program Receiving Scores values.
STATE/PROVINCE/COUNTY based on incoming Country Of Residence and State/Province/County values. Used with a delivered calculated field.

Each of these conversions will 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_PTE

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_PTE_TESTRESULTS

This file mapping definition can be used to post PTE 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_PTE. 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 PTE 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 – Two rows
SCC_STG_TEST.TEST_ID
SCC_STG_TEST.CHKLST_ITM_UPDT
SCC_STG_TESTCMP.TEST_COMPONENT – Eleven rows
SCC_STG_TESTCMP.LS_DATA_SOURCE – Eleven rows
SCC_STG_TESTDT.TEST_ID
SAD_STG_TST_CAF.TEST_ID – Five rows

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

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 Country of Residence and State/Province/County and compares them to the Field Conversion Definition for STATE/PROVINCE/COUNTY to determine the value to populate.

File Mapping Definition Template: SAD_PTE_TESTPROSPECT

This file mapping definition can be used to post PTE 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 PTE 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 – Two rows
SCC_STG_TEST.TEST_ID
SCC_STG_TEST.CHKLST_ITM_UPDT
SCC_STG_TESTCMP.TEST_COMPONENT – Eleven rows
SCC_STG_TESTCMP.LS_DATA_SOURCE– Eleven rows
SCC_STG_TESTDT.TEST_ID
SAD_STG_TST_CAF.TEST_ID – Five 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

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

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/COUNTY to determine the value to populate.
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.

Common Attribute Framework:

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

PTE_DTSCORESAVAIL for Date Scores Available To Program
PTE_FIRSTTIMETESTTKR for First-Time Test Taker
PTE_PROGRECSCORES for Program Receiving Scores
PTE_REGISTRATIONID for Registration Id
PTE_SCORESVALIDUNTIL for Scores Valid Until

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: Irregularity Code

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