This article collects the changes made to the database schema as part of the Campus.2607 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-142409 | CERSConfiguration | cersConfigurationID | int | no |
vendorID | int | no | ||
tokenUrl | varchar(300) | no | ||
url | varchar(300) | no | ||
clientKey | varchar(100) | no | ||
clientSecret | varchar(2000) | no | ||
automaticSyncing | bit | no | ||
useSchoolName | bit | no | ||
useSchoolNumber | bit | no | ||
useCourseName | bit | no | ||
useCourseNumber | bit | no | ||
useSectionNumber | bit | no | ||
SIS-142409 | CERSSyncRecord | cersSyncRecordID | int | no |
schoolID | int | no | ||
lastSyncedTimestamp | datetime2(0) | no | ||
lastSyncedResult | varchar(200) | no | ||
SIS-190957 | PaymentDepositSnapshot | paymentTransactionProductID | int | no |
paymentDepositID | int | no | ||
SIS-194109 | IMLearningObjectLibraryBlockSettings | objectLibraryBlockSettingsID | int | no |
objectLibraryID | int | no | ||
objectID | int | no | ||
discussionAllowEditPublished | bit | no | ||
discussionAllowFileAttachment | bit | no | ||
SIS-194109 | IMLearningObjectPersonBlockSettings | objectPersonBlockSettingsID | int | no |
objectPersonID | int | no | ||
objectID | int | no | ||
discussionAllowEditPublished | bit | no | ||
discussionAllowFileAttachment | bit | no | ||
SIS-194109 | IMRubricItemDescriptionPerson | rubricItemDescriptionPersonID | int | no |
objectPersonID | int | no | ||
rubricItemDescriptionID | int | no | ||
weight | decimal(6,3) | yes | ||
itemID | int | yes | ||
markID | int | yes | ||
SIS-194109 | IMRubricItemPerson | rubricItemPersonID | int | no |
objectPersonID | int | no | ||
rubricItemID | int | no | ||
taskID | int | yes | ||
scoreGroupID | int | yes | ||
markGroupID | int | yes | ||
value | decimal(6,3) | yes | ||
autoCalculate | bit | no |
Modified Tables
Added Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-193958 | AssessmentScoreImport | assessmentIdentifier | varchar(50) | yes |
SIS-194141 | Evaluation | noticeDate4 | date | yes |
SIS-194141 | Evaluation | notice4Modality | varchar(500) | yes |
SIS-194141 | Evaluation | specifyOther5 | varchar(150) | yes |
SIS-194141 | Evaluation | noticeDate5 | date | yes |
SIS-194141 | Evaluation | notice5Modality | varchar(500) | yes |
SIS-194141 | Evaluation | specifyOther6 | varchar(150) | yes |
SIS-195428 | MessageEmailerJob | messageID | int | no |
SIS-196196 | MessageRecipientDevice | seq | smallint | no |
SIS-196196 | MessageRecipientDevicePreview | seq | smallint | no |
SIS-194987 | SEETeamMeeting | relatedMeetingGUID | uniqueidentifier | yes |
SIS-194987 | SEPTeamMeeting | relatedMeetingGUID | uniqueidentifier | yes |
SIS-193194 | Tuition | code | varchar(15) | no |
SIS-193194 | TuitionAssignment | source | varchar(15) | no |
SIS-193194 | TuitionAssignmentDistribution | signed | bit | no |
SIS-193194 | TuitionPaymentPlan | code | varchar(15) | no |
Altered Columns
Ordered by Table Name.
Case Number | Table | Column | Data Type | Can Be NULL? |
|---|---|---|---|---|
SIS-191343 | Calendar | type | varchar(15) | yes |
SIS-194109 | IMRubricItem | type | varchar(10) | yes |
SIS-195428 | MessageEmailerJob | messageRecipientDeviceID | int | yes |
SIS-194987 | PlanState | pkPlacement | varchar(100) | yes |
Deprecated Columns
Ordered by Table Name.
Case Number | Table | Column |
|---|---|---|
SIS-194287 | CampusAttribute | direction |
SIS-194109 | IMRubricItem | type |
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-171617 | Updated Contact Log routePatterns for Custom Modules | |
SIS-188057 | formDocument versioning for blank and non-db | |
SIS-193513 | MO | Updated District table |
SIS-193958 | Restricted Assessments From Having Same Name and Root ID | |
SIS-194214 | DE | Removed empty strings |
SIS-194408 | IL | Immunization Rule Update |
SIS-194768 | HI | Updated state enthnicity rollup |
SIS-194987 | ND | Deleted Irrelevant Attributes in Dictionary |
SIS-195292 | KS | Deleted Dyslexia EdFiIdentityMapping records so they are recreated as school based |
SIS-195329 | SpecialEdState.transportation data conversion | |
SIS-195408 | Enabled Account Linking Phase 4 | |
SIS-195550 | NC | Removed dbo DV PMRFatal26 |
SIS-195571 | Added Feature Toggle for MFA Enforcement with SAML and LDAP Authentication | |
SIS-195635 | Updated CustomStudent table with military connection data from ImpactAidEmployment table | |
SIS-195856 | Added preference for RRSv2 | |
SIS-196072 | ND | Removed Gifted Migrant services and Records Transfer tool rights |
