This article collects the changes made to the database schema as part of the Campus.2551 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-191646
|
EarlyInterventionsValue
|
earlyInterventionsValueID |
int |
no |
earlyInterventionsID |
int |
no | ||
earlyInterventionsValueGUID |
uniqueidentifier |
no | ||
attributeID |
int |
no | ||
value |
varchar(15) |
yes | ||
SIS-192938
|
AttYearAggregation
|
personID |
int |
no |
schoolNumber |
varchar(12) |
no | ||
gradeLevel |
varchar(10) |
no | ||
startDate |
datetime2(0) |
no | ||
endDate |
datetime2(0) |
yes | ||
daysAbsent |
decimal(7,2) |
no | ||
daysPresent |
decimal(7,2) |
no |
Deprecated Tables
Case Number |
Table |
|---|---|
SIS-194173 |
GradingTaskICCSDeleted |
Deleted Tables
Case Number |
Table |
|---|---|
SIS-192938 |
AttYearAggregationNC |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-149823 |
AttendanceCounts |
periodsBitmask2 |
bigint |
no |
SIS-149823 |
AttendanceCounts |
periodsBitmask3 |
bigint |
no |
SIS-149823 |
AttendanceCounts |
periodsBitmask4 |
bigint |
no |
SIS-189139 |
CTEStatusNJ |
industryValuedCredential1 |
varchar(15) |
yes |
SIS-189139 |
CTEStatusNJ |
industryValuedCredential2 |
varchar(15) |
yes |
SIS-189139 |
CTEStatusNJ |
industryValuedCredential3 |
varchar(15) |
yes |
SIS-187212 |
PaymentTransactionProduct |
balanceAvailableDate |
date |
yes |
SIS-175684 |
PupilCount |
fte |
decimal(3,2) |
yes |
SIS-175684 |
PupilCount |
partTimeInstructionalMinutes |
int |
yes |
SIS-193087 |
RecordsTransfer |
suppLearningPlanXML |
varchar(max) |
yes |
SIS-193087 |
RecordsTransfer |
suppLearningPlanFOP |
varchar(max) |
yes |
SIS-193087 |
RecordsTransfer |
suppLearningPlanDataXML |
varchar(max) |
yes |
SIS-194675 |
Title1PartD |
daysServed |
smallint |
yes |
SIS-194675 |
Title1PartD |
locationType |
varchar(50) |
yes |
SIS-194675 |
Title1PartD |
stayLength |
smallint |
yes |
SIS-194258 |
Title3 |
exitReason |
varchar(15) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-191646 |
EarlyInterventions |
intervention |
varchar(8000) |
yes |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-194173 |
CTEStatusTX |
vocationalCode |
SIS-194173 |
ESLStatusTX |
ESLID |
SIS-194173 |
ESLStatusTX |
startDate |
SIS-194173 |
ESLStatusTX |
endDate |
SIS-194173 |
ESLStatusTX |
lep |
SIS-194173 |
ESLStatusTX |
language |
SIS-194173 |
ESLStatusTX |
bilingual |
SIS-194173 |
ESLStatusTX |
esl |
SIS-194173 |
ESLStatusTX |
eslSummerSchool |
SIS-194173 |
ESLStatusTX |
parentalPermission |
SIS-194173 |
ESLStatusTX |
lEPTested |
SIS-194173 |
ESLStatusTX |
lEPReclassDt |
SIS-194173 |
ESLStatusTX |
scienceExempt |
SIS-194173 |
ESLStatusTX |
socialStudiesExempt |
SIS-194173 |
ESLStatusTX |
writingExempt |
SIS-194173 |
ESLStatusTX |
readingELAExempt |
SIS-194173 |
ESLStatusTX |
mathematicsExempt |
SIS-191646 |
EarlyInterventions |
intervention |
SIS-194173 |
FLFederalStateIndicator |
programPriorKindergarten |
SIS-194173 |
MobileDevice |
deviceToken |
SIS-194173 |
MobileDevice |
personID |
SIS-194173 |
MobileDevice |
deviceModel |
SIS-194173 |
MobileDevice |
deviceType |
SIS-194173 |
MobileDevice |
systemVersion |
SIS-194173 |
MobileDevice |
notifyAssignments |
SIS-194173 |
MobileDevice |
notifyAttendance |
SIS-194173 |
MobileDevice |
notifyGrades |
SIS-194173 |
MobileDevice |
notifyBehavior |
SIS-194173 |
MobileDevice |
notifyLunchBalance |
SIS-194173 |
MobileDevice |
assignmentThreshold |
SIS-194173 |
MobileDevice |
gradesThreshold |
SIS-194173 |
MobileDevice |
lunchBalanceThreshold |
SIS-194173 |
MobileDevice |
createdDate |
SIS-194173 |
MobileDevice |
modifiedDate |
SIS-194173 |
RestraintEventTX |
restraintEventID |
SIS-194173 |
RestraintEventTX |
personID |
SIS-194173 |
RestraintEventTX |
eventDate |
SIS-194173 |
RestraintEventTX |
reasonCode |
SIS-194173 |
RestraintEventTX |
comments |
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-185637 |
PA |
Added 2 Year Eval Alert |
SIS-187212 |
|
Copied Settlement Dates over to products |
SIS-187212 |
|
Payments - Copied overall transaction date to new PaymentTransactionProduct availableDate column |
SIS-191646 |
MT |
Added Missing Early Targeted Interventions DIS Object |
SIS-192177 |
DE |
Fixed behaviorResTypes |
SIS-192207 |
CA |
Corrected Lowell Joint district number |
SIS-192505 |
MO |
Added College Park Christian Academy to district list |
SIS-192878 |
MO |
Converted Reading Deficiency fields |
SIS-193803 |
KY |
Immunization Rule Update |
SIS-193848 |
TX |
LEP ServiceType Conversion |
SIS-193879 |
|
aigReported conversion |
SIS-193879 |
|
Added localAigPlan bit DistrictAttribute |
SIS-193909 |
NC |
Data Validations Transition GDV Validations to System Owned |
SIS-193910 |
NC |
Updated AMC data validation to system owned procedures |
SIS-193947 |
|
UNC requirement checked |
SIS-194081 |
SD |
Updated District Number Black Hills Christian Academy |
SIS-194205 |
VA |
EdFi tool preference script |
SIS-194237 |
OK |
Title3 Conversion |
SIS-194335 |
|
Added SIF error log cleanup quartz job |
SIS-194349 |
|
Assigned Owners to Campus Support and OLR Administrator User Groups |
SIS-194477 |
NC |
Converted State-Owned Rules for WARN and INFO to System Owned |
SIS-194936 |
|
Fixed winter GPA Snapshot Quartz Job trigger schedule |
