This article collects the changes made to the database schema as part of the Campus.2639 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.
Modified Tables
Added Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-201406 | BehaviorRole | trainingOffered | bit | no |
SIS-201406 | BehaviorRole | trainingReceived | bit | no |
SIS-200384 | EmploymentAssignment | contractorProvider | varchar(255) | yes |
SIS-201471 | EnrollmentMO | stackableCred3 | varchar(15) | yes |
SIS-201471 | EnrollmentMO | stackableCred4 | varchar(15) | yes |
SIS-201697 | EnrollmentMO | overFTE | varchar(15) | yes |
SIS-201769 | NCSnapshotPMRDetail | calendarID | int | yes |
SIS-201769 | NCSnapshotPMRDetail | createdByID | int | yes |
SIS-201769 | NCSnapshotPMRDetail | createdTimestamp | datetime2(0) | no |
SIS-201769 | NCSnapshotPMRDetail | districtID | int | yes |
SIS-201769 | NCSnapshotPMRDetail | endyear | int | no |
SIS-201769 | NCSnapshotPMRDetail | rerun | smallint | no |
SIS-201769 | NCSnapshotPMRDetail | reviewed | bit | no |
SIS-201769 | NCSnapshotPMRDetail | schoolID | int | yes |
SIS-201769 | NCSnapshotPMRDetail | submitted | bit | no |
SIS-201769 | NCSnapshotPMRDetail | verified | bit | no |
SIS-201769 | NCSnapshotPMRDetail | verifiedByID | int | yes |
SIS-201769 | NCSnapshotPMRDetail | verifiedTimestamp | datetime2(0) | yes |
SIS-188119 | ProcessMessage | notifyUserID | int | yes |
SIS-200918 | Section | programTypeOverride | varchar(70) | yes |
SIS-165306 | Section | stateReportExclude | bit | no |
Altered Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-201769 | NCSnapshotPMRDetail | ncSnapshotPMRSummaryID | int | yes |
SIS-201769 | NCSnapshotPMRDetail | schoolMonth | int | yes |
SIS-201769 | NCSnapshotPMRDetail | psu | varchar(50) | yes |
SIS-201769 | NCSnapshotPMRDetail | schoolName | varchar(255) | yes |
SIS-201769 | NCSnapshotPMRDetail | schoolNumber | varchar(255) | yes |
SIS-201769 | NCSnapshotPMRDetail | race | varchar(50) | yes |
SIS-201769 | NCSnapshotPMRDetail | lastname | varchar(50) | yes |
SIS-201769 | NCSnapshotPMRDetail | stateID | varchar(15) | yes |
SIS-201769 | NCSnapshotPMRDetail | endStatus | varchar(15) | yes |
SIS-201769 | NCSnapshotPMRDetail | presentOnSite | int | yes |
SIS-201769 | NCSnapshotPMRDetail | presentOffSite | int | yes |
Deprecated Columns
Case Number | Table | Column |
|---|---|---|
SIS-198073 | CampusDictionary | edFiCode |
SIS-201498 | ProductWaitlistNotification | activityID |
Renamed Tables and Columns
Case Number | Table | New Name | Column | New Name |
|---|---|---|---|---|
SIS-201769 | NCSnapshotPMRDetail | NoChange | daysAbsent1R | daysRemote |
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-190898 | TN | Immunization Rule Update |
SIS-200108 | IL | Immunization Rule Update |
SIS-200874 | ND | Disabled Curriculum Import for BIE Districts |
SIS-200874 | ND | Disable curriculum import for ND districts |
SIS-200934 | BIE and MT | State Grade Level Code drop-down add KG |
SIS-200940 | AZ | Added Live Vaccine Logic |
SIS-201157 | DE | Converted Course.cipCode and CareerTechnicalEducation.ctePathway |
SIS-201173 | VA | Conversion CourseMaster |
SIS-201173 | VA | Conversion |
SIS-201341 | NY | Immunization Rule Update |
SIS-201435 | MO | Added Multiple New Attending Districts |
SIS-201489 | Backfilled uploadsComplete and formsComplete for activity registration | |
SIS-201577 | MN | Deleted idPostAmble from EdFi configurations |
SIS-201705 | Stripe Staging Vendor | |
SIS-201943 | Enabled interdistrict cross-site feature toggle for all | |
SIS-202180 | Updated seating chart coordinates |
