This article collects the changes made to the database schema as part of the Campus.2539 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-177982 |
Title1PartAValue |
title1PartAValueID |
int |
no |
title1PartAID |
int |
no | ||
title1PartAValueGUID |
uniqueidentifier |
no | ||
attributeID |
int |
no | ||
value |
varchar(15) |
yes | ||
SIS-177982 |
Title1PartDValue |
title1PartDValueID |
int |
no |
title1PartDID |
int |
no | ||
title1PartDValueGUID |
uniqueidentifier |
no | ||
attributeID |
int |
no | ||
value |
varchar(15) |
yes | ||
SIS-186879 |
IMLearningObjectLibraryGrading |
objectLibraryGradingID |
int |
no |
objectLibraryID |
int |
no | ||
taskID |
int |
yes | ||
scoringType |
varchar(1) |
yes | ||
totalPoints |
smallint |
yes | ||
weight |
decimal(6,3) |
yes | ||
markGroupID |
int |
yes | ||
categoryName |
varchar(50) |
yes | ||
modifiedTimestamp |
datetime2(0) |
no | ||
SIS-186879 |
IMLearningObjectPersonGrading |
objectPersonGradingID |
int |
no |
objectPersonID |
int |
no | ||
taskID |
int |
yes | ||
scoringType |
varchar(1) |
yes | ||
totalPoints |
smallint |
yes | ||
weight |
decimal(6,3) |
yes | ||
markGroupID |
int |
yes | ||
categoryName |
varchar(50) |
yes | ||
modifiedTimestamp |
datetime2(0) |
no | ||
SIS-186879 |
LTILibraryLink |
ltiLibraryLinkID |
int |
no |
ltiLinkID |
int |
no | ||
ltiLibraryLinkGUID |
varchar(250) |
no | ||
objectLibraryID |
int |
no | ||
tag |
varchar(256) |
yes | ||
resourceId |
varchar(256) |
yes | ||
sourceLtiLibraryLinkID |
int |
yes | ||
SIS-186879 |
LTIPersonLink |
ltiPersonLinkID |
int |
no |
ltiLinkID |
int |
no | ||
ltiPersonLinkGUID |
varchar(250) |
no | ||
objectPersonID |
int |
no | ||
tag |
varchar(256) |
yes | ||
resourceId |
varchar(256) |
yes | ||
sourceLtiPersonLinkID |
int |
yes | ||
SIS-189297 |
SIFErrorLog |
sifErrorLogID |
int |
no |
timestamp |
datetime2(3) |
yes | ||
archived |
bit |
yes | ||
configurationName |
varchar(20) |
yes | ||
sifObject |
varchar(40) |
yes | ||
actionType |
varchar(6) |
yes | ||
errorType |
varchar(100) |
yes | ||
errorMessage |
varchar(8000) |
yes | ||
sifResponseHistoryID |
int |
yes | ||
SIS-189321 |
PaymentVendorSync |
vendorSyncID |
int |
no |
syncName |
varchar(32) |
no | ||
paymentVendorAccountID |
int |
no | ||
lastModified |
datetime2(3) |
no | ||
SIS-191851 |
DistrictEditionInfoForStateLogin |
districtLoginID |
int |
no |
districtID |
int |
no | ||
appName |
varchar(50) |
no | ||
url |
varchar(2000) |
no | ||
SIS-192030 |
SummerEducationValue |
summerEducationValueID |
int |
no |
summerEducationID |
int |
no | ||
attributeID |
int |
no | ||
value |
varchar(50) |
yes | ||
summerEducationValueGUID |
uniqueidentifier |
no |
Deleted Tables
Case Number |
Table |
|---|---|
SIS-189115 |
TuitionRelatedDocument |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-185328 |
DataExtractUtility |
isDeleted |
bit |
no |
SIS-185328 |
DataExtractUtility |
lastRunMessage |
varchar(4000) |
yes |
SIS-185328 |
DataExtractUtility |
createdByID |
int |
yes |
SIS-185328 |
DataExtractUtility |
frequencyMonthOfTheYear |
int |
no |
SIS-185328 |
DataExtractUtilityHistory |
ranBy |
varchar(255) |
yes |
SIS-191455 |
DistrictGeneralInformation |
earlyEntrancePolicy |
varchar(15) |
yes |
SIS-189885 |
EdFiIdentityMappingRoster |
serviceSchoolID |
int |
yes |
SIS-191638 |
EmploymentAssignment |
pdClass2 |
varchar(15) |
yes |
SIS-190191 |
EnrollmentMT |
educationalSavingsAccount |
bit |
no |
SIS-190191 |
EnrollmentMT |
esaOPIPaysYear1 |
bit |
no |
SIS-188198 |
EvalState |
districtOfResident |
varchar(200) |
yes |
SIS-188198 |
EvalState |
residentSchoolBuilding |
varchar(200) |
yes |
SIS-188198 |
EvalState |
servingSchool |
varchar(200) |
yes |
SIS-188198 |
EvalState |
specialEdUnitAddress |
varchar(250) |
yes |
SIS-188198 |
EvalState |
servingDistrictNameLong |
varchar(200) |
yes |
SIS-188198 |
EvalState |
specialEdUnit |
varchar(200) |
yes |
SIS-186879 |
IMLearningObjectLibrary |
duration |
decimal(6,3) |
yes |
SIS-186879 |
IMLearningObjectLibrary |
abbrev |
varchar(5) |
yes |
SIS-186879 |
IMLearningObjectLibrary |
active |
bit |
no |
SIS-186879 |
IMLearningObjectLibrary |
notGraded |
bit |
no |
SIS-186879 |
IMLearningObjectPerson |
duration |
decimal(6,3) |
yes |
SIS-186879 |
IMLearningObjectPerson |
abbrev |
varchar(5) |
yes |
SIS-186879 |
IMLearningObjectPerson |
active |
bit |
no |
SIS-186879 |
IMLearningObjectPerson |
notGraded |
bit |
no |
SIS-186879 |
IMLearningObjectPerson |
cartridgeImportID |
int |
yes |
SIS-186879 |
IMLearningObjectPerson |
cartridgeIdentifier |
varchar(500) |
yes |
SIS-188198 |
PlanGuardian |
hideParentContactInfo |
bit |
no |
SIS-191342 |
PlanOfStudy |
programType |
varchar(100) |
yes |
SIS-191342 |
PlanOfStudy |
programDays |
decimal(7,2) |
yes |
SIS-191342 |
PlanOfStudy |
attendedDays |
decimal(7,2) |
yes |
SIS-188198 |
PlanStudent |
disability1 |
varchar(15) |
yes |
SIS-188198 |
PlanStudent |
disability2 |
varchar(15) |
yes |
SIS-145106 |
POSPreference |
blockConcessionsStudent |
bit |
no |
SIS-145106 |
POSPreference |
blockConcessionsParent |
bit |
no |
SIS-145106 |
POSPreference |
singlePurchaseRestrictStudent |
bit |
no |
SIS-145106 |
POSPreference |
singlePurchaseRestrictParent |
bit |
no |
SIS-145106 |
POSPreference |
dailyLimitStudent |
bit |
no |
SIS-145106 |
POSPreference |
dailyLimitParent |
bit |
no |
SIS-145106 |
POSPreference |
blockAlaCarteStudent |
bit |
no |
SIS-145106 |
POSPreference |
blockAlaCarteParent |
bit |
no |
SIS-145106 |
POSPreference |
portalInstructions |
varchar(500) |
yes |
SIS-191890 |
RecordsTransfer |
specialEdStateXML |
varchar(max) |
yes |
SIS-192176 |
RecordsTransfer |
title1PartDXML |
varchar(max) |
yes |
SIS-192176 |
RecordsTransfer |
title1PartDFOP |
varchar(100) |
yes |
SIS-192176 |
RecordsTransfer |
title3XML |
varchar(max) |
yes |
SIS-192176 |
RecordsTransfer |
title3FOP |
varchar(100) |
yes |
SIS-192176 |
RecordsTransfer |
title6XML |
varchar(max) |
yes |
SIS-192176 |
RecordsTransfer |
title6FOP |
varchar(100) |
yes |
SIS-192176 |
RecordsTransfer |
title1PartAXML |
varchar(max) |
yes |
SIS-192176 |
RecordsTransfer |
title1PartAFOP |
varchar(100) |
yes |
SIS-188198 |
SEPExtendedYear |
justification |
varchar(8000) |
yes |
SIS-188198 |
SEPTeamMeeting |
meetingType6 |
bit |
no |
SIS-188198 |
SEPTeamMeeting |
meetingType7 |
bit |
no |
SIS-188198 |
SEPTeamMeeting |
meetingType8 |
bit |
no |
SIS-188198 |
SEPTeamMeeting |
meetingType9 |
bit |
no |
SIS-188198 |
SEPTeamMeeting |
meetingType10 |
bit |
no |
SIS-188198 |
SEPTeamMeeting |
meetingType11 |
bit |
no |
SIS-188198 |
SEPTestAccommodationList |
participation |
varchar(15) |
yes |
SIS-188198 |
SEPTestAccommodationList |
assessment |
varchar(15) |
yes |
SIS-188198 |
SEPTestAccommodationList |
subjectArea |
varchar(15) |
yes |
SIS-188198 |
SEPTestAccommodationList |
accessibilityToolCategory |
varchar(15) |
yes |
SIS-188198 |
SEPTestAccommodationList |
accessibilityTool |
varchar(50) |
yes |
SIS-188198 |
SpecialEDState |
assessmentParticipation |
varchar(15) |
yes |
SIS-190996 |
SummerEducation |
exitStatus |
varchar(15) |
yes |
SIS-177982 |
Title1PartD |
programType |
varchar(15) |
yes |
SIS-187223 |
Title3 |
immigrant |
varchar(15) |
yes |
SIS-187223 |
Title3 |
title3Immigrant |
varchar(15) |
yes |
SIS-187223 |
Title3 |
title3EnglishLearner |
varchar(15) |
yes |
SIS-191594 |
Transportation |
eligibleRoute |
varchar(50) |
yes |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
Can Be NULL? |
|---|---|---|---|---|
SIS-191838 |
BehaviorResolution |
removalReason2 |
varchar(15) |
yes |
SIS-191838 |
BehaviorResolution |
modificationReason |
varchar(15) |
yes |
SIS-186879 |
IMLearningObjectLibrary |
identifier |
varchar(500) |
yes |
SIS-188198 |
PlanServiceProvided |
providerName |
varchar(150) |
yes |
SIS-188198 |
PlanServiceProvided |
positionName |
varchar(150) |
yes |
SIS-188198 |
PlanState |
residentDistrictName |
varchar(200) |
yes |
SIS-188198 |
PlanState |
servingSchoolName |
varchar(200) |
yes |
SIS-188198 |
PlanState |
servingSchoolAddress |
varchar(250) |
yes |
SIS-188198 |
PlanState |
residentSchool |
varchar(200) |
yes |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-183142, SIS-186759, SIS-186879 |
IMLearningObjectLibrary |
identifier |
SIS-183142, SIS-186759, SIS-186879 |
IMLearningObjectLibrary |
cartridgeImportID |
Deleted Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-189883 |
DependentCareSessionMemberChargeAdjustment |
editComment |
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-186879 |
My Curriculum - Fixes for soft deleted imports and notGraded flag | |
SIS-186879 |
My Curriculum - Curriculum Import Notification Update | |
SIS-186879 |
My Curriculum - Fixed standards with no standardID | |
SIS-186879 |
Fixed standards with no standardID | |
SIS-186879 |
Migrate Curriculum Import content from IMLearningObjectLibrary to IMLeanringObjectPerson | |
SIS-186889 |
NM |
Dropped Flat File Stored Procedures |
SIS-187427 |
NC |
FTE Extract Feature Toggle |
SIS-189023 |
Converted StudentSchoolAssociation object keys | |
SIS-189115 |
Tuition Audit Tables | |
SIS-189321 |
OLPDisputeSync Quartz Job | |
SIS-189650 |
OH |
Dropped PreID2014 |
SIS-189775 |
MO |
Added values to District |
SIS-189868 |
Added preference for Attendance Recovery | |
SIS-189868 |
Added quartz job for Attendance Recovery | |
SIS-189885 |
Cleaned up old service school EdFiIdentityMappings | |
SIS-189906 |
KY |
Inactivated districts |
SIS-189921 |
Added field trip students to roster | |
SIS-190996 |
Summer Education Program Exit Status field | |
SIS-191104 |
HI |
State Ethnicity reroll |
SIS-191263 |
Deprecated College Surveys | |
SIS-191300 |
NM |
Added new BehaviorResType and BehaviorType records |
SIS-191364 |
KS |
Updated Attendance Aggregation Refresh SP |
SIS-191408 |
NC |
Converted ProviderSchool and ProviderSchoolOverride in NC |
SIS-191608 |
NY |
Updated stateReporting flag when code is set |
SIS-191759 |
NC |
Reapplied splay to quartz jobs |
SIS-191759 |
DE |
Reapplied splay to quartz jobs |
SIS-191774 |
Enabled Preference POS Messaging OAuth2 | |
SIS-191774 |
Preference POS Messaging OAuth2 | |
SIS-191854 |
KY |
Immunization Rule Update |
SIS-191907 |
DE |
CTECareerPathwayChanges |
SIS-192067 |
Converted FATAL13 to System owned and update script | |
SIS-192074 |
IA |
Updated District LIst |
SIS-192176 |
Added Title1PartA to DCT | |
SIS-192176 |
Added DIS Object Title1PartA | |
SIS-192176 |
Added title1partd to dis | |
SIS-192176 |
ND |
Added Title6 DIS object |
SIS-192176 |
Added Title 6 to Data Change Tracker | |
SIS-192176 |
ND |
Added Title III DIS Object |
SIS-192176 |
Added Title III program to Data Change Tracker to DCT | |
SIS-192176 |
Added title1partd to dct | |
SIS-192343 |
Turned on CSE Interdistrict toggle |
