Ellucian Banner Student Change Request Resolutions RELEASE NAME: BA STUDENT 8.16 RELEASE DATE: 06/27/2018 ====================================================================== SYSTEM: Banner SC Brazil STUMECR Education Ministry (MEC) Reports Change Request (Enhancement) #: CR-000156613 PROGRAM: DDL's sgracmo_081600_01.sql sgracmo_081600_02.sql sgracmo_081600_03.sql sgracmo_081 600_04.sql sgracmo_081600_05.sql Page SGAACMO PROBLEM: A new page SGAACMO should be created to capture the details related to academic mobility of students BUSINESS PURPOSE: Data entered on this page will be used for the MEC reports RESOLUTION: Following new objects (DDL's) will be released with Student 8.16. sgracmo_081600_01.sql sgracmo_081600_02.sql sgracmo_081600_03.sql sgracmo_081 600_04.sql sgracmo_081600_05.sql Also a new page SGAACMO will be released for this with Banner Student 9.3.11. Link: https://ellucian.force.com/clients/a0x1M000005kwaQQAQ ====================================================================== SYSTEM: Banner Student Change Request (Defect) #: CR-000154544 MODULE: Registration PROGRAM: sfkrgst.sql,sfkrgst1.sql PROBLEM: Rules defined on groups attached to areas are not represented correctly in Structured Registration. IMPACT: When Structured Registration requirements are defined using Mandatory, Optional, and Elective rules within Groups, all requirements display in self-service under the Compulsory heading which could be confusing for students when they are selecting classes. RESOLUTION: Corrections have been made to the processing in the SFKRGST database package to represent rules defined on groups attached to areas correctly in Structured Registration. When processing groups and group rules, include the type code and key so that they can appear in the correct category rather than all falling under MANDATORY. Link: https://ellucian.force.com/clients/a0x1M000005XjQFQA0 ====================================================================== SYSTEM: Banner Student Change Request (Defect) #: CR-000138397 MODULE: Registration PROGRAM: sfkrgst1.sql PROBLEM: When elective requirements are defined in a group and there are no mandatory requirements, the requirement display in self-service is not correct. IMPACT: When a group is defined with Mandatory, Elective and/or Optional rules that require students to select from lists of courses, the rule umbrella information for each rule type displays twice. This duplicated information can make it difficult to determine what the requirements are. RESOLUTION: When an area is being displayed without any groups attached, the SFRSTRD record created for the subset does not have the parent rule. In the handling of an area set up with groups, the rule of ELECTIVE is being inserted into SFRSTRD. This causes the RegistrationStructuredRegistrationRequirementDescriptio n.generateShortDescription() to skip the look up of the description in the map, and use the ruleDetail.ruleDescription instead. This is why we get the same WHERE condition text appearing twice instead of the message text. The fix is delivered in SFKRGST1.sql package body with Student 8.16. In the format_sfrstrd logic, we eliminate the setting of the rule and rule_desc fields. elsif smbgrul_cond_rec.smbgrul_group is not null then p_print_dbms('format_sfrstrd smbgrul cond area ' || area || ' key rule ' || smbgrul_cond_rec.smbgrul_key_RULE || ' group ' || smbgrul_cond_rec.smbgrul_group); -- sfrstrd_rec.sfrstrd_RULE := smbgrul_cond_rec.smbgrul_key_RULE; -- sfrstrd_rec.sfrstrd_RULE_DESC := smbgrul_cond_rec.smbgrul_desc; Link: https://ellucian.force.com/clients/a0x16000004UtpkAAC ====================================================================== SYSTEM: Banner Student Change Request (Defect) #: CR-000152398 MODULE: Regulatory PROGRAM: sfpcpos.jar PROBLEM: Banner SORLCUR_PROGRAM Degree Works block type: PROGRAM ("Banner program codes are not being sent as Degree Works PROGRAM blocks". Clarification note: Program is being sent over to the API in case 'program as degree' is in use; but it is not sent as a Degree Works "Goal"/Field of Study) Banner COLLEGE In certain circumstances, Degree Works uses this information to determine the correct block for a student. Without it, Degree Works will either not pull in any blocks or could pull in the incorrect block. Needs to be sent over with a Goal Type of COLLEGE IMPACT: Banner SORLCUR_PROGRAM Degree Works block type: PROGRAM Program is being sent over to the API in case 'program as degree' is in use; but it is not sent as a Degree Works "Goal"/Field of Study. Banner SORLCUR_COLL_CODE Degree Works block type: COLLEGE The college code is not being sent to Degree Works as a Goal Type. In certain circumstances, Degree Works uses this information to determine the correct block for a student. Without it, Degree Works will either not pull in any blocks or could pull in the incorrect block. RESOLUTION: Modified below class or methods to pass Program and College value to what if request payload. a) createAPIPayload b) processDegreeAuditRequest c) StudentProgram.java d) StudentDegree.java Link: https://ellucian.force.com/clients/a0x1M000005XRVJQA4 ====================================================================== SYSTEM: Banner Student Change Request (Defect) #: CR-000145608 MODULE: Regulatory PROGRAM: sfpcpos.jar,sfacpsc.fmb,SFACPSC PROBLEM: SFPCPOS and Degree Works and repeated courses for Financial Aid purposes IMPACT: Federal funds will pay for one repeat of a passed "non-repeatable" course or as many repeats as necessary for a failed "non-repeatable" course. This fix resolves the issue of in-progress courses not being counted when Degree Works is the audit program used to run compliance. The fix will now accurately count in-progress repeat courses where applicable. RESOLUTION: a)Modified updateClassStmt update to include update of column SFRSCRE_IN_PROGRAM_REPEAT_CDE. b)Added logic in getInProgramIndicatorRESTful() method for IN PROGRAM REPEAT logic. c)Modified updateClassAllProgramExcluded() method to include update of column SFRSCRE_IN_PROGRAM_REPEAT_CDE. d)Modified DegreeAudit.Java method to add other logic around IN PROGRAM REPEAT column. Delivering SFACPSC (9.3.11) page changes with 8.16 release for this CR. Link: https://ellucian.force.com/clients/a0x160000058CKoAAM ====================================================================== SYSTEM: Banner Student Change Request (Defect) #: CR-000150592 MODULE: Registration PROGRAM: shkrpt1.sql PROBLEM: Issues with Repeats in Banner 9X 1. When a student has courses in history BELOW the evaluation grade on SHARPTR, that are marked with manual INCLUDE and EXCLUDE, Registration should be ignoring them as they are below the evaluation grade. Registration is NOT ignoring them, and giving a repeat error. Student has HS 101 in history with a ‘D’ grade in 201610 (manual excluded) and 201710 (manually included). SHARPTR evaluation grade set to ‘C’. Students attempts to register for HS 101 in 201720, and get repeat count error. In the same scenario if the repeat system Ind in history are a ‘S’, the student is allowed to register in 201720. Note: 1-18TJZ3I (same issue) is listed as resolved in XE. IMPACT: Repeats that are manual, below evaluation grade, are being ignored in next term registration as expected RESOLUTION: When a student has courses in history BELOW the evaluation grade on SHARPTR, Registration will now ignore them as they are below the evaluation grade. The SHKRPTS database package has been modified for this fix and hence this issue is fixed for both 8x and 9x and will be available in Student 8.16 release. The issue #2 described in CRM attachment is fixed as part of CR-000151468 CR. Link: https://ellucian.force.com/clients/a0x16000005ZafdAAC ====================================================================== SYSTEM: Banner Student Change Request (Enhancement) #: CR-000155715 MODULE: Regulatory PROGRAM: sorfncr_081600_01.sql,sorfncr_081600_02.sql, sorfncr_081600_03.sql,sorfncr_081600_04.sql, sorfnpt_081600_01.sql,sorfnpt_081600_02.sql, sorfnpt_081600_03.sql,sorfnpt_081600_04.sql, sgjbpdefi_081600.sql,sgjbpvali_081600.sql, sgjbpdfti_081600.sql,sfrnslc.pc PROBLEM: This enhancement will provide a new page and tables to store final exam dates for a part of term or CRN in order to support accurate Enrollment Reporting. BUSINESS PURPOSE: To include Final Exam dates in Enrollment Reporting as needed IMPACT: This enhancement will provide a new page and tables to store final exam dates for a part of term or Course Reference Number (CRN) to support accurate Enrollment Reporting. RESOLUTION: 1) Delivered new page SOAFNDT with 9.3.11 for to define new final end dates for Part of Term or CRN based. 2) Delivered 2 new tables SORFNCR and SORFNPT for to support with above new page. SFRNSLC.pc ------------------- a) Created new variables: usefinaldateflag,final_end_dates. b) Created new methods: readusefinaldate(), selfinaldates(). c) Added logic to retrieve new parameter value for 33, "Use Final Dates". d) Added logic in selfinaldates() to get max final end date from new final date tables sorfncr and sorfnpt. e) Modified selstartenddates() to support this new functionality to "Use Final dates". f) Modified sel_grad_date_g() to get max grad date from the above new tables or SSBSECT PTRM date, if parameter 33 value = Y. g) DTP|382|RD8| dates will be displayed based on this new logic if parameter 33 value = Y. Link: https://ellucian.force.com/clients/a0x1M000005krv9QAA ====================================================================== ************************************************************************ Without limitation: Ellucian(R), Banner(R), Colleague(R), and Luminis(R) are trademarks of the Ellucian group of companies that are registered in the U.S. and certain other countries; and Ellucian Advance(TM), Ellucian Course Signals(TM), Ellucian Degree Works(TM), Ellucian PowerCampus(TM), Ellucian Recruiter(TM), Ellucian SmartCall(TM), are also trademarks of the Ellucian group of companies. Other names may be trademarks of their respective owners. (C)2018 Ellucian. Contains confidential and proprietary information of Ellucian and its subsidiaries. Use of these materials is limited to Ellucian licensees, and is subject to the terms and conditions of one or more written license agreements between Ellucian and the licensee in question. In preparing and providing this publication, Ellucian is not rendering legal, accounting, or other similar professional services. Ellucian makes no claims that an institution's use of this publication or the software for which it is provided will guarantee compliance with applicable federal or state laws, rules, or regulations. Each organization should seek legal, accounting, and other similar professional services from competent providers of the organization's own choosing. Ellucian 2003 Edmund Halley Drive Reston, VA 20191 United States of America