This article collects the changes made to the database schema as part of the Campus.2347 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
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 | DataType |
|---|---|---|---|
SIS-171181 | SchoolYearGPA | gpaID | int |
gpaGUID | uniqueidentifier | ||
personID | int | ||
endYear | int | ||
districtID | int | ||
weightedGPA | decimal(8,5) | ||
unweightedGPA | decimal(8,5) |
Deprecated Tables
Case Number | Table |
|---|---|
SIS-173635 | DataExtractUtil |
CusDevDataZip | |
DataExtractHistory |
Modified Tables
Added
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-170971 | EnrollmentEndStatusType | isCrossSiteDefault | bit |
SIS-170971 | EnrollmentStartStatusType | isCrossSiteDefault | bit |
SIS-170971 | Roster | crossSiteRosterGUID | uniqueidentifier |
SIS-171672 | PaymentTransaction | cardEntryType | varchar(6) |
SIS-172339 | BehaviorResolution | alternateSchoolID | varchar(8) |
SIS-172339 | BehaviorResolution | disciplineProcess | varchar(15) |
SIS-172984 | CalculatedAbsenteeValues | calculatedAbsenteeValueGUID | uniqueidentifier |
SIS-172984 | CalculatedAbsenteeValues | calculatedAbsenteeValueID | int |
SIS-173079 | SEEAssessmentResult | areaReviewed | varchar(100) |
SIS-173079 | SEEAssessmentResult | description | varchar(8000) |
SIS-173079 | SEEAssessmentResult | dataSource | varchar(100) |
SIS-173079 | SEEProvideToParent | disability | varchar(150) |
SIS-173079 | SEEProvideToParent | typeOfNotification | varchar(150) |
SIS-173079 | SEEProvideToParent | notificationMethodUsed | varchar(150) |
SIS-173079 | SEEProvideToParent | disabilityName | varchar(150) |
SIS-173079 | SEEProvideToParent | specifyOther | varchar(8000) |
Modified
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-172339 | BehaviorResolution | auxiliaryCode | varchar(15) |
SIS-172665 | CloudFileLocation | code | varchar(20) |
SIS-173079 | SEEAssessmentResult | date | date |
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-155151 | WY | New Vaccine MenACWY and added to rules |
SIS-170971 | Added DefaultStateExcludeCrossSiteEnrollments to Preferences | |
SIS-171181 | Populated SchoolYearGPA table | |
SIS-171665 | Updated OneRoster OAuth1 Expiration Messages to Send at 4AM | |
SIS-171666 | Moved Immunization Jobs outside update window | |
SIS-171800 | PA | Immunization Rule Update |
SIS-172530 | GA | Added DV to unlocked auxiliaryCode |
SIS-172606 | NV | Renamed sped-504 custom form |
SIS-172606 | NV | Updated Testing Accommodations Form |
SIS-172665 | Added New Messenger CloudFileLocations | |
SIS-172665 | Added Messenger CloudFileLocations | |
SIS-172946 | CA | ELLScreener sproc |
SIS-172967 | KS | Enabled edfiShowPreference |
SIS-172984 | Added CalculatedAbsenteeValues DIS Object | |
SIS-173093 | OH | Scheduled IMM job |
SIS-173093 | OH | Added job to overnight immunization quartz |
SIS-173327 | Enabled OneRoster Sequenct tables | |
SIS-173341 | WI | Immunization Rule Update |
SIS-173457 | DE | Updated State Grade Level Code |
SIS-173457 | DE | Updated District Table |
SIS-173660 | ME | District list update |
SIS-173715 | Marked newly unhidden test fields as in use | |
SIS-173757 | DE | Added new State Grade Levels |
