This article collects the changes made to the database schema as part of the Campus.2335 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
Infinite Campus has removed all NOLOCK (and its equivalent, READUNCOMMITTED) query hints and READ UNCOMMITTED settings from the Infinite Campus code base with Campus.2331.
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-155145 | PupilCount | pupilCountID | int |
personID | int | ||
districtID | int | ||
pupilCountGUID | uniqueidentifier | ||
modifiedByID | int | ||
modifiedDate | datetime2(0) | ||
startDate | date | ||
endDate | date | ||
program | varchar(15) | ||
residencyStatus | varchar(15) | ||
comments | varchar(255) | ||
SIS-155145 | CustomPupilCount | customID | int |
attributeID | int | ||
pupilCountID | int | ||
value | varchar(256) | ||
date | date | ||
SIS-162913 | WISNote | personID | int |
modifiedByID | int | ||
modifiedDate | datetime2(0) | ||
note | varchar(5000) | ||
SIS-167580 | PortalDisplayHomeText | textID | int |
type | varchar(10) | ||
homeHTML | nvarchar | ||
modifiedDate | datetime2(0) | ||
modifiedByID | int | ||
SIS-169830 | AtRisk | atRiskID | int |
personID | int | ||
districtID | int | ||
atRiskGUID | uniqueidentifier | ||
createdDate | date | ||
modifiedByID | int | ||
modifiedDate | date | ||
startDate | date | ||
endDate | date | ||
comments | varchar(500) | ||
status | varchar(15) | ||
SIS-169830 | CustomAtRisk | customID | int |
attributeID | int | ||
atRiskID | int | ||
value | varchar(256) | ||
date | date | ||
SIS-171493
| CustomPregnantAndParenting | customID | int |
attributeID | int | ||
pregnantAndParentingID | int | ||
value | varchar(256) | ||
date | date | ||
SIS-171493
| PregnantAndParenting | pregnantAndParentingID | int |
personID | int | ||
districtID | int | ||
pregnantAndParentingGUID | uniqueidentifier | ||
createdDate | date | ||
modifiedByID | int | ||
modifiedDate | date | ||
programStatus | varchar(15) | ||
tuitionType | varchar(15) | ||
startDate | date | ||
endDate | date | ||
comments | varchar(255) | ||
SIS-171523, SIS-168675 | AIR1Course | air1CourseID | int |
schoolGUID | uniqueidentifier | ||
schoolID | int | ||
courseNumber | varchar(13) | ||
courseName | varchar(30) | ||
subject | varchar(50) | ||
creditGroup | varchar(2000) | ||
standardID | int | ||
rank | int | ||
SIS-171523, SIS-168675 | AIR1Population | personID | int |
personGUID | uniqueidentifier | ||
schoolGUID | uniqueidentifier | ||
schoolID | int | ||
math | bit | ||
ela | bit | ||
SIS-171523, SIS-168675 | StudyEvent | studyEventID | int |
eventTime | datetime2(7) | ||
userID | int | ||
studentPersonID | int | ||
studyCode | varchar(15) | ||
eventCode | varchar(15) | ||
eventData | varchar(max) |
Modified Tables
Added
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-144199 | Message | incidentID | int |
SIS-155145 | EdFiConfiguration | countDate1 | date |
SIS-155145 | EdFiConfiguration | countDate2 | date |
SIS-155145 | EdFiConfiguration | countDate3 | date |
SIS-155145 | EnrollmentWI | secondFriJanMembOverride | varchar(15) |
SIS-155145 | EnrollmentWI | firstFriMayMembOverride | varchar(15) |
SIS-155145 | EnrollmentWI | thirdFriSeptMembOverride | varchar(15) |
SIS-169539 | SEPPostSecondaryGoals | anticipatedGraduation | varchar(8000) |
SIS-169539 | SEPPostSecondaryGoals | metCondition1 | tinyint |
SIS-169539 | SEPPostSecondaryGoals | metCondition2 | tinyint |
SIS-169539 | EvalState | servingSchoolState | varchar(2) |
SIS-169539 | EvalState | servingSchoolCity | varchar(25) |
SIS-169539 | EvalState | servingSchoolZip | varchar(10) |
SIS-169597 | RecordsTransfer | twentyFirstCCLCFOP | varchar(100) |
SIS-169597 | RecordsTransfer | twentyFirstCCLCXML | varchar(MAX) |
SIS-169597 | TwentyFirstCCLC | createdDate | date |
SIS-170083 | HealthScreeningTeenCheckup | tcFamilyCardiacHistory | bit |
SIS-170781 | School | allowCrossSiteEnrollment | bit |
SIS-170781 | Section | allowCrossSiteEnrollment | bit |
SIS-170781 | Section | crossSiteMaxStudents | smallint |
SIS-170781, SIS-171845 | Course | allowCrossSiteEnrollment | bit |
SIS-170781 | CourseMaster | allowCrossSiteEnrollment | bit |
SIS-170781 | District | allowCrossSiteEnrollment | bit |
SIS-170928 | SEETeamMeeting | varchar13 | varchar(8000) |
SIS-171079 | CareerReadiness | createdDate | date |
SIS-171413 | GradeLevel | overrideEndDate | date |
SIS-171413 | GradeLevel | overrideStartDate | date |
SIS-171494 | FundedProgram | period1 | int |
SIS-171494 | FundedProgram | period3 | int |
SIS-171494 | FundedProgram | createdDate | date |
SIS-171494 | FundedProgram | period2 | int |
SIS-171494 | FundedProgram | programStatus | varchar(15) |
SIS-171494 | FundedProgram | period4 | int |
SIS-171494 | FundedProgram | comments | varchar(256) |
SIS-171675 | EnrollmentCA | graduationExemption | bit |
SIS-171774 | ReportConfigTemplate | isDashboardItem | bit |
SIS-171845 | EnrollmentIA | esaFunded | bit |
Altered
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-167580 | UniqueLink | location | varchar(2000) |
SIS-171582 | AssessmentScoreImportColumnMapping | scoreDate | datetime(2) |
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-167304 | WI | Immunization Rule Update |
SIS-169472 | KY | English Learners Program Service Plan updates |
SIS-166099 | OH | Immunization Rule Update |
SIS-170865 | MO | Immunization Rule Update |
SIS-170911 | NM | Immunization Rule Update |
SIS-171494 | Added new fields to FundedProgram | |
SIS-169410 | MD | Immunization Rule Update |
SIS-168451 | MO | District renamed Alta Vista Charter to Guadalupe Centers Schools |
SIS-169921 | MN | Direct Admissions Survey Updates |
SIS-170867 | NY | Immunization Rule Update |
SIS-169590 | Removed TryNewLookOptionVisible and default TryNewLookOptInMode to all users for self-hosted | |
SIS-169982 | CT | Immunization Rule Update |
SIS-149287 | Removex FeatureToggles-NavWrapper-UnifiedSearch preference | |
SIS-171202 | NM | EdFi turned off unused resources |
SIS-154373 | Updateed LTI Cleanup Job time | |
SIS-170781 | Added Feature Toggle For Intra District Cross Site Enrollment | |
SIS-165792 | KY | Dropped Warning 8 proc |
