These cases are included in the Campus.2243 release pack.
We're making improvements
and we want to learn more about how customers use this article. Please respond to this survey and let us know what you use, what you don't use, and how the information in this article fits into your day. 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-157931 | AssessmentScoreImport | Mapping configuration to import files of scores into the test score table |
SIS-158532 | CustomProgramOptOut | ProgramOptout district elements |
SIS-158532 | ProgramOptOut | ProgramOptout related data |
Modified Tables
Added
Case Number | Table | Column | Description |
SIS-153249 | ActivitySection | postToCourse | 'auto' or 'manual' tracks if posting to course is none, auto, or manual. |
SIS-153249 | ActivitySectionRoster | autoPostWarning | True/false if a post was attempted but failed due to multiple enrollments. |
SIS-153249 | ActivitySectionRoster | autoPosted | True/false if we have attempted to auto post this student. |
SIS-153249 | CampusEventAction | internalActionIdentifier | Used to identify which java class will process this action. coded by and available only to campus. |
SIS-154620 | CampusJobTrigger | missedTriggerPolicy | Indicates what action should be performed if the quartz trigger is missed (null indicates no action) |
SIS-155722 | GradingTask | gradeBookPosted | |
SIS-155722 | GradingTask | termMask | |
SIS-155722 | GradingTask | activeMask | |
SIS-157570 | BehaviorHarassment | religiousAffiliation | The perceived religious affiliation of the victim of a behavior event classified as harassment. |
SIS-158333 | CrisisEvent | crisisName | The name given to crisis event. |
SIS-158333 | Identity | educationLevel | Indicates the highest level of educational attained by the student's parent. |
SIS-158587 | Employment | certified | Indicates if staff member is certified. |
SIS-158621 | UserAccount | passwordUpdatedByID | ID of person who last reset the password of this account. |
SIS-158962 | DistrictAttribute | medicaidParticipation | Indicates the enrollment of medicaid insurance |
Deprecated
Case Number | Table | Column | Description |
SIS-150186 | TeacherPreferenceSectionGroup | hideGradeTotals | Controls whether grade totals (posted/in progress) should be displayed initially on load. |
SIS-155722 | AssignmentMarkGroup | legacyCurveID | Deprecated: internal database identifier |
SIS-155722 | SAMLSPConfig | hidePortalSSO | Deprecated (2021 sis-146779) - hide sso for portal users |
SIS-155722 | hideGradeTotals | Controls whether grade totals (posted/in progress) should be displayed initially on load. | |
SIS-155722 | UserGroup | identityGroupID | Internal database identifier. |
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-123023 | Converted Bad EvalChecklist Data | |
SIS-153061 | Cleared rollupCalcMethod leftover from standards replacement wizard removal | |
SIS-154592 | Removed Bemidji from tier 4 | |
SIS-154620 | Set Attendance Aggregation job to retry if missed | |
SIS-155469 | POS Quick Serve tool seq set at Cafeteria Serve level | |
SIS-156925 | MN | Corrected DirectAdmisions in data extract utility |
SIS-156925 | Inserted getDirectAdmissions procedure into DataExtractUtility | |
SIS-157460 | MO | District Name Changed |
SIS-158635 | HI | Immunization Rule Updated |
SIS-158852 | CO | Fixed Behavior Event Type Bullying |
SIS-158877 | New replace invalid char in custom tool | |
SIS-158877 | Updated invalid char in CTPE | |
SIS-158924 | OH | Immunization Rule Updated |
SIS-158987 | MT | Removed Military Connected Start and End Status From MT Edition |
SIS-159089 | Dropped load-LimitedDistrictEdition-Product and update-LimitedDistrictEdition-Products | |
SIS-159119 | MN | Immunization Rule Updated |
SIS-159392 | MA | Added SIF Race Mappings |
SIS-159414 | KY | Updated Lep exitState field to KY so it reports in adhoc |
SIS-159747 | Refactored SIS-144520 script |
