Technical Information - Release Pack Campus.2307

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

We've made some changes!

Thanks for your feedback via our recent survey. We're continuing to make updates to how we provide this information; here are the changes we've made this time: 

  • Added the column names and data types included in each new table.
  • Restored the Data Type information for new columns.
  • Removed the Description for new and modified columns to simplify and reduce confusion.

Please use the comments field at the end of this article if you have feedback. 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

ColumnData Type

SIS-156876

BuildingGeneralInformation

buildingGeneralInformationID

int

districtID

int

schoolID

int

buildingGeneralInformationGUID

uniqueidentifier

schoolYear

int

modifiedByID

int

modifiedDate

datetime2(0)

ccpDenials

int

ccpCount

int

ccpRestitution

int

hardwareProvP

bit

hardwareProvK

bit

hardwareProv1

bit

hardwareProv2

bit

hardwareProv3

bit

hardwareProv4

bit

hardwareProv5

bit

hardwareProv6

bit

hardwareProv7

bit

hardwareProv8

bit

hardwareProv9

bit

hardwareProv10

bit

hardwareProv11

bit

hardwareProv12

bit

hardwareProv23

bit

localWellnessPolicy

varchar(15)

externalWifi

bit

notYetBegun

varchar(15)

explorationAdoption

varchar(15)

installation

varchar(15)

initialImplementation

varchar(15)

fullImplementation

varchar(15)

innovationSustainability

varchar(15)

squareFootage

int

lunchPercent

int

transpoPercent

int

peK2LimitedCount

int

peK2ProficientCount

int

peK2AdvancedCount

int

peK2UnevaluatedCount

int

pe35LimitedCount

int

pe35ProficientCount

int

pe35AdvancedCount

int

pe35UnevaluatedCount

int

pe68LimitedCount

int

pe68ProficientCount

int

pe68AdvancedCount

int

pe68UnevaluatedCount

int

pe912LimitedCount

int

pe912ProficientCount

int

pe912AdvancedCount

int

pe912UnevaluatedCount

int

comments

varchar(500)

SIS-156876

DistrictGeneralInformation

districtGeneralInformationID

int

districtID

int

districtGeneralInformationGUID

uniqueidentifier

schoolYear

int

modifiedByID

int

modifiedDate

datetime2(0)

fallG3ELADate

date

springELADate

date

springMSSDate

date

hardwareProvP

bit

hardwareProvK

bit

hardwareProv1

bit

hardwareProv2

bit

hardwareProv3

bit

hardwareProv4

bit

hardwareProv5

bit

hardwareProv6

bit

hardwareProv7

bit

hardwareProv8

bit

hardwareProv9

bit

hardwareProv10

bit

hardwareProv11

bit

hardwareProv12

bit

hardwareProv23

bit

spedFundsYes

bit

spedFundsNo

bit

officeSquareFootage

int

eyeExamCountA

int

eyeExamCountB

int

eyeExamCountC

int

kgAge5Day

varchar(15)

homeSchoolCount

int

unservedStudentCount

int

nonSpedStudentCount

int

psTransBeforeAge3ConfCount

int

psTransitionAfterAge3ConfCount

int

comments

varchar(500)

SIS-156876

DistrictInstructionMode

districtInstructionModeID

int

districtInstructionModeGUID

uniqueidentifier

districtID

int

startDate

date

endDate

date

instructionMode

varchar(15)

comments

varchar(500)

SIS-156876

MedicalGroup

medicalGroupID

int

medicalGroupGUID

uniqueidentifier

districtID

int

dateProcured

date

modifiedByID

int

modifiedDate

datetime2(0)

medication

varchar(15)

medCount

int

comments

varchar(500)

Modified Tables

Added

Case Number

Table

Column

Data Type

SIS-66618

AdditionalIDHistory

endDate

datetime2(3)

SIS-66618

EdFiIDHistory

endDate

datetime2(3)

SIS-66618

OtherIDHistory

endDate

datetime2(3)

SIS-66618

StaffNumberHistory

endDate

datetime2(3)

SIS-66618

StaffStateIDHistory

endDate

datetime2(3)

SIS-66618

StateIDHistory

endDate

datetime2(3)

SIS-66618

StudentNumberHistory

endDate

datetime2(3)

SIS-151334

ActivitySectionRoster

productItemID

int

SIS-156876

SchoolInstructionMode

comments

varchar(500)

SIS-156876

SchoolInstructionMode

instructionMode

varchar(15)

SIS-160766

VaccineExemption

exemptionEndDateRequired

bit

SIS-160963

POSPreference

alertContinuous

bit

SIS-160963

POSPreference

alertGeneral

bit

Altered

Case Number

Table

Column

Data Type

SIS-151334ActivitySectionRostermanualAddtionvarchar(20)
SIS-156490EnrollmentAZcteCreditHoursdecimal(5,2)
SIS-160685BehaviorResponseendTimedatetime2(0)
SIS-160685BehaviorResponsestartTimedatetime2(0)

Deprecated

Case Number

Table

Column

Data Type

SIS-160963

POSPreference

allergyPopup

bit

Data Manipulation Language Scripts (DML)

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

Case NumberStateDescription

SIS-151334


Set ActivitySectionRoster productItemID

SIS-151675


Added tabsetToolID to existing CustomModule records

SIS-151675


Added otherUser Subright to Existing Custom Contact Logs

SIS-151675


Switched custom module Contact Log apps to new app

SIS-153575


Updated pescLabels for race

SIS-156490

AZ

Created CalculateCTEHours Job

SIS-159569


Added Attendance Contact Log core module and convert data

SIS-160963


Updates alertGeneral to old allergyPopup value

SIS-165740

CT

Immunization Rule Update

SIS-165741

HI

Immunization Rule Update

SIS-165996


Updated Default Value Constraint names

SIS-166082

OR

Updated stategradeLevelDefinition

SIS-166086


Fixed Index Fillfactor to be 100 on all indexes

SIS-166244

IL

Immunization Rule Update

SIS-166289

MI

Set graduationPlans to inactive in EdFiResourcePreferences

SIS-166475

CI

HR Status Code Updates

SIS-166568

IN

Converted specialEdSetting

SIS-166649

WI

Updated DigitalEquity fields to match new dictionary codes