Adhering to the standard Stellic format (particularly the column names/attributes and the order in which they are presented) will minimize the custom work required and speed up the onboarding process. Stellic can make adjustments to these feeds and formats in the data pipeline for each institution (particularly for custom fields added to students or data sourced from two different locations). For questions, please contact your Stellic implementation team.
We strongly prefer receiving data in CSV format. Sample data files can be found here. The following are the specific file names that should be provided to Stellic as part of your institutional data feed (not all are necessary, depending on your SIS configuration). Again, we will work with your implementation team to help you determine the best approach for your context and technical resources.
Catalog Data Feeds
school.csv: school/college identifiers and names
department.csv: department identifiers and names
degree.csv: degree data for programs in program.csv
grade.csv: grade data for all valid options sent in course.csv and student_course.csv
enrollment_levels.csv: enrollment identifiers and names
program.csv: programs/offerings data
concentration.csv: concentration data for programs in program.csv (if applicable)
course.csv: course catalog data
course_topic.csv: topic data for courses (if applicable)
Schedule Data Feeds
class_types.csv: class_type values used in schedule_basic.csv (schedule) data
class_delivery_mode.csv: institution delivery_mode in the schedule_basic.csv feed (if applicable)
schedule_basic.csv: basic schedule/course section data
schedule_timing: class meeting pattern data for sections in schedule_basic.csv
schedule_constraints: constraint data for sections in schedule_basic.csv
calendar.csv: institutional calendar data for terms, schedule release dates, etc. (optional feed or Google sheet)
Student Data Feeds
class_level.csv: student level data for students in student_basic.csv
registration_status.csv: all valid registration status options used in the SIS (if applicable)
repeat_code.csv: all valid repeat options used in the SIS (if applicable)
advisor_role.csv: all valid advisor roles that will be used in the student_advisor.csv feed (if applicable)
student_basic.csv: basic student data
student_course.csv: course enrollment data for students in student_basic.csv
student_program.csv: program and concentration data for students in student_basic.csv (if multiple programs exist for each student, including those completed/with graduated status)
student_advisor.csv: details about student<>advisor relationships for students in student_basic.csv
student_enrollment_level.csv: student enrollment level data for students in student_basic.csv (if applicable)
Users and Access Feeds
user.csv: non-student user (i.e. staff, advisors, faculty, admin) data
Calendar Feeds
calendar.csv: academic calendar data
For convenience, the sample csv files are stored in a Google Sheet in different tabs but can be downloaded as CSV files.
Stellic is also able to accept data feeds in JSON format but this is a secondary option if needed by the institution based on the data infrastructure available. Please contact your Stellic integration team for more information.