Open topic with navigation

CAMS Enterprise Update Release 21.1.0

Revision Date: March 19, 2021

This document describes the items deployed in the 21.1.0 CAMS Enterprise Update Release. Enhancements, modifications, and system corrections are included and categorized primarily by module. Those items needing CAMS Manager attention have been noted as such. For detailed information and instructions on functionality additions and changes, refer to the online help files located in the CAMS Enterprise application. Note that portal updates are not automatically installed on your site and must be applied by your institution.

Glossary Table Script

We will be releasing a CAMS Glossary table update in a future release which will break up the CAMS Glossary table into several individual "Glossary_[category]" tables (one category per table). Foreign keys will be dropped from the Glossary table and added to the individual tables. This will alleviate the issue of not being able to delete from the Glossary table due to too many foreign keys pointing at table Glossary.

We have included a Glossary Table script in this release. The path for this script is SQL\ManualRun\GlossaryBreakup\PossibleColumnsWithUniqueIndexForeignKeyGlossary.sql. Run the Glossary Table script on your college database to identify issues with your current Glossary table and multiple Glossary categories. Executing this script will NOT change any data. It simply prints out warning messages about such issues and where in you database they occur. If you have a column in your existing tables that points to a glossary with 2 or more categories (bad data that is currently allowed), it will cause foreign key violations on the new tables. The CAMS Glossary Table Update will attempt to fix these issues but may fail with a Unique Index Error. This will prevent you from successfully updating to the next version of CAMS until the issue(s) are fixed.

This Glossary Table script should be executed prior to installing the future CAMS Glossary Table Update so that issues can be resolved in advance.

General

• Modified printing out of single student transcripts so you can simply enter an ID and tab out for faster student lookup.
• Removed RDS dependency from Grade Summary Export.
• Glossary Table Script added to the SQL\ManualRun\GlossaryBackup folder that helps identify possible issues with glossary table lookups that can cause errors in a future release.

Financial Aid

• Added academic year to Informed Borrowing. The student's Informed Borrowing information can be viewed in Financial Aid>Maintenance on the Financial Status lower grid of the page. These fields are imported from Tools>Import>Financial Aid>COD Import>Awards Tab.

Billing

• Corrected bug in 1098T for Box 7 future term's checkbox value.

Development

• Corrected issue that occurred when new pledges were entered on the Constituent Pledges/Linked Gifts page. Pledge reminders are now created and displayed in the Activities for Selected Pledge grid on that page.

Portals

• Faculty/Student portal narrative grades can now display special characters.
• Pictures in Faculty Portal will display for all students on page without the faculty having to go and view one at a time.

How to Update Portals

***CAMS Manager Action Needed

Portal files will be downloaded to your CAMS Enterprise \ Portal Updates directory.

If you do not (or have not yet) customized your portals, follow these instructions: MOVE all files from the CAMS Enterprise\Portal Updates\[PortalName] folder to the installation directory for the matching portal. Do not copy the folders but only the files in those sub-folders to the same sub-folder in the matching portal folder.

If you do customize your portals follow these instructions: After making a backup of your customized portal pages, move the stock portal files for this update to the installation directory for your specific Portal. Then apply your customizations to the new, stock portal files.

Portal files that were added or changed with the 21.1.0 update

Faculty

• inc/CommonFunctions.asp
• scripts/globalObjects.js
• ceFacultyRoster.asp
• ceSelectStudent.asp
• cmGrdbkAssignmentCalcGradesFinal.asp
• cmGrdbkAssignmentCalcGradesMidTerm.asp
• cmGrdbkAssignmentGradeEntry.asp
• cmGrdbkAssignmentViewGrades.asp
• cmGrdbkDirectGradeSubmit.asp
• cmGrdbkGradesByStudentView.asp
• cmGrdbkRptCalculatedGrades.asp
• cmGrdbkRptCalculatedGradesFriendly.asp
• cmGrdbkRptStudentDetails.asp
• cmGrdbkRptStudentDetailsExport.asp
• cmGrdbkRptStudentDetailsFriendly.asp
• cmGrdbkUtilitiesGradesSentToReg.asp
• cmGrdbkUtilitiesSubmitGrades1.asp
• cmGrdbkUtilitiesSubmitGrades2.asp
• cmGrdbkUtilitiesSubmitGrades2r.asp
• cmGrdbkUtilitiesSubmitGrades2rEdit.asp
• cmGrdbkUtilitiesSubmitGrades3.asp
• cmGrdbkUtilitiesSubmitGrades3r.asp

Faculty MRP

• inc/CommonFunctions.asp
• scripts/common.js
• ceFacultyRoster.asp
• ceSelectStudent.asp
• cmGrdbkAssignmentCalcGradesMidTerm.asp
• cmGrdbkAssignmentGradeEntry.asp
• cmGrdbkAssignmentViewGrades.asp
• cmGrdbkAssignmentViewGradesFinalEdit.asp
• cmGrdbkDirectGradeSubmit.asp
• cmGrdbkGradesByStudentView.asp
• cmGrdbkRptCalculatedGrades.asp
• cmGrdbkRptCalculatedGradesFriendly.asp
• cmGrdbkRptStudentDetails.asp
• cmGrdbkRptStudentDetailsExport.asp
• cmGrdbkRptStudentDetailsFriendly.asp
• cmGrdbkUtilitiesGradesSentToReg.asp
• cmGrdbkUtilitiesSubmitGrades1.asp
• cmGrdbkUtilitiesSubmitGrades2.asp
• cmGrdbkUtilitiesSubmitGrades2r.asp
• cmGrdbkUtilitiesSubmitGrades2rEdit.asp
• cmGrdbkUtilitiesSubmitGrades3.asp
• cmGrdbkUtilitiesSubmitGrades3r.asp

Student

• inc/CommonFunctions.asp
• scripts/common.js
• scripts/globalObjects.js
• cePortalGradeReport.asp
• cePortalGradeReportFriendly.asp
• cePortalNumberGradeReport.asp
• daudit.asp
• dauditFriendly.asp
• login.asp

Student MRP

• inc/CommonFunctions.asp
• cePortalGradeReport.asp
• cePortalGradeReportFriendly.asp
• cePortalNumbeGradereport.asp

SQL objects that were added or changed with the 21.1.0 update

Stored Procedures

• CAMS_A1098TForm.sql
• CAMS_A1098TForm_Debugger.sql
• CAMS_CODImportInformedBorrowingInfo.sql
• CAMS_CM_GetGrades_FinalPts_Grade.sql
• CAMS_CM_Grades2Submit_Final.sql
• CAMS_CM_SRCourseTest_Selection.sql
• CAMS_SRGradeEntry.sql
• CAMS_T4Form_Generate.sql
• CAMS_T2202AForm_Generate.sql
• CAMS_T2202AForm_Generate_ByProgram.sql
• CAMS_TranscriptCumTotals.sql
• CAMS_TranscriptTermTotals.sql

Triggers

• CAMS_TRG_InsertStudentFinAid.sql

Views

• CAMS_CM_FinalPts_Grade_With_MissingGrades_View.sql
• CAMS_CM_GradeBkDetailFinalGr_View.sql
• CAMS_CM_SelectedFinalPts_Grade_with_MissingGrades_View.sql
• CAMS_FinancialInformedBorrowing_View.sql