Technical Information - Release Pack Campus.2507

This article collects the changes made to the database schema as part of the Campus.2507 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.

By request, we've added a new column to the New Tables and Modified Tables that indicates whether a field can be null.

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

Can Be NULL?

SIS-179783



ActivityWaitlistNotification



activityWaitlistNotificationID

int

no

activityID

int

no

productWaitlistNotificationID

int

no

SIS-179783










ProductItemWaitlist










productItemWaitlistID

int

no

personID

int

no

schoolID

int

no

priority

int

yes

productItemID

int

yes

waitlistTimestamp

datetime2(0)

no

approved

bit

no

approvedByID

int

yes

approvedTimestamp

datetime2(0)

yes

signupUserID

int

yes

SIS-179783






ProductWaitlistNotification






productWaitlistNotificationID

int

no

productID

int

yes

activityID

int

yes

enabled

bit

no

message

varchar(500)

yes

notificationType

varchar(20)

no

SIS-184819





PortalPreference





preferenceID

int

no

element

varchar(128)

no

value

varchar(500)

no

modifiedDateTime

datetime2(0)

yes

modifiedByID

int

yes

Modified Tables

Added Columns

Ordered by Table Name. 

Case Number

Table

Column

Data Type

Can Be NULL?

SIS-179783

Activity

waitlist

bit

no

SIS-179783

Activity

waitlistEndDate

date

yes

SIS-184031

AltProgram

districtNumber

varchar(15)

yes

SIS-183541

AttDayAggregation

noStateCodeAbsentMinutes

smallint

yes

SIS-184712

AttendanceCheckInOut

reconciledByServing

bit

no

SIS-184712

AttendanceCheckInOut

crossSiteTransfer

bit

no

SIS-184712

AttendanceCheckInOut

crossSiteSection

bit

no

SIS-183156

Message

scheduleID

int

yes

SIS-183156

MessagePreview

scheduleID

int

yes

SIS-183541

NonCSEAttDayAggregation

noStateCodeAbsentMinutes

smallint

yes

SIS-179783

Product

waitlist

bit

no

SIS-179783

Product

waitlistEndDate

datetime2(7)

yes

SIS-184031

SupportEnvironment

locationID

varchar(10)

yes

SIS-184031

SupportEnvironment

districtNumber

varchar(15)

yes

Altered Columns

Case Number

Table

Column

Data Type

Can Be NULL?

SIS-183607

Form

requireGuardianES

varchar(15)

no

SIS-183607

FormDocument

requireGuardianES

varchar(15)

no

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-167760

TX

 Ed-Fi Removed staffSchoolAssociations resource

SIS-179783


Added Waitlist Notification Job

SIS-179783


Added Activity Registration Portal Notification Type

SIS-180251

MT 

Created an 02MT - District List script 

SIS-180701

NH

Dictionary Conversions 

SIS-183352

NH 

Health Professions Attribute Code Change 

SIS-183607


requireGuardianES conversion

SIS-184034

CA 

Missing District 3977388 Banta Unified 

SIS-184164

WI 

Immunization Rule Update 

SIS-184201

ME 

birthCountry Bosnia Herzegovina conversion 

SIS-184217

MO 

Added New Attending School The Behavior Helper 

SIS-184265


Fixed OLP recipient name

SIS-184357

TX 

Ed-Fi Student CTE removed deprecated objectKeys 

SIS-184389

WI 

Updated District List 

SIS-184601

TN 

Immunization Rule Update 

SIS-184819


Data migration for new PortalDistrictPreference table

SIS-184873


Configured DCT via CAS

SIS-184874

NY 

Immunization Rule Update 

SIS-185009

PA 

Immunization Rule Update 

SIS-185019


Added daily CUPS Auto Registration Trigger

SIS-185054

NC 

Added Early Learning DIS Object to NC

SIS-185114


Updated interdistrict mapped course state codes 

SIS-185116


Populated state code and state code name fix

SIS-185116

NC 

Populated state code and state code name