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 |
