Technical Information - Release Pack Campus.2112

These cases are included in the Campus.2112 release pack

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

IMEngagementItem

Expansion table to IMItem that is used only for engagements.

SIS-143558

IMEngagementItemSection

Links an engagement question inside a learning object to a past assignment within a section.

SIS-143593

OneRosterClass

Only used for OneRoster, cache of the current years classes, refreshed with sp_onerosterclassrefresh daily.

SIS-143558

StudentEngagementTemplateQuestion

Stores template engagement question information.

SIS-143558

StudentEngagementTemplateResponse

Stores each response's display information and relative value.

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-142585

Course

nonTraditionalCourse

varchar(15)

Nv, identifies if the the course is non traditional for males or females

SIS-142585

Course

scedInstructionalDeliveryMode

varchar(15)

Nv, indicates the delivery method of instruction for sced course data

SIS-142585

CourseCatalog

lockNonTraditionalCourse

bit

Nv, non traditional course locked on course

SIS-142585

CourseMaster

nonTraditionalCourse

varchar(15)

Nv, identifies if the the course is non traditional for males or females

SIS-142585

CourseMaster

scedInstructionalDeliveryMode

varchar(15)

Nv, indicates the delivery method of instruction for sced course data

SIS-144104

EnrollmentPA

locationCode

varchar(4)

School code override

SIS-143023

OnlineMealBenefitApplication

isESigned

bit

Used to track if the esignature preference was turn on when an online meal app is submitted.

SIS-144811

PaymentMethodReference

firstName

varchar(50)

The first name of the account holder.

SIS-144811

PaymentMethodReference

lastName

varchar(50)

The last name of the account holder.

SIS-142362

Test

resultValueMax

decimal

Highest possible score a student could receive in a corresponding result

SIS-142362

Test

learningObjectiveID

varchar(200)

The id of the learning objective source

SIS-142362

Test

resultValueMin

decimal

Lowest possible score a student could receive in a corresponding result.

SIS-142362

Test

learningObjectiveSource

varchar(200)

Used for standards-based grading. this is a set of learningObjectives that are relevant to this particular lineItem.

SIS-142362

Test

description

varchar(200)

A description of the test.

SIS-142585

TranscriptCourse

scedHighestGrade

varchar(4)

The highest grade level enrolled in the course.

SIS-142585

TranscriptCourse

scedLowestGrade

varchar(4)

The lowest grade of student's enrolled into the course.

SIS-142585

TranscriptCourse

scedInstructionalDeliveryMode

varchar(15)

The delivery method of instruction for SCED course data.

SIS-142585

TranscriptCourse

scedSequenceMax

varchar(2)

Max SCED sequence.

SIS-142585

TranscriptCourse

scedCourseLevel

varchar(5)

SCED course level.

SIS-142585

TranscriptCourse

scedSequenceNum

varchar(2)

SCED sequence.

SIS-142585

TranscriptCourse

scedAvailableCredit

decimal

Indicates the possible SCED credits a student can earn for the course.

SIS-139049

UserAccount

pivCardAuthenticationConfigured

bit

Flag that indicates whether a user has been registered to use PIV authentication using their PIV card certificate.

SIS-139049

UserAccount

lastLoginTimestamp

datetime2

The timestamp that a user login the application.

SIS-139049

UserAccount

pivCardAuthenticationEnabled

bit

Flag that indicates if a user has enabled PIV authentication.

SIS-139049

UserAccount

pivCardAuthenticationIdentifier

varchar(128)

Identifier pulled off PIV card certificate that is used to lookup user account for authentication.

Altered

Case Number

 Table 

 Column 

 Data Type 

 Note 

 Description 

SIS-121975

FreeReducedApplication

overrideReason

varchar(75)

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

User-entered reasons for override.

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-144511


Added script to create and populate new blended learning group assignments tool code.

SIS-144035

NJ

Updated course scedCourseID list.

SIS-141273

MN

Immunization Rule Update.

SIS-144022

WA

Immunization Rule Update.

SIS-144811


Updated MVP2 Payrix Transaction.

SIS-145120

IL

Immunization Rule Update.

SIS-140613


Enabled Messenger Maintenance Task in Scheduled Task.

SIS-139049


Added PIV authentication preference.

SIS-144511


Removed unused student attendance tab subright tool codes.

SIS-142984


Reset TOTP token if it has not been configured.

SIS-144511


Added script to populate new blended learning group history tool code and remove related Student Attendance tab subrights.

SIS-145003

CA

Immunization Rule Update.

SIS-144576

NY

Immunization Rule Update.

SIS-144904


Curriculum LTI Link Conversion.

SIS-144005

SD

Immunization Rule Update.

SIS-144613


Associated Daily Health Survey with SIS Security Role Group fix.

SIS-144620

MN

Updated null transportationCodes.

SIS-144437

TN

Converted immigrant.

SIS-144100

MO

Updated District List.

SIS-144792

CA

Updated CA-ODS Status.

SIS-143558


Updated engagement tool rights to On Off.

SIS-130818


Duplicated stateID rights for staffStateID.

SIS-143552


Fixed capitalization of SectionPlacement in AuditTable.

SIS-143558


Added engagement questions and responses.

SIS-143023


Updated Past OL Meal Apps.

SIS-142585

NV

Course field conversion.

SIS-140613


Enabled MessengerMaintenanceTask.

SIS-143121


Added DLPP Enablment Sync Job.

SIS-135552


Activated stateScore for ScoreListItem.