Technical Information - Release Pack Campus.2243

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 NumberStateDescription

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