Technical Information - Release Pack Campus.2120

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 NumberStateDescription

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