The attached stored procedure(s) 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. 
You will need both scripts below and the table create script for this integration to function. 


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


Package Name = BANINST1.z_campuslogic.p_su_transaction (this comes straight from the Stored Procedure template attached to this article. This needs to match whatever that's updated to, if it's updated at all.)


Below are the parameters in the example Stored Procedure along with the Event Property name CL Connect will need. The lengths under the "Data Type" column are suggestions - they should match the actual data that's coming over. This might vary from value to value depending on the data you're feeding into the ScholarshipUniverse application. 


Stored Procedure ValueData TypeCL Connect Event Property
p_eventStudentId
VARCHAR2 (Your Student ID length)EventStudentId
p_eventId
VARCHAR2 (100)EventId
p_eventNotificationId
IntegerEventNotificationId
p_eventNotificationName
VARCHAR2 (100)EventNotificationName
p_eventDateTime
VARCHAR2 (50)EventDateTimeUtcStandard
p_suAwardYearName
VARCHAR2 (100)
SuAwardYearName
p_suTermId
VARCHAR2 (6)
SuClientTermId
p_suTermName
VARCHAR2 (50)
SuTermName
p_suScholarshipAwardId
VARCHAR2 (30)
SuScholarshipAwardId
p_suScholarshipName
VARCHAR2 (100)
SuScholarshipName
p_suScholarshipCode
VARCHAR2 (100)
SuScholarshipCode
p_suAmount
NUMERIC (11,2)SuAmount
p_suPostBatchUser
VARCHAR2 (100)
SuPostBatchUser
p_suPostType
VARCHAR2 (30)
SuPostType
p_suTermComments
VARCHAR2 (4000)SuTermComments