Technical Information - Release Pack Campus.2036

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

CourseLearningMethodsWY

Course learning methods WY. 

SIS-138875

GoalMonitoringConfiguration

A configuration that defines how progress will be monitoring for a person's PlanGoal or PlanGoalObjective.

SIS-138875

GoalMonitoringEntry

A data entry that logs progressing on a goal that is being monitored by a goal monitoring configuration.

SIS-138875

GoalMonitoringIntervention

A intervention in how goals are being monitored by a goal monitoring configuration.

SIS-139889

GradingWindowNotificationConfiguration

Represents the grading window notification configuration for a given calendar.

SIS-140126

WebConferenceMeetingPersonStatistics

Web conference meeting statistics.

SIS-140126

WebConferencePreference

Web conference preferences.

Modified Tables

Added

Case Number

Table

Column

Data Type

Description

SIS-139836

Activity

cancellationReason

varchar(500)

Why the activity was cancelled.

SIS-139836

Activity

cancelledByID

int

UserID of who cancelled the activity.

SIS-139836

Activity

cancelled

bit

Set to true if the activity is cancelled.

SIS-139836

Activity

cancelledDate

date

When the activity was cancelled.

SIS-139836

ActivitySectionRoster

manualAddition

bit

True/false if the student was added through the add student tool.

SIS-135187

AltDeliveryService

location

varchar(15)

The school tied to the record

SIS-135187

AltProgram

location

varchar(15)

The school tied to the record

SIS-135962

AttendanceCounts

customCount3

tinyint

Displays the number of item requests for the third custom option for that period.

SIS-135962

AttendanceCounts

customCount2

tinyint

Displays the number of item requests for the second custom option for that period.

SIS-135962

AttendanceCounts

customCount1

tinyint

Displays the number of item requests for the first custom option for that period.

SIS-139160

BehaviorResponse

imminentDangerToOtherStudents

bit

IL, imminent danger to other students

SIS-139160

BehaviorResponse

imminentDangerToStaff

bit

IL, imminent danger to staff

SIS-139160

BehaviorResponse

imminentDangerToSelf

bit

IL, imminent danger to self

SIS-139597

BlendedLearningGroup

archived

bit

Used to determine if the group has been archived.

SIS-139718

Course

advancedPlacementBIE

bit

BIE - identifies course as advanced placement

SIS-139718

Course

collegePreparationBIE

bit

BIE - identifies course as college preparation

SIS-139718

Course

fundedBIE

varchar(15)

BIE - identifies whether the course is BIE funded

SIS-139718

Course

offCampusELO

bit

NH, off campus ELO

SIS-139718

Course

postsecondaryCreditBIE

bit

BIE - identifies course as offering both hs and college credit

SIS-139718

Course

careerClusterELO

varchar(15)

Nh, elo career cluster

SIS-139718

Course

coreTypeBIE

varchar(15)

BIE - identifies course as a BIE core or BIE non-core course

SIS-139718

Course

providerID

varchar(15)

Instructor/provider id for the course

SIS-139718

Course

careerDevelopmentBIE

bit

BIE - identifies course as career development

SIS-139718

Course

approvedBIE

varchar(15)

BIE - identifies whether the course is BIE approved

SIS-139718

Course

providerDisplay

varchar(100)

Instructor/provider name for the course

SIS-139718

Course

dualCreditBIE

bit

BIE - identifies course as dual credit

SIS-139718

Course

internationalBaccalaureateBIE

bit

BIE - identifies course as international baccalaureate

SIS-139718

CourseCatalog

lockCareerClusterELO

bit

NH, ELO career cluster locked on course

SIS-139718

CourseCatalog

lockFundedBIE

bit

BIE - indicates fundedBIE is locked on course

SIS-139718

CourseCatalog

lockProviderID

bit

Indicates providerid is locked on a course

SIS-139718

CourseCatalog

lockPostsecondaryCreditBIE

bit

BIE - indicates postsecondarycreditBIE is locked on course

SIS-139718

CourseCatalog

lockCareerDevelopmentBIE

bit

BIE - indicates careerdevelopmentBIE is locked on course

SIS-139718

CourseCatalog

lockAdvancedPlacementBIE

bit

BIE - indicates advancedplacementBIE is locked on course

SIS-139718

CourseCatalog

lockInternationalBaccalaureateBIE

bit

BIE - indicates internationalbaccalaureateBIE is locked on course

SIS-139718

CourseCatalog

lockCoreTypeBIE

bit

BIE - indicates coretypeBIE is locked on course

SIS-139718

CourseCatalog

lockProviderDisplay

bit

Indicates providerdisplay is locked on a course

SIS-139718

CourseCatalog

lockCollegePreparationBIE

bit

BIE - indicates collegepreparationBIE is locked on course

SIS-139718

CourseCatalog

lockDualCreditBIE

bit

BIE - indicates dualcreditBIE is locked on course

SIS-139718

CourseCatalog

lockApprovedBIE

bit

BIE - indicates approvedBIE is locked on course

SIS-139718

CourseCatalog

lockOffCampusELO

bit

NH, off campus ELO locked on course

SIS-139718

CourseMaster

advancedPlacementBIE

bit

BIE - identifies course as advanced placement

SIS-139718

CourseMaster

collegePreparationBIE

bit

BIE - identifies course as college preparation

SIS-139718

CourseMaster

fundedBIE

varchar(15)

BIE - identifies whether the course is BIE funded

SIS-139718

CourseMaster

offCampusELO

bit

NH, off campus ELO

SIS-139718

CourseMaster

postsecondaryCreditBIE

bit

BIE - identifies course as offering both HS and college credit

SIS-139718

CourseMaster

careerClusterELO

varchar(15)

NH, ELO career cluster

SIS-139718

CourseMaster

coreTypeBIE

varchar(15)

BIE - identifies course as a BIE core or BIE non-core course

SIS-139718

CourseMaster

providerID

varchar(15)

College setting for the course

SIS-139718

CourseMaster

careerDevelopmentBIE

bit

BIE - identifies course as career development

SIS-139718

CourseMaster

approvedBIE

varchar(15)

BIE - identifies whether the course is BIE approved

SIS-139718

CourseMaster

providerDisplay

varchar(100)

College setting for the course

SIS-139718

CourseMaster

dualCreditBIE

bit

BIE - identifies course as dual credit

SIS-139718

CourseMaster

internationalBaccalaureateBIE

bit

BIE - identifies course as international baccalaureate

SIS-138595

DigitalEquity

instructionPercentOfTime

varchar(15)

Percent of time in digital/remote learning

SIS-138595

DigitalEquity

parentDecision

varchar(15)

Parental decision regarding remote/digital learning

SIS-135187

EarlyEducationMN

exitDate

date

Identifies the early education program exit date.

SIS-135187

EarlyInterventionService

location

varchar(15)

The school tied to the record

SIS-138559

EmploymentAssignment

contractType

varchar(15)

Type of staff contract.

SIS-138595

EnrollmentVA

headStartProvider

varchar(15)

Head start provider code

SIS-138595

EnrollmentVA

regionalPercentOfTime

varchar(15)

Regional student percent of time

SIS-139216

Evaluation

contactPhone2

varchar(22)

Second contact person phone

SIS-139216

Evaluation

contactPhone

varchar(22)

Contact person phone

SIS-139216

Evaluation

contactName

varchar(100)

Contact person name

SIS-139216

Evaluation

contactTitle

varchar(150)

Contact person title

SIS-139216

Evaluation

contactName2

varchar(100)

Second contact person name

SIS-139216

Evaluation

contactTitle2

varchar(150)

Second contact person title

SIS-135187

Gifted

location

varchar(15)

The school tied to the record

SIS-137726

GiftedStatusKY

psychStudentLeadership

bit

Evidence indicator when the documentation of student leadership in community, class, and student organization code is selected in the gifted category field.

SIS-136357

Homeless

comments

varchar(255)

Comments.

SIS-135187

HomelessService

location

varchar(15)

The school tied to the record

SIS-139789

LTIProvider

videoConferencingVendor

bit

Indicates whether the provider can make video conferencing lti launches.

SIS-139789

LTIProvider

basicLaunchVendor

bit

Indicates whether the provider can make basic lti launches.

SIS-139789

LTIProvider

contentSelectionVendor

bit

Indicates whether the provider can make content selection lti launches.

SIS-136357

Migrant

comments

varchar(255)

Comments.

SIS-139457

OAuth1Client

createdByID

int

Indicates the campus user who created the record

SIS-139457

OAuth1Client

createdDate

datetime

Indicates the date the record was created

SIS-139457

OAuth2ClientCredentials

modifiedDate

datetime

Indicates the date the record was modified

SIS-139457

OAuth2ClientCredentials

createdByID

int

Indicates the campus user who created the record

SIS-139457

OAuth2ClientCredentials

createdDate

datetime

Indicates the date the record was created

SIS-139457

OAuth2ClientCredentials

modifiedByID

int

Indicates the campus user who modified the record

SIS-139695

PortalOptions

showPOSPinBarcode

bit

Flag to show POS barcode in campus student.

SIS-135187

PostSecondaryEnrollmentOptions

location

varchar(15)

The school tied to the record

SIS-139942

Product

limitedToAssociatedSchools

bit

Indicates if a recipient must be enrolled in a school linked to the product to purchase it

SIS-135962

Section

customcount3

bit

Indicates whether the third custom count field should be added to the attendance tool for this section

SIS-135962

Section

customcount1

bit

Indicates whether the first custom count field should be added to the attendance tool for this section

SIS-135962

Section

customcount2

bit

Indicates whether the second custom count field should be added to the attendance tool for this section

SIS-135962

Section

providerDisplayOverride

varchar(100)

Instructor/provider name for the section. section level override of the value at the course level.

SIS-135962

Section

providerIDOverride

varchar(15)

Instructor/provider id for the section. section level override of the value at the course level.

SIS-135187

Section504

location

varchar(15)

The school tied to the record

SIS-136357

Title1

comments

varchar(255)

Comments.

SIS-135187

TwentyFirstCCLC

location

varchar(15)

The school where the student is receiving services

SIS-137957

UserAccount

lastUsedTOTPTokenHash

varchar(128)

Hash of previously used TOTP code that is compared to to help prevent replay attacks during TOTP authentication process

SIS-140126

WebConferenceMeeting

disableWebcams

bit

Flag indicating if webcams of attendees will be disabled when meeting starts.

Altered

Case Number

Table

Column

Data Type

Description

SIS-139427

ALPSS

comments

varchar(500)

Any additional information user wants to provide.


Changed data type from varchar(255) to varchar(500).

SIS-139427

ALPSS

otherReason

varchar(500)

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


Changed data type from varchar(255) to varchar(500).

SIS-139427

ALPSSAfterCare

description

varchar(500)

Full description of record.


Changed data type from varchar(255) to varchar(500).

Deprecated

Case Number

Table

Column

Data Type

Description

SIS-136357

EnrollmentIA

homelessServed

varchar(2)


SIS-136357

EnrollmentIA

supplementalServices

varchar(2)


SIS-139573

EnrollmentNV

homelessServedbySubgrantee

bit

Deprecated 2020

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-137726


Updated studentleadershipcol in giftedstatusky

SIS-139888


Added GW Notification Type

SIS-139588


Updated DailyHealthLog with Events and Actions

SIS-139975


Removed duplicate try-new-look preferences

SIS-140126


Added new quartz job for BigBlueButton events processing

SIS-139209

UT

Immunization Rule Update

SIS-140098

MT

Cleaned Up SpecialEDState Data Bad End Dates Redo

SIS-132865


Created Grading Window Job

SIS-140123

UT

Added State Grade Levels

SIS-140098

MT

Cleaned Up SpecialEDState Converted Data Bad End Dates

SIS-139389


Removed obsolete report code

SIS-133432

CA

EO conversion

SIS-140027

AZ

Updated district table

SIS-139695


Converted POS Pin Portal Option

SIS-135187


CI SAOneEh cleanup

SIS-139413


Converted DEU quartz trigger names

SIS-139573


Data clean up NV Enrollment and EnrollmentNV

SIS-138242


Graduation Seal IA Conversions

SIS-139493


Triggered UserNavTools and NewNavPreference ES Reindex

SIS-139704


Created trigger for group creation for previous covid-19 solution

SIS-138380


Fixed disabled MessengerMaintenanceTask

SIS-136357

IA

2021 Reporting conversions