Skip to main content
Liaison

Coursework Data Mapping in Slate Source Formats

Before you can begin mapping the data from the application to Slate, you'll need to import the standard Source Format for CAS Coursework from the Library. For more information, see below and visit the Slate Knowledge Base.

Unique Identifiers for Matching

Create two new fields and set them as "unique for merging." These should already exist in your Slate instance upon importing the standard Source Format for CAS Coursework data. The standard Source Format maps CAS IDs into these fields to ensure proper matching for incoming CAS data.

  • Person scope: "CAS/Liaison Person ID"
  • School scope: "CAS/Liaison School ID"

Additionally, the CAS course ID will be pre-mapped to the Slate "School Course: External ID" field in the standard Source Format to ensure that CAS coursework information is loaded to the same Slate Course even if delivered multiple times.

Information Available for CAS Coursework

Different CAS may collect different coursework details. The fields consistently available have been pre-mapped in the standard Source Format and include the following:

  • "title" - The name of the course taken.
  • "creditsReceived" - The number of credits earned by the applicant in the course taken.
  • "grade" - The grade earned by the applicant in the course taken.
  • "subject" - The subject, selected from a standardized list, of the course taken.
  • "termYear" - The year when the course was taken.

Additional fields are available depending on the CAS from which the coursework information is being delivered. You should consider your uses for coursework information in Slate and the availability of data when deciding whether to map additional coursework fields.
 
One field you may well want to map is the "term" field. This field will contain the term when the course was taken, such as "Fall", "Spring", or "Summer". To effectively map this field, you'll need to complete some Slate baseline configuration work to define possible Slate Course Term values to which to map the CAS course term values. Consult Slate's Knowledge Base for more information on configuring the Slate Courses object.

Value Mapping: Course Subject

The CAS Coursework "subject" field delivers the subject, selected from a standardized list, of the course taken. The "subject" field is mapped to the Slate "School Course: Type" field. To effectively map this field, you'll need to complete some Slate baseline configuration work to define possible Slate Course Type values to which to map the CAS Coursework "subject" values. Consult Slate's Knowledge Base for more information on configuring the Slate Courses object. The exhaustive list of possible CAS Coursework "subject" values can be found in the CAS-Slate Data Dictionary article. Download the "Lookups" file and navigate to the sheet called "LK_Subject". The list of values on that sheet are the possible values that will be delivered in the CAS Coursework "subject" field.

For more information, also see the Slate Knowledge Base.

  • Was this article helpful?