Technical Information - Release Pack Campus.2144

These cases are included in the Campus.2144 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

Case Number

 Table 

 Description 

SIS-149088 

BirthTo3

Birth to 3 program related data.

SIS-149088 

CustomBirthTo3

Birth to 3 program district elements.

SIS-138349

DISEventQueue

Queue for records to be processed for dis from database triggers.

SIS-138349

DISTrigger

Contains data on what triggers should insert into the DISEventQueue in sp_dcttriggergenerate.

SIS-144974 

DatasetDefinition

Definition of a dataset within a snapshot.

SIS-144974 

DatasetIdentifier

Unique identifier for snapshot definition schema version corresponding to cache db table name.

SIS-144974 

DatasetSnapshot

Record of a report snapshot.

SIS-131349 

PortalDisplay

Calendar/schedule structure options for portal display.

SIS-131349 

PortalDisplayModule

Custom modules enabled to display in campus portal.

SIS-131349 

PortalDisplayOptions

Indicates the tools/data that displays in campus portal.

SIS-131349 

PortalDisplayTemplate

Template information for portal display options.

SIS-131349 

PortalDisplayTerm

Terms enabled to display in campus portal.

SIS-148854 

RTIBatch

A group of students receiving RTI.

SIS-148854 

RTIBatchMember

This table links RTIBatch to person and plans tables.

SIS-138349

SIFSentRecord

Stores the XML that is needed to later delete a SIFf record that has been sent. Only saved for objects that can send events.

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-138349

DISZone

excludeStateExcludeDistrictAssignments

bit


SIS-143456

DigitalLearningVendor OAuth2ClientCredentials

forLTI

bit

Indicates whether the OAuth client is for that vendor's LTI configuration.

SIS-149280

GiftedStatusKY

artsAnecdotalRecords

bit

Evidence indicator when a visual and performing arts code is selected in the gifted category field.

SIS-149280

GiftedStatusKY

artsContinuousProgress

bit

Evidence indicator when a visual and performing arts code is selected in the gifted category field.

SIS-149280

GiftedStatusKY

artsPrimaryReviewCommittee

bit

Evidence indicator when a visual and performing arts code is selected in the gifted category field.

SIS-149280

GiftedStatusKY

artsFormalTesting

bit

Evidence indicator when a visual and performing arts code is selected in the gifted category field.

SIS-143456

LTILaunch

ltiProviderID

int

LTI 1.3 only, LTIProviderID for launch.

SIS-143456

LTILaunch

ltiVersion

varchar(20)

Indicates what LTI version was used in the launch, 1.1 or 1.3.

SIS-143456

LTILaunch

personGUID

uniqueidentifier

LTI 1.3 only, PersonGUID for launch.

SIS-143456

LTIProvider

v1p3Enabled

bit

Indicates this provider should be configured to use LTI 1.3 specification.

SIS-143456

LTIProvider

targetLinkURI

varchar(100)

Target link URI for a given provider.

SIS-143456

LTIProvider

oauth2ClientID

int

Indicates the oauth2 client for the LTI provider.

SIS-143456

LTIProvider

deploymentID

uniqueidentifier

Deployment id used in LTI 1.3 specification, all records will have a value by default.

SIS-143456

LTIProvider

loginInitiationURL

varchar(100)

Login initiation URL for a given provider.

SIS-143456

OAuth2ClientCredentials

publicKeysetURL

varchar(100)

Public keyset URL for a given provider.

SIS-150260, SIS-149553

PaymentTransactionProduct

transactionFeeRefund

bit

Indicates if this record is a refund to a transaction fee.

SIS-150260, SIS-149553

PaymentTransactionProduct

modifiedTimestamp

datetime2

When this record was last synchronized with the payment vendor.

SIS-150260, SIS-149553

PaymentTransactionProduct

depositRequired

bit

Indicates if the product can be deposited or not.

SIS-146975

PlanGuardian

languageAlt

varchar(100)

Stores an alternate language value.

SIS-146975

PlanGuardian

surrogateParentCheck

bit

Indicates if the guardian is the students surrogate parent.

SIS-146975

PlanState

varCharMSStr2

varchar(8000)

Generic field to hold multiselect name data.

SIS-146975

PlanState

varCharMS1

varchar(8000)

Generic field to hold multiselect name data.

SIS-146975

PlanState

varCharMSStr1

varchar(8000)

Generic field to hold multiselect name data.

SIS-146975

PlanState

varCharMS2

varchar(8000)

Generic field to hold multiselect name data.

SIS-148021

Product

enabledPortal

bit

Boolean indicating if product is available on campus parent and student.

SIS-148021

Product

enabledEss

bit

Boolean indicating if category is active on ESS.

SIS-148021

ProductCategory

enabledPortal

bit

Boolean indicating if product is active on campus parent and student.

SIS-148021

ProductCategory

enabledEss

bit

Boolean indicating if category is active on ESS.

SIS-148344

Roster

provider

varchar(15)

CTE institution identification number for the rostered student.

SIS-146975

SEPDetermineEligibility

recordDate1

date

A field for a date.

SIS-146975

SEPGenericSubForm

varchar5

varchar(8000)

A field for text.

SIS-146975

SEPGenericSubForm

varchar4

varchar(8000)

A field for text.

SIS-146975

SEPGenericSubForm

recordDate1

datetime2

A field for a date.

SIS-146975

SEPGenericSubForm

varchar6

varchar(8000)

A field for text.

SIS-146975

SEPOutcomeMeasures

exitAssessmentToolName

varchar(100)

This table is used in special education IEPs.

SIS-146975

SEPOutcomeMeasures

exitAssessmentTool

varchar(15)

This table is used in special education IEPs.

SIS-146975

SEPTransportationPlan

varCharMS1

varchar(8000)

Generic multi select codes field to be used as states see fit.

SIS-146975

SEPTransportationPlan

varChar3

varchar(100)

Generic varchar field to be used as states see fit.

SIS-146975

SEPTransportationPlan

varCharMSStr1

varchar(8000)

Generic multi select names field to be used as states see fit.

SIS-146975

SEPTransportationPlan

varChar1

varchar(100)

Generic varchar field to be used as states see fit.

SIS-146975

SEPTransportationPlan

varChar2

varchar(100)

Generic varchar field to be used as states see fit.

SIS-148021

SchoolStoreSettings

enabledEss

bit

Boolean indicating if store is active on ESS.

SIS-150368

SurveyRespondent

fromStudentFilter

bit

Is the respondent from the student filter.

Altered

Case Number

Table

Column

Data Type

Note

Description

SIS-150175

TestScore

responsibleEntityID

varchar(12)

Changed data type from varchar(6) to varchar(12).

Internal database identifier

SIS-150153

TwentyFirstCCLC

programProvider

varchar(15)

Changed data type from int to varchar(15).

Indicates program provider.

Deprecated

Case Number
Table
Column
Data Type
Description

 SIS-143456 

LTIProvider

iconURL

varchar(2000)

Deprecated: icon image source URL.

 SIS-131349 

MobileDevice

deviceToken

varchar(256)


 SIS-131349 

MobileDevice

notifyAssignments

tinyint


 SIS-131349 

MobileDevice

notifyLunchBalance

tinyint


 SIS-131349 

MobileDevice

systemVersion

varchar(100)


 SIS-131349 

MobileDevice

notifyGrades

tinyint


 SIS-131349 

MobileDevice

createdDate

smalldatetime


 SIS-131349 

MobileDevice

assignmentThreshold

varchar(50)


 SIS-131349 

MobileDevice

deviceModel

varchar(50)


 SIS-131349 

MobileDevice

personID

int


 SIS-131349 

MobileDevice

notifyBehavior

tinyint


 SIS-131349 

MobileDevice

gradesThreshold

varchar(50)


 SIS-131349 

MobileDevice

deviceType

varchar(50)


 SIS-131349 

MobileDevice

lunchBalanceThreshold

varchar(50)


 SIS-131349 

MobileDevice

notifyAttendance

tinyint


 SIS-131349 

MobileDevice

modifiedDate

smalldatetime


 SIS-131349 

PortalDocumentOptions

portalID

int

Foreign key to PortalOptions.

 SIS-131349 

PortalDocumentOptions

form

bit

Stores the flag that indicates if custom forms from the module should be displayed on campus student/parent.

 SIS-131349 

PortalDocumentOptions

moduleID

int

Foreign key to CustomModule.

 SIS-131349 

PortalDocumentOptions

optionID

int

Internal identifier.

Data Manipulation Language Scripts

DML: Statements to create, alter, or drop data structures in an instance of SQL Server.

Case NumberStateDescription

SIS-150365

NV

Enabled Homeless Tab

SIS-149268


Reindexed Household

SIS-143456


Fixed oneRoster autoTestProvider for cat tests

SIS-146975

MI

Enrollment Attribute

SIS-150492

NM

Converted gender data to birthGender

SIS-149707

HI

Immunization Rule Update

SIS-150146


Set editorType for messenger sms

SIS-138349


Dropped EdFi trial trigger and add replacement

SIS-150389

MP

Added State Grade Levels

SIS-150175

AZ

Updated responsibleEntityID length

SIS-150219

IL

Immunization Rule Update

SIS-150113

MN

Immunization Rule Update

SIS-144974


Snapshot Report Preference

SIS-138349


Added DIS quartz jobs

SIS-150148

GA

Updated dummy districts to inactive

SIS-148551


Added subRight for RecordsTransfer

SIS-149930


Updated OneRoster Hourly Quartz Job to run at 30th minute of hour

SIS-150017

AZ

Immunization Rule Update

SIS-148321


Reindexed Person

SIS-145827


Added POS tables to DCT

SIS-149775

NE

Ed-Fi Update School Entity ID

SIS-96207


Deleted and updated entries for previously combined persons

SIS-131349


Portal Options conversion to new schema

SIS-140395


Added workspaceUrls to existing notifications

SIS-96207


Deleted and updated entries for combined persons