This article collects the changes made to the database schema as part of the Campus.2531 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.
By request, we've added a new column to the New Tables and Modified Tables that indicates whether a field can be null.
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-176756 |
PurchaseProductType |
purchaseProductTypeID |
int |
no |
code |
varchar(30) |
no | ||
SIS-189820 |
AtRiskValue |
atRiskValueID |
int |
no |
atRiskID |
int |
no | ||
attributeID |
int |
no | ||
value |
varchar(256) |
yes | ||
SIS-189882 |
DependentCarePayment |
dependentCarePaymentID |
int |
no |
dependentCareInvoiceID |
int |
no | ||
purchaseProductPaymentID |
int |
no | ||
SIS-189970 |
SAMLConfigGroupMapping |
configID |
int |
no |
groupID |
int |
no |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-190763 |
AuditGroup |
custom |
bit |
no |
SIS-190763 |
AuditGroupMapping |
custom |
bit |
no |
SIS-190763 |
AuditTable |
custom |
bit |
no |
SIS-189866 |
Course |
attendanceRecovery |
bit |
no |
SIS-189866 |
CourseCatalog |
lockAttendanceRecovery |
bit |
no |
SIS-189866 |
CourseMaster |
attendanceRecovery |
bit |
no |
SIS-190241 |
CrisisEvent |
homelessIndicator |
bit |
no |
SIS-190597 |
DependentCareSetting |
enabledPortal |
bit |
no |
SIS-190183 |
Dyslexia |
programStatus |
varchar(15) |
yes |
SIS-190622 |
EnrollmentIN |
goodCauseExemption |
varchar(15) |
yes |
SIS-190179 |
ExtendedLearningOpportunity |
subjectArea |
varchar(15) |
yes |
SIS-187629 |
PaymentTransactionProduct |
disputeID |
int |
yes |
SIS-190497 |
PaymentTransactionProduct |
type |
varchar(20) |
yes |
SIS-176756 |
Purchase |
purchaseReferenceID |
varchar(100) |
no |
SIS-176756 |
PurchaseProduct |
productUuid |
uniqueidentifier |
no |
SIS-176756 |
PurchaseProduct |
productReferenceID |
varchar(100) |
yes |
SIS-176756 |
PurchaseProduct |
purchaseProductTypeID |
int |
yes |
SIS-176756 |
PurchaseProductPayment |
creditRef |
varchar(100) |
yes |
SIS-189970 |
SAMLSPConfig |
configType |
varchar(50) |
yes |
SIS-189866 |
Section |
attendanceRecovery |
bit |
no |
SIS-175687 |
SEPTestAccommodationsCO |
other11 |
bit |
yes |
SIS-175687 |
SEPTestAccommodationsCO |
other11Text |
varchar(50) |
yes |
SIS-175687 |
SEPTestAccommodationsCO |
other12 |
bit |
yes |
SIS-175687 |
SEPTestAccommodationsCO |
other12Text |
varchar(50) |
yes |
SIS-189455 |
SEPTransferRights |
tinyInt2 |
tinyint |
yes |
SIS-187550 |
SpecialEDStateGA |
specialEdStatus |
varchar(15) |
yes |
SIS-188296 |
Survey |
isExternalSurvey |
bit |
no |
SIS-190305 |
TestAccommodations |
reducedDistractions |
bit |
no |
SIS-190305 |
TestAccommodations |
popupGlossEng |
bit |
no |
SIS-190305 |
TestAccommodations |
popupGlossEsp |
bit |
no |
SIS-190305 |
TestAccommodations |
spellCheck |
bit |
no |
SIS-190305 |
TestAccommodations |
textToSpeechPlusGraphics |
bit |
no |
SIS-190305 |
TestAccommodations |
btHearingAids |
bit |
no |
SIS-189970 |
UserAccount |
samlIdentity |
varchar(50) |
yes |
SIS-189970 |
UserAccount |
accountOwner |
varchar(50) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-189452 |
EnrollmentME |
residentTownNumber |
varchar(15) |
yes |
SIS-178375 |
HealthConditionList |
description |
varchar(250) |
yes |
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-174001 |
KS |
Added NCES Grade to 3AR and 4AR |
SIS-176756 |
Populated Purchase Product Types | |
SIS-178375 |
ICD11 Health Conditions | |
SIS-184932 |
WI |
Immunization Rule Update |
SIS-185047 |
Populated default values for attribute | |
SIS-187543 |
NJ |
Special Ed Enrollment conversion to State Reporting Tab issues |
SIS-187550 |
GA |
Migrated SpecialEDState rights to SpecialEDState |
SIS-188606 |
NY |
Immunization Rule Update |
SIS-188620 |
AZ |
Immunization Rule Update |
SIS-188713 |
OK |
Immunization Rule Update |
SIS-188727 |
NC |
Added Feature Toggle Preference for Dropout Extract |
SIS-188963 |
Added Alternative Education program to Data Change Tracker to DCT | |
SIS-188964 |
ND |
Added DistrictResidency to DIS |
SIS-189218 |
SD |
New and updated districts |
SIS-189228 |
MD |
Immunization Rule Update |
SIS-189452 |
Converted residentTownNumber codes to new 5-digit values | |
SIS-189970 |
Added quartz job to disable helper account daily | |
SIS-190176 |
SD |
RX SPED Conversion - Clear Converted Data |
SIS-190218 |
OR |
Script to insert Program Type 01 for Cumulative ADM report |
SIS-190364 |
SD |
Configured DIS for SpecialEdState |
SIS-190376 |
Deleted CTEProgramReportingPeriodAttendance Identity Mappings Due to objectKey Update | |
SIS-190380 |
DE |
Enabled Identity Management |
SIS-190456 |
CA |
Immunization Rule Update |
SIS-190538 |
Removed Lift Up research artifacts | |
SIS-190763 |
Added back missing DCT configurations for new districts | |
SIS-190862 |
DE |
Enabled Identity Management pilot |
