This article collects the changes made to the database schema as part of the Campus.2343 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-171856 | CalculatedAbsenteeValues | personID | int |
calendarID | int | ||
scheduledDays | int | ||
daysAbsent | int | ||
absenteeismPercentage | decimal(5,2) | ||
endYear | int |
Modified Tables
Added
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-150612 | OLPSettings | splitProcessingFees | BIT |
SIS-150612 | PaymentTransaction | feesSplit | BIT |
SIS-150612 | PaymentTransactionProduct | processingFeeType | VARCHAR(20) |
SIS-150612 | PaymentTransactionProduct | splitFeeSourceProductID | INT |
SIS-170803 | Calendar | crossSiteEnrollmentOpen | BIT |
SIS-170803 | Section | crossSiteInstructionalSetting | VARCHAR(15) |
SIS-171959 | BehaviorResponse | responseUnknownTimes | BIT |
SIS-172605 | DigitalLearningVendorOAuth2ClientCredentials | omitUserLegalName | BIT |
SIS-172942 | EnrollmentGA | enrollmentLocCalc5 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | inclusionCalc5 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | fteProgramCalc2 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | fteProgramCalc1 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | enrollmentLocCalc4 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | enrollmentLocCalc1 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | enrollmentLocCalc2 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | inclusionCalc3 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | fteProgramCalc3 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | inclusionCalc6 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | enrollmentLocCalc6 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | fteProgramCalc6 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | inclusionCalc2 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | fteProgramCalc4 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | fteProgramCalc5 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | inclusionCalc4 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | enrollmentLocCalc3 | VARCHAR(15) |
SIS-172942 | EnrollmentGA | inclusionCalc1 | VARCHAR(15) |
SIS-172944 | Gifted | giftedReferral | VARCHAR(15) |
SIS-172995 | Lunch | startTime | TIME |
SIS-172995 | Lunch | endTime | TIME |
SIS-173340 | SSRSDistrictReport | enableDebug | BIT |
SIS-173561 | Enrollment | crossSiteEnrollment | BIT |
Modified
Case Number | Table | Column | DataType |
|---|---|---|---|
SIS-169241 | TeamMember | role | VARCHAR(25) |
SIS-171959 | BehaviorResponse | duration | INT |
SIS-171959 | BehaviorResponse | startTime | DATETIME2(0) |
SIS-172867 | SSRSDistrictReport | reportInstructions | VARCHAR(8000) |
SIS-173049 | DISQueuedMessage | packetNumber | INT |
Deprecated
Case Number | Table | Column |
|---|---|---|
SIS-166875 | EdFiIdentityMapping | edFiTransactionID |
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-167446 | AZ | Maricopa County add HepA |
SIS-167446 | AZ | Immunization Rule Update |
SIS-167633 | TX | Removed unused resources for EdFi |
SIS-168996 | OH | End date opv Immunization Rule Update |
SIS-168996 | OK | Immunization Rule Update |
SIS-168996 | NY | Immunization Rule Update |
SIS-168996 | OH | Immunization Rule Update |
SIS-171475 | OH | accelerationWriting conversion |
SIS-171660 | IN | Data conversion Roster to SSD |
SIS-171818 | Replacing preferenceID with elements as the Clustered Index on CloudPreference | |
SIS-171856 | Onetime Quartz job to populate CalculatedAbsenteeValues | |
SIS-171856 | Populated previous year CalculatedAbsenteeValues | |
SIS-171919 | IA | District List Update |
SIS-172125 | MO | Immunization Rule Update |
SIS-172244 | OH | Immunization Rule Update 2 |
SIS-172244 | OH | Immunization Rule Update |
SIS-172867 | Changed Instruction Text Box to WYSIWYG on SSRS Report Configuration | |
SIS-172915 | KY | Removed dbo.KYAttDailySummary from DCT |
SIS-172944 | GA | Moved gifted related from the enrollment tab to the gifted tab |
SIS-172985 | ID | District List Update |
SIS-172986 | Cleaned CampusEventLog records | |
SIS-173328 | IA | Resident District Fix |
