Technical Information - Release Pack Campus.2515

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

By request, we've added a new column to the New Tables and Modified Tables that indicates whether a field can be null. 

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









IMAssessmentLockdownSettings









settingsID

int

no

createdDateTime

datetime2(2)

no

modifiedDateTime

datetime2(2)

no

ltiProviderID

int

no

assessmentObjectID

int

no

objectSectionID

int

no

lockdownEnabled

bit

no

monitorEnabled

bit

no

monitorData

varchar(max)

yes

SIS-181324










LockdownUserLaunch










launchID

int

no

launchToken

varchar(50)

no

tokenUsed

bit

no

settingsID

int

no

initializationVector

binary(16)

no

userID

int

no

studentPersonID

int

yes

launchingPersonID

int

no

isReattempt

bit

no

createdDateTime

datetime2(2)

no

SIS-183542









DependentCareMemberCredit









dependentCareMemberCreditID

int

no

dependentCareMemberID

int

no

name

varchar(255)

no

amount

decimal(7,2)

no

effectiveDate

date

no

comment

varchar(255)

yes

editComment

varchar(255)

yes

modifiedBy

int

no

modifiedDateTime

datetime2(0)

no

SIS-183542





DependentCareMemberCreditAdjustment





dependentCareMemberCreditAdjustmentID

int

no

dependentCareMemberCreditID

int

no

amount

decimal(7,2)

no

effectiveDate

date

no

comment

varchar(255)

yes

SIS-183542




DependentCareRegistrationCharge




dependentCareRegistrationChargeID

int

no

dependentCareApplicationID

int

no

dependentCareSessionChargeID

int

no

lock

bit

no

SIS-183542



DependentCareRegistrationDiscount



dependentCareRegistrationDiscountID

int

no

dependentCareApplicationID

int

no

dependentCareSessionDiscountID

int

no

SIS-183542








DependentCareSectionAttendance








dependentCareSectionAttendanceID

int

no

personID

int

no

dependentCareSessionSectionID

int

no

attendanceDate

date

no

checkInTime

time

yes

checkOutTime

time

yes

dependentCareAuthorizedPickupID

int

yes

commentedPickup

varchar(50)

yes

SIS-183542








DependentCareSessionMemberCharge








dependentCareSessionMemberChargeID

int

no

dependentCareSessionMemberID

int

no

dependentCareSessionChargeID

int

no

minutes

int

yes

effectiveDate

date

no

comment

varchar(255)

yes

modifiedBy

int

no

modifiedDateTime

datetime2(0)

no

SIS-183542






DependentCareSessionMemberChargeAdjustment






dependentCareSessionMemberChargeAdjustmentID

int

no

dependentCareSessionMemberChargeID

int

no

amount

decimal(7,2)

no

effectiveDate

date

no

comment

varchar(255)

yes

editComment

varchar(255)

yes

SIS-183542








DependentCareSessionMemberDiscount








dependentCareSessionMemberDiscountID

int

no

dependentCareSessionMemberID

int

no

dependentCareSessionDiscountID

int

no

startDate

date

no

endDate

date

yes

applyToDropIns

bit

no

modifiedBy

int

no

modifiedDateTime

datetime2(0)

no

SIS-183542














DependentCareSessionMemberSchedule














dependentCareSessionMemberScheduleID

int

no

dependentCareSessionMemberID

int

no

dependentCareSessionSectionID

int

no

monday

bit

no

tuesday

bit

no

wednesday

bit

no

thursday

bit

no

friday

bit

no

scheduleCode

varchar(2)

no

scheduleStartDate

date

no

scheduleEndDate

date

yes

modifiedDateTime

datetime2(0)

yes

modifiedBy

int

yes

scheduleRate

decimal(7,2)

no

SIS-183542



DependentCareSessionSectionCharge



dependentCareSessionSectionChargeID

int

no

dependentCareSessionSectionID

int

no

dependentCareSessionChargeID

int

no

SIS-185468





CCIRegistration





registrationID persisted (int) (always 1) no

accountID

nvarchar(50)

no

accountSecret

nvarchar(200)

no

createdTimestamp

datetime2(0)

no

lastModifiedTimestamp

datetime2(0)

no

SIS-186858






DISEventQueueHistory






disEventQueueHistoryID

bigint

no

actionType

varchar(1)

no

campusTableName

varchar(128)

yes

disImplementationType

varchar(20)

no

insertTimestamp

datetime2(2)

yes

processTimestamp

datetime2(2)

no

SIS-187480











ActivitySectionRosterPendingPayment











activitySectionRosterPendingPaymentID

int

no

activitySectionRosterID

int

yes

personID

int

no

schoolID

int

yes

priceAtCheckout

decimal(19,4)

no

comments

varchar(500)

yes

override

bit

no

overridePrice

decimal(19,4)

yes

overrideComment

varchar(500)

yes

formsComplete

bit

no

registrationConfirmed

bit

no

Deleted Tables

Case Number

Table

SIS-183542

DependentCareMemberSchedule

Modified Tables

Added Columns

Ordered by Table Name. 

Case Number

Table

Column

Data Type

Can Be NULL?

SIS-183542

DependentCareSessionCharge

calculation

varchar(12)

yes

SIS-183542

DependentCareSessionDiscount

seq

int

no

SIS-183542

DependentCareSessionSection

startTime

time

no

SIS-183542

DependentCareSessionSection

endTime

time

no

SIS-183542

DependentCareSessionSection

dropInRate

decimal(7,2)

yes

SIS-183542

DependentCareSessionSection

requirePickup

bit

no

SIS-183542

DependentCareSessionSection

allowDropIn

bit

no

SIS-186858

DISEventQueue

insertTimestamp

datetime2(2)

no

SIS-187323

DISLog

objectName

varchar(100)

yes

SIS-184286

EdFiConfiguration

active

bit

no

SIS-177066

EmploymentAssignment

extendedContractDays

smallint

yes

SIS-186367

EnrollmentNH

outOfDistrictSchool

varchar(15)

yes

SIS-185246

Graduation

fafsaCompletionIndicator

varchar(15)

yes

SIS-187713

IMItem

wysiwygAnswers

bit

no

SIS-181324

LTIProvider

institutionID

varchar(40)

yes

SIS-187361

LTIProvider

allowStudentAccess

bit

no

SIS-186755

NCSnapshotLCSCSA

sectionCount

int

yes

SIS-187480

PaymentsCartItem

metadataID

int

yes

SIS-186357

PlanOfStudy

reasonForDifference

varchar(15)

yes

SIS-186357

PlanOfStudy

participation

varchar(15)

yes

SIS-186357

PlanOfStudy

instructionSubject

varchar(15)

yes

SIS-186357

PlanOfStudy

assignedHours

decimal(8,2)

yes

SIS-186357

PlanOfStudy

completedHours

decimal(8,2)

yes

SIS-186357

RecordsTransfer

planOfStudyXML

varchar(max)

yes

SIS-186357

RecordsTransfer

planOfStudyFOP

varchar(100)

yes

SIS-185675

ReflectionsSurvey

showCompletedPage

bit

no

SIS-181206

TEDSCO

wblType

varchar(50)

yes

SIS-181206

TEDSCO

apprenticeship

bit

no

SIS-181206

TEDSCO

secondaryCert

varchar(15)

yes

Altered Columns

Ordered by Table Name. 

Case Number

Table

Column

Data Type

Can Be NULL?

SIS-183542

DependentCareSessionCharge

chargeType

varchar(14)

yes

SIS-182837

NCSnapshotGRSSummary

rerun

smallint

no

SIS-182837

NCSnapshotPMRSummary

rerun

smallint

no

SIS-185077

StudentContact

county

varchar(50)

yes

Deprecated Columns

Ordered by Table Name. 

Case Number

Table

Column

SIS-183542

DependentCareSetting

applyRegistrationCharge

SIS-187480

PaymentsCartItem

personID

SIS-187480

PaymentsCartItem

productSaleID

SIS-187480

PaymentsCartItem

schoolID

SIS-187480

PaymentsCartItem

override

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

NC

Updated default transcript to include credit rollups

SIS-180575

TX

Set Removed Resources to Inactive

SIS-182225

NC

Removed Scripted Grad Program

SIS-183528

NV

District table on District Edition should match the State Edition

SIS-184475

MD

Updated Race Codes

SIS-184569

GA

State Program Field Changes

SIS-184696

NC

Migrated enrollmentLocations

SIS-184733


Added preferences for rrs

SIS-184733


Added preferences for fop

SIS-184836

NV

impactAidEmployment data conversion

SIS-185518


Added Prefernce for DIS Dashboard

SIS-185681

WY

Converted Hathaway field values FLA to WL1

SIS-186361

NE

EdFi - Removed mappings for a deprecated Enrollment State Exit Status code

SIS-186528

NV

Updated Charter School drop-down

SIS-186561


Enabled LTI13

SIS-186642

KS

Deleted EdfiMappings for SSFSPA

SIS-186858


Added insertTimestamp column to DISEventQueue

SIS-186858


Added disEventQueueHistory system preference

SIS-186875


Created Scheduled Task for EdFi Session Override Auto-Mapping

SIS-186882


Added Assignment Reassign Notification

SIS-187182

NC

DISDataObject DISDataAccess added FosterCare

SIS-187198

NC

Non BIE Removed SSN from identity

SIS-187206

NC

Fixed academic programs

SIS-187211


Added quartz job for rrs

SIS-187597


Migrated Non-Status Payrix Payment Methods

SIS-187698


Removed DIS Truancy Object

SIS-187713


Set IMItem wysiwygAnswers to true for answers with html tags

SIS-187755


Updated Start Minute of DLPP Activation Job