Element451Integrations Guide

Banner Majors

Updated Article

Element451 Data Source Sync#

Explanation#

Majors are synced from Banner using the following Ethos endpoint: /api/academic-programs

For additional context, see the Data Source sections in the Functional Overview and/or Technical Overview.

Sync Behavior#

Element451 imports majors based on the following criteria:

  • The program is active, or
  • The program has an end date that is:
    • A default “end of time” value, or
    • Within the past 10 years

During sync, Element451 creates multiple versions of each program based on how Ethos structures academic data.

These include:

  • Program only
  • Program + major (field of study)
  • Program + major + concentration (if applicable)

Ethos does not indicate which combinations are valid based on Banner configuration (SOACURR). As a result, all combinations are initially synced, and partners must determine which are valid.


Program/Major Details#

In Element451, program combinations are represented using a pipe ( | ) separator in the Code field.

Example program structures:

  • CEAC-CERTG
    • Program only
  • CEAC-CERTG | CEAC
    • Program + major (field of study)
  • CEAC-CERTG | CEAC | XCON
    • Program + major + concentration
    Element451 Majors list with three Accounting Graduate Cert entries whose Codes show program, major and concentration
    Three rows of an Element451 majors data source with columns Title, Code, Tags and Active. Codes are 'CEAC-CERTG' (program only), 'CEAC-CERTG | CEAC' (program + major) and 'CEAC-CERTG | CEAC | XCON' (program + major + concentration), with the pipe character separating each level. Only the third, 'Accounting Graduate Certificate', is marked Active (Yes); each row has edit (pencil) and delete icons.

The Name field can be customized, but the Code field reflects the structure used for integration and should not be modified.


Integration Codes

Each major includes associated Ethos identifiers, which can be viewed by:

  • Clicking the pencil icon.
  • Clicking to the Integration Code tab
Element451 Edit Major dialog, Integration Code tab, mapping SIS and Custom 1, 2 and 4 to Ethos GUIDs
The Edit Major (Accounting Graduate Certificate) dialog in Element451 with the Integration Code tab selected (other tabs: General, Available For). Under 'Use integration codes to match with common mappings', four rows pair a 'With' dropdown (Custom 1, Custom 2, Custom 4, SIS) with a Code field holding a GUID. An Add Code link and Cancel and Done buttons appear below.

These values map to Ethos GUIDs used during integration.

Example mapping:

  • SIS → Program GUID
  • Custom 1 → Major (field of study) GUID
  • Custom 2 → Degree GUID
  • Custom 4 → Concentration GUID

Validating Active Options#

All majors are imported as active by default.

Because Ethos does not validate combinations against SOACURR:

  • Some program combinations may be invalid
  • Invalid combinations can result in sync errors, such as:
    • “Curriculum invalid”
    • “The curriculum for priority 1 and sequence 1 is invalid”

To prevent these errors:

  • Review all synced program combinations
  • Deactivate invalid options

Recommended Approach

  • Deactivate program entries that do not include a pipe (|) when other versions exist
  • For programs with multiple pipe-separated options:
    • Validate each combination against SOACURR
    • Deactivate any invalid combinations

Only valid program + major + concentration combinations should remain active for use in applications.

Example Ethos Data#

Using our sample programs/majors above, here are examples of what the data can look like in Ethos (from the /api/academic-programs endpoint):

  • CEAC-CERTG:
json
{
    "academicLevel": {
        "id": "1034ab00-190c-412a-be3d-7179adab2913"
    },
    "code": "CEAC-CERTG",
    "credentials": [
        {
            "id": "68daab97-870d-4881-92db-6c8c744fd678" #Degree / Custom 2
        }
    ],
    "id": "bd2f2021-978f-4399-8845-fc2feb5919ac", #Program GUID / SIS
    "programOwners": [
        {
            "id": "292ee609-8ca1-4e87-8bcf-9700cddcb09e"
        }
    ],
    "startOn": "2012-02-20",
    "status": "active",
    "title": "Accounting Graduate Cert"
}
  • CEAC-CERTG | CEAC
json
{
    "academicLevel": {
        "id": "1034ab00-190c-412a-be3d-7179adab2913"
    },
    "administrativePeriodEnd": {
        "id": "9180dcda-5f50-4421-aaac-913cc62eb124"
    },
    "administrativePeriodStart": {
        "id": "578a5ed9-32b6-46aa-8043-b3448cd6a86d"
    },
    "code": "CEAC-CERTG",
    "credentials": [
        {
            "id": "68daab97-870d-4881-92db-6c8c744fd678" #Degree / Custom 2
        }
    ],
    "disciplines": [
        {
            "administeringInstitutionUnit": {
                "id": "4c94d852-943e-4c1e-922e-5404fd67c19a"
            },
            "administrativePeriodEnd": {
                "id": "9180dcda-5f50-4421-aaac-913cc62eb124"
            },
            "administrativePeriodStart": {
                "id": "578a5ed9-32b6-46aa-8043-b3448cd6a86d"
            },
            "discipline": {
                "id": "4bcda9d7-91f3-4d2a-9906-7a4352ec959f" #Major / Custom 1
            },
            "endOn": "2999-01-01",
            "programConstraint": "requiredDiscipline",
            "startOn": "1900-01-01"
        }
    ],
    "endOn": "2999-01-01",
    "id": "271f7578-2c3d-42dd-a3a6-ba522ad5f2a5", #Program GUID / SIS
    "programOwners": [
        {
            "id": "292ee609-8ca1-4e87-8bcf-9700cddcb09e"
        }
    ],
    "startOn": "1900-01-01",
    "status": "active",
    "title": "Accounting Graduate Cert"
}
  • CEAC-CERTG | CEAC | XCON
json
{
    "academicLevel": {
        "id": "1034ab00-190c-412a-be3d-7179adab2913"
    },
    "administrativePeriodEnd": {
        "id": "9180dcda-5f50-4421-aaac-913cc62eb124"
    },
    "administrativePeriodStart": {
        "id": "578a5ed9-32b6-46aa-8043-b3448cd6a86d"
    },
    "code": "CEAC-CERTG",
    "credentials": [
        {
            "id": "68daab97-870d-4881-92db-6c8c744fd678" #Degree / Custom 2
        }
    ],
    "disciplines": [
        {
            "administeringInstitutionUnit": {
                "id": "4c94d852-943e-4c1e-922e-5404fd67c19a"
            },
            "administrativePeriodEnd": {
                "id": "9180dcda-5f50-4421-aaac-913cc62eb124"
            },
            "administrativePeriodStart": {
                "id": "578a5ed9-32b6-46aa-8043-b3448cd6a86d"
            },
            "discipline": {
                "id": "4bcda9d7-91f3-4d2a-9906-7a4352ec959f" #Major / Custom 1
            },
            "endOn": "2999-01-01",
            "programConstraint": "requiredDiscipline",
            "startOn": "1900-01-01"
        },
        {
            "administrativePeriodEnd": {
                "id": "9180dcda-5f50-4421-aaac-913cc62eb124"
            },
            "administrativePeriodStart": {
                "id": "578a5ed9-32b6-46aa-8043-b3448cd6a86d"
            },
            "discipline": {
                "id": "95323cf6-6c2e-4718-8dc9-29682f3d7c98" #Concentration / Custom 4
            },
            "endOn": "2999-01-01",
            "parentDiscipline": {
                "id": "4bcda9d7-91f3-4d2a-9906-7a4352ec959f"
            },
            "startOn": "1900-01-01"
        }
    ],
    "endOn": "2999-01-01",
    "id": "271f7578-2c3d-42dd-a3a6-ba522ad5f2a5", #Program GUID / SIS
    "programOwners": [
        {
            "id": "292ee609-8ca1-4e87-8bcf-9700cddcb09e"
        }
    ],
    "startOn": "1900-01-01",
    "status": "active",
    "title": "Accounting Graduate Cert"
}