This article collects the changes made to the database schema as part of the Campus.2631 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-198546 | UserGroupToolRightsForStateToDistrictLogin | sedeGroupToolRightsID | int | no |
toolID | int | no | ||
groupID | int | no | ||
read | bit | no | ||
write | bit | no | ||
add | bit | no | ||
delete | bit | no | ||
grant | bit | no |
Deprecated Tables
Case Number | Table |
|---|---|
SIS-200282 | FinanceAccount |
SIS-200282 | FinanceAccountType |
SIS-200282 | FinanceJournalEntry |
SIS-200282 | FinanceJournalEntryItem |
SIS-200282 | FinanceSourceCode |
SIS-200282 | FinanceSystemCode |
Deleted Tables
Case Number | Table |
|---|---|
SIS-198546 | DistrictEditionInfoForStateLogin |
SIS-197996 | EarlyWarningYearlySyncRecord |
SIS-198546 | StateIDPConfig |
Modified Tables
Added Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-199593 |
DependentCareSession |
published |
bit |
no |
|
SIS-198546 |
District |
campusLoginURL |
varchar(500) |
yes |
|
SIS-199394 |
DistrictGeneralInformation |
ccProInfo |
varchar(15) |
yes |
|
SIS-199550 |
EnrollmentIN |
spedResponsibility |
varchar(15) |
yes |
|
SIS-198865 |
Evaluation |
archivedToCDR |
bit |
no |
|
SIS-198865 |
Evaluation |
cloudID |
uniqueidentifier |
yes |
|
SIS-198865 |
Evaluation |
archiveFailed |
bit |
no |
|
SIS-198865 |
Evaluation |
archiveRetryCount |
tinyint |
no |
|
SIS-200169 |
Homebound |
minutesPerDay |
smallint |
yes |
|
SIS-200169 |
Homebound |
attendanceOverride |
smallint |
yes |
|
SIS-199787 |
MobilePaymentsDevice |
deviceGUID |
varchar(36) |
no |
|
SIS-199787 |
MobilePaymentsDevice |
lastRequestUserID |
int |
yes |
|
SIS-198865 |
Plan |
archivedToCDR |
bit |
no |
|
SIS-198865 |
Plan |
cloudID |
uniqueidentifier |
yes |
|
SIS-198865 |
Plan |
archiveFailed |
bit |
no |
|
SIS-198865 |
Plan |
archiveRetryCount |
tinyint |
no |
|
SIS-198865 |
|
archiveToCDRYear |
smallint |
yes |
|
SIS-200169 |
RecordsTransfer |
homeboundXML |
varchar(max) |
yes |
|
SIS-200169 |
RecordsTransfer |
homeboundFOP |
varchar(100) |
yes |
|
SIS-198865 |
RecordsTransfer |
archivedDocumentsXML |
varchar(max) |
yes |
|
SIS-200033 |
SpecialEDState |
homeEducation |
bit |
no |
|
SIS-199565 |
StudentMilitaryConnections |
rank |
varchar(15) |
yes |
|
SIS-199830 |
SummerEBT |
postOfficeBox |
bit |
no |
|
SIS-199830 |
SummerEBT |
number |
varchar(12) |
yes |
|
SIS-199830 |
SummerEBT |
prefix |
varchar(10) |
yes |
|
SIS-199830 |
SummerEBT |
street |
varchar(30) |
yes |
|
SIS-199830 |
SummerEBT |
tag |
varchar(20) |
yes |
|
SIS-199830 |
SummerEBT |
apt |
varchar(17) |
yes |
|
SIS-199830 |
SummerEBT |
city |
varchar(24) |
yes |
|
SIS-199830 |
SummerEBT |
state |
varchar(2) |
yes |
|
SIS-199830 |
SummerEBT |
zip |
varchar(10) |
yes |
|
SIS-199830 |
SummerEBT |
county |
varchar(50) |
yes |
|
SIS-199830 |
SummerEBT |
addressID |
int |
yes |
Altered Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
|
SIS-199565 |
ImpactAidEmployment |
rank |
varchar(15) |
yes |
Deprecated Columns
Ordered by Table Name.
|
Case Number |
Table |
Column |
|---|---|---|
|
SIS-199394 |
DistrictGeneralInformation |
kgAge5Day |
|
SIS-198105, SIS-199550 |
EnrollmentMT |
educationalSavingsAccount |
|
SIS-198105, SIS-199550 |
EnrollmentMT |
esaOPIPaysYear1 |
|
SIS-200534 |
FlexMonsterCube |
groupID |
|
SIS-200534 |
FlexMonsterCube |
layout |
Deleted Columns
|
Case Number |
Table |
Column |
|---|---|---|
|
SIS-200317 |
EnrollmentDE |
studentCharacteristics |
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-176365 |
NV |
Added to race ethnicity |
|
SIS-194471 |
IA |
Added SIF error log cleanup quartz job |
|
SIS-195671 |
|
POS added default POSPreference record |
|
SIS-196910 |
MN |
Immunization Rule Update |
|
SIS-196931 |
WY |
Turned on DIS Quartz job for clearing SIFSentRecordHistory |
|
SIS-197371 |
DE |
Updated existing and add new BehaviorResponseTypes |
|
SIS-197460 |
IL |
Immunization Rule Update |
|
SIS-197996 |
|
Dropped EarlyWarningYearlySyncRecord Table |
|
SIS-197996 |
|
Updated Quartz Job for EarlyWarningSync |
|
SIS-198094 |
NY |
Immunization Rule Update |
|
SIS-198103 |
DE |
Inactivate Grade Level Code 00 |
|
SIS-198315 |
VT |
Converted ProgramTypeDescriptor to localized namespace |
|
SIS-198526 |
ND |
Added districtOverride to School |
|
SIS-198540 |
VA |
Immunization Rule Update |
|
SIS-198546 |
|
SE to DE User Group push |
|
SIS-198546 |
|
Added DIS object for UserGroup |
|
SIS-198546 |
|
Altered configType for State to District SAMLSPConfig entries |
|
SIS-198546 |
|
Updated CampusTool for Custom Tools pushed to Districts for SEDE Login User Groups |
|
SIS-198546 |
|
Added DIS object for SAMLSPConfig |
|
SIS-198546 |
|
Removed State to District Login Right from users and groups |
|
SIS-198855 |
GA |
Ed-Fi deleted invalid identity mappings |
|
SIS-199094 |
|
Made SCEDConcentrator startYear and endYear non null |
|
SIS-199438 |
|
Removed Old Invalid Core Mappings For attendanceEventCategoryDescriptors |
|
SIS-200288 |
ND |
Added new district |
|
SIS-200317 |
DE |
Deleted Enrollment CampusAtt studentCharacteristics - added in SIS-199959 |
|
SIS-200411 |
BIE |
Configured DIS for TestAccommodations BIE |
|
SIS-200620 |
CO |
District update applied to every state fix other states |
|
SIS-200620 |
CO |
District update applied to every state fix one off |
|
SIS-200644 |
MN |
Updated district list |
|
SIS-200756 |
NV |
New district |
