This article collects the changes made to the database schema as part of the Campus.2503 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.
New Tables
No new tables were added with this release.
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-184222 |
CustomStudent |
createdDate |
smalldatetime |
SIS-184222 |
CustomStudent |
modifiedDate |
smalldatetime |
SIS-184222 |
CustomStudent |
createdByID |
int |
SIS-184222 |
CustomStudent |
modifiedByID |
int |
SIS-183409 |
NonCSEAttDayAggregation |
stateScheduledMinutes |
smallint |
SIS-183839 |
PaymentVendorAccount |
onboardingComplete |
bit |
SIS-182793 |
SEPCourseOfStudy |
startDate |
date |
SIS-182793 |
SEPCourseOfStudy |
endDate |
date |
SIS-182793 |
SEPTransitionServices |
instructionStart |
date |
SIS-182793 |
SEPTransitionServices |
instructionEnd |
date |
SIS-182793 |
SEPTransitionServices |
vocationalStart |
date |
SIS-182793 |
SEPTransitionServices |
vocationalEnd |
date |
Altered Columns
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-183951 |
BIEISEPCertInstructional |
tribalCode |
varchar(105) |
SIS-183951 |
BIEISEPVerInstructional |
tribalCode |
varchar(105) |
SIS-184487 |
EnrollmentOK |
coreCurriculum |
varchar(15) |
SIS-183951 |
ISEP_Cert |
tribalCode |
varchar(105) |
SIS-183951 |
ISEP_Ver |
tribalCode |
varchar(105) |
SIS-182793 |
PlanServiceProvided |
locationGED |
varchar(150) |
SIS-182793 |
PlanServiceProvided |
locationSPED |
varchar(150) |
SIS-182793 |
SEPTransitionPlan |
otherText |
varchar(500) |
SIS-181290 |
TestScore |
accommodation |
varchar(3) |
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-166939 |
WI |
EdFi Removed SAR records with old format objectKey |
SIS-173768 |
KY |
Enabled CSE |
SIS-175518 |
Enable CSE for SIF States | |
SIS-177453 |
HI |
Enabled CSE |
SIS-177459 |
MA |
CSE Intra-District Functionality |
SIS-178606 |
NY |
Converted Program Code 120504E to 120504 |
SIS-178606 |
NY |
Converted Program Code value |
SIS-180123 |
MO |
Converted Roster to SSDV in Batches |
SIS-181295 |
NC |
Updated name of District 298 |
SIS-182665 |
Added POSTerminalAutoInactivate Quartz Job | |
SIS-183410 |
AZ |
Ed-Fi Deleted food mappings with deprecated objectKey |
SIS-183723 |
Data Validation rule name changes | |
SIS-183839 |
Updated Stripe Vendor Names | |
SIS-184222 |
Added crated and modified columns to CustomStudent | |
SIS-184411 |
OH |
Immunization Rule Update |
SIS-184446 |
TX |
Ed-Fi Student Title I remove any deprecated objectKey |
SIS-184487 |
OK |
Converted coreCurriculum to droplist |
