Technical Information - Release Pack Campus.2104

These cases are included in the Campus.2104 release pack

Data Manipulation Language Scripts (DML)

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

New Tables

Case NumberTableDescription

SIS-136188

HandRaise

Campus instruction hand raise questions between students and teachers

SIS-136188

IMLearningObjectPerson

Association between instructional management learning object and person

SIS-136188

LessonPlanSubmissionDeleted

Student submissions that were deleted because they were orphaned.

SIS-139047

PaymentDeposit


Modified Tables

Added

Case NumberTableColumnData TypeDescription

SIS-136188

ForumSystemCI

objectID

int

Internal database identifier for associated discussion curriculum block object.

SIS-136188

IMItemResponse

previousItemResponseID

int

The previous IMItemResponse when versioned.

SIS-136188

IMLearningObject

wysiwygSubmission

bit

Indicates if a student can leave an online response to this assignment.

SIS-136188

IMLearningObject

driveSubmission

bit

Indicates if a student can attach a file to this assignment using google drive.

SIS-136188

IMLearningObject

upload

bit

Indicates if a student can attach a file to this assignment.

SIS-136188

IMLearningObjectSection

modifiedDate

smalldatetime

Indicates the date the record was modified.

SIS-136188

IMLearningObjectSection

notGraded

bit

Indicates the assignment is not graded.

SIS-136188

IMLearningObjectSection

objectID

int

Internal database identifier for associated curriculum learning object.

SIS-136188

IMLearningObjectSection

parentObjectSectionID

int

Internal database identifier for parent IMLearningObjectSection record.

SIS-136188

IMLearningObjectSection

abbrev

varchar(5)

Abbreviation of assignment that will appear in grade book.

SIS-136188

IMLearningObjectSection

modifiedByID

int

Indicates the campus user who modified the record

SIS-136188

IMRubricItem

previousRubricItemID

int

The previous IMItemResponse when versioned.

SIS-136188

IMRubricItemDescription

previousRubricItemDescriptionID

int

The previous RubricItemDescriptionid when versioned.

SIS-136188

LessonPlanSubmission

objectSectionID

int

Internal database identifier that references IMLearningobjectsection.

SIS-136188

LessonPlanSubmission

objectID

int

Internal database identifier for associated submission curriculum block object.

SIS-136188

LessonPlanSubmission

sectionID

int

Internal database identifier from section table.

SIS-136188

PortalOptions

handRaise

bit

Flag to allow students to ask a question to their teacher.

SIS-139047

PaymentMethodReference

vendorPaymentMethodID

varchar(255)

Additional identifier of the payment method passed from vendor.

SIS-139047

PaymentTransactionProduct

depositDate

date

Date indicating when vendor has deposited funds into district's bank account.

SIS-139047

PaymentTransactionProduct

description

varchar(100)

Description of the item the PaymentTransactionProduct represents.

SIS-139047

PaymentTransactionProduct

paymentDepositID

int

Internal database identifier to the original product following a reversal.

SIS-139949

CampusEvent

premium

bit

Flag the associated event is premium.

SIS-139949

CampusEventProcedure

premium

bit

Flag the associated procedure is premium.

SIS-139949

DataValidationDef

premium

bit

Flags the associated def as premium.

SIS-139949

DataValidationGroup

premium

bit

Flags the associated group as premium.

SIS-139949

DataValidationProcedure

premium

bit

Flags the associated procedure as premium.

SIS-142628

PACTE

adultCumulativeCreditEquiv

bit

Indicates that adult cumulative credit was awarded.

SIS-142628

PACTE

status

varchar(15)

Indicates the status of the PACTE record.

SIS-142628

PACTE

simulatedWorkEnvironment

bit

Indicates if the program occurred in a simulated work environment.

SIS-142628

PACTE

degreeAwarded

bit

Indicates if a degree was awarded.

SIS-142628

PACTE

certificateOfApprenticeship

bit

Indicates if a certificate of apprenticeship was awarded.

SIS-142628

ProgramParticipationCTE

adultCumulativeCreditEquiv

bit

Indicates that adult cumulative credit was awarded.

SIS-142628

ProgramParticipationCTE

degreeAwarded

bit

Indicates if a degree was awarded.

SIS-142628

ProgramParticipationCTE

certificateOfApprenticeship

bit

Indicates if a certificate of apprenticeship was awarded.

SIS-142913

Message

senderDisplayName

varchar(100)

Display name sent with the reply to address.

SIS-142913

MessagePreview

senderDisplayName

varchar(100)

Display name sent with the reply to address.

SIS-142913

MessengerDistrictSchedule

senderDisplayName

varchar(100)

The display name that will show on the emails received by recipients.

SIS-142938

BehaviorResolution

durationHours

decimal

The number of duration hours the resolution will last.

SIS-143032

BlendedLearningPreference

allowPhysicalOverride

bit

Whether a teacher is allowed to indicate that a physical student can be considered virtual for a period.

SIS-143032

StudentParticipation

physicalOverride

bit

Flag to override physical attendance as virtual.

SIS-143289

ElasticDatabaseEvents

id

int

Identifier of the item that caused the database change.

SIS-143478

Evaluation

disabilityString

varchar(8000)

A string representation of a students disability or disabilities.

Altered

Case NumberTableColumnData TypeNoteDescription

SIS-139047

PaymentTransaction

transactionRef

varchar(100)

Changed data type from bigint to varchar(100).

Transaction identifier shared with customer

SIS-139047

PaymentTransactionProduct

paymentTransactionProductRef

varchar(100)

Changed data type from bigint to varchar(100).

Vendor-originated reference for transaction product

SIS-143323

LepService

sheltered

varchar(15)

Changed data type from bit to varchar(15).

Sheltered instruction - used in hi

SIS-143535

Survey

name

varchar(1000)

Changed data type from varchar(50) to varchar(1000).

Name of the survey

Deprecated

Case NumberTableColumnData TypeDescription

SIS-136188

IMLearningObjectSchedulingSet

wysiwygSubmission

bit

Indicates if a student can leave an online response to this assignment.

SIS-136188

IMLearningObjectSchedulingSet

driveSubmission

bit

Indicates if a student can attach a file to this assignment using google drive.

SIS-136188

IMLearningObjectSchedulingSet

upload

bit

Indicates if a student can attach a file to this assignment.

SIS-136188

IMLearningObjectSection

dueTimestamp

smalldatetime

Due time of the assignment's assessment on the due date.

SIS-136188

IMLearningObjectSection

assignedTimestamp

smalldatetime

Assigned time of the assignment's assessment on the assigned date.

SIS-136188

IMLearningObjectSection

schedulingSetID

int

References imlearningobjectschedulingset table

SIS-136188

IMLearningObjectSection

subRosterID

int

References subroster (student group) table

SIS-136188

IMRubricItemDescription

objectID

int

Foreign key to imlearningobject

SIS-139047

PaymentUserAccount

paymentClientAccountID

int

Internal database identifier

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.

Case NumberStateDescription

SIS-143535


Increased the maximum length of the survey name

SIS-130267

WY

Immunization Rule Updated

SIS-142576

NY

Immunization Rule Updated

SIS-143215

UT

Immunization Rule Updated

SIS-143003

IL

Immunization Rule Updated

SIS-141859


Deleted UserToolOption Duplicated Records And Add Unique Constraint

SIS-139727


Added New PlanAccommodation Records

SIS-141753


Updated District table entityID

SIS-139047


Added Settlement State and Job

SIS-139047


Added Payrix Payment Vendor

SIS-142674


Added defaults for BIE password preferences

SIS-143211

NM

Updated Language Codes

SIS-143123


Associated Daily Health Survey with SIS Security Role Group

SIS-142938

AZ

Converted BehaviorResolution duration to durationHours field

SIS-136188


Updated portal assignment NotificationType workspaceUrl

SIS-139949


Added Quartz Job for Data Validation Remaining Sites