This article collects the changes made to the database schema as part of the Campus.2311 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-157516 | OneRosterSeqStudentV1P1 | seq | int |
personID | int | ||
SIS-157516 | OneRosterSeqStudentV1P1Active | seq | int |
personID | int | ||
SIS-157516 | OneRosterSeqStudentV1P1School | schoolID | int |
seq | int | ||
personID | int | ||
SIS-157516 | OneRosterSeqStudentV1P2 | seq | int |
personID | int | ||
SIS-157516 | OneRosterSeqStudentV1P2Active | seq | int |
personID | int | ||
SIS-157516 | OneRosterSeqStudentV1P2School | schoolID | int |
seq | int | ||
personID | int | ||
SIS-157516 | OneRosterSeqUserV1P1 | seq | int |
personID | int | ||
prefix | char | ||
SIS-157516 | OneRosterSeqUserV1P1Active | seq | int |
personID | int | ||
prefix | char | ||
SIS-157516 | OneRosterSeqUserV1P2 | seq | int |
personID | int | ||
isStudent | bit | ||
isRelated | bit | ||
isTeacher | bit | ||
isAide | bit | ||
isAdmin | bit | ||
SIS-157516 | OneRosterSeqUserV1P2Active | seq | int |
personID | int | ||
isStudent | bit | ||
isRelated | bit | ||
isTeacher | bit | ||
isAide | bit | ||
isAdmin | bit |
Modified Tables
Added
Case Number | Table | Column | Data Type |
SIS-167594 | BehaviorEvent | gangRelatedDescriptor | varchar(15) |
SIS-166752 | Course | competencyBased | bit |
SIS-166752 | CourseCatalog | lockCompetencyBased | bit |
SIS-166752 | CourseMaster | competencyBased | bit |
SIS-166752 | DistrictAttribute | priorYearADA | decimal(6,2) |
SIS-158296 | EvalGuardian | languageAlt | varchar(5) |
SIS-158296 | EvalGuardian | languageAlt2 | varchar(5) |
SIS-160480 | LessonPlanAttachment | submittedByID | int |
SIS-160480 | LessonPlanSubmission | submittedByID | int |
SIS-160480 | LessonPlanSubmissionGoogleDriveAttachment | submittedByID | int |
SIS-158296 | PlanGuardian | languageAlt2 | varchar(5) |
SIS-158296 | PlanServiceProvided | planServiceProvidedGUID | uniqueidentifier |
Deprecated
Case Number | Table | Column |
SIS-167117 | CampusAttribute | GUIPath |
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-120572 | PCV vaccine updates | |
SIS-120572 | PCV and PPV vaccine description updates | |
SIS-152878 | Migrated device notification preferences | |
SIS-152878 | Setup decrypt email quartz job | |
SIS-157516 | Set OneRosterManualCacheRefreshTrigger Active | |
SIS-158984 | Removed StSA object keys that follow old format to force resync for IN | |
SIS-166202 | NM | Staff IDs |
SIS-166393 | KY | New Vaccine Exemption For Titer Immune |
SIS-166784 | Updated DLPP nightly sync not to run immediately | |
SIS-166813 | NJ | Converted GraduationSeal method WORLDSPEAK to STAMP WS |
SIS-167453 | Updated OneRoster v1p2 scopes to use https | |
SIS-167540 | Added job for messaging out homeroom info for POS terminals | |
SIS-167593 | Grandfather data health check to DVv2 | |
SIS-167593 | Give Limited Data Validations |
In addition to these scripts, a script has also been run with SIS-165825 to remove the following tables as they are no longer relevant:
- DupScoreInstanceFullLogTranscriptCredit
- DupScoreInstanceFullLogTranscriptCourse
- DupScoreInstanceWorkingLogGradingScore
- DupScoreInstanceFullLogGradingScore
- DupScoreInstanceFullLog
- DupScoreInstanceFullLogTranscriptCreditV2
- DupScoreInstanceFullLogTranscriptCourseV2
- DupScoreInstanceWorkingLogGradingScoreV2
- DupScoreInstanceFullLogGradingScoreV2
- DupScoreInstanceFullLogV2
