Technical Information - Release Pack Campus.2647

This article collects the changes made to the database schema as part of the Campus.2643 release pack. Campus provides this information to enable users to update queries and scripts that may be affected by these changes.

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

Column

Data Type

Can Be NULL?

SIS-201380

SSRSReportParameters

parametersID

int

no

parametersGUID

uniqueidentifier

yes

userID

int

no

reportID

int

no

requestTimestamp

datetime2(0)

no

parameters

nvarchar(max)

no

SIS-202613

AttendanceDayPerson

attendanceDayPersonID

int

no

personID

int

no

calendarID

int

no

date

datetime2(0)

no

attributeID

int

no

value

varchar(256)

yes

attendanceDayPersonGUID

uniqueidentifier

no

createdDate

datetime2(0)

yes

modifiedDate

datetime2(0)

yes

createdByID

int

yes

modifiedByID

int

yes


Modified Tables

Added Columns

Ordered by Table Name.

Case Number

Table

Column

Data Type

Can Be NULL?

SIS-203258

BehaviorResponseRole

trainingOffered

bit

no

SIS-203258

BehaviorResponseRole

trainingReceived

bit

no

SIS-203207

BehaviorRole

aiGeneratedOrModified

bit

no

SIS-185554

EvalType

transferableUnlocked

bit

no

SIS-202961

NCSnapshotGRSSummary

summaryGroup

varchar(50)

yes

SIS-203436

NCSnapshotPMRDetail

submittedByID

int

yes

SIS-203436

NCSnapshotPMRDetail

submittedTimestamp

datetime2(0)

yes

SIS-203436

NCSnapshotPMRSummary

submittedByID

int

yes

SIS-203436

NCSnapshotPMRSummary

submittedTimestamp

datetime2(0)

yes

SIS-202600

PaymentsRuntimeLock

lockedAtUTC

datetime2(0)

yes

SIS-202769

POSEligibility

incomeStatus

varchar(15)

yes

SIS-195652

ResponsiveOffering

lunchCount

bit

no

SIS-195652

ResponsiveOffering

milkCount

bit

no

SIS-195652

ResponsiveOffering

adultCount

bit

no

SIS-195652

ResponsiveOffering

customCount1

bit

no

SIS-195652

ResponsiveOffering

customCount2

bit

no

SIS-195652

ResponsiveOffering

customCount3

bit

no

SIS-192218

TestAccommodations

handheldCalculator

bit

no

SIS-192218

TestAccommodations

signLanguageASL

bit

no

SIS-192218

TestAccommodations

onlineCalculator

varchar(100)

yes

SIS-192218

TestAccommodations

textToSpeechSubject

varchar(100)

yes


Altered Columns

Ordered by Table Name.

Case Number

Table

Column

Data Type

Can Be NULL?

SIS-203186

EmploymentAssignment

accessToIDEA

varchar(15)

yes

SIS-199093

NCSnapshotLCSCS

teacherDuties

varchar(55)

yes

SIS-203205

PlanGoal

serviceProvider

varchar(500)

yes

SIS-203205

PlanGoal

standardName

varchar(1000)

yes

SIS-203205

PlanGoal

standardAbbr

varchar(1000)

yes

SIS-203205

PlanGoal

standardGradeLevel

varchar(1000)

yes

SIS-203205

PlanGoal

completeStandardString

varchar(8000)

yes

SIS-203205

PlanServiceProvided

serviceName

varchar(500)

yes

SIS-202887

SEPTransitionPlan

creditsNeeded

decimal(6,2)

yes

SIS-202887

SEPTransitionPlan

creditsTotal

decimal(6,2)

yes

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-192339

MO

Moved title3 fields off enrollment

SIS-201250


Populated state code on attendanceExcuse

SIS-201422

OK

Created Presidential Fitness Tests2

SIS-201422

OK

Created Presidential Fitness Tests

SIS-201422


Test File

SIS-202350

MN

26-27 District list updates

SIS-202410

MN

Updated Little Falls district name

SIS-202673


Dropped pmr05 inline tvf

SIS-202920

KS

Ed-Fi Turned off Staffs resource

SIS-203034

MO

Updated cleanup bad startDate in OnTrack table

SIS-203053

KY

Immunization Rule Update

SIS-203070

PA

Immunization Rule Update

SIS-203070

PA

Added Live Vaccine Logic

SIS-203134


PMR snapshot conversion

SIS-203186


Converted EmploymentAssignment accessToIDEA values

SIS-203360

NE

Updated TranscriptCourse creditEarnedMethod hide flag

SIS-203520

NE

Converted SPED Plan Gen En Hours to Decimal Varchar