This article collects the changes made to the database schema as part of the Campus.2523 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-180761 |
RecurringTuitionPayment |
recurringTuitionPaymentID |
int |
no |
startDate |
datetime2(7) |
no | ||
endDate |
datetime2(7) |
no | ||
recurringPaymentFrequencyID |
int |
no | ||
tuitionAssignmentID |
int |
no | ||
tuitionPayerDistributionGroupID |
int |
no | ||
recurringPaymentAmount |
decimal(7,2) |
yes | ||
active |
bit |
no | ||
customerRef |
varchar(100) |
yes | ||
paymentMethodReferenceID |
int |
no | ||
emailAddress |
varchar(320) |
yes | ||
lastExecutedDate |
datetime2(2) |
yes | ||
lastExecutionStatus |
varchar(30) |
yes | ||
createdDate |
datetime2(7) |
yes | ||
modifiedDate |
datetime2(7) |
yes | ||
deletedDate |
datetime2(7) |
yes | ||
SIS-180761 |
TuitionAdjustmentPaymentDate |
tuitionAdjustmentPaymentDateID |
int |
no |
tuitionAdjustmentID |
int |
no | ||
tuitionPaymentPlanDateID |
int |
no | ||
amount |
decimal(9,2) |
no | ||
SIS-180761 |
TuitionAssignmentDistribution |
tuitionAssignmentDistributionID |
int |
no |
tuitionAssignmentID |
int |
no | ||
tuitionPaymentPlanID |
int |
no | ||
tuitionPayerDistributionGroupID |
int |
no | ||
amount |
decimal(9,2) |
no | ||
SIS-180761 |
TuitionDiscountAssignmentDistribution |
tuitionDiscountAssignmentDistributionID |
int |
no |
tuitionDiscountAssignmentID |
int |
no | ||
tuitionPayerDistributionGroupID |
int |
no | ||
amount |
decimal(9,2) |
no | ||
SIS-180761 |
TuitionPayer |
tuitionPayerID |
int |
no |
payerPersonID |
int |
no | ||
tuitionPayerDistributionGroupID |
int |
no | ||
SIS-180761 |
TuitionPayerDistributionGroup |
tuitionPayerDistributionGroupID |
int |
no |
SIS-180761 |
TuitionPurchaseProduct |
tuitionPurchaseProductID |
int |
no |
tuitionAssignmentID |
int |
no | ||
tuitionAssignmentDistributionID |
int |
no | ||
purchaseProductID |
int |
no | ||
SIS-180761 |
TuitionScholarshipAssignmentDistribution |
tuitionScholarshipAssignmentDistributionID |
int |
no |
tuitionScholarshipAssignmentID |
int |
no | ||
tuitionPayerDistributionGroupID |
int |
no | ||
amount |
decimal(9,2) |
no | ||
SIS-182663 |
CourseCodeFieldValue |
courseCodeFieldValueID |
int |
no |
courseCodeFieldValueGUID |
uniqueidentifier |
no | ||
courseCodeID |
int |
no | ||
lock |
bit |
no | ||
fieldName |
varchar(60) |
yes | ||
attributeID |
int |
yes | ||
value |
varchar(256) |
yes | ||
SIS-182663 |
CourseCodePublishHistory |
courseCodePublishHistoryID |
int |
no |
courseCodeID |
int |
no | ||
districtID |
int |
no | ||
courseCodeStatus |
int |
no | ||
courseCodeTimestamp |
datetime2(0) |
yes | ||
courseCodeGUID |
uniqueidentifier |
yes | ||
SIS-182867 |
ProgramPublishHistory |
programPublishHistoryID |
int |
no |
programID |
int |
no | ||
districtID |
int |
no | ||
programStatus |
int |
no | ||
programTimestamp |
datetime2(0) |
yes | ||
programGUID |
uniqueidentifier |
yes | ||
SIS-187431 |
CustomEarlyInterventions |
customID |
int |
no |
attributeID |
int |
no | ||
earlyInterventionsID |
int |
no | ||
value |
varchar(256) |
yes | ||
date |
date |
yes | ||
SIS-187431 |
EarlyInterventions |
earlyInterventionsID |
int |
no |
personID |
int |
no | ||
districtID |
int |
no | ||
earlyInterventionsGUID |
uniqueidentifier |
no | ||
createdDate |
date |
no | ||
modifiedByID |
int |
yes | ||
modifiedDate |
date |
yes | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
comments |
varchar(500) |
yes | ||
intervention |
varchar(8000) |
no | ||
endYear |
varchar(4) |
no | ||
stateGrade |
varchar(4) |
no | ||
methodologyTool |
varchar(15) |
no | ||
methodologyToolComments |
varchar(100) |
yes | ||
programType |
varchar(50) |
no | ||
SIS-187984 |
AttendanceRecovery |
attendanceRecoveryID |
int |
no |
personID |
int |
no | ||
districtID |
int |
no | ||
attendanceRecoveryGUID |
uniqueidentifier |
no | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
createdDate |
date |
no | ||
modifiedByID |
int |
yes | ||
modifiedDate |
date |
yes | ||
comments |
varchar(255) |
yes | ||
SIS-187984 |
AttendanceRecoveryService |
attendanceRecoveryServiceID |
int |
no |
attendanceRecoveryID |
int |
yes | ||
personID |
int |
no | ||
districtID |
int |
no | ||
attendanceRecoveryServiceGUID |
uniqueidentifier |
no | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
serviceType |
varchar(15) |
yes | ||
schoolNumber |
varchar(12) |
no | ||
timeEarned |
int |
yes | ||
daysUsed |
int |
yes | ||
isCalendar |
bit |
no | ||
comments |
varchar(255) |
yes | ||
modifiedByID |
int |
yes | ||
modifiedDate |
date |
yes | ||
createdByID |
int |
yes | ||
createdDate |
date |
yes | ||
SIS-187984 |
CustomAttendanceRecoveryService |
customID |
int |
no |
attributeID |
int |
no | ||
attendanceRecoveryServiceID |
int |
no | ||
value |
varchar(256) |
yes | ||
date |
date |
yes | ||
SIS-188181 |
GradeCalculationSnapshot |
gradeCalculationSnapshotID |
int |
no |
gradeCalculationSnapshotGUID |
uniqueidentifier |
no | ||
personID |
int |
no | ||
calendarID |
int |
no | ||
grade |
varchar(4) |
no | ||
timestamp |
datetime2(0) |
no | ||
unweightedGPA |
decimal(9,6) |
no | ||
weightedGPA |
decimal(9,6) |
no | ||
rank |
int |
yes | ||
SIS-188257 |
CustomSummerEducation |
customID |
int |
no |
attributeID |
int |
no | ||
summerEducationID |
int |
no | ||
value |
varchar(256) |
yes | ||
date |
date |
yes | ||
SIS-188257 |
SummerEducation |
summerEducationID |
int |
no |
personID |
int |
no | ||
summerEducationGUID |
uniqueidentifier |
no | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
parentDeclined |
bit |
no | ||
priority |
varchar(15) |
yes | ||
educationalProgram |
varchar(15) |
yes | ||
assessmentType |
varchar(15) |
yes | ||
comments |
varchar(255) |
yes | ||
createdDate |
date |
yes | ||
modifiedDate |
date |
yes | ||
modifiedByID |
int |
yes | ||
districtID |
int |
no |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-188355 |
BehaviorRole |
reasonableForce |
bit |
no |
SIS-188355 |
BehaviorRole |
reasonableForceRole |
varchar(150) |
yes |
SIS-182663 |
CourseCode |
courseCodeGUID |
uniqueidentifier |
no |
SIS-182663 |
CourseCode |
modifiedDate |
datetime2(0) |
yes |
SIS-182663 |
CourseCode |
modifiedByID |
int |
yes |
SIS-182663 |
CourseCode |
lastPublishedTimestamp |
datetime2(0) |
yes |
SIS-182663 |
CourseCode |
lastPublishedByID |
int |
yes |
SIS-188221 |
DigitalLearningVendorOAuth2ClientCredentials |
exPartnerIdentityManagementAccess |
bit |
no |
SIS-184739 |
PlanGuardian |
printAddress |
bit |
no |
SIS-187773 |
PlanState |
tertiaryDisabilityMulti |
varchar(8000) |
yes |
SIS-187773 |
PlanState |
varCharMS3 |
varchar(8000) |
yes |
SIS-187773 |
PlanState |
varCharMSStr3 |
varchar(8000) |
yes |
SIS-180761 |
PortalDisplayOptions |
tuition |
bit |
no |
SIS-180761 |
PortalDisplayOptions |
tuitionBalance |
bit |
no |
SIS-182867 |
Program |
programGUID |
uniqueidentifier |
no |
SIS-182867 |
Program |
modifiedDate |
datetime2(0) |
yes |
SIS-182867 |
Program |
modifiedByID |
int |
yes |
SIS-182867 |
Program |
publishedTimestamp |
datetime2(0) |
yes |
SIS-182867 |
Program |
publishedByID |
int |
yes |
SIS-180761 |
PurchaseProductPayment |
voided |
bit |
yes |
SIS-180761 |
PurchaseProductPayment |
comments |
varchar(255) |
yes |
SIS-188257 |
RecordsTransfer |
summerEducationXML |
varchar(max) |
yes |
SIS-188257 |
RecordsTransfer |
summerEducationFOP |
varchar(100) |
yes |
SIS-189118 |
RecordsTransfer |
earlyInterventionsXML |
varchar(max) |
yes |
SIS-189118 |
RecordsTransfer |
earlyInterventionsFOP |
varchar(100) |
yes |
SIS-180761 |
RecurringPaymentTransaction |
recurringTuitionPaymentID |
int |
yes |
SIS-180761 |
Tuition |
portalDisplay |
bit |
no |
SIS-180761 |
Tuition |
defaultPaymentPlanID |
int |
no |
SIS-180761 |
TuitionAdjustment |
applyType |
varchar(15) |
no |
SIS-180761 |
TuitionAdjustment |
tuitionPayerDistributionGroupID |
int |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-180761 |
TuitionAdjustment |
description |
varchar(120) |
no |
SIS-180761 |
TuitionDiscountMultiStudent |
tierName Renamed from name |
varchar(50) | no |
Deleted Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-180761 |
RelatedPair |
tuition |
SIS-180761 |
TuitionAdjustment |
tuitionGroupID |
SIS-180761 |
TuitionAdjustment |
adjustmentDate |
SIS-180761 |
TuitionAssignment |
tuitionPaymentPlanID |
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-174841 |
Deleted Big Blue Button Quartz Job | |
SIS-180761 |
Tuition Part II | |
SIS-180761 |
Created TuitionNotificationJob | |
SIS-182663 |
Transferred CourseCode tool rights to new CourseManagement tool with create if not exists | |
SIS-182663 |
Transferred CourseCode tool rights to new Course Management tool | |
SIS-182663 |
NC |
Populated CourseCodeFieldValue table from the CourseCode table transcript and type and gpaWeight columns |
SIS-182850 |
HI |
State Ethnicity |
SIS-182867 |
Fixed DIS Program rights | |
SIS-182867 |
Added Program to DIS | |
SIS-182867 |
NC |
Converted stateReported academic programs to stateManaged |
SIS-182867 |
Changed default value to lower case for AcademicProgram programType attribute | |
SIS-185256 |
NH |
Immunization Rule Update |
SIS-185657 |
NY |
Immunization Rule Update |
SIS-186554 |
Added ProcessMessage quartz cleanup job | |
SIS-187299 |
CA |
Immunization Rule Update |
SIS-187747 |
MT |
Updated GradeLevel and StateGradeLevelDefinition |
SIS-187904 |
Added Feature Toggle Preference for the both new and old DIS resync | |
SIS-187907 |
Added batch preference for rrs | |
SIS-188181 |
Inserted Quartz Job for taking GPA and Class Rank Snapshot | |
SIS-188181 |
Added GradeCalculationSnapshot to DIS | |
SIS-188194 |
NC |
Required race ethnicity |
SIS-188221 |
Added Preference for Identity Management | |
SIS-188257 |
Added DIS Object SummerEducation | |
SIS-188257 |
Added SummerEducation to DCT | |
SIS-188468 |
Removed true and false string values from bit field | |
SIS-188868 |
Default prefer central display to true for rrs | |
SIS-189033 |
Changed CustomCourse checkbox attribute values from true to 1 | |
SIS-189092 |
Deleted ReportingPeriodExts EdFi Identity Mappings | |
SIS-189118 |
Added Early Targeted Interventions program to Data Change Tracker to DCT | |
SIS-189118 |
MT |
Added Early Targeted Interventions DIS Object |
SIS-189118 |
MT |
Converted atRisk to EarlyTargentedIntervention |
