This article collects the changes made to the database schema as part of the Campus.2407 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 |
SIS-145938 | ActivityClearedRosterOption | activityClearedRosterOptionID | int |
personID | int | ||
documentID | int | ||
activitySectionID | int | ||
createdDate | datetime2(0) | ||
modifiedByID | int | ||
modifiedTimestamp | datetime2(0) | ||
deletedByID | int | ||
SIS-173616 | LibraryGradeLevel | gradeLevelID | int |
metadataID | int | ||
name | varchar(255) | ||
value | varchar(255) | ||
humanAbbrev | varchar(255) | ||
seq | int | ||
SIS-173616 | LibraryStandard | standardID | int |
metadataID | int | ||
externalGUID | varchar(255) | ||
name | nvarchar | ||
caseIdentifier | varchar(255) | ||
SIS-173616 | LibrarySubject | subjectID | int |
metadataID | int | ||
id | varchar(255) | ||
name | varchar(255) | ||
key | varchar(255) | ||
SIS-173616 | LibraryFolderFullTextSearch | fullTextSearchID | int |
objectLibraryID | int | ||
name | varchar(255) | ||
childNames | varchar(max) | ||
childTeacherContent | nvarchar | ||
childHtmlContent | nvarchar | ||
childFileAttachments | nvarchar | ||
childQuizzes | nvarchar | ||
childDiscussions | nvarchar | ||
SIS-173616 | LibraryResourceMetadata | metadataID | int |
familyGUID | varchar(60) | ||
cnclContentGUID | varchar(60) | ||
description | varchar(max) | ||
contentName | varchar(255) | ||
SIS-173616 | ReflectionsSubmission | submissionID | int |
surveyID | int | ||
personID | int | ||
learningObjectVersionGroupID | int | ||
surveyJSON | nvarchar | ||
submissionJSON | nvarchar | ||
submissionDateTime | datetime2(0) | ||
SIS-173616 | ReflectionsSubmissionResponse | responseID | int |
submissionID | int | ||
questionID | int | ||
SIS-173616 | ReflectionsSubmissionResponseSelection | selectionID | int |
responseID | int | ||
answerID | int | ||
SIS-174894 | CustomSupportEnvironment | customID | int |
attributeID | int | ||
supportEnvironmentID | int | ||
value | varchar(256) | ||
date | date | ||
SIS-174894 | SupportEnvironment | supportEnvironmentID | int |
personID | int | ||
districtID | int | ||
supportEnvironmentGUID | uniqueidentifier | ||
modifiedByID | int | ||
modifiedDate | date | ||
createdDate | date | ||
startDate | date | ||
endDate | date | ||
programStatus | varchar(15) | ||
programType | varchar(15) | ||
segments | int | ||
comments | varchar(255) | ||
SIS-175153 | NonCSEAttDayAggregation | calendarID | int |
personID | int | ||
date | date | ||
lastModifiedDate | datetime2(0) | ||
scheduledMinutes | smallint | ||
absentMinutes | smallint | ||
unexcusedAbsentMinutes | smallint | ||
mostCommonExcuseID | int | ||
tardies | smallint | ||
absentPeriods | smallint | ||
unexcusedOnlyAbsentMinutes | smallint | ||
unexcusedAbsentPeriods | smallint | ||
unexcusedOnlyAbsentPeriods | smallint | ||
stateAbsentMinutes | smallint | ||
customAbsentMinutes | smallint | ||
SIS-175241, SIS-174749 | CustomHomelessService | customID | int |
attributeID | int | ||
homelessServiceID | int | ||
value | varchar(256) | ||
date | date |
Deprecated Tables
Case Number | Table |
SIS-173616 | IMLearningObjectAlignment |
SIS-173616 | IMLearningObjectDepthOfKnowledge |
SIS-173616 | IMLearningObjectGradeLevel |
SIS-173616 | IMLearningObjectGradeLevelLink |
SIS-173616 | IMLearningObjectTagMap |
SIS-173616 | IMTag |
Modified Tables
Added
Case Number | Table | Column | DataType |
SIS-145938 | Activity | autoFormClear | bit |
SIS-164830, SIS-168430 | CloudFile | auditToolCode | varchar(50) |
SIS-164830, SIS-168430 | CloudFileLocation | auditToolCode | varchar(50) |
SIS-168780 | InstructionMode | comments | varchar(255 |
SIS-168780 | InstructionMode | percentVirtual | varchar(15) |
SIS-168780 | InstructionMode | exitReason | varchar(15) |
SIS-168780 | InstructionMode | createdDate | date |
SIS-168784 | Gifted | programStatus | varchar(15) |
SIS-168784 | Gifted | createdDate | date |
SIS-172286, SIS-174685 | DigitalLearningVendorOAuth2ClientCredentials | acceptIncomingScoreComments | bit |
SIS-172286, SIS-174685 | DigitalLearningVendorOAuth2ClientCredentials | displayPrimaryHomeLanguage | bit |
SIS-173565 | EvalState | varCharMSStr1 | varchar(8000) |
SIS-173565 | EvalState | varCharMS1 | varchar(8000) |
SIS-173565 | SEPTransferRights | staffMember | varchar(150) |
SIS-173565 | SEPTransferRights | educationalRepName | varchar(100) |
| SIS-173565 | SEPTransferRights | certificationDate | date |
SIS-173565 | SEPTransferRights | educationalRepCheck2 | int |
SIS-173565 | SEPTransferRights | studentCheck4 | int |
| SIS-173565 | SEPTransferRights | educationalRepCheck | int |
SIS-173565 | SEPTransferRights | studentCheck1 | int |
SIS-173565 | SEPTransferRights | guardianName | varchar(100) |
SIS-173565 | SEPTransferRights | parentCheck | int |
SIS-173565 | SEPTransferRights | parentName | varchar(100) |
SIS-173565 | SEPTransferRights | teamDiscussion | varchar(8000) |
SIS-173565 | SEPTransferRights | studentCheck3 | int |
SIS-173565 | SEPTransferRights | studentCheck2 | int |
SIS-173616 | ReflectionsSurveyQuestion | category | varchar(255) |
SIS-173616 | ReflectionsSurveyQuestionAnswer | score | tinyint |
SIS-173616 | IMLearningObject | libraryResourceMetadataID | int |
SIS-174464 | OnTrack | firstHighSchoolYear | smallint |
SIS-174514 | Program | provider | varchar(15) |
SIS-174670 | TwentyFirstCCLC | programStatus | varchar(15) |
SIS-174670 | FosterCare | programStatus | varchar(15) |
SIS-174670 | FosterCare | createdDate | date |
SIS-174672 | Homeless | programStatus | varchar(15) |
SIS-174672 | Homeless | createdDate | date |
SIS-174749, SIS-174671 | EarlyLearning | firstYearAttendingKN | smallint |
SIS-174749, SIS-174671 | EarlyLearning | dateDistrictNotified | date |
SIS-174749, SIS-174671 | EarlyLearning | yrPreKAttended | smallint |
SIS-174749, SIS-174671 | EarlyLearning | referralDateToCDW | date |
SIS-174749, SIS-174671 | EarlyLearning | countyOfPreK | varchar(15) |
SIS-174749, SIS-174671 | EarlyLearning | preKPastYear | varchar(15) |
SIS-174749, SIS-174671 | EarlyLearning | createdDate | date |
SIS-174749, SIS-174671 | EarlyLearning | programStatus | varchar(15) |
SIS-174888 | AltProgram | programStatus | varchar(15) |
SIS-174888 | AltProgram | createdDate | date |
SIS-174888 | AltProgram | locationID | varchar(10) |
SIS-175241, SIS-174749 | HomelessService | programStatus | varchar(15) |
SIS-175241, SIS-174749 | HomelessService | comments | varchar(255) |
SIS-175241, SIS-174749 | HomelessService | createdDate | date |
SIS-175241, SIS-174888 | RecordsTransfer | pregnantAndParentingXML | varchar(max) |
SIS-175241, SIS-174888 | RecordsTransfer | homelessServiceXML | varchar(max) |
SIS-175241, SIS-174888 | RecordsTransfer | altProgramFOP | varchar(100) |
SIS-175241, SIS-174888 | RecordsTransfer | altProgramXML | varchar(max) |
SIS-175241, SIS-174888 | RecordsTransfer | pregnantAndParentingFOP | varchar(100) |
SIS-175241, SIS-174888 | RecordsTransfer | homelessServiceFOP | varchar(100) |
Altered
Case Number | Table | Column | DataType |
SIS-174672 | Homeless | homelessServed | varchar(15) |
Deprecated
Case Number | Table | Column |
SIS-168430 | Cloud | studentCount |
freeRate |
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-145938 | Added Auto Form Clear Job | |
SIS-168430 | Updateed legacyAuditToolCode rows with values in CloudFileLocation | |
SIS-168784 | Data Conversion of high ability from EnrollmentIN to Gifted.status | |
SIS-170740 | IN | Converted enrollment virtual education to InstructionMode |
SIS-173524 | OR | Immunization Rule Update v2 |
SIS-173524 | OR | Immunization Rule Update |
SIS-173536 | IL | Immunization Rule Update |
SIS-173536 | IL | Overnight Immunization Job |
SIS-173827 | CA | Immunization Rule Update |
SIS-174310 | Cleaned up ConstraintTeacherRoom foreign keys | |
SIS-174542 | MO | Immunization Rule Update |
SIS-174673 | Added Foster Care to DIS batch resync | |
SIS-174749 | Added homeless service to batch resync | |
SIS-174749 | Added programStatus to Homeless Service | |
SIS-174796 | PA | Immunization Rule Update |
SIS-174872 | KS | Immunization Rule Update |
SIS-174882 | Moved data from assignmentCode to spedLevel in EmploymentAssignment | |
SIS-174906 | Added DIS Object PregnantAndParenting | |
SIS-175121 | Populated EntityID for VT Districts | |
SIS-175194 | DE | Immunization Rule Update |
SIS-175194 | DE | Scheduled IMM job |
SIS-175240 | Added Homeless to DIS | |
SIS-175627 | Added new Grades GPA tool rights and copy current Grades tool right to new GPA subrights | |
SIS-175688 | VT | Ed-Fi converted stateID or staffStateID to edFiID |
SIS-175696 | Reassigned StateReporting values to new codes |
