This article collects the changes made to the database schema as part of the Campus.2439 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 |
|---|---|---|---|
SIS-180939 |
CustomPreschool |
customID |
int |
attributeID |
int | ||
preschoolID |
int | ||
value |
varchar(256) | ||
date |
date | ||
SIS-180939 |
Preschool |
preschoolID |
int |
personID |
int | ||
districtID |
int | ||
preschoolGUID |
uniqueidentifier | ||
startDate |
date | ||
endDate |
date | ||
programType |
varchar(15) | ||
createdDate |
date | ||
modifiedByID |
int | ||
modifiedDate |
date | ||
comments |
varchar(255) | ||
SIS-181250 |
CustomGiftedService |
customID |
int |
attributeID |
int | ||
giftedServiceID |
int | ||
value |
varchar(256) | ||
date |
date |
Modified Tables
Added
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-181551 |
BehaviorResponseRole |
trainedInTechnique |
bit |
SIS-167827 |
CustomDistrict |
customGUID |
uniqueidentifier |
SIS-167827 |
CustomSchool |
customGUID |
uniqueidentifier |
SIS-181524 |
EnrollmentID |
onSchoolGrounds |
varchar(15) |
SIS-178932 |
EnrollmentMT |
homeBasedEarlyLiteracy |
bit |
SIS-181712 |
FormDocument |
tableFromStateCreated |
bit |
SIS-180518 |
IMAssessment |
scoringMethod |
int |
SIS-180518 |
IMAssessmentItem |
orderSeq |
int |
SIS-180518 |
IMItemInteraction |
previousInteractionID |
int |
SIS-180518 |
IMResponse |
feedback |
varchar(max) |
SIS-180518 |
IMResponse |
active |
bit |
SIS-180518 |
IMResponse |
feedbackTimestamp |
datetime2(0) |
SIS-180518 |
IMResponse |
feedbackByID |
int |
SIS-181181 |
InstructionMode |
reportingDistrict |
varchar(12) |
SIS-181557 |
Migrant |
fromCity |
varchar(15) |
SIS-181557 |
Migrant |
toCity |
varchar(15) |
SIS-181557 |
Migrant |
immunizationRecord |
bit |
SIS-181557 |
Migrant |
mepProjectType |
varchar(15) |
SIS-181557 |
Migrant |
medAlertIndicator |
varchar(15) |
SIS-181557 |
Migrant |
outOfStateTranscript |
bit |
SIS-181557 |
Migrant |
residencyVerificationDate |
date |
SIS-181557 |
Migrant |
alg1OrEquivalent |
bit |
SIS-181585 |
NCSnapshotPMRSummary |
fatalsCleared |
int |
SIS-180910 |
Program |
autoAssign |
bit |
SIS-181250 |
RecordsTransfer |
giftedServiceXML |
varchar(max) |
SIS-181250 |
RecordsTransfer |
giftedServiceFOP |
varchar(100) |
SIS-180939 |
RecordsTransfer |
preschoolXML |
varchar(max) |
SIS-180939 |
RecordsTransfer |
preschoolFOP |
varchar(100) |
SIS-182152 |
SpecialEDState |
summerProgram |
bit |
SIS-182152 |
SpecialEDState |
spedExitReason |
varchar(3) |
SIS-182152 |
SpecialEDState |
continueEligibility |
bit |
SIS-182152 |
SpecialEDState |
disability1 |
varchar(15) |
SIS-182152 |
SpecialEDState |
disability2 |
varchar(15) |
SIS-182152 |
SpecialEDState |
extendedYear |
bit |
SIS-182152 |
SpecialEDState |
ohp |
bit |
Altered Columns
Ordered by Table Name.
Case Number |
Table |
Column |
Data Type |
|---|---|---|---|
SIS-180517 |
ActivityProposalProduct |
description |
varchar(max) |
SIS-169416 |
DataExtractUtility |
serverName |
varchar(100) |
SIS-182152 |
SpecialEDState |
specialEdStatus |
varchar(5) |
Deprecated Columns
Ordered by Table Name.
Case Number |
Table |
Column |
|---|---|---|
SIS-176959 |
EnrollmentAZ |
yearEndStatus |
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-176029 |
Deleted duplicate Lesson Plan Preference entries | |
SIS-178170 |
MN |
Course college code update |
SIS-180275 |
IA |
24-25 Yearly Updates - converted enrollment start status |
SIS-180465 |
MI |
EdFi - Deleted no longer used TAS resource mappings |
SIS-180844 |
Added Missing category column to TestAccommodations | |
SIS-180844 |
NC |
Test Accommodations Conversion |
SIS-180910 |
NC |
Setup automatic CTE program assignment |
SIS-180939 |
Added Preschool to Data Change Tracker | |
SIS-181027 |
KY |
Reading Improvement Plan Published to Parent Portal |
SIS-181066 |
FRAM Application Dates | |
SIS-181111 |
KY |
Program Services Plan for English Learners Update |
SIS-181250 |
Added GiftedServices and CustomGiftedServices to DCT | |
SIS-181274 |
OK |
Updated SIF Mappings |
SIS-181274 |
OK |
Updated StateGradeLevelDefinition |
SIS-181309 |
ProcessAlert Added Missing districtID | |
SIS-181312 |
MN |
Immunization Rule Update |
SIS-181413 |
MO |
Deactiveated User-Entered disability2 Dictionaries |
SIS-181544 |
TX |
Updated edfi threads rate limiter |
SIS-181564 |
Re-Added Quartz Job For Logging DIS in State Edition | |
SIS-181565 |
OK |
Immunization Rule Update |
SIS-181574 |
NC |
Updated State Grade Levels |
SIS-181585 |
NC |
Removed proc getNCPMRExtract |
SIS-181658 |
DE |
Duplicated EvalTypes |
SIS-181769 |
Removed CampusVersionHistory discrepancies | |
SIS-181769 |
Corrected CampusVersionHistory | |
SIS-181817 |
NC |
Set specialCode for Courses in list |
SIS-181866 |
OR |
Immunization Rule Update |
SIS-181866 |
OR |
Added ImmComplianceLabel stateStatus data |
SIS-181890 |
Updated historical EL records to be Exited EL | |
SIS-182011 |
NY |
Immunization Rule Update |
SIS-182059 |
Added ForceSqlConnectionDefaultsPreference | |
SIS-182163 |
AZ |
Immunization Rule Update |
