Technical Information - Release Pack Campus.2020

These cases are included in the Campus.2020 release pack. 

Infinite Campus is moving to update all servers to ICAS (Infinite Campus Application Service) 2.0.6, which incorporates Tomcat 8.5.50 and Java 1.8.0_232

Each ICAS release has a Campus version dependency and will require its own update before moving to a higher version of Infinite Campus.  In order to update to Campus.2020, your production site must be on Campus.2016, which will include ICAS 2.0.6.

Cloud Choice and In-District hosted customers on Campus 2012.x or lower, you will not be able to submit an update request for Campus.2020, as it is hidden from the Version dropdown until Campus.2016 has been installed. There are code dependencies in each package that require them to be taken separately, so a district must first request an update to Campus.2016 before you can upgrade to Campus.2020. Your district will only see versions up to Campus.2016.x in the Update Request tool, and not other updates that may have been released, until Campus.2016 and the associated ICAS package have been taken.

Self-hosted customers will need to install the ICAS package before or after updating to Campus.2016.x. For more information on how to install the ICAS package, please see the instructions that have been posted to the Self-Hosted Customers forum.

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 NumberTableDescription

SIS-136217

CrisisEvent

Identifies student involvement in a crisis event.

SIS-136217

CustomCrisisEvent

Crisis event district elements.

SIS-133230

SchoolCaasppMapping

This table serves as a mapping table of school CAASPP configurations that override district configurations.

SIS-134369

EdFiErrorLogData

Contains data that should not be in the clustered columnstore index on edfierrorlog.

Modified Tables

Added

SIS

Table

Column

Data Type

Description

SIS-136720

AttendanceExcuse

assignmentBased

bit

Indicates this excuse is modifiable by assignments.

SIS-129488

EarlyInterventionServiceBIE

math

bit


SIS-129488

EarlyInterventionServiceBIE

reading

bit


SIS-129488

EarlyInterventionServiceBIE

behavior

bit


SIS-134369

EdFiErrorLog

resolutionName

varchar(128)

Ed-Fi action that the error was for.

SIS-134369

EdFiErrorLog

periodName

varchar(20)

Used for errors associated with a period.

SIS-134369

EdFiErrorLog

descriptor

varchar(128)

Used for errors associated with an Ed-Fi descriptor.

SIS-134369

EdFiErrorLog

errorType

nvarchar

First part of error message, used to group similar errors.

SIS-134369

EdFiErrorLog

scheduleStructureName

varchar(20)

Used for errors associated with schedule structure.

SIS-134369

EdFiErrorLog

roomName

varchar(20)

Used for errors associated with a room.

SIS-134369

EdFiErrorLog

incidentName

varchar(128)

Ed-Fi incident that the error was for.

SIS-134369

EdFiErrorLog

periodScheduleName

varchar(20)

Used for errors associated with period schedule.

SIS-134369

EdFiErrorLog

programName

varchar(128)

Ed-Fi program that the error was for.

SIS-136288

EnrollmentMO

reportingSchool

varchar(7)

Used when reporting alternative program students.

SIS-136521

Product

purchaseLimit

int

Indicates the maximum amount of a product a user can purchase.

SIS-136521

Product

itemLimited

bit

Indicates if product be limited in purchase-able quantity at the item-level.

SIS-136521

Product

filterID

int

Reference to adhocfilter to determine product eligibility.

SIS-136521

ProductItem

purchaseLimit

int

Indicates the maximum amount of a product item a user can purchase.

SIS-136521

ProductPrice

freeAmount

decimal

Selling price of the item for FRAM free eligibility.

SIS-106546

SIFPublishHistory

endYear

smallint

End year being run for.

SIS-136305

TEDSCO

wbl

varchar(50)

Indicates the experiences the student has had during their CTE program.

SIS-136186

UserAccount

reverifyFrequency

varchar(32)

Preference tied to enhanced security which indicates how frequently a user should be asked to re-authenticate with TOTP.

SIS-136186

UserAccount

totpConfigured

bit

Flag that indicates if a user has ever logged in successfully using TOTP authentication so that we can mark them as successfully configured.

SIS-136186

UserAccount

totpToken

varchar(255)

Token that is generated per user account to be used with time based two factor authentication application. Encrypted.

SIS-136186

UserAccount

enhancedSecurity

bit

Flag that indicates that a user has been marked for enhanced security, which involves things such as mandatory TOTP authentication with strict re-verify times

SIS-136186

UserAccount

totpEnabled

bit

Flag that indicates if user has enabled self-service TOTP that is not controlled at a district level.

SIS-136186

UserDeviceInformation

lastVerifiedTimestamp

datetime2

Timestamp of the most recent time a user has successfully verified, primarily used with TOTP authentication and enhanced user account security.

SIS-106546

ZIAgent_tblServer

endYear

smallint

End year being run for.

Data Manipulation Language Scripts (DML)

This section lists scripts to add, modify, query, or remove data from a SQL Server database.

Case NumberStateDescription

SIS-136805

MT

SCED updates for 20-21.

SIS-136810

AZ

Added new districts.

SIS-136295

BIE

Set StudentSSN to 0 for PortalSelfServiceOptions.

SIS-136878


Replaced daily CDR task with quartz job.

SIS-133644

CO

Immunization Rule Update

SIS-135228

WY

Immunization Rule Update

SIS-137063


Updated COVID assignment sequence.

SIS-136810

AZ

Added New Districts.

SIS-136006

MN

Updated districts.

SIS-136794


Updated MailgunEvent quartz jobs.

SIS-134464

KS

Updated and added districts.