Technical Information - Release Pack Campus.2040

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

ALPSSSources

Saves multiselect droplist for ALPSS table.

SIS-140833

CustomInstructionMode

Instruction mode district elements.

SIS-137452

CustomNavigationLink

Table that holds information about custom navigation tool mappings in the three tiered navigation.

SIS-136650

CustomSafeSchools


SIS-140833

InstructionMode

Identifies student instruction modes.

SIS-139004

PersonPicture

Table to hold person picture info.

SIS-136650

SafeSchools

Safe schools related data.

Modified Tables

Added

Case NumberTableColumnData TypeDescription

SIS-140701

ALPSS

otherSource

varchar(500)

Additional comments to explain why other fields are filled in. tied to a multiselect in HI.

SIS-138465

BehaviorEvent

retaliationRelated

bit

Indicates whether the behavior event was retaliation related.

SIS-140000

BlendedLearningGroup

instructionType

varchar(30)

Type of instruction for the group.

SIS-140863

BlendedLearningPreference

savePastAttendanceCounts

bit

Flag to allow teacher to update attendanceCode records on prior days.

SIS-138465

Course

cteIndicator

bit

CTE indicator

SIS-138465

CourseCatalog

lockCteIndicator

bit

Indicates CTE is locked on a course.

SIS-138465

CourseMaster

cteIndicator

bit

CTE indicator

SIS-139197

EdFiIdentityMappingAttendance

eventDuration

decimal

Duration of attendance event

SIS-139508

EnrollmentIN

distanceLearning

bit

This field is to determine if the student is distance or virtual as a result of covid-19 or not.

SIS-138465

EnrollmentMA

civicsProjGrade912

bit

Indicates the student has completed the grade 9-12 civics project.

SIS-138465

EnrollmentMA

civicsProjGrade8

bit

Indicates the student has completed the grade 8 civics project.

SIS-140099

EnrollmentMO

pkReplacementId

varchar(10)

Pk replacement ID.

SIS-139660

ExtendedLearningOpportunity

programCode

varchar(15)

Identifies the extended learning program in which the student participating.

SIS-139660

ExtendedLearningOpportunity

serviceProvider

varchar(100)

Identifies provider of the expanded and enriched learning time opportunities program.

SIS-139660

ExtendedLearningOpportunity

serviceProviderType

varchar(15)

Identifies service provider type.

SIS-140863

PortalOptions

blendedLearningGroup

bit

Flag to display blended learning group in campus student and campus parent.

SIS-139945

Product

partialRefundsAllowed

bit

Indicates if product can be partially refunded.

SIS-140429

ProductCategory

schoolStore

bit

True if this category is allowed to be used in the general product screen.

SIS-140429

ProductCategory

activityRegistration

bit

True if this category is allowed to be used in the activity monitor screen.

SIS-133754

RecordsTransfer

elDocumentFOP

varchar(100)

The EL document rendering object intended to be used in conjunction with the associated XML data.

SIS-133754

RecordsTransfer

elDocumentXML

varchar(MAX)

XML representation of the released student's EL documents.

SIS-140647

Roster

createdDate

smalldatetime

Indicates the date the campus user created the record.

SIS-137797

Survey

surveyJSON

nvarchar


SIS-137797

SurveyRespondent

regardingPersonID

int

Reference to the person table.

SIS-137797

SurveyRespondent

respondentGUID

uniqueidentifier

Internal database identifier.

SIS-137797

SurveyResponse

responseJSON

nvarchar


SIS-137797

SurveyResponse

respondentID

int

Reference to the survey respondent table.

Altered

Case Number

Table

Column

Data Type

Note

Description

SIS-140476

BorderStudent

borderDistrictNumber

varchar(12)

Changed data type from int to varchar(12).

State assigned id for the other district involved in the exchange of this border student. 

Deprecated

Case Number

Table

Column

Data Type

Description

SIS-140519

EnrollmentTX

crisisCode

varchar(2)

Crisis-code indicates a state health or weather related event that impacts a group of students, and may require additional funding, educational, or social services. the event may or may not cause the student to leave the district or campus of residence. a crisis event is designated by the commissioner of education.

SIS-133543

NASIS

nllNonLanguage

varchar(1)

Student is receiving instruction in other subject areas in the native language

SIS-133543

NASIS

nllInstruction

varchar(1)

Student is taking courses on the grammar or speaking of their native language; teachers use both native language and english while instructing the students

SIS-133543

NASIS

nllMaintResto

varchar(1)

Student is receiving maintenance or restoration instruction in reading or speaking the native language

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-140671


Addition of Tribal Foster Youth

SIS-140010

NY

Immunization Rule Update

SIS-140309

MO

PlanAccommodation Additions Updated

SIS-140501

MA

Immunization Rule Updated

SIS-137452


Inserted default custom tabs

SIS-140557


Converted thumbnails to https

SIS-140810

MT

Limited Edition SpecialEDState Cleanup

SIS-140519


Converted crisis codes into crisis events

SIS-140552

ME

Immunization Rule Updated

SIS-140000


Filled instructionType for TX districts

SIS-140670

MN

Added new Rock Ridge disctrict

SIS-124095


OneRoster OAuth expiration message

SIS-140165

SD

Immunization Rule Updated

SIS-140568


Migrated Tool Rights for Category screen

SIS-139914


Removed LTI launch type parameters from db

SIS-140529

PA

Immunization Rule Updated

SIS-140474

CA

Converted EL and Programs to EL Services

SIS-140339

NE

Converted SchoolID Data

SIS-140476

ID

Corrected data conversion to BorderStudent

SIS-140064

IN

Updated Districts

SIS-139744

IL

Modification to EL Services Type Name

SIS-133754

KY

Added custom module EL Documents

SIS-137452


Created navigation links for custom tabs

SIS-138747


Updated Behavior State Resolution Codes

SIS-138747


Updated Behavior State Event Codes

SIS-133543


Added parent rights for moved tool