This article collects the changes made to the database schema as part of the Campus.2635 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-189319 | PaymentsCartItemTransactionProduct | paymentsCartItemID | int | no |
paymentTransactionProductID | int | no | ||
SIS-201083 | PortalDisplayDefinition | portalDisplayDefinitionID | int | no |
registeredComponentID | int | yes | ||
optionName | varchar(200) | no | ||
displayName | varchar(200) | yes | ||
allowStudent | bit | no | ||
allowParent | bit | no | ||
url | varchar(500) | yes | ||
active | bit | no | ||
SIS-201083 | PortalDisplayDefinitionOption | portalDisplayDefinitionOptionID | int | no |
portalDisplayTemplateID | int | no | ||
portalDisplayDefinitionID | int | no | ||
type | varchar(10) | no | ||
enabled | bit | no | ||
modifiedDate | datetime2(0) | yes | ||
modifiedByID | int | yes |
Deprecated Tables
Case Number | Table |
|---|---|
SIS-200381 | OAuthGatewayRegistration |
SIS-200114 | WICATE |
Deleted Tables
Case Number | Table |
|---|---|
SIS-195715 | DependentCareSessionMemberCreditAdjustment |
Modified Tables
Added Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-197510 |
Enrollment |
entryReason |
varchar(15) |
yes |
|
SIS-197510 |
Enrollment |
withdrawalReason |
varchar(15) |
yes |
|
SIS-197510 |
EnrollmentHistory |
entryReason |
varchar(15) |
yes |
|
SIS-197510 |
EnrollmentHistory |
withdrawalReason |
varchar(15) |
yes |
|
SIS-199367 |
EnrollmentTX |
exitEnrollmentVerification |
varchar(15) |
yes |
|
SIS-200865 |
FERPA |
nonDirectoryQuestion |
varchar(15) |
yes |
|
SIS-198536 |
GraduationSeal |
proficiencyLevel |
varchar(15) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
percentOnSite |
decimal(6,2) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
percentOffsite |
decimal(6,2) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
percentRemote |
decimal(6,2) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
schoolName |
varchar(255) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
schoolNumber |
varchar(255) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
submitted |
bit |
no |
|
SIS-196720 |
NCSnapshotPMRSummary |
totalInstructionalDays |
int |
yes |
|
SIS-189319 |
PaymentsCart |
completed |
bit |
no |
|
SIS-198536 |
Program |
proficiencyLevel |
varchar(15) |
yes |
|
SIS-201343 |
RegisteredComponent |
builderKey |
varchar(45) |
no |
|
SIS-201343 |
RegisteredComponent |
active |
bit |
no |
|
SIS-192302 |
Title1PartA |
schoolNumber |
varchar(15) |
yes |
|
SIS-192302 |
Title1PartD |
delinquent |
varchar(15) |
yes |
|
SIS-192302 |
Title1PartD |
neglected |
bit |
no |
|
SIS-199931 |
Title3 |
programEligibilityDate |
date |
yes |
|
SIS-199931 |
Title3 |
projectedExitDate |
date |
yes |
|
SIS-199831 |
Title6 |
form506Indicator |
varchar(15) |
yes |
|
SIS-199831 |
Title6 |
applicationReceived |
varchar(15) |
yes |
|
SIS-199831 |
Title6 |
canadianNative |
varchar(15) |
yes |
|
SIS-199831 |
Title6 |
formCompliant |
varchar(15) |
yes |
|
SIS-199831 |
Title6 |
indianBirthCertificate |
varchar(15) |
yes |
|
SIS-199831 |
Title6 |
individualTribalMembership |
varchar(50) |
yes |
|
SIS-199831 |
Title6 |
mailingOptOut |
varchar(15) |
yes |
|
SIS-199831 |
Title6 |
otherTribalNames |
varchar(50) |
yes |
|
SIS-199831 |
Title6 |
tribalEnrollmentNumber |
varchar(50) |
yes |
Altered Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-194465 |
Course |
active |
bit |
no |
|
SIS-194465 |
Course |
homeroom |
bit |
no |
|
SIS-194465 |
Course |
transcript |
bit |
no |
|
SIS-194465 |
Course |
requestable |
bit |
no |
|
SIS-194465 |
Course |
required |
bit |
no |
|
SIS-194465 |
Course |
attendance |
bit |
no |
|
SIS-194465 |
Course |
unitAttendance |
bit |
no |
|
SIS-194465 |
Course |
bonusPointsAvail |
bit |
no |
|
SIS-194465 |
Course |
allowTeacherRequests |
bit |
no |
|
SIS-194465 |
Course |
standardsBased |
bit |
no |
|
SIS-194465 |
Course |
acceleratedCourse |
bit |
no |
|
SIS-194465 |
Course |
substituteCredit |
bit |
no |
|
SIS-194465 |
Course |
noAutobuild |
bit |
no |
|
SIS-194465 |
Course |
charterNonCoreCollegePrep |
bit |
no |
|
SIS-194465 |
Course |
middleSchoolCoreCourseInd |
bit |
no |
|
SIS-194465 |
Course |
highQualityCTEInd |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockNumber |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockName |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockStateCode |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockDescription |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockGrading |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockClassification |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockNCESData |
bit |
no |
|
SIS-194465 |
CourseCatalog |
lockHighQualityCTEInd |
bit |
no |
|
SIS-194465 |
CourseMaster |
active |
bit |
no |
|
SIS-194465 |
CourseMaster |
transcript |
bit |
no |
|
SIS-194465 |
CourseMaster |
lockNumber |
bit |
no |
|
SIS-194465 |
CourseMaster |
lockName |
bit |
no |
|
SIS-194465 |
CourseMaster |
lockStateCode |
bit |
no |
|
SIS-194465 |
CourseMaster |
lockDescription |
bit |
no |
|
SIS-194465 |
CourseMaster |
homeroom |
bit |
no |
|
SIS-194465 |
CourseMaster |
requestable |
bit |
no |
|
SIS-194465 |
CourseMaster |
required |
bit |
no |
|
SIS-194465 |
CourseMaster |
attendance |
bit |
no |
|
SIS-194465 |
CourseMaster |
unitAttendance |
bit |
no |
|
SIS-194465 |
CourseMaster |
bonusPointsAvail |
bit |
no |
|
SIS-194465 |
CourseMaster |
allowTeacherRequests |
bit |
no |
|
SIS-194465 |
CourseMaster |
standardsBased |
bit |
no |
|
SIS-194465 |
CourseMaster |
lock |
bit |
no |
|
SIS-194465 |
CourseMaster |
acceleratedCourse |
bit |
no |
|
SIS-194465 |
CourseMaster |
substituteCredit |
bit |
no |
|
SIS-194465 |
CourseMaster |
noAutobuild |
bit |
no |
|
SIS-194465 |
CourseMaster |
charterNonCoreCollegePrep |
bit |
no |
|
SIS-194465 |
CourseMaster |
middleSchoolCoreCourseInd |
bit |
no |
|
SIS-194465 |
CourseMaster |
highQualityCTEInd |
bit |
no |
|
SIS-196005 |
DependentCareSession |
invoiceInformation |
varchar(1000) |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
presentOnSite |
int |
yes |
|
SIS-196720 |
NCSnapshotPMRSummary |
presentOffSite |
int |
yes |
|
SIS-201343 |
NotificationType |
name |
varchar(255) |
no |
|
SIS-201083 |
RegisteredComponent |
code |
varchar(45) |
no |
Renamed Columns
|
Case Number |
Table |
Column |
New Column Name |
|---|---|---|---|
|
SIS-196720 |
NCSnapshotPMRSummary |
daysAbsent1R |
daysRemote |
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-187220 |
MO |
Created Gifted Records for all giftedTalented Enrollments |
|
SIS-189319 |
|
Set PaymentsCart completed for existing transactions |
|
SIS-190919 |
|
SIF Turned on quartz job to clear SIFSentRecord |
|
SIS-196720 |
|
Converted old PMR Summary Records |
|
SIS-199319 |
NY |
Immunization Rule Update |
|
SIS-199544 |
|
Updated CourseMaster and 26-27 Course CTE Program Cluster |
|
SIS-199764 |
|
Merged rows in stateIDHistory and edfiIDHistory tables |
|
SIS-199764 |
|
Merged rows in stateIDHistory table |
|
SIS-200056 |
|
Added Batch Fields and Subreports Messenger Preferences |
|
SIS-200448 |
ID |
Updated Districts |
|
SIS-200454 |
|
Added constraint to SchoolYear table for unique endYear |
|
SIS-200563 |
ND |
Immunization Rule Update |
|
SIS-200626 |
|
Enabled Account Linking Phase 5 |
|
SIS-200669 |
|
Removed ViewGender tool right from UserGroups where it is the only toolright |
|
SIS-200765 |
|
Converted formcleanup rights into in progress rights |
|
SIS-200836 |
DE |
BehaviorType updates |
|
SIS-200866 |
|
Fixed credit group reportCard indicators |
|
SIS-200977 |
AZ |
Added district to districtList |
|
SIS-201265 |
TN |
Deleted EdFiIdentityMappings as ObjectType has changed |
|
SIS-201270 |
MO |
Cleaned up Gifted Records with invalid programStatus values |
