This article collects the changes made to the database schema as part of the Campus.2303 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
We've made some changes!
Thanks for your feedback via our recent survey. We're continuing to make updates to how we provide this information; here are the changes we've made this time:
- Added the column names and data types included in each new table.
- Restored the Data Type information for new columns.
- Removed the Description for new and modified columns to simplify and reduce confusion.
Please use the comments field at the end of this article if you have feedback. 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
Case Number | Table | Column | Data Type |
SIS-158142 | Pronoun | pronounID | int |
| code | varchar(15) | ||
| stateCode | varchar(15) | ||
| name | varchar(256) | ||
| startDate | date | ||
| endDate | date | ||
| subjectiveForm | varchar(30) | ||
| objectiveForm | varchar(30) | ||
| dependentPossessiveForm | varchar(30) | ||
| independentPossessiveForm | varchar(30) |
Modified Tables
Added
Case Number | Table | Column | Data Type |
SIS-157228 | MessengerSchedule | triggerID | int |
SIS-157228 | MessengerSchedule | modifiedDate | datetime2 |
SIS-157228 | MessengerSchedule | parentTemplateID | int |
SIS-157228 | MessengerSchedule | createdDate | datetime2 |
SIS-157228 | MessengerSchedule | modifiedByID | int |
SIS-157228 | MessengerSchedule | name | varchar(50) |
SIS-157228 | MessengerSchedule | createdByID | int |
SIS-157228 | MessengerTemplate | scheduler | bit |
SIS-157668 | Trial | schedulingBoardModifiedDateTime | datetime2 |
SIS-157668 | Trial | schedulingBoardModifiedByID | int |
SIS-158142 | Identity | pronounID | int |
SIS-159639 | PortalDisplayOptions | stateID | |
SIS-165513 | GraduationSeal | provider | varchar(15) |
SIS-165703 | AssessmentScoreImport | studentIdentifier | varchar(50) |
| SIS-165789 | SpecialEdDates | esyServices | varchar(1) |
SIS-165798 | FollowUpData | cteConcentration | varchar(15) |
SIS-166200 | PaymentTransaction | eventName | |
SIS-166200 | PaymentTransaction | deviceID | |
SIS-166200 | ProductSale | paymentMethodReferenceID | bit |
SIS-166214 | PlanState | ancillaryDisability5 | bit |
SIS-166214 | PlanState | ancillaryDisability6 | bit |
SIS-166214 | PlanState | ancillaryDisability3 | bit |
SIS-166214 | PlanState | ancillaryDisability2 | bit |
SIS-166214 | PlanState | ancillaryDisability1 | bit |
SIS-166214 | PlanState | ancillaryDisability4 | bit |
SIS-166214 | PlanState | ancillaryDisability7 | bit |
Altered
Case Number | Table | Column | New Data Type |
SIS-157228 | MessengerSchedule | taskID | int |
SIS-157228 | MessengerSchedule | senderID | int |
SIS-158142 | Identity | comments | varchar(500) |
| SIS-165703 | AssessmentScoreImport | mappingConfig | varchar(max) |
Deprecated
Case Number | Table | Column |
SIS-157228 | MessengerSchedule | senderID |
SIS-157228 | MessengerSchedule | senderEmail |
SIS-157228 | MessengerSchedule | ani |
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-165744 | NY | Immunization Rule Update |
SIS-159648 | AZ | Immunization Rule Update |
SIS-165552 | IN | Inactivated code ESOL on EL Services |
SIS-160560 | Deactivated Smart Scholars, Smart Transfer, and P-Tech State Program Codes | |
SIS-152035 | Added remoteReportRenderingEnabled preference | |
SIS-160482 | NV | Immunization Rule Update |
SIS-160482 | NV | Immunization Rule Update |
SIS-165832 | MN | Immunization Rule Update |
SIS-160936 | ME | Added To State Title List |
SIS-165606 | MT | Data Conversion PlanState Disabilities Updates |
SIS-163781 | CA | Immunization Rule Update |
SIS-158142 | Added default pronouns | |
SIS-165657 | MA | Converted Staff Attendance fields from 0 to NULL |
SIS-157228 | Added MessengerSchedule CampusJobDetail | |
SIS-165513 | Added provider to seals | |
SIS-165798 | OH | Updated FW tab and report |
SIS-166214 | New SPED Schema | |
SIS-165789 | Added esyServices to SpecialEdDates | |
SIS-165938 | NV | eSign for IEP with compatibility for pre SQL Server 2016 |
SIS-160340 | Update Identity comments table length | |
SIS-165703 | Expanded fields for Assessment Mapping Import | |
SIS-157228 | Altered MessengerSchedule | |
SIS-157228 | Added scheduler field to MessengerTemplate | |
SIS-159639 | Added stateID column to PortalDisplayOptions | |
SIS-158142 | Added schema for pronouns |
