Technical Information - Release Pack Campus.2136

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

CustomSpecialEDTransition

A place for users to store additional specialEdTransition information.

SIS-147395

CustomTherapeuticProgramReferral

State reporting table for custom defined attribute values of the therapeutic program referral.

SIS-144704

RecurringPaymentTransaction

Links a payment transaction to the recurring payment that created it.

SIS-146926

SpecialEDTransition

Used for special education transition information.

SIS-147395

TherapeuticProgramReferral

State reporting table for therapeutic program referrals.

Modified Tables

Added

Case Number

 Table 

 Column 

 Data Type 

 Description 

SIS-144852

CustomNavigationLink

sortKey

varchar(100)

Optional value of alternative name for entry used in sorting

SIS-147395, SIS-149059

EmploymentAssignment

bit

Indicates if the staff member has access to idea data system

SIS-147395, SIS-149059

EmploymentAssignment

mentorID

varchar(15)

Id of the mentor for an educator

SIS-147395

EnrollmentIA

therapeuticProgramClassroom

bit

Is the student in a therapeutic program classroom?

SIS-149059

EnrollmentMA

enrollmentOfferDate

date

Charter school enrollment offer date field

SIS-149059

EnrollmentMA

charterSchoolSibling

varchar(15)

Charter school sibling preference.

SIS-148740

InstructionMode

school

varchar(4)

Indicates the state school number where the student is receiving instruction.

SIS-147579

Print

archiveDate

datetime2

Indicates the date the print format was archived.

SIS-148638

ProductItem

initialQuantity

int

Initial quantity on hand set for the item

SIS-148740

RecordsTransfer

instructionModeFOP

varchar(100)

The instructionMode rendering object intended to be used in conjunction with the associated XML data.

SIS-148740

RecordsTransfer

instructionModeXML

varchar(MAX)

XML representation of the released student's instructionMode.

SIS-144704

RecurringFeePayment

createdDate

datetime

The timestamp the payment entry was initially created.

SIS-144704

RecurringFeePayment

deletedDate

datetime

The timestamp the payment entry was deleted.

SIS-144704

RecurringFeePayment

modifiedDate

datetime

The timestamp the payment entry was modified.

SIS-144704

RecurringPOSPayment

createdDate

datetime

The timestamp the payment entry was initially created.

SIS-144704

RecurringPOSPayment

deletedDate

datetime

The timestamp the payment entry was deleted.

SIS-144704

RecurringPOSPayment

modifiedDate

datetime

The timestamp the payment entry was modified.

SIS-147874

Survey

createdByCampus

bit

Is the survey created and pushed by campus

SIS-147874

Survey

campusSurveyMetadata

nvarchar



Altered

Case Number

 Table 

 Column 

 Data Type 

 Note 

 Description 

SIS-147395

BehaviorEvent

propertyIncident

char


Used in IA. indicates that the behavior event related to property.

SIS-147955

SchoolAttribute

locale

varchar(15)

Changed data type from varchar(1) to varchar(15).

Indicates school virtual status.

Data Definition Language Scripts

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

Case NumberStateDescription

SIS-146981


Early Warning State Sync

SIS-145333

MN

Immunization Rule Update

SIS-148934

NY

Immunization Rule Update

SIS-148785


Set editorType for messenger

SIS-148980

MD

Immunization Rule Update

SIS-149067


Activity product date sync

SIS-147573

MI

Converted physical checkBox for HouseholdLocations

SIS-142281

MA

EndStatus Codes

SIS-144319

NE

Updated NE device mappings for 21 22

SIS-148740

MT

Added InstructionMode DIS Object

SIS-147874


Created Character Lab's Thriving Index Survey in Survey Tool

SIS-147874


Created Character Lab's Thriving Index in Survey Tool

SIS-144911

MN

Added day eventTypes to unlocked dictionary

SIS-148403


Triggered Reindex Address

SIS-147955


SchoolAttribute.locale field conversion