This article collects the changes made to the database schema as part of the Campus.2643 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 TablesCase Number
Table
Column
Data Type
Can Be NULL?
SIS-145578
UserFormCenterFilter
userFormCenterFilterID
int
no
userID
int
no
element
varchar(50)
no
value
varchar(1000)
yes
Deleted Tables
Case Number
Table
SIS-201561
IMAssessmentLockdownSettings
SIS-201561
LockdownUserLaunch
Modified Tables
Added Columns
Ordered by Table Name.
Case Number
Table
Column
Data Type
Can Be NULL?
SIS-189823
EdFiConfiguration
dataStandard
tinyint
yes
SIS-202191
EdFiIdentityResponse
clientKey
varchar(50)
yes
SIS-145578
Form
createdSource
varchar(10)
no
SIS-145578
FormDocument
allowParentStart
bit
no
SIS-145578
FormDocument
allowStudentStart
bit
no
SIS-201983
Lep
testedProficientOnScreener
datetime2(0)
yes
SIS-202137
Message
processingCompleteTimestamp
datetime2(0)
yes
SIS-202063
PreSchoolKY
familyVisit1Location
varchar(15)
yes
SIS-202063
PreSchoolKY
familyVisit2Location
varchar(15)
yes
SIS-202063
PreSchoolKY
modifiedByID
int
yes
SIS-202063
PreSchoolKY
modifiedDate
datetime2(0)
yes
SIS-201669
StaffEdOrgVacancy
buildingAdministrator40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
educationalAssistant40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
elaTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
giftedTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
mathTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
nonEnglishLangTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
performingArtsTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
physicalEdTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
preschoolTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
scienceTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
socStudiesHistoryTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
visualArtsTeacher40D
smallint
yes
SIS-201669
StaffEdOrgVacancy
buildingAdministrator80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
educationalAssistant80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
elaTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
giftedTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
mathTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
nonEnglishLangTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
performingArtsTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
physicalEdTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
preschoolTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
scienceTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
socStudiesHistoryTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
visualArtsTeacher80D
smallint
yes
SIS-201669
StaffEdOrgVacancy
buildingAdministrator120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
educationalAssistant120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
elaTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
giftedTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
mathTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
nonEnglishLangTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
performingArtsTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
physicalEdTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
preschoolTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
scienceTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
socStudiesHistoryTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
visualArtsTeacher120D
smallint
yes
SIS-201669
StaffEdOrgVacancy
buildingAdministratorEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
educationalAssistantEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
elaTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
giftedTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
mathTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
nonEnglishLangTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
performingArtsTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
physicalEdTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
preschoolTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
scienceTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
socStudiesHistoryTeacherEOY
smallint
yes
SIS-201669
StaffEdOrgVacancy
visualArtsTeacherEOY
smallint
yes
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-145578 | UserFormCenterFilter | userFormCenterFilterID | int | no |
userID | int | no | ||
element | varchar(50) | no | ||
value | varchar(1000) | yes |
Deleted Tables
Case Number | Table |
|---|---|
SIS-201561 | IMAssessmentLockdownSettings |
SIS-201561 | LockdownUserLaunch |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-189823 | EdFiConfiguration | dataStandard | tinyint | yes |
SIS-202191 | EdFiIdentityResponse | clientKey | varchar(50) | yes |
SIS-145578 | Form | createdSource | varchar(10) | no |
SIS-145578 | FormDocument | allowParentStart | bit | no |
SIS-145578 | FormDocument | allowStudentStart | bit | no |
SIS-201983 | Lep | testedProficientOnScreener | datetime2(0) | yes |
SIS-202137 | Message | processingCompleteTimestamp | datetime2(0) | yes |
SIS-202063 | PreSchoolKY | familyVisit1Location | varchar(15) | yes |
SIS-202063 | PreSchoolKY | familyVisit2Location | varchar(15) | yes |
SIS-202063 | PreSchoolKY | modifiedByID | int | yes |
SIS-202063 | PreSchoolKY | modifiedDate | datetime2(0) | yes |
SIS-201669 | StaffEdOrgVacancy | buildingAdministrator40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | educationalAssistant40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | elaTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | giftedTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | mathTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | nonEnglishLangTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | performingArtsTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | physicalEdTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | preschoolTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | scienceTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | socStudiesHistoryTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | visualArtsTeacher40D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | buildingAdministrator80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | educationalAssistant80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | elaTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | giftedTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | mathTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | nonEnglishLangTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | performingArtsTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | physicalEdTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | preschoolTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | scienceTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | socStudiesHistoryTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | visualArtsTeacher80D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | buildingAdministrator120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | educationalAssistant120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | elaTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | giftedTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | mathTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | nonEnglishLangTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | performingArtsTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | physicalEdTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | preschoolTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | scienceTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | socStudiesHistoryTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | visualArtsTeacher120D | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | buildingAdministratorEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | educationalAssistantEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | elaTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | giftedTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | mathTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | nonEnglishLangTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | performingArtsTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | physicalEdTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | preschoolTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | scienceTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | socStudiesHistoryTeacherEOY | smallint | yes |
SIS-201669 | StaffEdOrgVacancy | visualArtsTeacherEOY | smallint | yes |
Deprecated Columns
Case Number | Table | Column |
|---|---|---|
SIS-201561 | LTIProvider | institutionID |
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-184840 | MO | Updated cleanup bad endDate in OnTrack table |
SIS-189705 | VT | Converted ProgramTypeDescriptor to localized namespace |
SIS-189823 | Default EdFiConfiguration.dataStandard to 6 for all existing core connections | |
SIS-198624 | TN | Immunization Rule Update |
SIS-201561 | Disabled LDB LTI OAuth2 connections and LTI providers | |
SIS-201880 | MN | Localized the ImpactAidEmployment militaryBranch attribute |
SIS-202130 | Added EarlyWarningCacheEmptyViewRefresh Quartz Job | |
SIS-202373 | Fixed Duplicate Code in ProgramStatus | |
SIS-202396 | MN & WI | Turned on Sped Archiving |
SIS-202422 | ND | Added SpecialEdState to DIS |
SIS-202556 | Payments Cart Cleanup Job | |
SIS-202782 | NV | CTE Removed incorrect values from SCEDConcentrator |
SIS-202996 | ME, MT, & GA | Activate SpedArchive |
SIS-203032 | Temp Converted FATAL-15 to WARN | |
SIS-203104 | CO | Dropped Renamed State Reporting Procedure |
