Setting Up External Test Score Loads

This chapter discusses how to:

• Enable the posting to CRM option.

• Define external test components.

• Define external tests.

• Define and review external data setup tables.

• Map external test IDs.

• Map external test codes to internal codes.

Note. You must complete these items before you can post external test scores to PeopleSoft Campus Solutions or PeopleSoft CRM. When you post the test scores to CRM, the system automatically creates prospect records in CRM from the posted test scores. However, when you post the test scores to Campus Solutions, you can choose whether or not to create prospect records in Campus Solutions.

Enabling the Posting to CRM Option

If you want to post test scores to PeopleSoft CRM, select the CRM for Higher Education check box on the SA Features page (Set Up SACR, Install, Student Admin Installation, SA Features).

The Post To Enterprise CRM option is available on the Search/Match/Post Test Scores page only when you select the CRM for Higher Education check box on the SA Features page.

Defining External Test Components

To set up the external test components, use the Test Component Table component (SA_TEST_COMP_TABLE).

Page Used to Define External Test Components

Defining External Tests

To define external tests, use the Test Tables component (SA_TEST_TABLE).

Page Used to Define External Tests

Defining External Tests

Access the Test Tables page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Test Tables).

Testing Agency	Select the testing agency that administers this test (if applicable). This field is for informational purposes only. Values for this field are delivered with your system as translate values. You can modify these translate values. The delivered values are American College Testing, College Board, Educational Testing Services, and Law School Admission Services.
Component	Enter the test components that you want to link to this academic test. The system populates the descriptions based on the code that you select. Define test components on the Test Component Table page.
Min Score/Max Score (minimum score/maximum score)	Enter a test score range for each component.
Subtest	Enter the code used for TS130 or TS189 processing of test scores.

Defining and Reviewing External Data Setup Tables

To define external data setup tables, use the AP Subject Test Codes component (AP_SUBJECT_CODES), AP Country Codes (SAD_AP_CNTRY_TBL), ADA Country Codes component (ADA_COUNTRY_TBL), AMCAS Credit Hour Codes component (AMCAS_CR_HR_CODE), AMCAS GPA Codes component (AMCAS_GPA_CODE), SAT Math Recentered Values component (SAT_MATH_RECENTER), SAT Verbal Recentered Values component (SAT_VERBAL_RECENTR), SAT II Test Codes component (SATII_TEST_CODES), SAT II Test Recentered Values component (SATII_TST_RECENTER), Ethnicity Mapping component (SAD_ETHNIC_MAP), and the GMAT Country codes component (SAD_GMT_CNTRY_TBL). Use the CRS_MAJOR_CODE component interface to load the data into the tables from these component interfaces.

Recruiting and Admissions delivers AP and SAT test codes, CRS major codes, MCAT credit hours, GPA codes, and SAT recentered values. These codes and values are used in external data processing.

You can edit the delivered descriptions, but we recommend that the descriptions retain their original meaning to avoid confusion when viewing the loaded test data.

This section discusses how to:

• Map AMCAS ethnic groups.

• Map AMCAS country codes.

• Map SAT country codes.

• Map ethnicity codes.

Pages Used to Review External Data Setup Tables

Mapping AMCAS Ethnic Groups

Access the AMCAS Ethnicity Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AMCAS Setup, AMCAS Ethnicity Mapping).

Ethnic Group	Enter the internal ethnic group value that corresponds to the race code.
AMCAS Race Code	Enter the external AMCAS race code.
Copy Ethnicity Map to New Application Year	Click to copy ethnicity mapping data from one application year to another. The system prompts you for the new year value.

Mapping AMCAS Country Codes

Access the AMCAS Country Mapping page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AMCAS Setup, AMCAS Country Mapping).

Copy Country Map to New Application Year

The country code mappings are keyed by application year. Click this button to copy values from one application year to a new application year. You might need to add or delete rows to accurately maintain the table in the future.

AMCAS country code values mapped to PeopleSoft values for application years 2006 and 2007 are delivered with this release. Some AMCAS country codes do not have equivalent PeopleSoft country codes. Hence, these are not delivered. Your institution must determine the mappings for these values.

The following values are not delivered for application year 2006:

The following values are not delivered for application year 2007:

Mapping SAT Country Codes

Access the SAT Country Codes page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, SAT Setup, SAT Country Codes).

The SAT Country Codes table is delivered with known field values set as of the date of this publication. You might need to add, edit, or delete rows to accurately maintain the table in the future.

Mapping Ethnicity Codes

Access the Ethnicity Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Ethnicity Mapping).

Ethnic Group	Enter the ethnic group code that corresponds to the testing agency code. Ethnicity group codes are defined on the Ethnicity Group Table page.
Ethnicity	Enter the ethnicity code provided by the testing agency. You must contact the testing agency for these codes or refer to the test score layout provided by the testing agency.

For AMCAS and MCAT ethnicity data, use the AMCAS Ethnicity Map component.

See Mapping AMCAS Ethnic Groups.

Mapping External Tests IDs

To map external test IDs, use the External Test Score Mapping component (SAD_TEST_SETUP).

This section provides an overview of external test ID mapping and discusses how to map external test score IDs to PeopleSoft test codes.

Understanding External Test ID Mapping

The PeopleSoft system uses the External Test Score Mapping page to perform a variety of external test-related functions.

The PeopleSoft system needs to know which test IDs from your institution correspond to the PeopleSoft test codes in order to know which fields to display on the external test score components. For example, when you enter the External Test Score Load page and select a test ID, the page dynamically appears based on the test ID that you enter.

In addition, when you create a query in PeopleSoft Query Manager to create prospects from test loads, the query must contain the primary candidate data record for the test. To determine which is the primary data record, go to the External Test Score Mapping page, where the primary candidate data record is indicated. Also, the records listed under Suspense Records are used in the External Test Score Purge process.

Page Used to Map External Tests IDs to PeopleSoft Test Codes

Mapping External Tests IDs to PeopleSoft Test Codes

Access the External Test Score Mapping page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, External Test Score Mapping).

Test ID

Enter a test ID for each PeopleSoft test code. If you have more than one test ID affiliated to the PeopleSoft test code, add a row and enter the additional test ID.

Available for CRM Post

Indicates whether the scores for the test ID can be posted to PeopleSoft CRM. For example, you can post ACT, AP, CRS, DAT, EOS, GMS, GMT, GRE, LSAT, SAT, SSS and TOEFL scores to CRM, therefore, the system selects the Available for CRM Post check box for these test IDs. Conversely, you cannot post ADA, AMCAS, LSDAS, NCEA, OUAC, QTAC, SATAC, Studielink, UAC, and VTAC test scores to CRM, therefore, the system does not select the Available for CRM Post check box for these test IDs.

Note. On this page, you need to enter only a test ID that corresponds to a PeopleSoft test code. PeopleSoft delivers the rest of the page complete. All test IDs that you have defined and that you intend to load through the external test score load must be mapped to a PeopleSoft test code or you will not be able to load test score data.

Warning! Do not delete the suspense or candidate data records delivered or change the primary records flag because these changes will affect the External Test Score Load and Create Prospects from Test Scores processes.

Mapping External Test Codes to Internal Codes

To map external test codes to internal codes, use the Academic Interests Map component (SAD_ACAD_MAP), Extracurricular Activity Map component (SAD_EXTRA_MAP), and the Religious Preference Map component (SAD_REL_MAP).

This section provides an overview of external test data mapping and discusses how to:

• Map academic interest codes.

• Map extracurricular activity codes.

• Map religious preference codes.

• Map admit terms.

• Map programs, plans and subplans.

See Also

Creating Prospects When Posting External Test Scores

Understanding External Test Data Mapping

In order to populate academic interest, extracurricular activity, and religious preference information from external test score loads, you must map the testing agency codes to the corresponding PeopleSoft codes. Use the Academic Interest Map, Extracurricular Activity Map, and Religious Preference Map pages to map external codes to internal codes. Set up these pages only if you want to populate that data for prospects.

Map the following codes:

• Academic interest.

  You set up internal academic interest codes on the External Subject Table page. If you set up the Academic Interests Map page, when you create prospects from the external test loads listed in the following table, the system populates the Academic Interests page for each new prospect that the system creates based on the data populated in the Test Score Candidate Data component. This data is provided by students when they take the specific tests.

  The following table shows the external tests that provide academic interest information and where in the candidate data record that the system finds this information for each test:

  Test ID	Location in Test Score Candidate Data Component
  ACT	Academics page, Academic Information group box, Major Plan field.
  EOS	Test Score Candidate Data page, Student Profile Information group box, Intended Major field.
  GMASS	Test Score Candidate Data page, Additional Information group box, Area of Concentration field.
  SAT	Student Data page, Majors group box, First Choice and Other (1) through Other (4) fields.
  SSS	Student Data page, SSS SAT I Search Information group box, SAT Search Listed Major field or SSS PSAT Search Information group box, PSAT/NMSQT Search Listed Major field.
  GRE	Test Score Candidate Data page, Grad Major Code field

• Extracurricular activity.

  You set up internal extracurricular codes on the Extracurricular Activity Table page. If you set up the Extracurricular Activity Map page, the system populates the Extracurricular Activities page when you create prospects from ACT or SAT external test score loads based on the data populated in the Test Score Candidate Data component. This data is provided by the students when they take the specific tests.

  The following table shows the external tests that provide extracurricular activity information and where in the candidate data record that the system finds this information for each test:

  Test ID	Location in Test Score Candidate Data Component
  ACT	Activities page where the Participation field is selected for college activities or where the Participated field is selected for high school activities.
  SAT	Student Data page, High School/Community Activities group box, and School Data page, College Activities group box.

• Religious preference

  Set up religious preference codes on the Religious Preference Table page. When you create prospects from external test loads, the system populates the Religious Preference page for each new prospect that the system creates from the external test score load based on the data populated in the Test Score Candidate Data component. This data is provided by the students when they take the specific tests.

  The following table shows the external tests that provide religious preference information and where in the candidate record that the system finds this information for each test:

  Test ID	Location in Test Score Candidate Data Component
  ACT	Personal Information page, Profile Information group box, Religion field.
  SAT	Student Data page, SDQ Information group box, Religion field.

Pages Used to Map External Test Codes to Internal Codes

Mapping Academic Interest Codes

Access the Academic Interests Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Academic Interests Map).

Academic Interest	Enter the internal academic interest code that corresponds to the testing agency code. Academic interest codes are defined on the External Subject Table page.
Interest Code	Enter the interest code provided by the testing agency. You must contact the testing agency for these codes or refer to the test score layout provided by the testing agency.

Mapping Extracurricular Activity Codes

Access the Extracurricular Activity Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Extracurricular Activity Map).

Extracurricular Activity	Enter the internal extracurricular activity code that corresponds to the testing agency code. Extracurricular activity codes are defined on Extracurricular Activity Table page.
Activity Code	Enter the activity code provided by the testing agency. You must contact the testing agency for these codes or refer to the test score layout provided by the testing agency.
College Activity	The SAT and ACT testing agencies record two types of activity information: high school/community activities that the student has participated in and the activities that the student wants to participate in when in college. Select this check box if you want to populate extracurricular activities with the activity that the student wants to participate in when in college.
High School/Community Activity	Select this check box if you want to populate extracurricular activities with the activity from the student's high school/community activity data.

Mapping Religious Preference Codes

Access the Religious Preference Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Religious Preference Map).

Religious Preference	Enter the religious preference code that corresponds to the testing agency code. Religious preference codes are defined on the Religious Preference Table page.
Religion Code	Enter the religion code provided by the testing agency. You must contact the testing agency for these codes or refer to the test score layout provided by the testing agency.

Mapping Admit Terms

Access the Admit Term Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Admit Term Map).

Graduation Date From and Graduation Date To	Enter graduation date ranges for the test layouts that provide a graduation date.
Term	Enter the admit term that corresponds to the graduation date range.

When you run the Test Score Load process, the system uses this mapping to determine the relevant admit term for the prospect. For example, let us suppose that for SAT I you have mapped 2009 Fall to the Graduate to and from dates of January 24, 2009 and August 15, 2009. When you import a SAT I test score, and if the test score of a prospect contains a graduation date of January 25 2009, the system determines 2009 Fall as the admit term for the prospect.

Note that you cannot map overlapping dates to different admit terms. For example, if you have mapped a graduation date range of January 24, 2009 and August 15, 2009 to 2009 Fall for SAT I, then you cannot map a graduation date range of May 1, 2009 and August 15, 2009 to a different admit term for SAT I.

Mapping Programs, Plans and Subplans

Access the Program Plan SubPlan Map page (Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Program Plan SubPlan Map).

Interest Code	Enter the interest code provided by the testing agency. You must contact the testing agency for these codes or refer to the test score layout provided by the testing agency.
Academic Program, Academic Plan, Academic Sub-Plan	Enter the academic program, plan or subplan that corresponds to the interest code

When you run the Test Score Load process, the system uses this mapping to determine the relevant academic program, plan or subplan for the prospect. For example, let us suppose that for SAT I you have mapped interest code 450 to the Fine Arts Undergraduate program and Music plan. When you import an SAT I test score and the test score of a prospect contains the interest code 450, the system determines the program as Fine Arts Undergraduate and the plan as Music for the prospect.