Technical Information - Release Pack Campus.2219

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

There were no new tables added with this release.

Case Number

 Table 

 Description 

SIS-149309

LTIScoreLog

Stores logs of LTI 1.3 score publish events.

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

LTIResourceLink

tag

For LTI 1.3 line items. additional information about the line item; may be used by the tool to identify line items attached to the same resource or resource link (example: grade, originality, participation).

SIS-149309

LTIResourceLink

resourceId

For LTI 1.3 line items. Tool resource identifier for which this line item is receiving scores from.

SIS-149309

LTIResourceLink

sourceLtiResourceLinkID

For LTI 1.3 line items. References the ltiResourceLink whose resourceLinkID should be reported instead of this record's. Used when associating multiple line items with one resource link.

SIS-153072

AssessmentStatusCalcMD

ccrUnweightedGPA

Unweighted GPA used for CCR.

SIS-153072

AssessmentStatusCalcMD

hsdcUnweightedGPA

Unweighted GPA used for HSDC report.

SIS-153137

PlanServiceProvided

otherVal2

Other value associated with service.

SIS-154538

Test

seq

Sequence order for sorting children from 0 to n.

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-155189

MO

Added district to district list

SIS-152284

OK

Immunization Rule Update

SIS-152377


Updated stateExemptionCode L to M

SIS-155383


Regenerated Ed-Fi Triggers

SIS-155350


Updated MessengerTemplate Params

SIS-155350


Fixed MessengerTemplate Params

SIS-152880


Increased Default Security

SIS-154781

SD

Deleted dis objects for behavior and health

SIS-155029

HI

Immunization Rule Update

SIS-149250


New SPED Process Alert Rules

SIS-149309


Added new LTI 1.3 OAuth2 scopes to existing LTI 1.3 providers

SIS-151924

MN

BehaviorHarrassment harrassmentType Updates

SIS-154419

IN

Cleaned up Evaluation based records

SIS-154342


Added preference for time-based two factor

SIS-154506

TN

Changed blanks to NULL in TN transcriptfield1 column

SIS-154538


Updated seq in test to default alphabetical value

SIS-153116


Added show gender to Report.options