Technical Information - Release Pack Campus.2207

These cases are included in the Campus.2207 release pack

Feedback Requested

As a user of this schema change document, would you find would you find this type of information helpful if it was provided for Rx releases such as Rx Pack - Campus.2132? (Schema changes in Rx cases are rare, on average one in thirty cases.)

Please respond in the comments field at the end of this article. 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

There were no new tables added with this release.

Modified Tables

Because of a recent change to our database, Data Type information is no longer provided for these changes. Please comment at the end of this article if you have any concerns. Thank you!

Added

Case Number

 Table 

 Column 

 Description 

SIS-151490

CampusEventRecord

tableSchema

Database table schema for trigger.

SIS-151490

CampusEventTrigger

tableSchema

Database table schema for trigger.

SIS-152858

EmailAttachmentFile

createdByID

Created by personID (nullable for legacy records.)

SIS-151608

Gifted

exclude

Determines whether a program association should send for the gifted record.

SIS-152721

MessengerTemplate

createdByID

PersonID of person who created template.

SIS-152721

MessengerTemplate

locked

Locking will prevent some users from update the template.

SIS-150607

PlanGoalPLAAFP

plaafpGUID

Non-primary key unique internal identifier.

SIS-151707

PlanServiceProvided

sequenceNumber

Field used to order records by number.

SIS-129490

SchoolAttribute

ercBIE

Identifies the specific geographic organization or ERC under which a BIE school falls under.

SIS-151289

Title1IN

reasonExited


Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-137563

TN

Immunization Rule Update 2

SIS-151287

IN

Updated teacher role codes for EdFi.

SIS-152044

MO

PlanAccommodation moIEP22

SIS-153114


Converted ForumPersonAccess records to Individualized IMLOS

SIS-150451

OH

Converted transcriptField1

SIS-137563

TN

Immunization Rule Update

SIS-152981

KY

Converted Identity birthCounrty

SIS-150777


Set default values for elastic preferences

SIS-150777


Added Preference For Search Framework Locator Search

SIS-139833

PA

Immunization Rule Update

SIS-151790

AZ

Conversion of Person.staffStateID to Employment.licenseNumber

SIS-151490


Default tableSchema dbo

SIS-152175

AZ

Updated Tribal Affiliation

SIS-129490

BIE

Updateed new ercBIE SchoolAttribute field

SIS-150014


Reindex Personnel

SIS-151841

OH

Immunization Rule Update