---
title: "Common Black College Application Integration"
slug: "common-black-college-application-integration"
updated: 2026-02-27T22:55:49Z
published: 2026-02-27T22:55:49Z
---

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

# Common Black College Application Integration

The **Common Black College Application (CBCA) integration**allows schools to receive CBCA data and documents through an automated process.

The integration consists of two source formats:

- **The Common Black College Application - Applications source format**: Imports the application data for students who have submitted a CBCA application to your institution.
- **The Common Black College Application - Documents source format:**Imports application Materials to your instance.

These files are delivered to your database from the Common Black College Application via SFTP.

## Step 1: Creating the CBCA ID field

Both CBCA source formats rely on a **unique identifier**to match records and documents on import.

> [!WARNING]
> 📝 Your institution may already have a CBCA unique identifier field that can be used for matching imports. Look through all of your existing fields before creating a new one.

To create a CBCA ID field:

1. From the main navigation, select **Database.**
2. Select **Fields**.
3. Select **New Field**.
4. Configure the following settings:
  - **Status:** Active
  - **Scope Category:**Records
  - **Scope:**Application
  - **ID:**`cbca_id`
  - **Name:**Common Black College Application ID
  - **Field Type:**Free Text
  - **Unique for Merging:**Value contains a unique ID which identifies a single record for merging ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/ID field.png)
5. Select **Save.**

## Step 2: Sharing an RSA key pair with CBCA

To share an RSA key pair with CBCA and receive your SFTP credentials:

1. Follow the instructions in [Provisioning SFTP User Access](/v1/docs/provisioning-sftp-user-access#public-key-or-private-key) to generate an RSA public-private key pair.
2. Wait approximately 1-3 business days while CBCA adds your public key to the CBCA SFTP site.

> 📝 Your CBCA contact will provide SFTP connection information, including:
> 
> - SFTP hostname/URL
> - SFTP username

## Step 3: Creating a CBCA service account

Once you have received your SFTP credentials from CBCA, you’ll create a service account in Slate.

To create the CBCA service account:

1. From the main navigation, select **Database.**
2. Under Users & Access, select **User Permissions.**
3. Select **New User.**
4. Configure the following settings:
  - **First name:** CBCA
  - **Last name:** Service Account
  - **Email:**contact@commonblackcollegeapp.com
  - **User Type:** Service Account (Remote)
  - **Username:** Enter the username provided by CBCA in [Step 2: Sharing an RSA key pair with CBCA](/v1/docs/common-black-college-application#step-2-sharing-an-rsa-key-pair-with-cbca).
  - **SSH Private Key:** Enter the contents of the private key file you generated in [Step 2: Sharing an RSA key pair with CBCA](/v1/docs/common-black-college-application#step-2-sharing-an-rsa-key-pair-with-cbca).
5. Select **Save.**

> [!NOTE]
> 📝 Note
> 
> Save the username and password in a password manager so you can reference them later in this article.

## Step 4: Adding the *Applications*source format

This source format automatically imports Common Black College Application applications.

To add the CBCA source format in Slate:

1. From the main navigation, select **Database**.
2. Under Import and Data Processing, select **Source Format Library**.
3. In the Search Library box, enter “Common Black College Application - Applications”.
4. Next to *Common Black College Application - Applications*, select **Add**.
5. In the popup, select **Add**.
6. Confirm the browser dialogue.

## Step 5: Mapping the *Applications*source format

### Remapping the file

1. Select **Source Formats**in the Import and Data Processing section.
2. Find the **Common Black College Application - Applications** source format and select **Remap**to confirm destinations and to set up additional data mappings for this Source Format.

#### Field mappings

Some Slate destination fields are already mapped to data points included in the Common Black College Application file. These include mappings from Technolutions, as well as your mappings from previous years.

#### **Required mappings**

In general, you can make any changes to the mappings to suit your process and custom field structure.

However, there are a few exceptions. These mappings are critically important for a successful import:

- [Common Black College Application ID](/v1/docs/common-black-college-application#step-1-creating-the-cbca-id-field)
- Application round
- Entry Term

#### **Round Mapping**

**Round mapping**lets Slate create an application in the appropriate round for each record in the Common Black College Application file.

Round structures vary by institution. Think carefully about your round mappings to be consistent with your process.

#### **App: Round**

**App: Round**lets you map to a specific Application Round in Slate and create applications.

You may also map any source field to the *App: Round Override*destination. App: Round Override lets you map a specific application round to override the App: Round mapping for specific records.

The following are examples of how fields in this source format might be mapped.

### **Example 1: using *stat*with static Rounds**

In this example, we assume you have a single, static round per application type, re-used year to year.

Our example institution has the following rounds:

- First Year Regular Admission
- Transfer Admission
- First Year Early Action
- Non-Degree Admission
- Dual Enrollment Credit

The CBCA format contains a field called *Status*(`stat`), which can be used to map applications to this static rounds. Below is an example of how the mapping would be configured:

| stat > App:Round source value | Destination value |
| --- | --- |
| `F` - Freshman | App:Round *First Year Regular Admission* |
| `T` - Transfer | App:Round *Transfer Admission* |
| `E` - Early Admissions | App:Round *First Year Early Action* |
| `N` - Non-Degree | App:Round *Non-Degree Admission* |
| `D` - Dual Enrollment | App:Round *Dual Enrollment Credit* |

### **Example 2: Using *term*and *stat* with term-specific rounds**

If, instead of using static rounds, you use term- or year-specific rounds, an additional field called `term` can be used together with `stat` to create a field fusion that can be mapped.

In this example, you have two rounds: *First Year Admission - 2025 Fall*and *First Year Admission - 2025 Spring*.

To create appropriate source values for this round structure, create a [field fusion](/v1/docs/upload-dataset-stages#field-fusions-stage) using the `term` and `stat` fields. This produces the values in the following table, which can be mapped to App:Round

| term + stat > App:Round source value | Destination value |
| --- | --- |
| Fall 2025-F | App: Round *First Year - 2025 Fall* |
| Spring 2026-F | App: Round *First Year - 2026 Spring* |

### Add the server and file path

When you receive your SFTP credentials from CBCA, they will also share target paths for the files associated with this format. The path lets Slate fetch the correct files from CBCA when they are placed in that directory each morning.

To add the path to the source format:

1. In the source format’s main page, select **Edit**.
2. Select the **Import Automation**tab.
3. Paste the target path in the **Import Path/Mask**field.
4. Select **Save.**

### Field names and descriptions

The meaning and name of each field in this format can be found in the following CBCA document:

[PDF document](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Common_Black_College_Application_Database_Description_v2 (1).pdf)

## Step 5: Adding the *Documents*source format

This source format automatically imports Common Black College Application materials.

To add the CBCA source format in Slate:

1. From the main navigation, select **Database**.
2. Under Import and Data Processing, select **Source Format Library**.
3. In the Search Library box, enter “Common Black College Application - Documents”.
4. Next to *Common Black College Application - Documents*, select **Add**.
5. In the popup, select **Add**.
6. Confirm the browser dialogue.

## Step 6: Remapping the *Documents*source format

### Remapping the file

1. Select **Source Formats**in the Import and Data Processing section.
2. Find the **Common Black College Application - Documents** source format and select **Remap**to confirm destinations and to set up additional data mappings for this Source Format.

#### Field Mappings

The [Common Black College Application ID](/v1/docs/common-black-college-application#step-1-creating-the-cbca-id-field) field must be mapped.

#### Remap Values

1. The containing the file name must be mapped to **Material - Material Filename**.
2. The column containing the material type (or a static value if the imported documents are all the same material type) must be mapped to **Material - Material Code**.
3. The **Material Codes** should be mapped to the associated material keys in the **Value Mappings**. **[![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/2x41eyvfsky474afwvmwugmceclip0__6_.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/2x41eyvfsky474afwvmwugmceclip0__6_.png)** After the index file is mapped, set the **Remap Active** setting to **Active** to have Slate automatically process files uploaded on or after the **Remap As Of Date** value of the Source Format.

> [!NOTE]
> Note
> 
> If the material does not exist, it must be created. Custom materials can be created following the steps under the under [***Creating a New Material*********in the Materials**](https://portal.us.document360.io/v1/docs/materials-overview)article.

### Add the server and filepath

When you receive your SFTP credentials from CBCA, they will also share target paths for the files associated with this format. The path lets Slate fetch the correct files from CBCA when they are placed in that directory each morning.

To add the path to the source format:

1. In the source format’s main page, select **Edit**.
2. Select the **Import Automation**tab.
3. Paste the target path in the **Import Path/Mask**field.
4. Select **Save.**

Any document that needs to be stored with a person record.