Coursedog

Submit a ticket My Tickets
Welcome
Login  Sign up

Banner Integration

As an Ellucian Certified Partner, Coursedog has built a tight, bi-directional integration to both GET and POST schedule & curriculum planning data into Banner.  For a link to a forwardable slide deck detailing the SIS integration architecture, go here


Coursedog is able to have a tight bi-directional, controllable, nightly sync with Banner 9, and is building a closer to realtime integration with Ellucian Ethos. We do not require partners to use Ethos to integrate with our system, and in most cases advise against it. 


Coursedog’s integration process begins with our partners reviewing our Banner data workbook, which details the fields that we normally GET and POST for our Banner integration. If there are any customizations required to the initial build, your Customer Success Rep should be able to advise whether or not these are possible. 


A list of the fields we GET is outlined below:


Rooms and Buildings

FieldBanner
idslbrdef_bldg_code || '-' || slbrdef_room_number
nameslbrdef_desc
roomNumberslbrdef_room_number
typeslbrdef_room_type
displayNameslbrdef_bldg_code || '-' || slbrdef_room_number
blockedOutTimesnull
buildingIdslbrdef_bldg_code
buildingDisplayNamestvbldg_desc
floornull
capacityslbrdef_max_capacity
minCapacitynull
departmentsslbrdef_dept_code
featuresstvrdef_desc
notesslrcmnt_comments
room statusstvrmst.stvrmst_inact_ind
campusslbbldg_camp_code
addressLine1slbbldg_street_line1
addressLine2slbbldg_street_line2
cityslbbldg_city
stateslbbldg_stat_code
zipcodeslbbldg_zip
building statusstvrdef_desc


Instructors

FieldBanner
idspriden_id
emailgoremal_email_address
firstNamespriden_first_name
lastNamespriden_last_name
bionull
statussibinst_fcst_code to get the faculty and then 'active' checkbox value. Also SIBINST_SCHD_IND links the faculty member to schedule functionality and SPAIDEN table has checkbox for instructors who have passed away
typestvfcst_desc and sibinst_fctg_code 
termcodesirasgn_term_code
yearstvterm_fa_proc_yr
departmentssirdpcl_dept_code


Departments

API Field NameDatabase Field Name
displayNamestvdept_desc
idsirdpcl_dept_code
namestvdept_desc


Courses

API Field NameDatabase Field NameComments
departmentsstvdept_desc populate departments based on scbcrse_dept_code
descriptionscbdesc_text_narrative
idscbcrse_subj_code || scbcrse_crse_numb
namescbcrse_title
subjectCodescbcrse_subj_code
courseNumberscbcrse_crse_numb
prerequisitesscrrtst_subj_code_preq || scrrtst_crse_numb_preq || nvl(a.scrrtst_min_grde, a.scrrtst_test_score)populate prerequisites from scrrtst table
corequisitesscrcorq_subj_code_corq || scrcorq_crse_numb_corqpopulate prerequisites from scrcorq table
collegestvcoll_desc
catalogNumbernull
courseAttributesstvattr_descpopulate courseAttributes based on scrattr_subj_code and scrattr_crse_numb
courseNotesnull
statusscbcrse_csta_code
institutionIdscbcrse_coll_code
canSchedule

schdPrint

gradRosterPrint


blindGrading

courseApproved


Sections

API Field NameDatabase Field Name
idssbsect_subj_code || ssbsect_crse_numb || ssbsect_seq_numb || ssbsect_crn
sectionNumberssbsect_seq_numb
callNumberssbsect_crn
sectionNamessbsect_subj_code || ssbsect_crse_numb
courseIdssbsect_subj_code || ssbsect_crse_numb
sectionTypestvschd_desc and populates sectionType based on ssbsect_schd_code
populate sectionType based on ssbsect_schd_code
gradeModestvgmod_descpopulate gradeMode based on ssbsect_gmod_code
gradeModeCodessbsect_gmod_code
gradablessbsect_gradable_ind
campusssbsect_camp_code
creditHoursssbsect_credit_hrs
instructionModegtvmtyp_desc
partOfTermssbsect_ptrm_code
waitlistssbsect_wait_count
statusstvssts_descpopulate status based on ssbsect_ssts_code
topicnull
sectionAttributesstvattr_descCalculated field based on ssbsect_subj_code, ssbsect_crse_numb and scrattr_eff_term
sectionNotesnull
enrollmentssbsect_enrl
maxEnrollmentssbsect_max_enrl
priorEnrollmentssbsect_prior_enrl
waitlistssbsect_wait_count
maxWaitlistssbsect_wait_capacity
linkedSectionsssrlink_crnCalculated field based on ssbsect_term_code and ssbsect_crn
integrationPartnernull
schedulePrintnull
consentnull
preferredRoomFeaturesnull
preferredRoomTypeslbrdef_room_typeCalculated field based on ssrmeet_bldg_code, ssrmeet_room_code and slbrdef_term_code_eff
preferredRoomCapacityslbrdef_maximum_capacityCalculate field based on ssrmeet_bldg_code, ssrmeet_room_code and slbrdef_term_code_eff
preferredBuildingssrmeet_bldg_code
institutionIdssbsect_camp_code
professorsspriden_idCalculate field based on sirasgn_pidm
professorsMeta -> rolesirasgn_primary_ind
professorsMeta -> percentagesirasgn_percent_response
professorsMeta -> timeIndexsirasgn_category
professorsMeta -> idspriden_idCalculate field based on sirasgn_pidm
times -> classroomssrmeet_bldg_code || ssrmeet_room_code
times -> startssrmeet_begin_time
times -> endssrmeet_end_time
times -> dayssrmeet_sun_day || ssrmeet_mon_day || ssrmeet_tue_day || ssrmeet_wed_day || ssrmeet_thu_day || ssrmeet_fri_day || ssrmeet_sat_day
finalExam -> typenull
finalExam -> timesnull
billingHours

workloadHours

contactHours

lectureHours

labHours

otherHours


instrWorkload

instrLoadFactor

instrAccess

instrAssignType

instrConact

instrPrint

schedPrint

notesList


Terms

API Field NameDatabase Field Name
termCodestvterm_code
termDescstvterm_desc
yearstvterm_acyr_code
startDatestvterm_start_date
endDatestvterm_end_date
partOfTermsobptrm_ptrm_code
partOfTermDescsobptrm_desc
partOfTermStartDatesobptrm_start_date
partOfTermEndDatesobptrm_end_date




A list of fields we POST during Section Creation and Update is outlined below:

General Section FieldsSample Data
billingHours3
campus M
contactHours3
creditHours3
maxEnrollment 30
partOfTerm 1
sectionNumber 1
termCode 201909
partOfTermWeeks15
subjectCode CMD
courseNumber 511
partOfTermStartDate 8/26/2019
partOfTermEndDate 12/19/2019
censusEnrollDate 9/14/2019
gradable N
statusCode A
scheduleCode LEC
institutionId M
instructionMode 
availableSeats 0
lectureHours 
labHours 
otherHours 
gradeModeCode 
maxWaitlist 0
waitlist 0
registeredOneup 0
priorEnrollment 0
projectedEnrollment 0
enrollment 0
voiceAvailable Y
extensionAllowed 0
regFromDate 
regToDate 
learnerRegstartFromDate 
learnerRegstartToDate 
duntCode 
noOfUnits 
overrideDurInd 
name 
print 
callNumber 15563
Instructor Assignment related fields
role Y
timeIndex 1
percentage 100
 id 777888111
termCode 202030
 callNumber 36555
sessionPercentage 100
Meeting and room related fields
start 800
end 850
endDate  5/8/2020
startDate  1/13/2020
termCode 202030
scheduleCode A
callNumber 36426
monday M
tuesday T
wednesday W
thursday R
friday F
buildingId AD
roomNumber 11
timeIndex1
saturday  
sunday  
rowIdAAAVssAA5AAEL5DAA/


For a reference on this process, feel free to contact one of our Banner customers such as John Reina, CIO at SUNY New Paltz, reinaj@newpaltz.edu


To see the grant scripts for establishing the schema, setting up the Service Account, installing objects, and establishing permissions, go here


For additional info on the Gateway/Dataport and Timeline for SIS integration, see the following article detailing setup and configuration of the IIG. For HECVAT on the Gateway, see here

C
Coursedog is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.