This article collects the changes made to the database schema as part of the Campus.2611 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-193900 | OneRosterDynamicSeqEnrollment | critID | int | no |
seq | int | no | ||
dataID | int | no | ||
isStudent | bit | no | ||
personID | int | no | ||
sectionID | int | no | ||
schoolID | int | no | ||
SIS-193900 | OneRosterDynamicSeqEnrollmentSchool | critID | int | no |
schoolID | int | no | ||
seq | int | no | ||
dataID | int | no | ||
isStudent | bit | no | ||
personID | int | no | ||
sectionID | int | no | ||
SIS-196325 | IMRubricItemDescriptionLibrary | rubricItemDescriptionLibraryID | int | no |
objectLibraryID | int | no | ||
rubricItemDescriptionID | int | no | ||
weight | decimal(6,3) | yes | ||
itemID | int | yes | ||
markID | int | yes | ||
SIS-196325 | IMRubricItemLibrary | rubricItemLibraryID | int | no |
objectLibraryID | int | no | ||
rubricItemID | int | no | ||
taskID | int | yes | ||
scoreGroupID | int | yes | ||
markGroupID | int | yes | ||
value | decimal(6,3) | yes | ||
autoCalculate | bit | no |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-193053 | ActivitySectionRosterPendingPayment | currentSaleID | int | yes |
SIS-195233 | AtRiskValue | atRiskValueGUID | uniqueidentifier | no |
SIS-196988 | GraduationSeal | postSecondaryCredits | varchar(15) | yes |
SIS-192131 | LTILink | placement | varchar(80) | yes |
SIS-191948 | MigrantEnrollment | certificateOfEligibilityID | varchar(25) | yes |
SIS-191948 | MigrantEnrollment | h2aIndicator | bit | no |
SIS-191948 | MigrantEnrollment | immunizationRecordIndicator | bit | no |
SIS-191948 | MigrantEnrollment | multilingualLearnerIndicator | bit | no |
SIS-191948 | MigrantEnrollment | pkHours | int | yes |
SIS-191948 | MigrantEnrollment | terminationDate | date | yes |
SIS-197068 | NCSnapshotLCSPET | sectionNumber | smallint | yes |
SIS-197068 | NCSnapshotLCSPET | additionalStaffIDs | varchar(300) | yes |
SIS-195688 | PlanGuardian | priLanguageCode | varchar(15) | yes |
SIS-196893 | PregnantAndParenting | otherStatus | varchar(15) | yes |
SIS-188318 | ProgramPublishHistory | publishedByID | int | yes |
SIS-193053 | PurchaseProductPayment | transactionType | varchar(50) | no |
SIS-193053 | PurchaseProductPayment | paymentMethodType | varchar(50) | no |
SIS-197092 | RecordsTransfer | programOptOutXML | varchar(max) | yes |
SIS-197092 | RecordsTransfer | programOptOutFOP | varchar(100) | yes |
SIS-196804 | RecordsTransfer | progressReportXML | varchar(max) | yes |
SIS-196804 | RecordsTransfer | progressReportDataXML | varchar(max) | yes |
SIS-196804 | RecordsTransfer | progressReportFOP | varchar(100) | yes |
SIS-196351 | SCEDConcentrator | startYear | smallint | yes |
SIS-174391 | Trial | programParticipationWeight | tinyint | no |
SIS-174391 | Trial | programParticipationOption | varchar(20) | yes |
Altered Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-193053 | ActivitySectionRoster | paid | varchar(15) | no |
SIS-196004 | Evaluation | specifyOther1 | varchar(200) | yes |
SIS-196325 | IMLearningObjectLibrary | shared | bit | yes |
SIS-194482 | NCSnapshotLCSCS | staffUID | varchar(20) | yes |
SIS-194482 | NCSnapshotLCSPET | staffUID | varchar(20) | yes |
SIS-193053 | PurchaseProductPayment | paymentType | varchar(50) | yes |
Deprecated Columns
Ordered by Table Name.
Case Number | ||
|---|---|---|
SIS-196325 | IMLearningObjectLibrary | shared |
SIS-188314 | Program | schoolID |
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-188314 |
| Migrated Program.schoolID column to ProgramSchool records |
SIS-191948 | NC | Renamed MigrantService attribute name |
SIS-191948 | NC | Made MEP Enrollment custom tool read only |
SIS-191948 | NC | Converted old Migrant data to new workflow |
SIS-192413 | MA | Added SIFSentRecordHistory cleanup job |
SIS-193053 |
| Added School Store Notification Type |
SIS-193900 |
| Dynamic Index Criteria Templates for Enrollments |
SIS-195233 | NC | RtA data conversion |
SIS-195449 |
| Created EdFiAuditLogCleanup Job |
SIS-195451 |
| Added Special Education to CDR Preferences |
SIS-195567 | VA | Converted Endorsements and Responsible Division |
SIS-196259 | SD | Reverted adding GradutationSeal campus attribute |
SIS-196325 |
| Deleted Unshared Library Curriculum |
SIS-196461 | NJ | Immunization Rule Update |
SIS-196515 |
| Updated UNC Minimum for TranscriptCourses in multiple past school years |
SIS-196515 |
| Updated UNC Minimum for TranscriptCourses in 25-26 school year |
SIS-196515 |
| Updated UNC Minimum for TranscriptCourses in 24-25 school year |
SIS-196515 |
| Updated UNC Minimum for CourseMasters and Courses in 25-26 school year |
SIS-196515 |
| UNC Minimum revert for current and future years |
SIS-196680 | NY | Immunization Rule Update |
SIS-196692 | NY | Updated district name |
SIS-196893 |
| Added column to PregnantAndParenting |
SIS-196964 | NC | Updated enrollment end status in NC |
SIS-197143 | DE | Converted Custom Military Data |
SIS-197248 | MO | Added new Attending District |
SIS-197291 | MT | Added new District |
SIS-197501 | DE | Fixed Convert Custom Military Data |
SIS-197554 | ND | Updated District List |
SIS-197686 | ND | Updated State Grade Levels Dictionary |
