This source format is loaded into the databases of all Coalition members and many of its source fields are pre-mapped to standard destinations within Slate.

Source format requirements

Remap settings are customizable, with the following exceptions:

Mapped application round

An application round must be mapped to create an application. This may be mapped from the Application Round source field, with the appropriate Prompt Value Mappings configured, or it may be mapped as a Static Value if all applications should be created in the same round.

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.

Applications should be imported as unsubmitted.

Since the supplement form isn't yet completed by the applicant at the time of import, the submitted flag is purposely not mapped. The submitted flag is included on the supplement form instead. Positioning this status change at the submission of the supplement form allows Scoir to display an incomplete status to applicants when they view their Scoir profiles.

Configuring the source format

To configure the CoalitionApplicationProfile source format:

1. From the main navigation, select Database, then select Source Formats.

2. Select CoalitionApplicationProfile (JSON).

3. Click Remap.

4. Map additional items and make any desired changes in Field Mappings page.

5. On the right, click Prompt Value Mappings.

6. Map values as needed:

   • The full list of values that may be included in the source data are in the Application Profile Guide from Scoir. Request access to the guide here.

   • You may use Append Values to map the possible source values prior to receiving them in the data.

   • The application_round source field will contain the values configured in Scoir by your institution. See the section Application Round Considerations for more information.

7. Add Field Fusions and Static Mappings as needed.

8. With remapping completed, return to the CoalitionApplicationProfile source format page using the breadcrumb navigation. 

9. On the right, click Edit.

10. Set Remap Active to Active. 

11. Click Save

Application Round Considerations

Every application in Slate must have an application round. This data point must be mapped in the source format to ensure that an application is created.

How Scoir Application Rounds Relate to Rounds in Slate

Since your institution can configure which round options applicants can select within Scoir, the rounds should directly match your institution's round configurations within Slate in most circumstances.

If your application rounds have a specific entry term (for example, Fall and Spring), you can map the source format's same application_round source field to an entry term field (if you have one) as a second destination. Then, on the Prompt Value Mappings page, set the fall round to the fall entry term value, and the spring round to the spring entry term.

If your application rounds are complicated and determined by multiple factors, the application round set by the import can be preliminary. Use the application_round source field to place the applications into the likely round for most situations. The Coalition Supplement form is capable of updating the application round, and this field can be configured with conditional logic and calculation formulas as necessary.

Default and Override Behaviors for Application Creation

By default, Slate will match onto an existing application in the same mapped application round that exists on the same person record. If an application in that round does not exist on the person record, a new application will be created for that record.

There are three possible override options for this behavior:

1. Always create a new application. Slate's default behavior, rather than create an additional application in the same round, instead attempts to match onto the existing application. To force Slate to create a new application instead, map a new static value:

   • Destination: Application Fields; App: Round Always Create

   • Value: Yes

2. Always use the existing application (in an active application period). Slate's default behavior only matches onto the existing application if the mapped application round matches the round of the existing application. To force Slate to match onto an existing application in the active application period if one already exists for the record, map a new static value:

   • Destination: Application Fields; App: Round Use Existing

   • Value: Yes 

   Note: This method will not update the  round on the existing application. To use the existing application while also updating the round, use the next override option.

3. Always use the existing application (in an active application period) and update the round. This option is nearly identical to the previous option, with the exception that it also updates the application round to the one mapped in the import. To force Slate to match onto an existing application in the active application period if one already exists for the record while also updating the round to the value mapped in the import, map a new static value:

   • Destination: Application Fields; App: Round Use Existing and Update

   • Value: Yes

More information on these three override options can be found here.

Mapping Fee Waivers

If your institution has an application fee, it is important to map the Coalition fee waiver fields so the Coalition Supplement form can reference them when determining if a fee should be charged. The Coalition #fee-waiversSupplement Form article in this section discusses the use of this field to prevent the accidental charging of an application fee.

The Coalition fee waiver includes:

• Qualifying for the Federal Free and Reduced Lunch Program:

  • cfw_free_reduced_lunch_yn

  • Receiving a College Board, ACT, and/or NACAC fee waiver:

    • cfw_college_board_waiver_yn

    • cfw_act_waiver_yn

    • cfw_nacac_waiver_yn

  • Being eligible for a Pell Grant:

    • cfw_pell_grant_yn

  • Participating in TRIO programs:

    • cfw_participate_trio_program_yn

  • The application will also continue to support the Armed Forces Fee Waiver, which institutions can configure in their Application Settings in Scoir.

Bit, or Multiple?

Depending on your institutional needs, you may choose to map these data points differently. The two most common options include:

• A single application-scoped fee waiver field that uses a bit prompt. The application stores Yes if any of these fee waiver conditions are met. This may be useful if your institution only needs to capture whether the application is eligible for a fee waiver, but the specific details aren't necessary.

• A single application-scoped fee waiver field that stores multiple prompt values for each waiver eligibility. This option includes prompts for each fee waiver type.

Setting up the fee waiver mappings

If you are using a bit prompt for the fee waiver field:

If you are storing multiple prompt values in the fee waiver field:

Next, we'll talk about the Coalition Supplement form.

Have questions? Check out the Coalition FAQ article.