These cases are included in the Campus.2207 release pack.
Feedback Requested
As a user of this schema change document, would you find would you find this type of information helpful if it was provided for Rx releases such as Rx Pack - Campus.2132? (Schema changes in Rx cases are rare, on average one in thirty cases.)
Please respond in the comments field at the end of this article. Thanks!
Data Definition Language Scripts (DDL)
This section lists data structures that were created, altered, or dropped, based on the vocabulary used to define data structures in SQL Server.
New Tables
There were no new tables added with this release.
Modified Tables
Because of a recent change to our database, Data Type information is no longer provided for these changes. Please comment at the end of this article if you have any concerns. Thank you!
Added
Case Number | Table | Column | Description |
SIS-151490 | CampusEventRecord | tableSchema | Database table schema for trigger. |
SIS-151490 | CampusEventTrigger | tableSchema | Database table schema for trigger. |
SIS-152858 | EmailAttachmentFile | createdByID | Created by personID (nullable for legacy records.) |
SIS-151608 | Gifted | exclude | Determines whether a program association should send for the gifted record. |
SIS-152721 | MessengerTemplate | createdByID | PersonID of person who created template. |
SIS-152721 | MessengerTemplate | locked | Locking will prevent some users from update the template. |
SIS-150607 | PlanGoalPLAAFP | plaafpGUID | Non-primary key unique internal identifier. |
SIS-151707 | PlanServiceProvided | sequenceNumber | Field used to order records by number. |
SIS-129490 | SchoolAttribute | ercBIE | Identifies the specific geographic organization or ERC under which a BIE school falls under. |
SIS-151289 | Title1IN | reasonExited |
Data Manipulation Language Scripts (DML)
This section lists scripts to add, modify, query, or remove data from a SQL Server database.
| Case Number | State | Description |
SIS-137563 | TN | Immunization Rule Update 2 |
SIS-151287 | IN | Updated teacher role codes for EdFi. |
SIS-152044 | MO | PlanAccommodation moIEP22 |
SIS-153114 | Converted ForumPersonAccess records to Individualized IMLOS | |
SIS-150451 | OH | Converted transcriptField1 |
SIS-137563 | TN | Immunization Rule Update |
SIS-152981 | KY | Converted Identity birthCounrty |
SIS-150777 | Set default values for elastic preferences | |
SIS-150777 | Added Preference For Search Framework Locator Search | |
SIS-139833 | PA | Immunization Rule Update |
SIS-151790 | AZ | Conversion of Person.staffStateID to Employment.licenseNumber |
SIS-151490 | Default tableSchema dbo | |
SIS-152175 | AZ | Updated Tribal Affiliation |
SIS-129490 | BIE | Updateed new ercBIE SchoolAttribute field |
SIS-150014 | Reindex Personnel | |
SIS-151841 | OH | Immunization Rule Update |
