This article collects the changes made to the database schema as part of the Campus.2403 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 | DataType |
|---|---|---|---|
SIS-166566 | ActivitySectionRosterProductSale | activitySectionRosterProductSaleID | int |
personID | int | ||
activitySectionID | int | ||
productSaleID | int | ||
SIS-166566 | Purchase | purchaseID | int |
amount | decimal(12,2) | ||
purchaseSource | varchar(30) | ||
purchaseTimestamp | datetime2(0) | ||
purchaseProcessorPersonID | int | ||
purchasePayerPersonID | int | ||
SIS-166566 | PurchaseFee | purchaseFeeID | int |
purchaseID | int | ||
purchaseProductID | int | ||
paymentTransactionProductID | int | ||
price | decimal(12,2) | ||
name | varchar(100) | ||
fundAccountID | int | ||
refund | bit | ||
feeType | varchar(15) | ||
SIS-166566 | PurchaseProduct | purchaseProductID | int |
purchaseID | int | ||
description | varchar(100) | ||
price | decimal(12,2) | ||
SIS-166566 | PurchaseProductPayment | purchaseProductPaymentID | int |
purchaseProductID | int | ||
paymentType | varchar(16) | ||
checkNumber | varchar(15) | ||
amount | decimal(12,2) | ||
fundAccountID | int | ||
refund | bit | ||
paymentPersonID | int | ||
paymentTimestamp | datetime2(0) | ||
paymentTransactionProductID | int |
Modified Tables
Added
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-166566 | ProductSale | priceAtCheckout | decimal(12,2) |
SIS-166566 | ProductSale | overridePersonID | int |
SIS-166566 | ProductSale | purchaseProductID | int |
SIS-166566 | ProductSale | overrideComment | varchar(500) |
SIS-166566 | ProductSale | override | bit |
SIS-170020, SIS-170921 | EvalGuardian | legalGuardian | tinyint |
SIS-170106 | FreeReducedPreference | defaultSignature | varchar(250) |
SIS-174641 | Attendance | crossSiteTransfer | bit |
Altered
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-170020 | EvalGuardian | languageAlt | varchar(50) |
SIS-175119 | EnrollmentKS | mathAssessmentType | varchar(15) |
SIS-175119 | EnrollmentKS | readingAssessmentType | 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-175119 | KS | Expanded Enrollment Math and Reading Assessment Fields |
SIS-171558 | OH | Updated district list useage |
SIS-166566 | Converted ProductSale Purchase Payments v2 | |
SIS-173733 | KS | Immunization Rule Update |
SIS-166566 | Converted ProductSale Purchase Payments | |
SIS-171848 | NV | Deleted from SCEDConcentrator table |
SIS-174091 | DE | Immunization Rule Update 2 |
SIS-174290 | NE | Immunization Rule Update |
SIS-173591 | CA | Updated Hawthorne district name |
SIS-174228 | OR | Program Type initialize default value |
SIS-174866 | IL | Race ethnicity update |
SIS-175046 | Disabled OneRoster performance feature | |
SIS-174379 | NV | Made virtual attribute stateOwned |
SIS-174437 | TX | Added codes to CourseCodes |
SIS-174756 | Removed search framework view-procedures | |
SIS-174472 | MO | District list update |
SIS-174091 | DE | Immunization Rule Update |
SIS-174948 | Updated MessengerTemplate Staff Filter Type Param | |
SIS-174721 | GA | Updated SectionStudentDetail workBasedLearning name |
SIS-174385 | addPCV exemption to PPV exemptions | |
SIS-171925 | WY | Converted College Credit from RBE to SSD |
SIS-170106 | Added default signature column for FRAM Letters |
