This article collects the changes made to the database schema as part of the Campus.2643 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
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-201380 | SSRSReportParameters | parametersID | int | no |
parametersGUID | uniqueidentifier | yes | ||
userID | int | no | ||
reportID | int | no | ||
requestTimestamp | datetime2(0) | no | ||
parameters | nvarchar(max) | no | ||
SIS-202613 | AttendanceDayPerson | attendanceDayPersonID | int | no |
personID | int | no | ||
calendarID | int | no | ||
date | datetime2(0) | no | ||
attributeID | int | no | ||
value | varchar(256) | yes | ||
attendanceDayPersonGUID | uniqueidentifier | no | ||
createdDate | datetime2(0) | yes | ||
modifiedDate | datetime2(0) | yes | ||
createdByID | int | yes | ||
modifiedByID | int | yes |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-203258 | BehaviorResponseRole | trainingOffered | bit | no |
SIS-203258 | BehaviorResponseRole | trainingReceived | bit | no |
SIS-203207 | BehaviorRole | aiGeneratedOrModified | bit | no |
SIS-185554 | EvalType | transferableUnlocked | bit | no |
SIS-202961 | NCSnapshotGRSSummary | summaryGroup | varchar(50) | yes |
SIS-203436 | NCSnapshotPMRDetail | submittedByID | int | yes |
SIS-203436 | NCSnapshotPMRDetail | submittedTimestamp | datetime2(0) | yes |
SIS-203436 | NCSnapshotPMRSummary | submittedByID | int | yes |
SIS-203436 | NCSnapshotPMRSummary | submittedTimestamp | datetime2(0) | yes |
SIS-202600 | PaymentsRuntimeLock | lockedAtUTC | datetime2(0) | yes |
SIS-202769 | POSEligibility | incomeStatus | varchar(15) | yes |
SIS-195652 | ResponsiveOffering | lunchCount | bit | no |
SIS-195652 | ResponsiveOffering | milkCount | bit | no |
SIS-195652 | ResponsiveOffering | adultCount | bit | no |
SIS-195652 | ResponsiveOffering | customCount1 | bit | no |
SIS-195652 | ResponsiveOffering | customCount2 | bit | no |
SIS-195652 | ResponsiveOffering | customCount3 | bit | no |
SIS-192218 | TestAccommodations | handheldCalculator | bit | no |
SIS-192218 | TestAccommodations | signLanguageASL | bit | no |
SIS-192218 | TestAccommodations | onlineCalculator | varchar(100) | yes |
SIS-192218 | TestAccommodations | textToSpeechSubject | varchar(100) | yes |
Altered Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-203186 | EmploymentAssignment | accessToIDEA | varchar(15) | yes |
SIS-199093 | NCSnapshotLCSCS | teacherDuties | varchar(55) | yes |
SIS-203205 | PlanGoal | serviceProvider | varchar(500) | yes |
SIS-203205 | PlanGoal | standardName | varchar(1000) | yes |
SIS-203205 | PlanGoal | standardAbbr | varchar(1000) | yes |
SIS-203205 | PlanGoal | standardGradeLevel | varchar(1000) | yes |
SIS-203205 | PlanGoal | completeStandardString | varchar(8000) | yes |
SIS-203205 | PlanServiceProvided | serviceName | varchar(500) | yes |
SIS-202887 | SEPTransitionPlan | creditsNeeded | decimal(6,2) | yes |
SIS-202887 | SEPTransitionPlan | creditsTotal | decimal(6,2) | yes |
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-192339 | MO | Moved title3 fields off enrollment |
SIS-201250 | Populated state code on attendanceExcuse | |
SIS-201422 | OK | Created Presidential Fitness Tests2 |
SIS-201422 | OK | Created Presidential Fitness Tests |
SIS-201422 | Test File | |
SIS-202350 | MN | 26-27 District list updates |
SIS-202410 | MN | Updated Little Falls district name |
SIS-202673 | Dropped pmr05 inline tvf | |
SIS-202920 | KS | Ed-Fi Turned off Staffs resource |
SIS-203034 | MO | Updated cleanup bad startDate in OnTrack table |
SIS-203053 | KY | Immunization Rule Update |
SIS-203070 | PA | Immunization Rule Update |
SIS-203070 | PA | Added Live Vaccine Logic |
SIS-203134 | PMR snapshot conversion | |
SIS-203186 | Converted EmploymentAssignment accessToIDEA values | |
SIS-203360 | NE | Updated TranscriptCourse creditEarnedMethod hide flag |
SIS-203520 | NE | Converted SPED Plan Gen En Hours to Decimal Varchar |