This article collects the changes made to the database schema as part of the Campus.2515 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-181324 |
IMAssessmentLockdownSettings |
settingsID |
int |
no |
createdDateTime |
datetime2(2) |
no | ||
modifiedDateTime |
datetime2(2) |
no | ||
ltiProviderID |
int |
no | ||
assessmentObjectID |
int |
no | ||
objectSectionID |
int |
no | ||
lockdownEnabled |
bit |
no | ||
monitorEnabled |
bit |
no | ||
monitorData |
varchar(max) |
yes | ||
SIS-181324 |
LockdownUserLaunch |
launchID |
int |
no |
launchToken |
varchar(50) |
no | ||
tokenUsed |
bit |
no | ||
settingsID |
int |
no | ||
initializationVector |
binary(16) |
no | ||
userID |
int |
no | ||
studentPersonID |
int |
yes | ||
launchingPersonID |
int |
no | ||
isReattempt |
bit |
no | ||
createdDateTime |
datetime2(2) |
no | ||
SIS-183542 |
DependentCareMemberCredit |
dependentCareMemberCreditID |
int |
no |
dependentCareMemberID |
int |
no | ||
name |
varchar(255) |
no | ||
amount |
decimal(7,2) |
no | ||
effectiveDate |
date |
no | ||
comment |
varchar(255) |
yes | ||
editComment |
varchar(255) |
yes | ||
modifiedBy |
int |
no | ||
modifiedDateTime |
datetime2(0) |
no | ||
SIS-183542 |
DependentCareMemberCreditAdjustment |
dependentCareMemberCreditAdjustmentID |
int |
no |
dependentCareMemberCreditID |
int |
no | ||
amount |
decimal(7,2) |
no | ||
effectiveDate |
date |
no | ||
comment |
varchar(255) |
yes | ||
SIS-183542 |
DependentCareRegistrationCharge |
dependentCareRegistrationChargeID |
int |
no |
dependentCareApplicationID |
int |
no | ||
dependentCareSessionChargeID |
int |
no | ||
lock |
bit |
no | ||
SIS-183542 |
DependentCareRegistrationDiscount |
dependentCareRegistrationDiscountID |
int |
no |
dependentCareApplicationID |
int |
no | ||
dependentCareSessionDiscountID |
int |
no | ||
SIS-183542 |
DependentCareSectionAttendance |
dependentCareSectionAttendanceID |
int |
no |
personID |
int |
no | ||
dependentCareSessionSectionID |
int |
no | ||
attendanceDate |
date |
no | ||
checkInTime |
time |
yes | ||
checkOutTime |
time |
yes | ||
dependentCareAuthorizedPickupID |
int |
yes | ||
commentedPickup |
varchar(50) |
yes | ||
SIS-183542 |
DependentCareSessionMemberCharge |
dependentCareSessionMemberChargeID |
int |
no |
dependentCareSessionMemberID |
int |
no | ||
dependentCareSessionChargeID |
int |
no | ||
minutes |
int |
yes | ||
effectiveDate |
date |
no | ||
comment |
varchar(255) |
yes | ||
modifiedBy |
int |
no | ||
modifiedDateTime |
datetime2(0) |
no | ||
SIS-183542 |
DependentCareSessionMemberChargeAdjustment |
dependentCareSessionMemberChargeAdjustmentID |
int |
no |
dependentCareSessionMemberChargeID |
int |
no | ||
amount |
decimal(7,2) |
no | ||
effectiveDate |
date |
no | ||
comment |
varchar(255) |
yes | ||
editComment |
varchar(255) |
yes | ||
SIS-183542 |
DependentCareSessionMemberDiscount |
dependentCareSessionMemberDiscountID |
int |
no |
dependentCareSessionMemberID |
int |
no | ||
dependentCareSessionDiscountID |
int |
no | ||
startDate |
date |
no | ||
endDate |
date |
yes | ||
applyToDropIns |
bit |
no | ||
modifiedBy |
int |
no | ||
modifiedDateTime |
datetime2(0) |
no | ||
SIS-183542 |
DependentCareSessionMemberSchedule |
dependentCareSessionMemberScheduleID |
int |
no |
dependentCareSessionMemberID |
int |
no | ||
dependentCareSessionSectionID |
int |
no | ||
monday |
bit |
no | ||
tuesday |
bit |
no | ||
wednesday |
bit |
no | ||
thursday |
bit |
no | ||
friday |
bit |
no | ||
scheduleCode |
varchar(2) |
no | ||
scheduleStartDate |
date |
no | ||
scheduleEndDate |
date |
yes | ||
modifiedDateTime |
datetime2(0) |
yes | ||
modifiedBy |
int |
yes | ||
scheduleRate |
decimal(7,2) |
no | ||
SIS-183542 |
DependentCareSessionSectionCharge |
dependentCareSessionSectionChargeID |
int |
no |
dependentCareSessionSectionID |
int |
no | ||
dependentCareSessionChargeID |
int |
no | ||
SIS-185468 |
CCIRegistration |
registrationID | persisted (int) (always 1) | no |
accountID |
nvarchar(50) |
no | ||
accountSecret |
nvarchar(200) |
no | ||
createdTimestamp |
datetime2(0) |
no | ||
lastModifiedTimestamp |
datetime2(0) |
no | ||
SIS-186858 |
DISEventQueueHistory |
disEventQueueHistoryID |
bigint |
no |
actionType |
varchar(1) |
no | ||
campusTableName |
varchar(128) |
yes | ||
disImplementationType |
varchar(20) |
no | ||
insertTimestamp |
datetime2(2) |
yes | ||
processTimestamp |
datetime2(2) |
no | ||
SIS-187480 |
ActivitySectionRosterPendingPayment |
activitySectionRosterPendingPaymentID |
int |
no |
activitySectionRosterID |
int |
yes | ||
personID |
int |
no | ||
schoolID |
int |
yes | ||
priceAtCheckout |
decimal(19,4) |
no | ||
comments |
varchar(500) |
yes | ||
override |
bit |
no | ||
overridePrice |
decimal(19,4) |
yes | ||
overrideComment |
varchar(500) |
yes | ||
formsComplete |
bit |
no | ||
registrationConfirmed |
bit |
no |
Deleted Tables
Case Number |
Table |
---|---|
SIS-183542 |
DependentCareMemberSchedule |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
---|---|---|---|---|
SIS-183542 |
DependentCareSessionCharge |
calculation |
varchar(12) |
yes |
SIS-183542 |
DependentCareSessionDiscount |
seq |
int |
no |
SIS-183542 |
DependentCareSessionSection |
startTime |
time |
no |
SIS-183542 |
DependentCareSessionSection |
endTime |
time |
no |
SIS-183542 |
DependentCareSessionSection |
dropInRate |
decimal(7,2) |
yes |
SIS-183542 |
DependentCareSessionSection |
requirePickup |
bit |
no |
SIS-183542 |
DependentCareSessionSection |
allowDropIn |
bit |
no |
SIS-186858 |
DISEventQueue |
insertTimestamp |
datetime2(2) |
no |
SIS-187323 |
DISLog |
objectName |
varchar(100) |
yes |
SIS-184286 |
EdFiConfiguration |
active |
bit |
no |
SIS-177066 |
EmploymentAssignment |
extendedContractDays |
smallint |
yes |
SIS-186367 |
EnrollmentNH |
outOfDistrictSchool |
varchar(15) |
yes |
SIS-185246 |
Graduation |
fafsaCompletionIndicator |
varchar(15) |
yes |
SIS-187713 |
IMItem |
wysiwygAnswers |
bit |
no |
SIS-181324 |
LTIProvider |
institutionID |
varchar(40) |
yes |
SIS-187361 |
LTIProvider |
allowStudentAccess |
bit |
no |
SIS-186755 |
NCSnapshotLCSCSA |
sectionCount |
int |
yes |
SIS-187480 |
PaymentsCartItem |
metadataID |
int |
yes |
SIS-186357 |
PlanOfStudy |
reasonForDifference |
varchar(15) |
yes |
SIS-186357 |
PlanOfStudy |
participation |
varchar(15) |
yes |
SIS-186357 |
PlanOfStudy |
instructionSubject |
varchar(15) |
yes |
SIS-186357 |
PlanOfStudy |
assignedHours |
decimal(8,2) |
yes |
SIS-186357 |
PlanOfStudy |
completedHours |
decimal(8,2) |
yes |
SIS-186357 |
RecordsTransfer |
planOfStudyXML |
varchar(max) |
yes |
SIS-186357 |
RecordsTransfer |
planOfStudyFOP |
varchar(100) |
yes |
SIS-185675 |
ReflectionsSurvey |
showCompletedPage |
bit |
no |
SIS-181206 |
TEDSCO |
wblType |
varchar(50) |
yes |
SIS-181206 |
TEDSCO |
apprenticeship |
bit |
no |
SIS-181206 |
TEDSCO |
secondaryCert |
varchar(15) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
---|---|---|---|---|
SIS-183542 |
DependentCareSessionCharge |
chargeType |
varchar(14) |
yes |
SIS-182837 |
NCSnapshotGRSSummary |
rerun |
smallint |
no |
SIS-182837 |
NCSnapshotPMRSummary |
rerun |
smallint |
no |
SIS-185077 |
StudentContact |
county |
varchar(50) |
yes |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
---|---|---|
SIS-183542 |
DependentCareSetting |
applyRegistrationCharge |
SIS-187480 |
PaymentsCartItem |
personID |
SIS-187480 |
PaymentsCartItem |
productSaleID |
SIS-187480 |
PaymentsCartItem |
schoolID |
SIS-187480 |
PaymentsCartItem |
override |
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-163395 |
NC |
Updated default transcript to include credit rollups |
SIS-180575 |
TX |
Set Removed Resources to Inactive |
SIS-182225 |
NC |
Removed Scripted Grad Program |
SIS-183528 |
NV |
District table on District Edition should match the State Edition |
SIS-184475 |
MD |
Updated Race Codes |
SIS-184569 |
GA |
State Program Field Changes |
SIS-184696 |
NC |
Migrated enrollmentLocations |
SIS-184733 |
Added preferences for rrs | |
SIS-184733 |
Added preferences for fop | |
SIS-184836 |
NV |
impactAidEmployment data conversion |
SIS-185518 |
Added Prefernce for DIS Dashboard | |
SIS-185681 |
WY |
Converted Hathaway field values FLA to WL1 |
SIS-186361 |
NE |
EdFi - Removed mappings for a deprecated Enrollment State Exit Status code |
SIS-186528 |
NV |
Updated Charter School drop-down |
SIS-186561 |
Enabled LTI13 | |
SIS-186642 |
KS |
Deleted EdfiMappings for SSFSPA |
SIS-186858 |
Added insertTimestamp column to DISEventQueue | |
SIS-186858 |
Added disEventQueueHistory system preference | |
SIS-186875 |
Created Scheduled Task for EdFi Session Override Auto-Mapping | |
SIS-186882 |
Added Assignment Reassign Notification | |
SIS-187182 |
NC |
DISDataObject DISDataAccess added FosterCare |
SIS-187198 |
NC |
Non BIE Removed SSN from identity |
SIS-187206 |
NC |
Fixed academic programs |
SIS-187211 |
Added quartz job for rrs | |
SIS-187597 |
Migrated Non-Status Payrix Payment Methods | |
SIS-187698 |
Removed DIS Truancy Object | |
SIS-187713 |
Set IMItem wysiwygAnswers to true for answers with html tags | |
SIS-187755 |
Updated Start Minute of DLPP Activation Job |