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 |