Technical Information - Release Pack Campus.2235

These cases are included in the Campus.2235 release pack

We're making improvements

and we want to learn more about how customers use this article. Please respond to this survey and let us know what you use, what you don't use, and how the information in this article fits into your day. Thanks!

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-158212

CartridgeImportWarning

Keeps track of cartridge import warnings

SIS-156298

CertificationCriterion

Passing an assessment can be used to award participating students a certificate.

SIS-156298

StudentStatusRule

Stores student status rules associated with a compound requirement

Modified Tables

Added

Case Number

 Table 

 Column 

 Description 

SIS-124059

AdHocFilter

createdDate

Date the filter was created.

SIS-124059

AdHocFilter

createdByID

ID of the user to create the filter.

SIS-124059

AdHocFilter

modifiedByID

ID of the last user to modify the filter.

SIS-124059

FlexMonsterCube

lastRunTimestamp


SIS-124059

FlexMonsterCube

lastRunUserID


SIS-124059

FlexMonsterCube

modifiedByID


SIS-156298

Program

method

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

IBCExamFee

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

language

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

status

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

IBCVendor

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

sealType

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

stateSeal

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

certification

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156159

DigitalLearningVendorOAuth2ClientCredentials

updatedForMigrationByID

If non-null, indicates that this connection was updated to work properly after the base URL changes by the given personID.

SIS-156159

DigitalLearningVendorOAuth2ClientCredentials

createdBeforeMigration

Indicates that this connection was created before the oneroster API migration that caused base URLs to change

SIS-156298

Program

method

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

IBCExamFee

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

language

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

status

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

IBCVendor

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

sealType

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

stateSeal

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

Program

certification

Graduation seal value to be batch-assigned to students who met program requirements

SIS-156298

ProgramParticipationCertification

scoreID

Reference to the TestScore table

SIS-157215

ActivitySection

autoLock

True/false tracks the auto lock toggle for if forms should be locked automatically for this section.

SIS-157548

BehaviorEvent

teamReview

Indicates whether a school team conducted a threat assessment related to a reported disciplinary incident.

SIS-157737

Evaluation

evaluationDelayReason

WI state reporting reporting evaluation delay reason.

SIS-157737

Evaluation

evaluationLateReason

WI state reporting reporting evaluation late reason.

SIS-152448

ProgramParticipation

externalVendorPartnerKey

Partner key that program participant is associated with

SIS-152448

ProgramParticipation

externalVendorSourcedId

Sourcedid of the vendor the program participant is associated with


Altered Column

Case Number

Table

Column

Note

Description

SIS-155962

SectionStudentDetailValue

calendarID

Changed data type from int to None.

Reference to the calendar table

SIS-155962

SectionStudentDetailValue

value

Changed data type from varchar(256) to None.

User-defined value for the record

SIS-155962

SectionStudentDetailValue

sectionID

Changed data type from int to None.

Reference to the section table

SIS-155962

SectionStudentDetailValue

valueID

Changed data type from int to None.

Primary key for table

SIS-155962

SectionStudentDetailValue

startDate

Changed data type from date to None.

Date the value was first associated with section and attribute for a student

SIS-155962

SectionStudentDetailValue

personID

Changed data type from int to None.

Reference to the person table

SIS-155962

SectionStudentDetailValue

attributeID

Changed data type from int to None.

Reference to the campusattribute table

SIS-155962

SectionStudentDetailValue

endDate

Changed data type from date to None.

Last date the value was associated with section and attribute for a student

Deprecated Column

Case Number

Table

Column

Description

SIS-158219

EnrollmentKY

extraYearInPrimary

If flagged, checkbox indicates the student spent an extra year in primary school

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-157944

AZ

Added New Districts

SIS-157125


Converted RaceEthnicity 7 to 07

SIS-157210


Tested sequencescript due to errrors

SIS-157315

VT

Updated Districts

SIS-157469

ID

Added New Districts

SIS-157276

MO

Immunization Rule Update

SIS-155118

MA

Null Truancy Fields for Active Year

SIS-156927

MN

Direct Admission Survey

SIS-156159


Sent ProcessMessage about OneRoster migration to all users with DLA rights

SIS-156298


Added tables to DCT

SIS-147878


Replaced invalid char in custom tool titles