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 Number | Table | Description |
|---|---|---|
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 Number | State | Description |
|---|---|---|
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. |
