ScoirMaterials Source Format
The ScoirMaterials source format is loaded into the databases of all Coalition members, and several source fields are pre-mapped to standard destinations within Slate.
This source format is configured to import a ZIP archive containing PDFs and an index file that includes information about each PDF in the archive.
This is the same source format that is used to import documents from Scoir for their regular document integration. If your institution already accepts documents from Scoir, information about the specific updates made to handle Coalition application documents are found in the section ScoirMaterials for Members who Already Received Documents from Scoir; however, each of the sections of this document provides details about the source format specific to importing Coalition application documents.
Scoir Service Account
This user account grants Scoir access to place files into the /incoming/scoir/ directory. The ScoirMaterials source format is configured to automatically pick up files from this directory.
Source format requirements
Remap settings are customizable, with the following exceptions:
- Do not change: File
- This source field lets Slate know which PDF the row is associated with. It must remain mapped to the Material Filename destination.
- Prompt Value Mappings: DocumentType
- The DocumentType source field is mapped to the Material Code destination. Scoir will be sending multiple document types in this integration, including the application, transcripts, and counselor evaluations. This destination uses Prompt Value Mappings to allow you to map each of the document types from Scoir to a specific material type within Slate.
Any PDF that is associated with a document type that is not mapped will be sent to Batch Acquire for manual processing.
- Do not change: coalitionID & scoir_id
The fields Coalition Application ID and Scoir ID are both used to facilitate the integration, so these mappings should remain unchanged.
Configuring the source format
To configure the ScoirMaterials source format:
- From the main navigation, select Database, then select Source Formats.
- Select ScoirMaterials.
- Click Remap.
- Map additional items and make any desired changes on the Field Mappings page.
- On the right, click Prompt Value Mappings.
- Map values as needed:
- The full list of document types has been appended for your convenience.
- Map any Field Fusions and Static Values if desired.
- With remapping completed, return to the ScoirMaterials source format page using the breadcrumb navigation.
- On the right, click Edit.
The following source format settings should not be updated:
- Unsafe (Safe): This source format is used for sending documents at multiple parts of the application process and from multiple sources, so this source format should be set to Safe to prevent it from overwriting person-scoped data provided directly by the applicant if a current application exists on the record already. Documents will always be imported.
- Type (One-Time / Differential): This setting retains each source as new sources come in. Since each document is sent one time, changing this setting to Cumulative will degrade the integration and could result in data loss.
- Format Definitions: As a standard source format, format definitions are inherited. Updating the settings on the Format Definition tab will result in the inherited settings being overridden and will degrade the integration.
- Import Automations: The documents sent from Scoir are automated through the integration, so there is no need to adjust any settings on the Import Automation tab.
Every material within Slate is associated with a specific record, whether that is a specific school, an application, or the person record as a whole. Most of the documents that will be received from Scoir will be associated with either the application or the person record; however, you may choose to map certain types of documents, such as transcripts, to school-scoped materials.
Application or Person
Documents that are mapped to material types that are configured as Application/Folio-scoped will be associated with an application (application-scoped) if there is a matching application on the record. If there is no matching application, then the document will be person-scoped.
Matching to an Application
Scoir will send the CoalitionId field for any record that has one at the time the document exists. Since this field is mapped to the Coalition Application ID, this will allow the import process to associate the document with the specific Coalition application.
However, documents may be sent from Scoir even for records that do not have a Coalition application as part of your normal Scoir integration. In this scenario, the CoalitionId field will be blank. For these records, there are two options, and you may choose whichever works best for your process:
Option 1: Allow the imported document to be person-scoped.
Option 2: Map the Static Value: App: Round Use Existing. With this option, if there is an application in an active application period on the record, then the document will be associated with that application. Otherwise, the document will be person-scoped.
Note: Applications in rounds that are protected from rank are excluded. The matched application will be the rank 1 application on the record.
Documents that contain information specific to a particular school record may be imported to school-scoped material types in Slate provided that the school is specified in the import. Scoir sends the fields CEEBCode and HighSchoolName, which can be used to associate the document with the appropriate school on the record or create a new school on the record if it does not already exist.
Documents that are mapped to school-scoped materials that do not have an associated school will be sent to Batch Acquire for manual processing.
ScoirMaterials for Members who Already Received Documents from Scoir
The ScoirMaterials source format for Coalition files is the same source format that is used for the regular integration with Scoir for document receipt. There are three updates for this year to enable the capability of the source format handling both:
- New source field: CoalitionId - This field enables document matching to the Coalition application for any document related to that Coalition application. This field has been automatically mapped to the Coalition Application ID field in Slate.
- New document type: ApplicationProfile - This document type will be sent for the application PDF, and it must be mapped to the desired material type in Slate. While this new document type has been automatically appended to the list of types to map, the Prompt Value Mapping must be set for the new type, otherwise, these documents will be sent to Batch Acquire for manual processing.
- Updated source field: StudentId previously contained the Scoir ID field. For consistency, Scoir has renamed this source field scoir_id. The StudentId mapping configurations have been copied to the new scoir_id field. If your institution used a different field to store the Scoir ID previously, an additional destination has been added to also map this source field to the person-scoped Scoir ID field.
If your institution is not already receiving documents from Scoir, you will need to configure the integration in your Scoir account.
In Slate: Identify your Scoir Service Account's SFTP username
The username for Scoir will be email@example.com. You will be asked to enter the value after the @ (your subdomain) while configuring the integration in Scoir.
The subdomain is the part of the web address of your Slate database between the https:// and /manage. For example, if you log in to Slate at https://apply.slateuniversity.edu/manage, then the subdomain is apply.slateuniversity.edu.
Another way to find this value is by viewing the settings in the Scoir user account:
- From the main navigation, select Database, then select User Permissions.
- Select the Scoir Service Account from the list of active users.
- Click Edit User.
- On the Roles tab, scroll down to SFTP Access.
- Copy or make note of the Username (e.g., "firstname.lastname@example.org").
- Click Cancel or navigate away from the page and continue to the Scoir steps below.
In Scoir: Configure and Activate the Integration
Use this documentation from Scoir to configure the integration: Part 1: Connect Slate and Scoir, Step 3.
Once configured, activate the integration using the steps provided in Step 4 of the same document.
Scoir batches documents into a single evening delivery each night. The ZIP archive containing all PDFs received since the previous delivery along with an index file will be placed into the /incoming/scoir/ SFTP directory. The ScoirMaterials source format is configured to automatically pick up the files that are placed in this directory and import the data and documents using the Remap configurations.