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 Number | State | Description |
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 |
