---
title: "College Board High School Performance Information"
slug: "college-board-high-school-performance-information"
updated: 2026-04-20T19:53:36Z
published: 2026-04-20T19:53:36Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# College Board High School Performance Information

College Board provides **High School Performance Information (HSPI)** about an applicant’s high school, offering colleges important information for understanding academic opportunities and outcomes. The information includes data on class size, Advance Placement® (AP®) participation and performance, and SAT® testing patterns, drawn from College Board data.

The standard resources necessary to provide data to College Board (and to import the associated High School Performance Information into Slate) can all be located within the **Slate Research Configuration Library**. These resources include:

- **Research source:**Stores High School Performance Information based on the high school and score data that was provided to College Board.
- **Record export query:**Exports selected record data that can be uploaded to College Board.
- **Source format:**Imports the High School Performance Information to the research source.

## Step 1: Research source and additional configurations

### Initiate the HSPI process in Slate

To initiate the HSPI process in Slate:

1. Contact the **Future Admissions Tools and Models Initiative**at [FutureAdmissions@collegeboard.org](mailto:FutureAdmissions@collegeboard.org).
2. College Board begins to set up HSPI from their side and notify Technolutions when this is complete.
3. Technolutions sets up HSPI configurations within your institution’s database and notifies College Board.
4. College Board provides the final notification to your institution that HSPI configurations are ready and you may proceed to the next step listed below.

### Add the College Board HSPI Research Source

All of the elements needed to exchange data between Slate and College Board exist in the **Research Configuration Library**.

To add the College Board HSPI research source:

1. Select **Database**from the main navigation.
2. Under Configurations, select **Research Configurations**.
3. From the right navigation, select **Library**.
4. From the right navigation, select the **Admissions** folder.
5. Select **College Board HSPI**from the list of research sources.
6. To the right of the research source name, select the **plus sign**. A confirmation popup appears.
7. Select **OK**.

### Add Additional HSPI Configurations

In addition to the data keys needed for the HSPI research source and the prompts associated with those data keys, both of which were added to your database automatically when you added the research source, the College Board HSPI research source lets you easily add the following items to your database from one convenient location:

- The **data keys** needed for the HSPI research source (included by default)
- The **prompts** utilized by certain data keys (included by default)
- A **query** formatted to the College Board HSPI specifications that can be exported and uploaded for tagging by College Board
- A **source format** to import the tagged data back into Slate.

To add these additional elements:

1. Select the **plus sign** next to the item. A summary popup appears.
2. Select **Add**.
3. If the item has a confirmation popup, select **OK**.

Now that the HSPI resources have been added from the library, the next section will walk us through additional configurations required before use.

## Step 2: Customize the Export Query

The College Board HSPI Export query contains export values arranged and formatted to be consumed by College Board's data tagging system.

> [!TIP]
> 💬 [Reach out to the College Board Future Admissions team directly](mailto:FutureAdmissions@collegeboard.org) for data specifications and file formatting.

You must customize the query before it can be used. To customize the query:

1. Select **Queries** from **Queries / Reports** in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information: Record Export**query.
3. Select the drop down carrot next to **Edit Query** and select **Copy Query**.
4. Enter a name for this new query and, optionally, select a new folder for the copied query.
5. Select **Save**so that you can reference the original or start over if necessary. Now you are directed to the new query's edit page.
6. For each Literal export that includes the text `** Custom` (for example, `Application_Type`), add a **new export** to the query that targets the appropriate data point in Slate.
7. Give each of these exports the same name as the literal export with which it corresponds.
8. Select **X** to delete the placeholder export.
9. Add filters to limit the records sent to College Board.
10. (Optional): Adjust any standard exports to point to custom data points instead.****** **📝 Note**: The export name and the export data type must remain the same.

Once the query has been finalized, the query can be run manually to generate a data file.

Files uploaded to College Board's system ***must*****adhere to the format specified by College Board. Each column header must be included, regardless of whether your institution supplies data in that field.

| Field | Form or Allowed Values | Description |
| --- | --- | --- |
| `Applicant_ID` | Original format | Unique identifier for each record. The applicant_id should be anonymous, that is, not allowing personal identification of the student from publicly available information. It should not be the student's Social Security Number. |
| `Street_Address_1` | Text string | Line 1 – use permanent or mailing address |
| `Street_Address_2` | Text string | Line 2 – use permanent or mailing address |
| `Street_Address_3` | Text string | Line 3 – use permanent or mailing address |
| `City` | Text string | City name |
| `State` | 2 character string | Customary 2 character state abbreviation |
| `Zip` | 5-digit numeric | 5 digit zip code |
| `Country` | Text string | Full country name |
| `GeoID` | 11-digit number | OPTIONAL – submit GeoID **in lieu of** address |
| `HS_CEEB_code` | 6-digit number | CEEB code of the high school the applicant attended |
| `Gender` | 1, 2 or 3 | 1 = Female 2 = Male 3 = Another (not listed) |
| `SAT_Math` | 3-digit numeric | 3 digit SAT score |
| `SAT_EBRW` | 3-digit numeric | 3 digit SAT score |
| `ACT_Composite` | 2-digit numeric | 2 digit ACT score |
| `Old_SAT_Math` | 3-digit numeric | 3 digit SAT score |
| `Old_SAT_CR` | 3-digit numeric | 3 digit SAT score |
| `Old_SAT_Writing` | 3-digit numeric | 3 digit SAT score |
| `ACT_English` | 2-digit numeric | 2 digit ACT score |
| `ACT_Math` | 2-digit numeric | 2 digit ACT score |
| `ACT_Science` | 2-digit numeric | 2 digit ACT score |
| `ACT_Reading` | 2-digit numeric | 2 digit ACT score |
| `ACT_Writing` | 2-digit numeric | 2 digit ACT score |
| `Application_Type` | 1 or 2 | 1 = Early 2 = Regular |
| `Admitted` | 0, 1 | 0 = not admitted 1 = admitted |
| `Enrolled` | 0, 1 | 0 = not enrolled 1 = enrolled |
| `Waitlist` | 0 or 1 | 0 = not waitlisted 1 = waitlisted at any time. This variable only covers whether an applicant was waitlisted at any time during the admissions process; the applicant's final admission status should be indicated in the decision. |
| `First_Year_GPA` | 3-digit numeric | First year GPA (0.00 – 4.0 scale) |
| `Sophomore_Retention` | 0 or 1 | 0 = not retained to sophomore year 1 = retained to sophomore year |
| `Race` | 1 – 9 | OPTIONAL 1 = White 2 = Black or African American 3 = Hispanic/Latino 4 = Asian 5 = American Indian or Alaska Native 6 = Native Hawaiian or Other Pacific Islander 7 = Two or More Races 8 = International 9 = Unknown |
| `Entry_Term` | 4-digit numeric | Year of Fall Term for which the applicant applied |
| `First_Generation` | 0 or 1 | OPTIONAL 0 = not first generation 1 = first generation |
| `HSGPA` | 3-digit numeric | High school GPA (0.00 – 5.00 scale) |
| `Pell_eligible` | 0 or 1 | OPTIONAL 0 = not Pell eligible 1 = Pell eligible |
| `Number_of_AP_exams` | 1 or 2-digit numeric | Number of AP exams taken (0-38) |
| `AP_Average` | 3-digit numeric | Average of all AP exam scores (Min=1.00; Max=5.00) |
| `Number_of_IB_exams` | Numeric | Number of IB exams taken |
| `IB_Average` | Numeric | Average of all IB exams taken |
| `Custom_1` | Original format | Custom data field for use by institution. This field can hold up to 100 alphanumeric characters. Use this field to keep track of information for further distinction of records or for your own research purposes (e.g. distinguish between fall and winter applicants for 2020, identify scholarship candidates or honors scholars, etc.). |
| `Custom_2` | Original format | Custom data field for use by institution. This field can hold up to 100 alphanumeric characters. Use this field to keep track of information for further distinction of records or for your own research purposes (e.g. distinguish between fall and winter applicants for 2020, identify scholarship candidates or honors scholars, etc.). |
| `Custom_3` | Original format | Custom data field for use by institution. This field can hold up to 100 alphanumeric characters. Use this field to keep track of information for further distinction of records or for your own research purposes (e.g. distinguish between fall and winter applicants for 2020, identify scholarship candidates or honors scholars, etc.). |

### Permanent or Mailing Address

In the query template from the library, the top-ranked address, regardless of the type, is included in the data. Your institution can customize the type of address to send to College Board for tagging. This choice largely depends on how your institution captures and stores address data.

For example, if you always capture the mailing address, but only ask for permanent address if it is different, send the mailing address to College Board. If your institution captures a mixture of permanent and mailing addresses, you may wish to use the top-ranked address, regardless of the type.

To update the included address:

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. In the Joins section, select the **Address** subquery join.
5. Select **Filter.**
6. Add filters to limit which addresses are eligible for inclusion in the data. In this example, the **Address Type** filter limits the address types that are exported.
7. Select **Save** once all of the desired filters and adjustments to the join are complete.

[![Edit_Address_Join_to_Filter_for_Address_Type.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/edit_address_join_to_filter_for_address_type.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/edit_address_join_to_filter_for_address_type.png)

> [!WARNING]
> 📝 Note
> 
> - While the default, library version of this join has no filters, it includes a **sort** to order the addresses on the record by their overall rank. Since this is a subquery join, only **one row is returned for each record.** This effectively limits the address data to the rank 1 overall address on the record.
> - If you add an **address type filter**, then only addresses in the selected type are eligible for inclusion, and those addresses are *then* sorted by the overall rank to return just a single address for the record.
> - International addresses cannot be tagged.

### Test Score Options

#### **Verified or Self-Reported Scores**

In the query template from the library, test scores are used regardless of the verification status (self-reported or verified). If your institution elects to send **only verified test scores**, follow the steps below.

#### SAT Scores

> [!WARNING]
> 📝 Note
> 
> The SAT scores included in the joins described below are the highest combined scores from a single test date. If your institution would like to send the highest SAT scores achieved, regardless of the test date (superscores), follow the instructions in the section [Single Test Date or Superscore: SAT](/docs/college-board-high-school-performance-information#h_01GA4KC1A3NTCVVZSSA3ZGM89J) instead.

To filter the query for verified SAT scores only:

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. In the Joins section, select the **Tests - SAT R** subquery join.
5. Add the **Status** filter.
6. Select **Verified**.
7. Select **Save** to finish adding the filter.
8. Select **Save** to save the join.
9. Repeat steps 1 - 5 for the join **Tests - SAT I**.

[![Edit_SAT_-_R_Join_to_Filter_for_Verification_Status.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/edit_sat_-_r_join_to_filter_for_verification_status.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/edit_sat_-_r_join_to_filter_for_verification_status.png)

#### ACT Scores

> [!WARNING]
> 📝 Note
> 
> The ACT scores included in the joins described below are superscored. If your institution would like to send the scores associated with the highest composite score from a single test administration, follow the instructions in the section [Single Test Date or Superscore: ACT](/docs/college-board-high-school-performance-information#h_01GA4KD1QGFHRTRG95FFWEDZA9) instead.

To modify the query to send only verified ACT Composite scores:

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. Select the export `ACT_Composite`.[![ACT_Composite_Subquery_Exports.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/act_composite_subquery_exports.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/act_composite_subquery_exports.png)
5. For each subquery export in the ACT_Composite export (English, Math, Reading, Science, and Writing):
  1. Edit the subquery export.
  2. Add the **Status** filter under the **Tests** section.
  3. Selected **Verified**.
  4. Select **Save**to save the filter.
  5. Select **Save** to save the subquery export.
  6. Repeat these sub-steps for each remaining subquery export.
6. Select **Save**.

[![Add_Status_Filter_for_Verified_ACT_Scores.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_act_scores.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_act_scores.png)

To modify the query to send only verified ACT component scores, for each of the component score export columns (`ACT_English`, `ACT_Math`, `ACT_Reading`, `ACT_Science`, and `ACT_Writing`):

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. Select the export to modify (for example, `ACT_English`).
5. Add the **Status** filter under the **Tests** section.
6. Select **Verified**.
7. Select **Save** to save the filter.
8. Select **Save** to save the changes to the export.
9. Repeat these steps for the remaining ACT component score query export columns.

[![Add_Status_Filter_for_Verified_ACT_Component_Score.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_act_component_score.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_act_component_score.png)

#### AP and IB Scores

To send only information about verified test scores for AP and IB exams, for each of the exports `Number_of_AP_exams`, `AP_Average`, `Number_of_IB_exams`, `IB_Average`**:**

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. Select the export to modify (for example, `Number_of_AP_exams`).
5. Add the **Status** filter under the **Tests** section.
6. Select **Verified**.
7. Select **Save** to save the filter.
8. Select **Save** to save the changes to the export.
9. Repeat these steps for the remaining AP and IB query export columns.

[![Add_Status_Filter_for_Verified_AP_or_IB_Exams.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_ap_or_ib_exams.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_ap_or_ib_exams.png)

### Single Test Date or Superscore: SAT

The default query template uses the top-ranked test scores for each SAT type (SAT R and SAT I) on a single test date. If your institution would like to send the highest *combined* scores, regardless of the test date, follow these steps to modify the query.

To superscore SAT test scores for a given type:

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. **Delete the exports** in the query that correspond with the test score type (for example, `SAT_EBRW `and `SAT_Math`).
5. **Delete the join** that supported the deleted export columns (for example, **Tests - SAT R**). ***Note:***Any query references to the join must be removed before the can be deleted.

[![Delete_Exports_and_Joins_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/delete_exports_and_joins_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/delete_exports_and_joins_-_sat_r_example.png)

*SAT R examples*
6. Select **Subquery Export.**This replaces the first of the two exports you deleted.
7. Configure the following settings:
  - Enter a name that corresponds with the column you are configuring, for example: `SAT_EBRW`:
  - **Type**: Dependent subquery
  - **Output**: Aggregate
  - **Aggregate**: Maximum

[![Configure_SAT_EBRW_Subquery_Export_Settings_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/configure_sat_ebrw_subquery_export_settings_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/configure_sat_ebrw_subquery_export_settings_-_sat_r_example.png)
8. Select **Join.**Select the test type corresponding with the export being configured (for example, **Tests - SAT R**).
9. Select **Continue.**
10. Select **Save.**

[![Join_to_Test_Type_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/join_to_test_type_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/join_to_test_type_-_sat_r_example.png)
11. Select **Export.**Add the export from the added join's section (for example, **Tests - SAT R**) that corresponds with the column you are configuring, for example, **Evidence-Based Reading and Writing**.
12. Select **Continue.**
13. Select **Save.** [![Add_Export_-_Evidence-Based_Reading_and_Writing_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_export_-_evidence-based_reading_and_writing_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_export_-_evidence-based_reading_and_writing_-_sat_r_example.png)
14. Select **Subquery Filter.**The filter requires the test score is ranked to prevent the inclusion of cancelled, discrepancy status, and test optional scores in the data. Configure the following settings:
  - **Name:** Customizable and used solely for the configuration (for example, "**Rank Exists"**).
  - **Type:**Dependent subquery
  - **Aggregate:**Exists
15. Within the subquery filter, select **Export**.
16. Add the **Rank** export from the added join's section.
17. Select **Save**.

[![Subquery_Export_-_Rank_Export_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/subquery_export_-_rank_export_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/subquery_export_-_rank_export_-_sat_r_example.png)

#### (Optional) Send only verified test scores

If your institution would like to send only **Verified** test scores to College Board, add the **Status** filter from within the added join's section (for example, **Tests - SAT R**).

1. Within the subquery export, select **Filter.**
2. Under the join's section (in this example, **Tests - SAT R**), select **Status.**
3. Select **Continue.**
4. Select the **Verified**status.
5. Select **Save**.
6. Lastly, select **Save** to save the new subquery export. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/image(149).png)

[![Completed_SAT_Superscore_Subquery_Export.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/completed_sat_superscore_subquery_export.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/completed_sat_superscore_subquery_export.png)

*Completed SAT EBRW superscore subquery export (SAT R example).*

For each remaining export column associated with the current test type that must be replaced:

1. Use the **Copy** button on the export created in the steps above to open a replica of the export created.

[![Copy_SAT_Composite_Subquery_Export_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/copy_sat_composite_subquery_export_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/copy_sat_composite_subquery_export_-_sat_r_example.png)
2. Update the Name to the name of the column you are configuring (e.g., **SAT_Math**).
3. Delete the query export (e.g., **Tests - SAT R Evidence-Based Reading and Writing Section**) [![Rename_Copied_Subquery_Export__Delete_Export_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/rename_copied_subquery_export__delete_export_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/rename_copied_subquery_export__delete_export_-_sat_r_example.png)
4. Select **Export.**
5. Select an export from the join section (for example, **Tests - SAT R**) that corresponds with the column being replaced (for example, **Math Section**).
6. Select **Continue.**
7. Select **Save Copy**.
8. If both SAT score types should be superscored, Repeat Steps 1-7 for the other test type.

[![Add_Export_-_Math_Section_-_SAT_R_Example.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_export_-_math_section_-_sat_r_example.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_export_-_math_section_-_sat_r_example.png)

[![Completed_SAT_Math_Superscore_Subquery_Export.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/completed_sat_math_superscore_subquery_export.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/completed_sat_math_superscore_subquery_export.png)

*Completed SAT Math section superscore subquery export (SAT R example).*

### Single Test Date or Superscore: ACT

In the default query template, the ACT test type is superscored. If your institution would like to send the scores associated with the highest composite score from a single test administration, follow the steps below to modify the query.

To send ACT scores associated with the highest composite score from a single test administration:

1. Select **Queries**from **Queries / Reports**in the main navigation.
2. Use the search bar to find and select **College Board High School Performance Information Query**.
3. Select **Edit Query**.
4. **Delete the exports** that correspond with the ACT test score components:
  - `ACT_Composite`
  - `ACT_English`
  - `ACT_Math`
  - `ACT_Science`
  - `ACT_Reading`
  - `ACT_Writing`

[![Delete_ACT_score_component_exports.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/delete_act_score_component_exports.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/delete_act_score_component_exports.png)
5. Select **Join.**
6. In the Person, select **Tests - ACT.**
7. Select **Continue.**

[![Add_Join_to_Tests_-_ACT.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_join_to_tests_-_act.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_join_to_tests_-_act.png)
8. Select **Subquery Filter.**
9. To require that the test score is ranked to prevent the inclusion of cancelled, discrepancy status, and test optional scores in the data, configure the following settings:
  - **Name:** Customizable and used solely for the configuration.
  - **Type:**Dependent subquery
  - **Aggregate:**Exists

[![Configure_ACT_Subquery_Filter_Settings.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/configure_act_subquery_filter_settings.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/configure_act_subquery_filter_settings.png)
10. Within the subquery filter, select **Export.**
11. Select **Rank** from the Tests- ACT join's section.
12. Select **Continue.**
13. Select **Save**.

[![Subquery_Filter_Export_-_Rank_Export_-_ACT.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/subquery_filter_export_-_rank_export_-_act.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/subquery_filter_export_-_rank_export_-_act.png)

**Optional**: If your institution would like to send only **Verified** test scores to College Board, add the **Status** filter from within the Tests - ACT join's section.

Within the subquery filter:

1. Select **Filter.**
2. Under the Test - ACT join's section, select **Status.**
3. Select **Continue.**
4. Select **Verified**.
5. Select **Save.**

[![Add_Status_Filter_for_Verified_ACT_Scores_-_Single_Test_Date_or_Superscore.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_act_scores_-_single_test_date_or_superscore.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/add_status_filter_for_verified_act_scores_-_single_test_date_or_superscore.png)
6. Select **Sort**.
7. Select **Rank.**This orders the matching ACT scores by rank (highest composite score first). *Since this is a join, only the first score to meet the filter criteria will be included, so ordering by rank ensures that the data included in the query is from the highest highest composite ACT score achieved.*
8. Select **Save** to save the join.

[![Sort_Matching_ACT_Scores_by_Rank.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/sort_matching_act_scores_by_rank.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/sort_matching_act_scores_by_rank.png)
9. Select **Export.**
10. Select exports for each of the ACT score components from the Tests - ACT join configured previously:
  - **Composite**
  - **English**
  - **Match**
  - **Reading**
  - **Science Reasoning**
  - **Writing**

[![Select_ACT_Exports.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/select_act_exports.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/select_act_exports.png)
11. **Rename each of the exports** to match the column headers required by The College Board:
  - `ACT_English`
  - `ACT_Math`
  - `ACT_Composite`
  - `ACT_Science`
  - `ACT_Writing`
  - `ACT_Reading`

[![Rename_ACT_Exports.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/rename_act_exports.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/rename_act_exports.png)

## Step 3: Configure the Remap Settings for the Source Format

Once a file has been received from College Board, the **Remap**settings must be configured and then activated. Many of the source fields are pre-mapped to the College Board High School Performance Information research source destination.

> [!CAUTION]
> 🔔 Important!
> 
> - Remap settings are customizable, with the following exception: Mapped `applicant_id`
> - The `applicant_id `field is the Slate GUID that was sent in the data export.
> - This value is used for matching purposes back to Slate, and it is mapped to the Slate GUID Matching Only destination.
> - ***Changing this mapping destination will prevent records from importing appropriately.***
> 
> [![applicant_id_Source_Field.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/applicant_id_source_field.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/applicant_id_source_field.png)

To configure the source format's remap settings:

1. Select **Database** from the top navigation.
2. Under Import, select **Source Formats**.
3. From the list, select **College Board High School Performance Information**.
4. Select **Remap.**View the standard, pre-mapped Slate destinations, and update the settings according to your institution's needs. Refer to the [Source Formats](/v1/docs/source-formats) section of the Knowledge Base for additional details on the configuration of source formats.
5. Navigate back to the source format's landing page.
6. Select **Edit** from the upper right.
7. Update **Remap Active**to **Active**.

> [!WARNING]
> 📝 Note
> 
> The data in the files from College Board contains data that was exported from Slate in addition to the High School Performance Information data. The Slate GUID (included as the applicant_id column) is therefore able to be used for matching purposes. Bio/demo and score data exported from Slate should not be mapped back to those destinations within Slate.

### Exporting Data from Slate

1. Navigate to the landing page for the **College Board High School Performance Information: Record Export** query configured in the previous section.
2. Use the **Run to Browser** button to download the data from the query as a CSV file.

Follow the steps outlined on the [High School Performance Information Help page](https://landscape.collegeboard.org/help) to upload this file to College Board's High School Performance Information system and retrieve a tagged data file from College Board.

### Importing High School Performance Information Data

1. Navigate to the landing page for the **College Board High School Performance Information (HSPI)**source format added earlier.
2. Select **Upload File(s)**.
3. Upload the files retrieved from College Board's High School Performance Information system.

If you have already configured the source format and activated the Remap settings, Slate will automatically process the import during the next import job cycle (typically within 15 minutes).

If you have not yet configured the source format, return to the section [Configure the Remap Settings for the Source Format](/v1/docs/college-board-landscape#step-3-configure-the-remap-settings-for-the-source-format). Once the source format's Remap Active setting is Active, the data will import during the next import job cycle.