These cases are included in the Campus.2120 release pack.
New Tables
Case Number | Table | Description |
SIS-145910 | ActivityProposalComment | Saved comment for a returned or declined activity. |
SIS-136385 | CustomThirdGradeRetention | Custom data for thirdGradeRetention records. |
SIS-136385 | ThirdGradeRetention | State program thirdGradeRetention. |
Modified Tables
Added
| Case Number | Table | Column | Data Type | Description |
SIS-135626, SIS-145485 | BehaviorResolution | workProvided | varchar(15) | Used in VA to track is graded work is assigned with a suspension. |
SIS-135626, SIS-145485 | BehaviorResolution | intervention | varchar(15) | Indicates the intervention code applied to the resolution. |
SIS-135626, SIS-145485 | BehaviorResolution | instructionalSupport | varchar(15) | Indicates the instructional support applied to the resolution. |
SIS-135626, SIS-145485 | BehaviorResolution | alternatePlacementEA | varchar(15) | Indicates the education agency in which the student is alternately placed. |
SIS-135626, SIS-145485 | BehaviorResolution | alternatePlacementSchool | varchar(15) | Indicates the school in which the student is alternately placed. |
SIS-144198 | Form | endDate | smalldatetime | Parents cannot sign the form beyond this date. |
SIS-144198 | Form | startTimestamp | smalldatetime | Specify when the form can be sent to portal. |
SIS-144553 | PortalOptions | specialEdOther | bit | Flag indicating special education documents other than IEPs and custom forms should be available on the portal. |
SIS-145069 | EnrollmentNJ | bridgeYear | varchar(15) | An indication of whether the student plans to or is currently participating in the bridge year pilot program. |
SIS-145368 | Calendar | virtual | bit | When this checkbox is checked, the calendar is designated as 100% virtual. |
SIS-145446 | EnrollmentMN | placingDistrict | varchar(256) | Indicates the student placing district. |
SIS-145446 | TwentyFirstCCLC | attendanceDays | smallint | Identifies the number of days a student attends the 21st CCLC program. |
SIS-145446 | TwentyFirstCCLC | attendanceHours | decimal | Identifies the number of hours a student attends the 21st CCLC program. |
SIS-146160 | EnrollmentCO | remoteLearning | bit | Indicates if the student was enrolled in full time distance learning. |
Altered
| Case Number | Table | Column | Note | Description |
SIS-129886 | BIEDMAttendanceCertification | militaryConnectionStatus | Changed data type from varchar(100) to bit. | Student military connection status |
SIS-129886 | BIEDMAttendanceVerification | militaryConnectionStatus | Changed data type from varchar(100) to bit. | Student military connection status |
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.
| Case Number | State | Description |
SIS-129882 | BIE | Added DIS objects for Grad Rate DM |
SIS-129882 | BIE | Toggled ReportService |
SIS-129886 | BIE | Added DIS objects for Attendance DM |
SIS-134147 | WA | Corrected federal race code |
SIS-135585 | Added AttendanceExcuse DISObject | |
SIS-135585 | Added AttDayAggregation DISObject | |
SIS-139787 | IL | Immunization Rule Update |
SIS-144198 | eSignatureNotificationJob | |
SIS-144551 | IA | Converted Homeless Record EndDates |
SIS-144902 | FRAM Income Guide 2021-2022 | |
SIS-145180 | Updated FormDoc Sequence To Zero | |
SIS-145718 | Created custom parent category and tool types | |
SIS-145876 | IN | Immunization Rule Update |
SIS-145912 | MO | Immunization Rule Update |
SIS-145913 | VA | Immunization Rule Update |
SIS-146019 | NJ | District Added |
SIS-146216 | HI | Immunization Compliant Label |
