This article collects the changes made to the database schema as part of the Campus.2327 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
Infinite Campus will be removing all NOLOCK (and its equivalent, READUNCOMMITTED) query hints and READ UNCOMMITTED settings from the Infinite Campus code base with Campus.2331.
To mitigate the risk of query result inconsistencies, please be prepared to remove any NOLOCK (and READUNCOMMITTED) query hints from your own custom SQL code when you take Release Pack .2331 (July 2023). Removing them before or after taking this release could cause inconsistencies in your query results.
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 |
|---|---|---|---|
SIS-168500 | IMResponseDeleted | responseID | int |
objectID | int | ||
sectionID | int | ||
personID | int | ||
attempt | smallint | ||
startTimestamp | datetime | ||
endTimestamp | datetime | ||
clientIP | varchar(100) | ||
clientUserAgent | varchar(100) | ||
incomplete | bit | ||
releaseFeedback | bit | ||
| SIS-168500 | IMResponseItemDeleted | responseItemID | bigint |
responseID | int | ||
itemID | int | ||
responseTimestamp | datetime | ||
htmlContent | nvarchar | ||
value | varchar(100) | ||
seqAsPresented | smallint | ||
teacherComments | varchar(255) | ||
correct | bit | ||
systemScoredCorrect | bit | ||
points | decimal(18,0) | ||
SIS-168500 | IMResponseItemResponseDeleted | responseItemResponseID | bigint |
responseItemID | bigint | ||
itemResponseID | int | ||
selected | bit | ||
seqAsPresented | smallint | ||
selectedMatchingValue | nvarchar | ||
SIS-168500 | IMResponseItemScoreDeleted | responseItemScoreID | bigint |
responseItemID | bigint | ||
taskID | int | ||
points | decimal(18,0) | ||
score | varchar(10) | ||
itemBank | bit | ||
SIS-170090 | ReportConfigTemplate | templateID | int |
toolID | int | ||
userID | int | ||
name | varchar(150) | ||
isDefault | bit | ||
createdTimestamp | datetime2(0) | ||
modifiedTimestamp | datetime2(0) | ||
config | varchar(max) |
Deprecated Tables
Case Number | Table |
|---|---|
SIS-168500 | IMResponseActivity |
Modified Tables
Added
Case Number | Table | Column | Data Type |
|---|---|---|---|
SIS-160422 | EnrollmentOR | servingSchool | varchar(15) |
SIS-167112 | BehaviorResolution | removalServiceDeclined | varchar(15) |
SIS-167113 | Identity | tribalEnrollment | varchar(15) |
SIS-167896 | TeamMember | ideaParent | bit |
SIS-168500 | IMLearningObject | attemptLimit | tinyint |
SIS-168500 | IMResponse | objectSectionID | |
SIS-168821 | District | pkProgramEvaluation | varchar(2) |
SIS-168821 | Graduation | earlyHighSchoolGrad | varchar(2) |
SIS-169121 | Section504 | contactPersonID | int |
SIS-169121 | Section504 | disability3 | varchar(15) |
SIS-169121 | Section504 | location2 | varchar(15) |
SIS-169121 | Section504 | disability6 | varchar(15) |
SIS-169121 | Section504 | disability5 | varchar(15) |
SIS-169121 | Section504 | disability2 | varchar(15) |
SIS-169121 | Section504 | disability7 | varchar(15) |
SIS-169121 | Section504 | disability4 | varchar(15) |
SIS-169120 | TwentyFirstCCLC | evaluationDate | date |
SIS-169120 | TwentyFirstCCLC | classParticipation | varchar(15) |
SIS-169120 | TwentyFirstCCLC | positiveClassroomBehavior | varchar(15) |
SIS-169120 | TwentyFirstCCLC | positivePeerRelationships | varchar(15) |
SIS-169120 | TwentyFirstCCLC | staffPersonID | int |
SIS-169530 | PlanState | transitionDelayReason | |
SIS-169701 | BuildingGeneralInformation | pbisMonths | int |
SIS-169701 | BuildingGeneralInformation | pbisStatus | varchar(15) |
SIS-169701 | DistrictGeneralInformation | ccpDenials | int |
SIS-169701 | DistrictGeneralInformation | ccpRestitution | int |
SIS-169701 | DistrictGeneralInformation | externalWifi | bit |
SIS-169701 | DistrictGeneralInformation | localWellnessPolicy | varchar(15) |
SIS-169701 | DistrictGeneralInformation | districtIRNpreKsped | varchar(15) |
SIS-169701 | DistrictGeneralInformation | ccpCount | int |
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-170035 | Lift-Up Attendance Research Project Conditional Updates | |
SIS-166885 | VA | Immunization Rule Update |
SIS-169701 | OH | School and District updates |
SIS-168500 | Resubmissions add attemptLimit column to IMLearningObject | |
SIS-168624 | SD | Added section504 to DISObject |
SIS-169591 | Roster status cleanup | |
SIS-160569 | IL | Updated StateCode from 11 to 16 |
SIS-167896 | AZ | State Defined Service Type |
SIS-169042 | Enabled VoiceBundle MessengerPreference |
