This guide will walk you through the Colleague SIS Setup.



The attached screenshots and stored procedure are examples to help your school get up and running. Again, please remember the attached stored procedure will likely need to be modified and customized to fit your school's needs. 


If you are using this stored procedure without making any modifications, you will need to setup CL Connect with the following parameters:


Package Name = CLImportIntoColleague

Parameter 1 Information. @StudentId , Varchar , (Enter the length of your Student ID) , EventStudentId

Parameter 2 Information. @FaYear , Varchar , 9, EventAwardYearFormat1

Parameter 3 Information. @CodeType , Varchar , 3 , EventNotificationId

Parameter 4 Information. @TransactionCategory , Int , EventSvTransactionCategoryId




***Please note that you need to use the full Colleague ID when running an EventNotification test. If you don't, you run the run the risk of creating an orphan in the SIS files.



Once you create the stored procedure and install it in your DB, please move on to the next guide here: Configure Student Forms - Incoming API Credentials and CL Connect URL .


Stored procedure provided through the courtesy of Ellucian on behalf of Neumann University.