This article collects the changes made to the database schema as part of the Campus.2535 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-189715 |
Title1PartD |
title1PartDID |
int |
no |
personID |
int |
no | ||
districtID |
int |
no | ||
modifiedByID |
int |
yes | ||
modifiedDate |
datetime2(0) |
yes | ||
title1PartDGUID |
uniqueidentifier |
no | ||
startDate |
date |
yes | ||
endDate |
date |
yes | ||
comments |
varchar(255) |
yes | ||
createdDate |
datetime2(0) |
no | ||
SIS-190484 |
EnrollmentND |
enrollmentID |
int |
no |
personID |
int |
no | ||
calendarID |
int |
no | ||
daysPresent |
decimal(6,2) |
yes | ||
SIS-191165 |
Title1PartA |
title1PartAID |
int |
no |
personID |
int |
no | ||
districtID |
int |
no | ||
title1PartAGUID |
uniqueidentifier |
no | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
createdDate |
date |
no | ||
modifiedByID |
int |
yes | ||
modifiedDate |
date |
yes | ||
comments |
varchar(255) |
yes | ||
SIS-191165 |
Title3 |
title3ID |
int |
no |
personID |
int |
no | ||
districtID |
int |
no | ||
title3GUID |
uniqueidentifier |
no | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
createdByID |
int |
yes | ||
createdDate |
date |
no | ||
modifiedByID |
int |
yes | ||
modifiedDate |
date |
yes | ||
comments |
varchar(255) |
yes | ||
SIS-191314 |
Title6 |
title6ID |
int |
no |
personID |
int |
no | ||
districtID |
int |
no | ||
modifiedByID |
int |
yes | ||
modifiedDate |
datetime2(0) |
yes | ||
title6GUID |
uniqueidentifier |
no | ||
startDate |
date |
yes | ||
endDate |
date |
yes | ||
comments |
varchar(255) |
yes | ||
createdDate |
datetime2(0) |
no |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-190254 |
CourseCode |
lastPublishedDistrictIDs |
varchar(8000) |
yes |
SIS-190053 |
DataCertificationObjectMember |
schoolID |
int |
yes |
SIS-190053 |
DataCertificationSchoolAssignment |
certificationStatus |
varchar(15) |
yes |
SIS-190053 |
DataCertificationSchoolAssignment |
currentSnapshotID |
int |
yes |
SIS-190053 |
DataCertificationSchoolAssignment |
snapshotExists |
bit |
no |
SIS-190053 |
DataCertificationSchoolAssignment |
endDateOverride |
date |
yes |
SIS-190053 |
DataCertificationSchoolAssignment |
effectiveDateOverride |
date |
yes |
SIS-190053 |
DataCertificationSchoolAssignment |
modifiedById |
int |
yes |
SIS-190053 |
DataCertificationSchoolAssignment |
modifiedTimestamp |
datetime2(0) |
yes |
SIS-190053 |
DataCertificationType |
certificationLevel |
varchar(15) |
no |
SIS-190053 |
DataCertificationTypeMember |
schoolID |
int |
yes |
SIS-185409 |
DataExtractUtility |
ftpsMode |
varchar(10) |
yes |
SIS-178021 |
DigitalLearningVendor |
vendorStatus |
varchar(20) |
yes |
SIS-190979 |
DistrictResidency |
servingAddress |
varchar(100) |
yes |
SIS-190979 |
DistrictResidency |
residentSchool |
varchar(15) |
yes |
SIS-190979 |
DistrictResidency |
program |
varchar(15) |
yes |
SIS-190979 |
DistrictResidency |
spedAddress |
varchar(100) |
yes |
SIS-190979 |
DistrictResidency |
spedSchool |
varchar(15) |
yes |
SIS-189401 |
EnrollmentKY |
virtualProgram |
varchar(15) |
yes |
SIS-186600 |
HealthScreeningTuberculosis |
tbRiskAssessmentDate |
date |
yes |
SIS-186600 |
HealthScreeningTuberculosis |
tbRiskAssessmentResults |
varchar(15) |
yes |
SIS-190208 |
IMResponse |
submittedByID |
int |
yes |
SIS-181415 |
LEAStatsGA |
name |
varchar(50) |
yes |
SIS-181415 |
LEAStatsGA |
entityID |
varchar(12) |
yes |
SIS-188540 |
OAuth2OutboundClient |
solution |
varchar(255) |
yes |
SIS-188540 |
OAuth2OutboundClient |
environment |
varchar(255) |
yes |
SIS-188435 |
PaymentMethodReference |
varchar(254) |
yes | |
SIS-190341 |
PaymentVendorAccount |
inactiveTimeStamp |
datetime2(4) |
yes |
SIS-191557 |
PurchaseProduct |
recipientID |
int |
yes |
SIS-189326 |
SpecialEDState |
providerName |
varchar(255) |
yes |
SIS-189326 |
SpecialEDState |
providerID |
varchar(15) |
yes |
SIS-189326 |
SpecialEDState |
providerCity |
varchar(255) |
yes |
SIS-189326 |
SpecialEDState |
providerState |
varchar(2) |
yes |
SIS-189326 |
SpecialEDState |
providerType |
varchar(15) |
yes |
SIS-190288 |
TransportationStudentDetail |
transportationStudentDetailGUID |
uniqueidentifier |
no |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-190053 |
DataCertificationObject |
startDate |
smalldatetime |
yes |
SIS-185499 |
Identity |
languageAlt2 |
varchar(40) |
yes |
SIS-190288 |
TransportationStudentDetail |
createdByID |
int |
yes |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-190053 |
DataCertificationLink |
filterID |
SIS-190053 |
DataCertificationObject |
startDate |
SIS-185409 |
DataExtractUtility |
ftpsAuth |
Deleted Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-191212 |
CampusVersion |
standardEnabled |
SIS-190053 |
DataCertificationDistrictAssignment |
startDateOverride |
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-178316 |
NC |
Added Retention Promotion feature toggle |
SIS-184803 |
OK |
Converted RaceSubcategory values to new codes |
SIS-185409 |
Set FTPS mode from auth | |
SIS-185499 |
CustomLanguage replacement migration | |
SIS-185499 |
Migrated customLanguage to identity table | |
SIS-188293 |
OH |
Immunization Rule Update |
SIS-188540 |
Added Columns to OAuth2OutboundClient | |
SIS-188540 |
OK |
Language Dictionary update |
SIS-188807 |
NC |
Deleted state owned AIG validations |
SIS-189042 |
MO |
Added value to District |
SIS-189660 |
MT |
Homeless Program Enhancements |
SIS-189660 |
MT |
Added homeless |
SIS-189715 |
NV |
Data Conversion for Type, Pass Status, and Program Status to NV CareerReadiness.status |
SIS-190013 |
NY |
Immunization Rule Update |
SIS-190116 |
WY |
Hhomeschool data conversions |
SIS-190131 |
NC |
PMR added validation |
SIS-190254 |
Populated lastPublishedDistrictIDs on CourseCode | |
SIS-190254 |
Added job and trigger for CourseManagementPublishNotification | |
SIS-190288 |
TransportationStudentDetail DIS Object | |
SIS-190391 |
IA |
Immunization Rule Update-2 |
SIS-190391 |
IA |
Immunization Rule Update |
SIS-190477 |
MO |
Immunization Rule Update |
SIS-190484 |
ND |
Added EnrollmentND db table |
SIS-190491 |
GA |
BOI |
SIS-190565 |
DE |
Added State defined Plan service types |
SIS-190581 |
Preference for POS Messaging OAuth2 and expiration date | |
SIS-190596 |
Converted Cohort EdFi Identity Mappings to new object key | |
SIS-190629 |
Disabled AIR | |
SIS-190720 |
DE |
Converted Course.cipCode |
SIS-190903 |
NY |
Immunization Rule Update |
SIS-190909 |
NC |
Added missing PSU schools |
SIS-190915 |
NC |
Updated Course dictionary |
SIS-191002 |
ND |
Localization of 21st CCLC Program v2 |
SIS-191059 |
NC |
Retention Promotion remove feature toggle |
SIS-191105 |
NC, |
Enabled DCT default tables |
SIS-191273 |
ID |
Updated District List |
SIS-191322 |
MN |
Removed Direct Admissions Surveys |
SIS-191557 |
Changed name of Activity product type | |
SIS-191557 |
Inserted preference for All Payments Export minimum date |
