Setting Up External Test Score Loads

This chapter discusses how to:

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 process external tests.

Defining External Test Components

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

Use the Test Component Table page to define the test components (such as verbal, math, and analytical) of external academic tests (such as ACT, GMAT, and GRE). You also use this table to create components of placement and other tests administered internally by your institution. If a component is used in more than one test, it only needs to be defined once. Note that totals are not computed by the system, so if you want to enter and track totals, be sure to define Total as one of your test components.

Page Used to Define External Test Components

Page Name	Object Name	Navigation	Usage
Test Component Table	SA_TEST_COMP_TABLE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Test Component Table	Define the test components (such as verbal, math, and analytical) of external academic tests (such as ACT, GMAT, and GRE). Also, create components of placement and other tests administered internally by your institution. If a component is used in more than one test, it only needs to be defined once. Note that totals are not computed by the system, so if you want to enter and track totals, be sure to define Total as one of your test components.

Defining External Tests

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

This section discusses how to define external tests.

Page Used to Define External Tests

Page Name	Object Name	Navigation	Usage
Test Tables	SA_TEST_TABLE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Test Tables	Define tests (such as ACT, GMAT, and GRE) and associate test components with the appropriate tests. You can also associate tests on this page with a particular testing agency, such as American College Testing, College Board, Educational Testing Services and Law School Admission Services.

Defining External Tests

Access the Test Tables page.

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), GRE Subject Test Codes component (GRE_SUBJECT_CODES), 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, GRE 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 ethnicity codes.
Map AMCAS Ethnic Groups.

Pages Used to Review External Data Setup Tables

Page Name	Object Name	Navigation	Usage
AP Subject Test Codes	AP_SUBJECT_CODE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AP Subject Test Codes	Define or review the delivered AP subject test codes or to add or edit a code. This table stores the test codes used on the AP test. You can link your own codes and descriptions to these codes so that the system displays your codes after the scores are posted. Use the AP Subject Test Code Parameters page to link your codes to the delivered codes.
AP Country Codes	SAD_AP_CNTRY_TBL	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AP Country Codes	Translates the AP country values to internal PeopleSoft country values during the AP specific load routine. The AP Country Codes table is delivered with known values set as of the date of this publication. You might need to add or delete rows to accurately maintain the table in the future.
ADA Country Table	ADA_COUNTRY_TBL	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, ADA Country Codes	Define or review the AADAS country code. Before processing the ADA external test score load, use the Country field to map AADAS country codes used on the ADA to PeopleSoft country codes.
CRS Major Codes	CRS_MJR_CD_TABLE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, CRS Major Codes	Review the delivered CRS major codes or add or edit a code.
GRE Subject Test Codes	GRE_SUBJECT_CODE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, GRE Subject Test Codes	Define or review the delivered GRE subject test codes or add or edit a code. You can link your own codes and descriptions to these so that the system displays your codes after the scores are posted. This linking is done on the GRE Subject Test Code Parameters page.
AMCAS Credit Hours Codes	AMCAS_CR_HR_CODE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AMCAS Credit Hour Codes	Define or review the delivered AMCAS credit hours codes or add or edit a code. An AMCAS file only includes the actual number of credit hours, so this table includes the codes and descriptions that are mapped to the AMCAS credit hour types.
AMCAS GPA Codes	AMCAS_GPA_CODE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AMCAS GPA Codes	Define and review the delivered AMCAS GPA codes or add or edit a code. An AMCAS file only includes the actual GPA, so this table includes the codes and descriptions that are mapped to the GPA.
AMCAS Ethnicity Map	SAD_AMC_ETHNIC_MAP	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, AMCAS Ethnicity Mapping, AMCAS Ethnicity Map	For AMCAS and MCAT only, map the race codes provided by testing agency to the corresponding PeopleSoft codes in order to capture ethnicity information on the Add/Update a Person component.
SAT Math Recentered Values	SAT_MATH_RECENTER	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, SAT Setup, SAT Math Recentered Values	Review or edit the recentered SAT math score values. When you process SAT math scores, the system recenters some of the scores (as indicated by the SAT load) according to the values in this table. When the system recenters scores, only the recentered scores post to the person’s record. The system displays the score it receives from the testing agency in the Math Score field. The translated score appears in the Recentered Math Score field. This is the score that the reported score is translated to.
SAT Verbal Recentered Values	SAT_VERBAL_RECENTR	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, SAT Setup, SAT Verbal Recentered Values	Review or edit the recentered SAT verbal score values. When you process SAT verbal scores, the system recenters some of the scores according to the values in this table. When the system recenters scores, only the recentered scores post to the person’s record. The system displays the score it receives from the testing agency in the Verbal Score field. The score displayed in the Recentered Verbal Score field is what the reported score is translated to when processed.
SAT II Test Codes	SATII_CODE	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, SAT Setup, SAT II Test Codes	Review the delivered SAT II test codes or add or edit a code. You can link your own codes and descriptions to the codes you received in an SAT II tape or file so that your codes are displayed on your Admissions pages.
SAT II Test Recentered Values	SATII_TST_RECENTER	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, SAT Setup, SAT II Test Recentered Values	Review or edit the recentered test score values for each SAT II test code. When you process SAT II scores, the system recenters the scores according to the values in this table. Only the recentered scores post to the person’s record. The left column lists the SAT II test scores received from the testing agency. The right column lists the recentered test scores, which are what the reported score is translated to when processed.
Ethnicity Map	SAD_ETHNICITY_MAP	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Ethnicity Mapping	Map the ethnicity codes provided by testing agencies to the corresponding PeopleSoft codes in order to capture ethnicity information on the Bio/Demo Data component.
GMAT Country Codes	SAD_GMT_CNTRY_TBL	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, GMAT Country Codes	Define or review the mapping of GMAT Country Codes to PS Country Codes. Before processing the GMAT external test score load, use the Country field to map GMAT country codes to PeopleSoft country codes.

Mapping Ethnicity Codes

Access the Ethnicity Map page.

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 Mapping component.

See Mapping Ethnicity Codes.

Mapping AMCAS Ethnic Groups

Access the AMCAS Ethnicity Map page.

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 External Tests IDs

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

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

Understanding External Test ID Mapping

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

PeopleSoft 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 displays based on the test ID entered.

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

Page Name	Object Name	Navigation	Usage
External Test Score Mapping	SAD_TEST_SETUP	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, External Test Score Mapping	Map your test ID defined on the Test Table to the PeopleSoft test code. The system needs this setup to perform a variety of external test related functions. You also use this page to determine the primary candidate data record for a test, which you need if you want to create prospect records from test score loads using a PeopleSoft Query Manager.

Mapping External Tests IDs to PeopleSoft Test Codes

Access the External Test Score Mapping page.

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.

Note. On this page, you only have to enter 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 it 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 and discusses how to:

Map academic interest codes.
Map extracurricular activity codes.
Map religious preference codes.

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. These pages only need to be set up 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 table below, the system populates the Academic Interests page for each new prospect the system creates based on the data populated in the Test Score Candidate Data component. This data is provided by the student when they take the specific test.

The following table shows the external tests that provide academic interest information, and where in the candidate data record 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.

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 student when they take the specific test.

The following table shows the external tests that provide extracurricular activity information, and where in the candidate data record 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 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 student when they take the specific test.

The following table shows the external tests that provide religious preference information, and where in the candidate record 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

Page Name	Object Name	Navigation	Usage
Academic Interests Map	SAD_ACAD_MAP	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Academic Interests Map	Map the academic interest codes provided by some external testing agencies to the corresponding PeopleSoft codes to capture academic interest information when creating prospects from certain test loads. Only set up this page if you want to capture academic interest information when creating prospects from test score loads.
Extracurricular Activity Map	SAD_EXTRA_MAP	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Extracurricular Activity Map	Map the extracurricular activity codes provided by the ACT and ETS testing agencies to the corresponding PeopleSoft codes to capture academic interest information when creating prospects from ACT or SAT test score loads. Only set up this page if you want to capture extracurricular activity information when creating prospects from test score loads.
Religious Preference Map	SAD_REL_MAP	Set Up SACR, Product Related, Recruiting and Admissions, External Test Scores, Create Prospects Setup, Religious Preference Map	Map the religious preference codes provided by the ACT and ETS testing agencies to the corresponding PeopleSoft codes to capture religious preference information when creating prospects from ACT or SAT test score loads. Only set up this page if you want to capture religious preference information when creating prospects from test score loads.

Mapping Academic Interest Codes

Access the Academic Interests Map page.

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 the test score layout provided by the testing agency.

Mapping Extracurricular Activity Codes

Access the Extracurricular Activity Map page.

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 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 the student has participated in, and the activities the student wants to participate in when in college. Select this check box if you want to populate extracurricular activities with the activity 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.

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.

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.

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.

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.

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 the test score layout provided by the testing agency.

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 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 the student has participated in, and the activities the student wants to participate in when in college. Select this check box if you want to populate extracurricular activities with the activity 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.

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.