Documentation for Course Exchange Student Identifier Production Instance Work - Banner

To identify which students at a college are participating in Course Exchange and taking courses at other colleges, students are assigned to a "cohort" at their Home College.

In Banner, student cohort codes appear on the INB form SGASADD where more than one cohort code can be associated to a student. 

SGASADD - Associate Cohort codes

A start date (From Term field value) is assigned to the cohort when it is created. The end date (To Term field value) can be '999999'.

Cohort codes are set up on STVCHRT form that holds the look-up values. 

STVCHRT - Look up Values

The underlying Oracle database table is SGRCHRT and the cohort code column name is SGRCHRT_CHRT_CODE. 

In order to identify cohorts, a new cohort code must be set up by your school on the STVCHRT form so that the cohort code can be used/defined in the application.properties file. For eg: Ventura has set up different cohort codes for each school within the district to identify which school the student belongs to depending on the misCode.