This article collects the changes made to the database schema as part of the Campus.2251 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-156711 | MobilePaymentsDevice | deviceID | int |
| clientCredentialsID | int | ||
| authorizationCodeID | int | ||
| deviceName | varchar(50) | ||
| deviceInternalID | varchar(100) | ||
| osType | varchar(16) | ||
| manufacturer | varchar(40) | ||
| model | varchar(40) | ||
| pending | bit | ||
| active | bit | ||
| deleted | bit | ||
| lastRequestTimeStamp | datetime2 | ||
| createdTimeStamp | datetime2 | ||
SIS-156711 | MobilePaymentsSchoolMap | mapID | int |
| deviceID | int | ||
| schoolID | int | ||
SIS-156711 | SchoolStoreEvent | eventID | int |
| name | varchar(50) | ||
| schoolID | int | ||
| startDate | datetime2 | ||
| endDate | datetime2 | ||
| description | varchar(500) | ||
| pending | bit | ||
SIS-156711 | SchoolStoreEventItem | eventItemID | int |
| productItemID | int | ||
| eventProductListingID | int | ||
| seq | int | ||
SIS-156711 | SchoolStoreEventProductListing | eventProductListingID | int |
| eventID | int | ||
| productCategorySchoolListingID | int | ||
| seq | int | ||
SIS-156711 | SchoolStoreEventSalesCategory | eventCategoryID | int |
| pinID | int | ||
| productCategorySchoolID | int | ||
SIS-156711 | SchoolStoreEventSalesPIN | pinID | int |
| pin | varchar(6) | ||
| eventID | int | ||
SIS-165753 | SSRSDistrictReport | reportID | int |
| ssrsConfigurationID | int | ||
| reportName | varchar(50) | ||
| indexName | varchar(50) | ||
| reportInstructions | varchar(250) | ||
| ssrsReportName | varchar(100) | ||
| toolID | int |
Modified Tables
Recent changes to the search framework in Campus have resulted in several tables being removed from MS SQL Change Tracking. See this article for more information.
Added
Case Number | Table | Column | Data Type |
| SIS-152720 | DataExtractUtility | freqDayOfMonth | int |
SIS-154263 | EvalChecklist | checklistHeaderName | varchar(200) |
SIS-154263 | EvalChecklistParticipant | lastName | varchar(50) |
SIS-154263 | EvalChecklistParticipant | firstName | varchar(50) |
SIS-154263 | EvalChecklistParticipant | teamID | int |
SIS-154263 | PlanGuardian | languageStr | varchar(100) |
SIS-154263 | PlanStudent | homePrimaryLanguageStr | varchar(100) |
SIS-154263 | SEEBrailleNeeds | varChar1 | varchar(8000) |
SIS-154263 | SEETeamMeeting | varchar12 | varchar(8000) |
SIS-154263 | SEETeamMeeting | varchar11 | varchar(8000) |
SIS-154263 | SEETeamMeeting | varchar9 | varchar(8000) |
SIS-154263 | SEETeamMeeting | varchar10 | varchar(8000) |
SIS-156711 | PaymentMethodReference | anonymous | bit |
| SIS-156711 | PaymentTransaction | deviceID | int |
| SIS-156711 | PaymentTransaction | eventName | varchar(50) |
SIS-156711 | Product | mobilePayments | bit |
SIS-156711 | ProductCategory | mobilePayments | bit |
SIS-156711 | ProductItem | requireStudentNumber | varchar(7) |
| SIS-156711 | ProductSale | paymentMethodReferenceID | int |
SIS-158591 | EnrollmentNJ | receivingCounty | varchar(2) |
SIS-158591 | EnrollmentNJ | receivingDistrict | varchar(4) |
SIS-158591 | EnrollmentNJ | receivingSchool | varchar(10) |
SIS-158628 | Calendar | ignoreCourseMasterPush | bit |
SIS-158628 | Course | virtualInstruction | varchar(15) |
| SIS-158628 | Course | ignoreCourseMasterPush | bit |
SIS-158628 | GradingTaskCreditMaster | edfiExclude | bit |
SIS-163675 | BehaviorResolution | hoursOverride | int |
SIS-165451 | CourseCatalog | lockVirtualInstruction | bit |
SIS-165451 | CourseMaster | virtualInstruction | varchar(15) |
SIS-165451 | Section | virtualInstruction | varchar(15) |
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-123187 | Set default classRankInclude status | |
SIS-156711 | Mobile Payment New Vendor IDs | |
SIS-158591 | NJ | Converted receivingDistrict receivingCounty andReceivingSchool from Custom Student to EnrollmentNJ |
SIS-158628 | DISCON Fixed Duplicate LessonPlanGroupCourseIDs | |
SIS-158628 | DISCON Quartz Job to Batch Queue | |
SIS-158753 | NY | Immunization Rule Update |
SIS-159262 | WI | Immunization Rule Update |
SIS-159355 | KS | Immunization Rule Update |
SIS-159531 | NV | Requested to Update to SCED Version 9 |
SIS-159598 | Turned off LocatorEnhancedSearch | |
SIS-159598 | Added UserSQLSearch preference | |
SIS-159598 | Turned off ES indices and change tracking | |
SIS-159707 | MN | Updated EdFiMappings for MN scedCourseLevel |
SIS-160289 | PA | Data conversion for EnrollmentPA bidAUN, bidSchoolNumber, pasaTestingAUN |
SIS-160289 | PA | Populated PA Enrollment bidSchoolNumber dictionary |
SIS-160289 | PA | EnrollmentPA data conversion for bidAUN, bidSchoolNumber, pasaTestingAUN |
SIS-160392 | NM | Program Fact Not Reporting T3 |
SIS-160606 | TX | Turned on core EdFi for TX |
SIS-160762 | MI | Converted roles for P and T staff types |
SIS-160860 | WI | Immunization Rule Update |
SIS-165451 | MO | Converted provider to VirtualInstruction |
SIS-165508 | Fix for Being Unable to Delete Record That Has No Dependencies | |
SIS-165537 | KY | Updated Form Document PSP for English Learners |
