This article collects the changes made to the database schema as part of the Campus.2307 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
We've made some changes!
Thanks for your feedback via our recent survey. We're continuing to make updates to how we provide this information; here are the changes we've made this time:
- Added the column names and data types included in each new table.
- Restored the Data Type information for new columns.
- Removed the Description for new and modified columns to simplify and reduce confusion.
Please use the comments field at the end of this article if you have feedback. Thanks!
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-156876 | BuildingGeneralInformation | buildingGeneralInformationID | int |
districtID | int | ||
schoolID | int | ||
buildingGeneralInformationGUID | uniqueidentifier | ||
schoolYear | int | ||
modifiedByID | int | ||
modifiedDate | datetime2(0) | ||
ccpDenials | int | ||
ccpCount | int | ||
ccpRestitution | int | ||
hardwareProvP | bit | ||
hardwareProvK | bit | ||
hardwareProv1 | bit | ||
hardwareProv2 | bit | ||
hardwareProv3 | bit | ||
hardwareProv4 | bit | ||
hardwareProv5 | bit | ||
hardwareProv6 | bit | ||
hardwareProv7 | bit | ||
hardwareProv8 | bit | ||
hardwareProv9 | bit | ||
hardwareProv10 | bit | ||
hardwareProv11 | bit | ||
hardwareProv12 | bit | ||
hardwareProv23 | bit | ||
localWellnessPolicy | varchar(15) | ||
externalWifi | bit | ||
notYetBegun | varchar(15) | ||
explorationAdoption | varchar(15) | ||
installation | varchar(15) | ||
initialImplementation | varchar(15) | ||
fullImplementation | varchar(15) | ||
innovationSustainability | varchar(15) | ||
squareFootage | int | ||
lunchPercent | int | ||
transpoPercent | int | ||
peK2LimitedCount | int | ||
peK2ProficientCount | int | ||
peK2AdvancedCount | int | ||
peK2UnevaluatedCount | int | ||
pe35LimitedCount | int | ||
pe35ProficientCount | int | ||
pe35AdvancedCount | int | ||
pe35UnevaluatedCount | int | ||
pe68LimitedCount | int | ||
pe68ProficientCount | int | ||
pe68AdvancedCount | int | ||
pe68UnevaluatedCount | int | ||
pe912LimitedCount | int | ||
pe912ProficientCount | int | ||
pe912AdvancedCount | int | ||
pe912UnevaluatedCount | int | ||
comments | varchar(500) | ||
SIS-156876 | DistrictGeneralInformation | districtGeneralInformationID | int |
districtID | int | ||
districtGeneralInformationGUID | uniqueidentifier | ||
schoolYear | int | ||
modifiedByID | int | ||
modifiedDate | datetime2(0) | ||
fallG3ELADate | date | ||
springELADate | date | ||
springMSSDate | date | ||
hardwareProvP | bit | ||
hardwareProvK | bit | ||
hardwareProv1 | bit | ||
hardwareProv2 | bit | ||
hardwareProv3 | bit | ||
hardwareProv4 | bit | ||
hardwareProv5 | bit | ||
hardwareProv6 | bit | ||
hardwareProv7 | bit | ||
hardwareProv8 | bit | ||
hardwareProv9 | bit | ||
hardwareProv10 | bit | ||
hardwareProv11 | bit | ||
hardwareProv12 | bit | ||
hardwareProv23 | bit | ||
spedFundsYes | bit | ||
spedFundsNo | bit | ||
officeSquareFootage | int | ||
eyeExamCountA | int | ||
eyeExamCountB | int | ||
eyeExamCountC | int | ||
kgAge5Day | varchar(15) | ||
homeSchoolCount | int | ||
unservedStudentCount | int | ||
nonSpedStudentCount | int | ||
psTransBeforeAge3ConfCount | int | ||
psTransitionAfterAge3ConfCount | int | ||
comments | varchar(500) | ||
SIS-156876 | DistrictInstructionMode | districtInstructionModeID | int |
districtInstructionModeGUID | uniqueidentifier | ||
districtID | int | ||
startDate | date | ||
endDate | date | ||
instructionMode | varchar(15) | ||
comments | varchar(500) | ||
SIS-156876 | MedicalGroup | medicalGroupID | int |
medicalGroupGUID | uniqueidentifier | ||
districtID | int | ||
dateProcured | date | ||
modifiedByID | int | ||
modifiedDate | datetime2(0) | ||
medication | varchar(15) | ||
medCount | int | ||
comments | varchar(500) |
Modified Tables
Added
Case Number | Table | Column | Data Type |
|---|---|---|---|
SIS-66618 | AdditionalIDHistory | endDate | datetime2(3) |
SIS-66618 | EdFiIDHistory | endDate | datetime2(3) |
SIS-66618 | OtherIDHistory | endDate | datetime2(3) |
SIS-66618 | StaffNumberHistory | endDate | datetime2(3) |
SIS-66618 | StaffStateIDHistory | endDate | datetime2(3) |
SIS-66618 | StateIDHistory | endDate | datetime2(3) |
SIS-66618 | StudentNumberHistory | endDate | datetime2(3) |
SIS-151334 | ActivitySectionRoster | productItemID | int |
SIS-156876 | SchoolInstructionMode | comments | varchar(500) |
SIS-156876 | SchoolInstructionMode | instructionMode | varchar(15) |
SIS-160766 | VaccineExemption | exemptionEndDateRequired | bit |
SIS-160963 | POSPreference | alertContinuous | bit |
SIS-160963 | POSPreference | alertGeneral | bit |
Altered
Case Number | Table | Column | Data Type |
|---|---|---|---|
| SIS-151334 | ActivitySectionRoster | manualAddtion | varchar(20) |
| SIS-156490 | EnrollmentAZ | cteCreditHours | decimal(5,2) |
| SIS-160685 | BehaviorResponse | endTime | datetime2(0) |
| SIS-160685 | BehaviorResponse | startTime | datetime2(0) |
Deprecated
Case Number | Table | Column | Data Type |
|---|---|---|---|
SIS-160963 | POSPreference | allergyPopup | bit |
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-151334 | Set ActivitySectionRoster productItemID | |
SIS-151675 | Added tabsetToolID to existing CustomModule records | |
SIS-151675 | Added otherUser Subright to Existing Custom Contact Logs | |
SIS-151675 | Switched custom module Contact Log apps to new app | |
SIS-153575 | Updated pescLabels for race | |
SIS-156490 | AZ | Created CalculateCTEHours Job |
SIS-159569 | Added Attendance Contact Log core module and convert data | |
SIS-160963 | Updates alertGeneral to old allergyPopup value | |
SIS-165740 | CT | Immunization Rule Update |
SIS-165741 | HI | Immunization Rule Update |
SIS-165996 | Updated Default Value Constraint names | |
SIS-166082 | OR | Updated stategradeLevelDefinition |
SIS-166086 | Fixed Index Fillfactor to be 100 on all indexes | |
SIS-166244 | IL | Immunization Rule Update |
SIS-166289 | MI | Set graduationPlans to inactive in EdFiResourcePreferences |
SIS-166475 | CI | HR Status Code Updates |
SIS-166568 | IN | Converted specialEdSetting |
SIS-166649 | WI | Updated DigitalEquity fields to match new dictionary codes |
