Return to Navigation

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), AMCAS Ethnicity Mapping component (SAD_AMC_ETHNIC_MAP), AMCAS Country Mapping component (SAD_AMC_CNT_MAP), SAT Country Codes component (SAD_SAT_CNTRY_TBL), 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 State/Province Codes component (SAD_GMT_STATE_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:

Page Name

Definition Name

Navigation

Usage

AP Subject Test Codes

AP_SUBJECT_CODE

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select 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 Subjects section on the External Test Score Load page to link your subject test components to the delivered codes.

AP Country Codes

SAD_AP_CNTRY_TBL

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select 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

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select 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.

Note: This setup is relevant only for posting to Campus Solutions. The system does not support posting ADA test scores to CRM therefore this setup is not needed for posting test scores to CRM.

CRS Major Codes

CRS_MJR_CD_TABLE

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select CRS Major Codes

Review the delivered CRS major codes or add or edit a code.

AMCAS Credit Hours Codes

AMCAS_CR_HR_CODE

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select AMCAS Setup, then select AMCAS Credit Hour Codes

Define or review the delivered AMCAS credit hours codes or add or edit a code. An AMCAS file includes only the actual number of credit hours, so this table includes the codes and descriptions that are mapped to the AMCAS credit hour types.

Note: This setup is relevant only for posting to Campus Solutions. The system does not support posting AMCAS test scores to CRM therefore this setup is not needed for posting test scores to CRM.

AMCAS GPA Codes

AMCAS_GPA_CODE

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select AMCAS Setup, then select 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.

Note: This setup is relevant only for posting to Campus Solutions. The system does not support posting AMCAS test scores to CRM therefore this setup is not needed for posting test scores to CRM.

AMCAS Ethnicity Map

SAD_AMC_ETHNIC_MAP

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select AMCAS Setup, then select AMCAS Ethnicity Mapping

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.

Note: This setup is relevant only for posting to Campus Solutions. The system does not support posting AMCAS test scores to CRM therefore this setup is not needed for posting test scores to CRM.

AMCAS Country Mapping

SAD_AMC_CNT_MAP

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select AMCAS Setup, then select AMCAS Country Mapping

Map the AMCAS country code values to the corresponding PeopleSoft country code values.

Note: This setup is relevant only for posting to Campus Solutions. The system does not support posting AMCAS test scores to CRM therefore this setup is not needed for posting test scores to CRM.

SAT Country Codes

SAD_SAT_CNTRY_TBL

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select SAT Setup, then select SAT Country Codes

Translates the SAT country values to internal PeopleSoft country values during the SAT specific load routine.

SAT Math Recentered Values

SAT_MATH_RECENTER

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select SAT Setup, then select 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 when it is processed.

SAT Verbal Recentered Values

SAT_VERBAL_RECENTR

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select SAT Setup, then select 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 that it receives from the testing agency in the Verbal Score field. The score that appears in the Recentered Verbal Score field is what the reported score is translated to when it is processed.

SAT II Test Codes

SATII_CODE

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select SAT Setup, then select 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 that you received in an SAT II tape or file so that your codes appear on your Admissions pages.

SAT II Test Recentered Values

SATII_TST_RECENTER

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select SAT Setup, then select 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 it is processed.

Ethnicity Map

SAD_ETHNICITY_MAP

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select 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 State/Province Codes

SAD_GMT_STATE_TBL

select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select GMAT State/Province Codes

Define or review the mapping of GMAT State/Province codes to PeopleSoft State/Province codes.

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

Image: AMCAS Ethnicity Map page

This example illustrates the fields and controls on the AMCAS Ethnicity Map page. You can find definitions for the fields and controls later on this page.

AMCAS (American Medical College Application Service) Ethnicity Map page

Field or Control

Definition
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.

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

Image: AMCAS Country Mapping page

This example illustrates the fields and controls on the AMCAS Country Mapping page. You can find definitions for the fields and controls later on this page.

AMCAS (American Medical College Application Service) Country Mapping page

Field or Control

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

Country Code

Country

Description

996

ALA

Aaland Island

830

CHI

Channel Islands

891

SCG

Serbia and Montenegro

626

TMP

East Timor

998

UCI

United States Miscellaneous Caribbean Islands

997

UPI

United States Miscellaneous Pacific Islands

The following values are not delivered for application year 2007:

Country Code

Country

Description

248

ALA

Aaland Islands
 

FXX

France, Metropolitan

891

SCG

Serbia and Montenegro

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

Image: SAT Country Codes page (top of page)

This example illustrates the fields and controls on the SAT Country Codes page (top of page). You can find definitions for the fields and controls later on this page.

SAT Country Codes page (top of page)

Image: SAT Country Codes page (bottom of page)

This example illustrates the fields and controls on the SAT Country Codes page (bottom of page). You can find definitions for the fields and controls later on this page.

SAT Country Codes page (bottom of page)

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.

Field or Control

Definition
SAT Country Code and SAT Country Description

SAT country codes, descriptions and their corresponding PeopleSoft country codes are delivered in the table.
State/Province

If a state or province is associated with the specific SAT code, that state or province is also delivered in the table.

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

Image: Ethnicity Map page

This example illustrates the fields and controls on the Ethnicity Map page. You can find definitions for the fields and controls later on this page.

Ethnicity Map page

Field or Control

Definition
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.

Access the GMAT State/Province Codes page (select Set Up SACR, then select Product Related, then select Recruiting and Admissions, then select External Test Scores, then select GMAT State/Province Codes).

Image: GMAT State/Province Codes page

This example illustrates the fields and controls on the GMAT State/Province Codes page. You can find definitions for the fields and controls later on this page.

GMAT (Graduate Management Admission Test) State/Province Codes page

Use this page to define or review the mapping of GMAT State/Province codes to PeopleSoft State/Province codes for the following countries: Australia, Brazil, Canada, China, India, Japan, Mexico and the United States.

For the country of Pakistan, State/Province values do not exist in the PeopleSoft State/Province Table. You must therefore map the GMAT State/Province codes for Pakistan to the State/Province codes that you have set up for Pakistan in Campus Solutions.

The GMAT State/Province 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.