Jenzabar SONIS 2024 Increased Field Lengths
Overview
In Jenzabar SONIS 2024, field lengths in many tables were increased to accommodate greater amounts of data. Many of the fields affected relate to payment transactions, transcript creation, course management, honors, and satisfactory academic progress processing. Existing data is maintained and not changed by the lengthening script.
The following lists the most common fields and tables that were updated, as well as the new length. This is not a list of every field updated.
Display Name | Table Name | Column Name | New Length |
|---|---|---|---|
First Name | Name | first_name | 40 |
Last Name | Name | last_name | 80 |
Other Name | Name | other_name | 50 |
Middle Name | Name | mi | 40 |
Course | Course | course | 30 |
Course Text | Course | crs_txt | 125 |
Institution Name | Institute | inst_txt | 125 |
Institution Name | nmcrs | institut | 125 |
Honors and Probation | honors.prob | honors_prob_txt | 125 |
Operator | Various | Various | 9 |