The Secondary School Admission Test (SSAT) was developed by the Enrollment Management Association (EMA) to standardize the secondary school admissions testing process.

This article covers the steps to import score data and score report PDFs.

The following steps will show you how to configure your database to import SSAT score data and score report PDFs.

Adding SSAT test types to your database

The test types store the SSAT score results.

1. Go to Database → Slate Template Library.

2. Select the Test Types section to expand it. Alternatively, enter "SSAT" in the search bar.

3. Select Add.

4. Select Save.

Repeat for the other SSAT test subtype as necessary.

🔔 Do not change the score configurations of the SSAT test types.

Creating a SSAT Score Report material

If you already have a material type you'd like to use to store these documents, you can skip this step.

➡️ Follow steps in Creating Materials to Create an SSAT Score Report material that stores the SSAT Score Report PDFs.

If you'd like, you can make this custom material type test-scoped. This associates the score report document with the specific test score.

Adding a custom EMA Folio ID field

Create a person-scoped custom field to store the EMA Folio ID.

1. Select Database from the top navigation, then select Fields.

2. Create a custom field to store the SSAT Student Folio ID using the following settings:

   • Scope: Person

   • ID: ssat_id

   • Value: Store Value

   • Multiple: Single Value

   • Unique for Merging: Value contains a unique ID which identifies a single record for merging

3. Select Save.

Adding the SSAT source formats

You’ll use two source formats to import the SSAT data and documents, one for test score data, the other for documents.

Secondary school admission test score data file

The source format used to import score data is called Secondary School Admission Test Score Data File.

To add and configure it:

1. Go to Database → Source Format Library.

2. Add the Secondary School Admission Test Score Data File (CSV) source format.

3. When you receive a file from EMA, configure the Remap settings. Many items have been pre-mapped.

4. Customize how the data will be imported.

5. Set the source format's Remap Active flag to Active. Do not make any other changes to the source format settings.

   

The import runs using the Remap settings for all files uploaded on or after the Remap As Of Date.

Secondary school admission test score report documents

The source format used to import the score report documents is called Secondary School Admission Test Score Report Documents.

To add and configure it:

1. Go to Database → Source Format Library.

2. Add the Secondary School Admission Test Score Report Documents (DIP) source format.

3. When you receive a file from EMA, configure the Remap settings as follows:

   • On the Static Mappings page, configure a static mapping for the destination Material - Material Code.

   • Select the material type that should be used to store the score report documents. If the material type is test-scoped, then the Reg ID source field must be mapped to the Test: SSAT - External ID destination so the document can be associated with the specific test score.

4. Set the source format's Remap Active flag to Active. Do not make any other changes to the source format settings.

   

The import runs using the Remap settings for all files uploaded on or after the Remap As Of Date.

Import order

The data for records must exist in Slate prior to importing the documents.

The Import Order setting has been pre-set for the Secondary School Admission Test Score Report Documents to ensure that, if the source formats are configured to automatically pick up files, the data file will be processed first.

If you are manually uploading the files, it is imperative that the data file is uploaded and imported using the Secondary School Admission Test Score Data File prior to importing the file with the associated documents.

Do not map first or last names

This source format requires that the data be loaded onto the record via the Secondary School Admission Test Score Data File source format first.

As such, this source format is configured not to create new records, and will only match an existing record using the unique Folio ID value sent in both source formats.

Matching record does not exist

Any documents that cannot be matched to a record in Slate will be displayed in Batch Acquire for manual processing.

Read-only PDFs

Any documents uploaded in SAO should be in a read-only format and not writable PDFs.

Prior to uploading files in SAO, convert them into a static, read-only format.

Any PDFs that cannot be matched to a record in Slate appear in Batch Acquire for manual processing.

Retrieving files from EMA

EMA provides a PowerShell script to retrieve and package files.

The DownloadScoresAsZip.ps1 script generates the files in the Document Import Processor format required by the Secondary School Admission Test Score Report Documents source format.

See the ReadMe for prerequisites and instructions on using the script.

📝 Request EMA credentials by contacting [email protected].