Student Search Service (SSS)

Delivered Transaction Code: SAD_SSS

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_SSS

Conversion examples have been delivered for the following fields:

  • Academic Interest based on incoming Major Choice values.

  • Academic Plan based on incoming Major Choice values.

  • Academic Program based on incoming Major Choice values.

  • Admit Term based on incoming Grad Year value.

  • Ethnicity based on incoming Ethnicity value.

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

Context Definition Template: SAD_SSS

Review the delivered template and determine if any records need to be added. Modify this delivered version. It will be used in 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_SSS_PROSPECTS

This file mapping definition can be used to create prospects 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_SSS. 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 SSS layout you are using.

Mapping Tab:

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

  • SCC_STG_NAMES.NAME_TYPE

  • SCC_STG_ADDR.ADDRESS_TYPE

  • SCC_STG_EMAIL.E_ADDR_TYPE

  • 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_STG_PRS_CAF.ACAD_CAREER – Eight Rows

  • SAD_STG_PRS_CAF.INSTITUTION – Eight Rows

  • SAD_PRS_PRG_STG.ACAD_CAREER

  • SAD_PRS_PRG_STG.INSTITUTION

  • SAD_PRS_PRG_STG.RECRUITING_STATUS

  • SAD_PRS_PLN_STG.ACAD_CAREER

  • SAD_PRS_PLN_STG_PRG.INSTITUTION

  • SCC_STG_ADMIHD.ACAD_CAREER

  • SCC_STG_ADMINT.ACAD_CAREER – Five rows

Calculated Fields. The following calculated fields have been delivered for SSS:

  • 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.COUNTRY – Uses the incoming value from Country Name in position 334 - 362 to determine the three character Country value to populate from COUNTRY_TBL.

  • SAD_PRS_CAR_STG.ADM_RCR_CTR – Looks at the prospect setup you have defined to determine recruiting center. If you did not 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 AI Code in position 434 to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ATP_CODE.

  • SCC_STG_ADMINT.DESCR - Derive the academic interest description based on the External Subject Area populated.

Note:

If you have purchased names based on AP Test Takers, it is suggested that you delete the row for SCC_STG_ADMIHD and 5 rows for SCC_STG_ADMINT as the Major Choice data is not provided in the data file.

Field Conversion Definitions. If you changed the Conversion Definition on the File Definition tab, you will need to repopulate the conversion fields on the Value Conversion tab of the Field Mapping Detail for the following fields:

  • SCC_STG_DIV_ETH.ETHNIC_GRP_CD – Ethnicity Conversion Field

  • SCC_STG_ETH_DTL.ETHNIC_GRP_CD – Ethnicity Conversion Field

  • SAD_PRS_CAR_STG.ADMIT_TERM – Admit Term Conversion Field

  • SAD_PRS_PRG_STG.ACAD_PROG – Academic Program Conversion Field

  • SAD_PRS_PLN_STG.ACAD_PROG – Academic Program Conversion Field

  • SAD_PRS_PLN_STG.ACAD_PLAN – Academic Plan Conversion Field

  • SCC_STG_ADMINT.EXT_SUBJECT_AREA (Five Rows) – Academic Interest Conversion Field

Common Attribute Framework

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

  • SSS_POSTAL_DEL_PT for Postal Delivery Point

  • SSS_POSTAL_COR_CHAR for Postal Correction Character

  • SSS_GEOMKT_CODE for Geomarket Code

  • SSS_MR_CB_EXAM for Most Recent CB Exam

  • SSS_HOMESCH_IND for Homeschooled Indicator

  • SSS_COUNTRY_NAME for Country Name

  • SSS_SEGA_HS_CLUSTER for Segment Analysis HS Cluster

  • SSS_SEGA_EN_CLUSTER for Segment Analysis EN Cluster

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 ADM_PRSPCT_CAR 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:

  • Order Number

  • Run Code

  • Student ID

  • County Code

  • AP Exam Code 1

  • AP Exam Code 2

  • AP Exam Code 3

  • AP Exam Code 4

  • AP Exam Code 5

  • AP Exam Code 6

  • AP Exam Code 7

  • AP Exam Code 8

  • AP Exam Code 9

  • AP Exam Code 10

  • SAT Subject Test Code 1

  • SAT Subject Test Code 2

  • SAT Subject Test Code 3

  • SAT Subject Test Code 4

  • SAT Subject Test Code 5

  • SAT Subject Test Code 6

  • SAT Subject Test Code 7

  • SAT Subject Test Code 8

  • SAT Subject Test Code 9

  • SAT Subject Test Code 10

  • Last Update Date

  • Low SES

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