Technical Information - Release Pack Campus.2311

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

ColumnData 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 NumberStateDescription

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